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 query, or wade through the dialog boxes for the SQL Server services top see what …
TSQL Query to find the user the SQL services run as Read more »
I just received my email with the PASS Summit 2018 session evaluations, for my presentation on SQL Server Join types. I loved the feedback, thanks everyone who completed the session evaluations. Something about the Venn diagrams, which …
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 file hierarchy like this: Database Name Type of object (proc, table, view, etc) Name of …
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 is offering the Kindle edition for free for 2 days, December 14th and December 15th, …
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 directory in a file system. Point it to a directory in your source control system, …
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 SQL Queries exam. This week we will be a three part session on functions. This …
Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs) Read more »
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 70-461 SQL Queries exam. This week we will be a two part session Using Cursors, …
Using Cursors, followed by Using String Functions Read more »
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 MERGE Statement and how to do Recursive Queries. This is intended to help prepare TSQL …
Next Week’s Free SQL Training: MERGE Statement and Recursive Queries Read more »
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 provided by Steve Stedman and Aaron Buma to prepare for the Microsoft 70-461 SQL Queries …
Next Free SQL Query Training – OUTPUT Clause and Derived Tables Read more »
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 changes have been made since Beta 9.3. New Features Updated new, fresh icon. Adding filegroup …