(Daniel Calbimonte) In this article, we’ll take a look at a brief TSQL history and a few examples of loops, conditionals, and stored procedures

(Pinal Dave) I often travel across the world presenting on SQL Server Performance Tuning Topics. When I am not busy with Comprehensive Database Performance Health Check, I like to train IT professionals with SQL Server Performance Tuning Practical Workshop.

(Denny Cherry) Yes, absolutely. In order to do this, you need to configure the replication to use the Availability Group listener as the subscriber. That way, the database that you’re using as the subscriber will follow the AG.

(Fikrat Azizov) In these series of posts, I am going to explore Azure Data Factory (ADF), compare its features against SQL Server Integration Services (SSIS) and show how to use it towards real-life data integration problems.

(Kenneth Fisher) I recently found this DMV and couldn’t wait to share.

(Paul White) Performance spools are lazy spools added by the optimizer to reduce the estimated cost of the inner side of nested loops joins.

(Pinal Dave) Recently one of the customers of Comprehensive Database Performance Health Check asked me if I can help them analysis their entire database for In-Memory OLTP Migration. Well, honestly you do not need my help to check the readiness of your database for In-Memory OLTP Migration.

(Hannes Du Preez) T-SQL window functions perform calculations over a set of rows (known as a “window”) and return a single value for each row from the underlying query.

(Eli Leiba) I need to create a method of reporting the SQL Server database data and log files that have latency issues. The criteria for measuring the IO busy levels is presented as “average tot

(Pinal Dave) Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check yesterday’s engagement. You may read my Read What My Clients Say about my performance services here.