(Kenneth Fisher) T-SQL TuesdayAfter a while the intros for my T-SQL Tuesday posts get a little boring. So without any further ado, it’s that time, Garry Bargsley (b/t) is our host and the subject is Automate all the things

(Glenn Berry) The Intel Optane SSD DC P4800X Series was introduced in Q1 of 2017, initially with a 375GB capacity and later with a 750GB capacity being released later in 2017.

(Pinal Dave) Since I wrote my article about the script of shrinking the Log Files, there have been many emails from my blog readers about various messages which they are seeing during shrink.

(Jason Brimhall) There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a database.

(Hannes du Preez) You can ensure that your SQl Server Agent always restarts when the SQL Server restarts by using sp_Configure and xp_cmdshell, as shown underneath:

(Grant Fritchey) Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still want to see some sort of load on the server, how can you do it?

(Pinal Dave) One of the most successful offerings from me has been Comprehensive Database Performance Health Check. Sometimes during my assistance, some random issues appear which I try to solve as well.

(Rajendra Gupta) In my previous articles, we installed the SQL Server 2019 CTP 2.1 on Ubuntu Linux. You can follow the below articles to prepare the SQL instance on Linux.

(James Serra) If you are building a big data solution in the cloud, you will likely be landing most of the source data into a data lake. And much of this data will need to be transformed (i.e. cleaned and joined together – the “T” in ETL).

(Pinal Dave) It is indeed a pleasure when we write a timeless article for SQL Server and DBAs read it after many years. In the year 2007, I wrote an article about an error related to Could not open a new database.