SQLSaturday Orlando Notes – Coffee
I like to say that the goal for any event is to meet the expectations of attendees. The trick is to set the expectations because if you don’t, they...
2019-11-11
30 reads
Blog Posts
Weekly reading #30
Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...
2019-11-11
13 reads
Weekly reading #30
Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...
2019-11-11
42 reads
Last Week Reading (2019-11-10)
Hello all! An extraordinary week has just passed. Two big conferences took place in the USA, PASS Summit and Ignite, where Microsoft announced plenty of new products or updates....
2019-11-10
15 reads
MAXDOP and Tempdb – SQL 2016
Starting SQL Server 2016 Max Degree of Parallellism (Max DOP) Macrosoft has made hanges on this and now we can set it at database level. This helps for replication...
2019-11-09
186 reads
Omaha Azure User Group Presentation Nov 18
I’m happy to announce that I’ll be presenting an in-person session for Omaha’s Azure Users Group on Monday, November 18 at 3:00pm, entitled “SQL Server in the Microsoft Cloud“....
2019-11-09
22 reads
Invest in Yourself Stop Making Excuses
Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me and elicited a strong reaction from myself. It got me thinking I need to write...
2019-11-08 (first published: 2019-10-22)
1,559 reads
SQLSaturday Orlando Notes – Kahoot
The last two years we did Family Feud as part of our end of day gathering. Fun, exciting, and energetic are all words I’d use to describe it. Definitely...
2019-11-08 (first published: 2019-10-22)
178 reads
Create Azure Data Studio SQL Notebooks with PowerShell
At PASS Summit today I gave a presentation about SQL Notebooks in Azure Data Studio for the DBA. I demo’d the PowerShell module ADSSQLNotebook. which you can also find...
2019-11-07
33 reads
Finding out the most cached database in the buffer cache - The DMV Way
While there are many ways and criteria to find out what database is the most used, under optimized, trouble maker etc....., here is one more to find out the...
2019-11-07
196 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