(Rohit Garg) A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS summit & from then users are waiting for this. Currently backup encryption supporting four encryption algorithms: AES 128, AES 192, AES 256, and Triple DES

(Robert Sheldon) SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get asked on the forums. It is a shame, because the answers to them tend to clear up some ingrained misconceptions about functions that can lead to problems, particula

(Pinal Dave) Today I have received a fantastic email from Matthew Spieth. SQL Server expert from Ohio. He recently had a great conversation with his colleagues in the office and wanted to make sure that everybody who reads this blog knows about this little feature which is commonly confused.

(Mayuran Parathalingam) Two of my colleagues had the following error recently and I helped them resolve it. So I thought of writing a blog on how to prevent this error with a simple example.

(Sebastian Meine) SQL Server certificates come with a variety of properties. To retrieve some of these properties, you can use the built-in CERTPROPERTY function.

(Allen White) Unless you’ve got a well-defined strategy to manage SQL Server logins and database users via Active Directory groups (as I usually recommend when setting up SQL Server security), you’re going to eventually find yourself in a situation where you’ll need to clean up logins that don’t hav

(Brian P ODwyer) We have numerous SQL 2012 Availability Groups in our environment with more projected to come online. The issue we are faced with is that we want to find which SQL Instance (cluster node) is hosting the Primary Replica. You can use SSMS to find the information either with the DashBoa

(Daniel Adeniji) Preparing to perform a bit of load test against MS SQL Server. And, so downloaded spawner, a MS Windows desktop application that allows one to generate test data.

(Faiz Farazi) Auto Shrink needs to be kept false (off) for the user databases. True option will shrunk the database files automatically. If the free space of the database files is more than 25 percent. If the shrinking of database files occurred it will affect the data position. That’s why this opti

(Pinal Dave) This is the third part of the series Incremental Statistics. Here is the index of the complete series.