SQL Server Installation Checklist
Many people have published SQL Server installation checklists before. Here is one I have been using for several installations without...
2014-04-01
20,783 reads
Blog Posts
What is Program Database?
If you are working with .Net then you will be aware about PDB files.A PDB file is a Program Database,that is...
2014-04-01
731 reads
Cumulative Update #16 for SQL Server 2008 SP3
Here’s a link for the download for the CU #16 for SQL2008 SP3 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx. The post also includes all the previous...
2014-03-31
1,277 reads
Default nullability of a new column
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs?...
2014-03-31
1,194 reads
Default nullability of a new column
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs?...
2014-03-31
1,041 reads
Follow Up on The Unusable User–Question Of The Day
I posted about one of my questions of the day called The Unusable User last week and wanted to return...
2014-03-31
1,200 reads
GetLogSpace – table and stored procedure
We’ve talked before about how to get log space usage information in SQL Server. After the 1,032nd time I re-wrote...
2014-03-31
1,260 reads
Last Weeks Top “Reading” Links #77
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-03-31
1,952 reads
Save Money On Your Training Server
You can spend less money. Some of us are lucky. We work for very large corporations who can easily set...
2014-03-31 (first published: 2014-03-25)
2,201 reads
Send SMS from SQL Server
We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...
2014-03-31
1,955 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