Scaling Out
Steve Jones likes Service Broker as a scale out technology, but it hasn't caught on. He thinks more people should take a look at this technology and implement it in places where it fits well.
SQL Server Integration Services - Delay Validation
Using delay validation the designer can control the response of default behaviour of package validation which happens at design time and also at run time.
Come to see the SQL Server 2012 Launch at DevConnections
On Mar 26-29 in Las Vegas, the DevConnections conference is hosting a launch of SQL Server 2012. Come to the conference and learn more at the SQLServerCentral track.
How to use RunAs command for SSMS if option does not exist
In order to use your normal Windows login and your admin login to connect to SQL Server using SSMS you need to use the "Run as" feature. What do you do in the case of Windows 7 or Windows Vista where you can’t find the Run As Different User option?
Win an Amazon Kindle! Complete our Data Compression Survey
We'd like to find out what you think about SQL Server data compression. Complete this quick survey and you could win an Amazon Kindle. Complete the survey now.
Basics of XML and SQL Server, Part 1: Streaming XML
This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.
Data Gravity
Does data have gravity? Will the law affect how applications are built and deployed? Steve Jones has a few thoughts.
Three Attack Vectors in SQL Server 2005
This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.
SQL Server 2012 - The Virtual Launch Event
Microsoft has scheduled a virtual launch event for SQL Server 2012 on Mar 7. Register now to learn about the next version of SQL Server.
Large table cleanup with minimal locks
How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers