TSQL Query to find the user the SQL services run as
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick… Read More »TSQL Query to find the user the SQL services run as
SQL
PASS Summit 2018 – My Session Evaluation
I just received my email with the PASS Summit 2018 session evaluations, for my presentation on SQL Server Join types. I loved the… Read More »PASS Summit 2018 – My Session Evaluation
Combining many SQL files into one
I come across the need occasionally to deploy a set of sql files that are all checked into source control in different files with a… Read More »Combining many SQL files into one
Zero to SQL in 20 Lessons
My good friend and business partner Carlos L. Chacon has just completed an introduction to SQL book, that he has just published on Amazon. He… Read More »Zero to SQL in 20 Lessons
Sync your database with source control
SchemaDrift is a tool that I have created to compare the schema between two databases. It can also compare (and save) the schema to a… Read More »Sync your database with source control
Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)
On Thursday March 19th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare for the Microsoft 70-461… Read More »Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)
Using Cursors, followed by Using String Functions
On Thursday March 12th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I to prepare developers for the Microsoft… Read More »Using Cursors, followed by Using String Functions
Next Week’s Free SQL Training: MERGE Statement and Recursive Queries
Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training, will be presenting on the use of the… Read More »Next Week’s Free SQL Training: MERGE Statement and Recursive Queries
Next Free SQL Query Training – OUTPUT Clause and Derived Tables
On Thursday Feb 19th at 9:00am pacific time, Aaron Buma and I will be doing another FREE SQL query training session. This is a free training… Read More »Next Free SQL Query Training – OUTPUT Clause and Derived Tables
Database Health Monitor Beta 10 Released
Today I am happy to announce that Database Health Monitor Beta 10 has been released. Click here to go to the download page. The following… Read More »Database Health Monitor Beta 10 Released