(Gregory Larsen) For years you probably have been writing code similar to the code below to verify an object exist prior to dropping it.

(Ken Simmons) As a DBA for several servers, I get a lot of calls about disk space. The first thing I do is look for data files I can shrink to free up some space on the disk. Some of the servers I support contain several databases and it can take a while to figure out which data file will […]

(Margaret Rouse) Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another — so that all users share the same level of information.

(Pinal Dave) During the recent consulting engagement Comprehensive Database Performance Health Check with SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.

(Jeremy Kadlec) Accurate data is imperative for an organization to conduct cost effective decision making, marketing promotions, mailings, database bloat impacting performance, storage and more. Like everything else, change is constant for your data. There is a need to cleanse and validate data wh

(Pinal Dave) The other day, I was helping my client of the Comprehensive Database Performance Health Check, and during the engagement, I provided a few scripts which they can use to tune their system. During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in

(Grant Fritchey) I wrote a short blog post about the misperception that Profiler was easier than Extended Events when it came to the core concept of “click, connect, BOOM, too much data”.

(Jeremy Kadlec) Between the legislation over the years (HIPAA, GLBA, GDPR, CCPA, etc.) and data breaches from large organizations that seem to pop-up in the news on a monthly basis, SQL Server database encryption is critical for our industry.

(Jason Brimhall) Tracing a query is a common task for a DBA. The methods employed are pretty varied. I seem to encounter a new method here and there throughout my journeys and projects.

(Kenneth Fisher) Conditions are the life blood of programming. This condition is met so now I need to do this task. That condition is met so I need for the program to end. Typically we are going to use parameters or calculate information to be used in the condition, but sometimes we want human input