SQL Saturday Atlanta Precon May 17
I am very proud to announce that I have been selected to present an exciting preconference training session at this year’s SQL Saturday Atlanta on May 17th, 2019, called...
2019-04-17
19 reads
Blog Posts
What’s a Key Lookup?
One of the easiest things to fix when performance tuning queries are Key Lookups or RID Lookups. The key lookup operator occurs when the query optimizer performs an index...
2019-04-17 (first published: 2019-04-03)
725 reads
Testing with Temporary Stored Procedures
A while back I learned that it’s possible to create temporary stored procedures in SQL Server. I never put that knowledge into practice however because I struggled to think of...
2019-04-16 (first published: 2019-04-02)
862 reads
Validation activity in Azure Data Factory - Traffic light of your operational workflow
(2019-Apr-02) Last week Microsoft introduced a new Validation activity task to the Azure Data Factory (ADF) - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-validation-activity Initially, I was confused by its name, thinking that it would help me...
2019-04-16 (first published: 2019-04-03)
11,131 reads
Window Functions vs GROUP BYs
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
9 reads
Window Functions vs GROUP BYs
Watch this week's video on YouTube
There are many options available for improving the performance of a query: indexes, statistics, configuration settings, etc...
However, not all environments allow you to use...
2019-04-16
8 reads
Actual Emails: How do I learn SQL Server despite limited SQL duties at work?
Got this email from a client in the southern US asking how to up their game in SQL Server, frustrated by a lack of hands-on opportunities to administer SQL...
2019-04-15
20 reads
Database Offline – Redux
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
147 reads
Database Offline – Redux
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
22 reads
Database Offline – Redux
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
6 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers