SQL Saturday Baton Rouge
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and...
2019-06-03
6 reads
Blog Posts
SQL Saturday Baton Rouge
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and...
2019-06-03
42 reads
Turning a Corporate Color Palette into a Data Visualization Color Palette
Last week, I had a conversation on twitter about dealing with corporate color palettes that don’t work well for data visualization. Usually, this happens because corporate palettes are designed...
2019-06-03 (first published: 2019-05-16)
1,414 reads
Using Extended Events To Capture Backup and Restore Progress
If you are running a DATABASE BACKUP or RESTORE command manually, SQL Server will show you the progress at a specified % completion interval. For the BACKUP, the default is...
2019-06-03 (first published: 2019-05-16)
987 reads
Weekly reading #0x10
This is the blog anniversary! 16th Weekly reading has come into the light! For great articles and a video wait for you! Report Parameter Support for Paginated Report E-Mail...
2019-06-03
19 reads
Which Query Used the Most CPU? Implementing Extended Events
A question that comes up on the forums all the time: Which query used the most CPU. You may see variations on, memory, I/O, or just resources in general....
2019-06-03
43 reads
Keynoting at SQL Saturday #831–Christchurch
After our SQL in the City Summit in Brisbane last week, Hamish Watson () asked me if I’d do a short version of my keynote talk at the upcoming...
2019-06-02
10 reads
Thanks for joining us at SQLSaturday Dallas!
Thanks for joining hundreds of SQL pros from around the country today at UTDallas!Here's my session downloads from my presentation today at 1:15 in room 1.102, there's a handy...
2019-06-01
14 reads
2019-05-31T19:00:42.000+00:00
TEST I'd read about Terraform 0.12 and thought it was much further out, so moved on with regret from evaluating the massive number of improvements. Just found out it...
2019-05-31
17 reads
Implicit Conversion Fail
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-05-31
9 reads
Blogs
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...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
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