(Pinal Dave) TRIM Function has haunted SQL DBA for ages. If you have been using SQL Server for a while, you will totally agree with me over here. In this blog post we will see how the new feature TRIM of SQL Server 2017 works in few simple words.

(Kenneth Fisher) Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the Error Log (and in fact the text files containing the data are named ERRORLOG, ERRORLOG.1, etc) although it contains a lot more information than just errors.

(Thomas LaRock) I love movies. I don’t know if I qualify as a movie buff, but I know I have spent a good chunk of my lifetime watching films. One of my favorite films is The Magnificent Seven. (We won’t talk about the awful remake; I like to pretend it never happened.)

(Neeraj Prasad Sharma) In this we will learn the importance of ever increasing clustered index / primary key in SQL Server.

(Siddharth Mehta) Hierarchical data is typically stored in multiple normalized tables in relational databases or even dimensional models. Relating normalized tables to create a uniform view of data for analysis is a standard practice. One of the regular needs of business analysts is to perform quan

(Greg Larsen) If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance.

(Robert Sheldon) SQL Operations Studio simplifies routine administration of SQL Server and Azure SQL databases, making database development and management easier for users who aren’t full-time DBAs.

(Michael J. Swart) Using the Blue-Green deployment method, database changes are decoupled from applications changes. That leaves us with one last challenge to tackle.

(Pinal Dave) I am really not sure how many times I have been asked about GDPR Compliance in the recent months. You must bookmark this page and share with your organizations if you are doing business with European Union or firm based out of European Union.

(Pinal Dave) Recently during Comprehensive Database Performance Health Check, I had a fascinating conversation. SQL Server has introduced Activity Monitor many version earlier. I think everybody is now pretty familiar with this tool and use it frequently.