SQL 2014 Release Date, April 1st
I'm not a fan of anything releasing on April Fool’s Day, but that's not for me to decide. I personally...
2014-03-31
1,790 reads
Blog Posts
SQL Server Quickie #12 – Nested Loop Operator
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-31
1,415 reads
SSIS Web Service Task
The Web Service task in SSIS can be used to call a web service command to perform a needed operation...
2014-03-31
947 reads
SSIS Web Service Task
The Web Service task in SSIS can be used to call a web service command to perform a needed operation...
2014-03-31
4,676 reads
The Illusion of Updateable Clustered ColumnStore Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-31 (first published: 2014-03-25)
2,364 reads
2014-03-31
1,565 reads
The Primary Filegroup Cannot be Backed Up as a File Backup
File Group backups are great when working with very large databases (VLDB’s) that have been partitioned. Typically when I come...
2014-03-31
2,737 reads
We Are Hiring!
My employer Ntirety (a division of HOSTING) is currently looking for multiple SQL Server DBA's. As you have probably seen...
2014-03-31
1,239 reads
Calendar Tables in T-SQL
In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of...
2014-03-30
32,858 reads
SQL Server 2014 RTM
The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...
2014-03-30
1,514 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