(Alexei Govorine) How to join two SQL tables and display the latest results.

(Melissa Coates) Last week I got involved with a customer issue. A refresh of the data imported to a PBIX always works in Power BI Desktop, but the refresh operation intermittently fails in the Power BI Service. Their workaround had been to refresh the PBIX in Desktop and re-upload the file to the S

(Manoj) Azure SQL Database is a Microsoft’s cloud based service on Microsoft on premise version of SQL Server relational database. It is a fully-managed relational cloud database service built for developers.

(Greg Larsen) Once you enable your database to be encrypted with Transparent Data Encryption (TDE), the physical database files, and the database backups are encrypted. If your database and database backup are encrypted, then how can you send the encrypted backup to a person outside your organizati

(Pinal Dave) One of my clients contacted me for quick On-Demand consulting. When I joined GoToMeeting with them they showed me below error when they were trying to run a job.

(Don Castelino) Recently, I had worked on an interesting Login failed error constantly getting reported in SQL Error log. In this blog, we are covering the steps taken to fix the issue.

(Daniel Farina) You have a script file that runs smoothly in SQL Server Management Studio, but when you execute it using sqlcmd command line utility, that script doesn’t work.

(Pinal Dave) During recent Comprehensive Database Performance Health Check, the customer put forward a compelling request. They wanted to improve their index rebuild performance as their index rebuilding process is taking forever to complete.

(James Serra) There is no better way to see the art of the possible with the cloud than in use cases/customer stories and sample solutions/architectures. Many of these are domain-specific which resonates best with the business decision makers:

(Jack Vamvas) Question: I’m getting an error when checking some new application installed with a SQL Server backend. How can I fix? The sql code and the associated error are below: