SQL Homework – April 2019 – Practice dealing with corruption
Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of ... Continue reading
2019-04-17 (first published: 2019-04-03)
356 reads
Blog Posts
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
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)
727 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)
864 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,146 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
14 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
11 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
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
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
26 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers