(Jon Smith) Pre-existing SQL databases, particularly if complex, can often pose problems for software developers who are creating a new application. The data may be in a format that makes it hard to access or update, and may include SQL functions and procedures.

(Scott Guthrie) Today we released a number of great enhancements to Microsoft Azure. These include:

(Pinal Dave) During my recent visit to customer site for a session on backups, they asked me to find the cause of the error while restoring a differential backup.

(Tony Davis) SQL Server provides a large number of built-in stored procedures that can tell us all sorts of useful information about what’s going on in our SQL Server databases.

(Chris Webb) Often when you’re working with web services in Power Query you’ll be making a large number of requests to the web service in a small amount of time – and you’ll notice that your query seems to be a lot slower than you would expect.

(Kris Wenzel) Recently a reader asked me how to sort an alpha numeric field in SQL in natural order.

(Kenneth Fisher) Every now and again you realize that the primary key for a table does not uniquely describe a row. Not really a big deal right? Just add an additional column in order to make it unique and move on.

(Pinal Dave) Errors are the best way to learn how SQL Server works and as DBA’s we are bound to see many of them from time to time. One of the primary functions of a DBA would include creating backups and most importantly trying to automate the same using jobs and maintenance plans.

(Chris) As a part of the project I’m currently working on, the development team is very enamored with the cache transform in SSIS. I consider myself pretty experienced with SSIS, and I’ve always stayed away components that come anywhere close to touching disk with SSIS, as I believe it slows down pa

(Rohit Garg) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.