Monitor Database Offline Events
Hopefully, a database being taken offline is a known event and not a surprise. Occasionally there are gremlins, in the form of users with too many permissions, that tend...
2018-11-15
133 reads
Monitor Database Offline Events
The other day, I shared an article showing how to audit database offline events via the default trace. Today, I...
2018-11-26 (first published: 2018-11-15)
1,927 reads
Parameterized dynamic SQL is parameterized.
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic...
2018-11-23 (first published: 2018-11-15)
2,534 reads
Microsoft Professional Program vs Microsoft Certification
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
264 reads
TSQL Tuesday #108 – Learning to Learn
G’day,
One attribute that I think is more relevant today than ever is to have a broad base of skills with...
2018-11-15
192 reads
Switching blog website
For quite some years now I have been active on my blog over at www.dotnine.net. While there was nothing wrong with...
2018-11-14
201 reads
Dates and Times in SQL Server: DATEADD()
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure...
2018-11-14
250 reads
Fix My Functions: Speeding Up Scalar and Table Valued UDFs (video)
Last week, I was lucky enough to present on the topic of TSQL User Defined Functions (UDFs) in SQL Server at the PASS Summit. My session was live-streamed, and...
2018-11-14
111 reads
Power BI Monthly Digest – November 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-11-23 (first published: 2018-11-14)
2,400 reads
Azure SQL Database – Fixing My Scaling Failure
This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I...
2018-11-14
241 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers