Keynotes in Australia and New Zealand
I get to do the SQL in the City Summit keynotes in Australia and New Zealand. I’m excited, following the footsteps of Kendra Little and Donovan Brown, who have...
2019-05-21
19 reads
Blog Posts
Microsoft SQL Server Error 5243 – Top 3 Ways To Fix This Issue
Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error...
2019-05-21
21 reads
Microsoft SQL Server Error 5243 – Top 3 Ways To Fix This Issue
Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error...
2019-05-21
226 reads
Predicate Execution Order on Mixed Data Type Columns
Watch this week's video on YouTube
SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions....
2019-05-21
5 reads
Predicate Execution Order on Mixed Data Type Columns
Watch this week's video on YouTube
SQL Server's cost-based query optimizer does a pretty good job of figuring out what order to filter your data to get fast query executions....
2019-05-21
15 reads
Strategies for Compliant Development Down Under
I’m doing a tour of Australia and New Zealand with our SQL in the City crew. We’re going to be in Brisbane, Christchurch, and Melbourne on three consecutive weeks....
2019-05-21
4 reads
T-SQL Tuesday #114 Puzzle Party – Roundup
Here’s my round-up for this month’s T-SQL Tuesday. Thanks to everyone who contributed last week. It was great reading your posts and seeing the different ways you interpreted the...
2019-05-21
103 reads
What’s Unique About SQL Saturdays: Nearly Everyone Interacts with Other People
Today I was looped in on an email thread about the pros and cons of attending a specific event. One person on the thread asked if any of us...
2019-05-21
13 reads
Why is my pivot query not returning any data? How to debug a PIVOT query
If you have a PIVOT query and it isn't returning the data you expect, what can you do to troubleshoot it? The thing to do is to break it...
2019-05-21
9 reads
Why is my pivot query not returning any data? How to debug a PIVOT query
If you have a PIVOT query and it isn’t returning the data you expect, what can you do to troubleshoot it? The thing to do is to break it...
2019-05-21
32 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
Alamat Kantor BCA KCP Kramat Jati WA(082144477715)
WhatsApp:0821-4447-7715 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
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...
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