SQL Server 2014 released April 1st!
SQL Server 2014 has been released to manufacturers (RTM) and will be generally available April 1. Here is the official...
2014-03-20
1,129 reads
Blog Posts
Using Configuration Files in SSIS
Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I...
2014-03-20 (first published: 2014-03-17)
3,471 reads
Virtual Lab – New Domain User
This is part of my series on building a virtual lab for use with SQL Server and Windows. You can...
2014-03-20
1,080 reads
A Nicely Made Smoke Detector
This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a...
2014-03-19
670 reads
Collation: Definition
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-19
2,205 reads
My Favorite Free Scripts
SQL Server Maintenance Solution
I'll start off with Ola Hallengren's scripts. I'm not a fan of reinventing the wheel. If someone...
2014-03-19 (first published: 2014-03-17)
4,587 reads
Query Tuning Near You
It really is so much easier to just throw hardware at badly performing databases. Just buy a bigger, faster server...
2014-03-19
1,189 reads
Submitting PASS Summit Sessions
I’ve been thinking for a while about what to submit for this year. I knew I wanted to have one...
2014-03-19
634 reads
Thank you!
I won’t be able to make it to the PASS Summit this year but I still consider myself part of...
2014-03-19
683 reads
The Phoenix Project: a DBA rises from the ashes
About a year ago, fellow blogger Thomas LaRock recommended the book The Phoenix Project, claiming that “every business leader and...
2014-03-19 (first published: 2014-03-10)
2,133 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