The case for SQL Server 2012 Enterprise (vs. Standard) edition
In celebration of the impending SQL Server 2014 release, and in recognition that a large percentage of my clients are...
2014-03-24
1,060 reads
Blog Posts
Using Variables and Parameters SSIS
When creating an SSIS package it is always a best practice to use variables, and parameters in 2012, to avoid...
2014-03-24
421 reads
Using Variables and Parameters SSIS
When creating an SSIS package it is always a best practice to use variables, and parameters in 2012, to avoid...
2014-03-24
2,597 reads
Webinar tomorrow – Avoiding Common SQL Server Virtualization Pitfalls
Tomorrow at 11am PST I will be holding a free webinar, hosted by Tegile Systems, entitled ‘Avoiding Common SQL Server Virtualization Pitfalls‘.
The...
2014-03-24
771 reads
When Data Should Walk Out The Door
What would you do?
What would your reaction be if, one day, all that old data you’ve been holding onto for...
2014-03-24 (first published: 2014-03-18)
1,966 reads
Common Table Expressions in SQL
In SQL Server 2005, Microsoft introduced the Common Table Expression (CTE). CTEs share similarities with VIEWS and derived tables, but...
2014-03-23
1,614 reads
CISSP and Enterprise Architecture
CISSP and Enterprise Architecture
One topic that professionals pursing Enterprise Architecture roles should focus on is security. Enterprise Architects are responsible...
2014-03-22
765 reads
The T-SQL ROW_NUMBER() Function
If you learn one new T-SQL (i.e., Microsoft SQL Server) concept today it should be ROW_NUMBER(). Introduced in SQL 2005,...
2014-03-22
2,972 reads
Disheartening Apples
Question: How many Oracle DBAs can you fit in Madison Square Garden?
Answer: None, their egos won’t fit through the door.
No,...
2014-03-21
640 reads
Friday Followup For March 21, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-03-21
341 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