Good stuff for the DBA from SQL Server Magazine...
I literally changed the topic of my blog today, (as I had my blogger open), since I had read some pretty...
2011-06-24
1,147 reads
Query Table Metadata
There will inevitably come a day when you want to take a look at the metadata of the tables inside...
2011-06-23
5,962 reads
Export SQL Server Error Messages from Event Viewer As HTML
i use the following powershell script to retrive all sql server error logs from event viewer and export as a...
2011-06-23
1,104 reads
Scripting dependencies of User-defined Table Types
I was using user-defined tables types (UDTT) quite intensively despite of their current disadvantages especially their forced READONLY behavior when...
2011-06-23
3,884 reads
SQL Server “Denali”
SQL Server “Denali” is the code name for the next version of SQL Server. The CTP1 of Denali was released...
2011-06-23
3,084 reads
Setting a Unique Index on a Bit Field
Can you set a unique index on a bit field? Well, you can, but you’d end up with a very...
2011-06-23
1,843 reads
SQL Server Separation of Duties
Microsoft published a white paper named "SQL Server Seperation of Duties". Security always an important problem for DBAs and many...
2011-06-23
1,612 reads
The Proxy Auto-configuration URL was not found
When configuring Merge Replication for Web Synchronization it's common to encounter the error The Proxy Auto-configuration URL was not foundand
...
2011-06-23
1,355 reads
Google as the Ultimate SQL Repository
A discussion of how Google can serve as an invaluable resource when facing a SQL-based challenge.
Today I briefly want to...
2011-06-23
744 reads
Taking Script of Sql Server Jobs for Migration
when migration sql server database to a new server, i use the following powershell script to take all sql server...
2011-06-23
2,467 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
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...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
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