SQL Saturday Exeter
A couple weeks back was the second SQL Saturday to be held in Exeter. Although I wasn’t speaking this time,...
2014-04-07
575 reads
Blog Posts
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
505 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
319 reads
SQL Server licensing consideration
You might already read lots of post about SQL server 2012 is license per core rather then per socket and...
2014-04-07
519 reads
SSIS XML Task
The XML Task in SSIS allows you to parse through an XML file and read the nodes in the XML....
2014-04-07
432 reads
Writing My Next Question Of The Day
I ran into a simple error last week and saved it to convert to a question. It’s another one where...
2014-04-07
566 reads
SQL Server Filtered Index
What is a SQL Server Filtered Index
A SQL Server Filtered index is a nonclustered indexes that can be used to...
2014-04-05
1,352 reads
Analyzing CXPACKET waits
One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This wait...
2014-04-04
533 reads
Book: Reporting with Microsoft SQL Server 2012
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012...
2014-04-04 (first published: 2014-03-25)
3,867 reads
Changing SQL Server Agent Jobs Ownership: Who should own SQL Server Agent Jobs
I writing this blog post as a result of the following two questions, which I’ve been asked by one of...
2014-04-04
2,177 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