PASS Data Architecture Present Microsoft – Readying on ‘Hadoop’
On Thursday July 20th, MCM Gaurav Aggarwal will provide an overview of the different options on MS platform for Hadoop
SQLServerCentral Webinar Series #11: A Sandbox Development Process
Steve Jones is your host introducing Grant Fritchey who'll present this webinar. This session explores the use of two Red Gate products, SQL Virtual Restore and SQL Source Control, in establishing a well-defined development process that allows for the use of known data sets and source code management of your database code. These tools work together to help you create a sandbox environment where you can test and develop your databases. Working with a development process is the best way to ensure a safe deployment process to protect your production systems.Developing software without establishing a good process can be a situation rife with the possibility of disaster.
I Want Stupid Employees
Why don't employers want to fund training? Steve Jones has a few thoughts after a great piece that shows the lack of wisdom in withholding training.
Stairway to SQL Server Replication - Level 5: Transactional Replication & How it works
This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.
Arrays in SQL that Avoid Repeated Groups
It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the repeating group, as Joe Celko explains.
Fitting In
Today we have a guest editorial from Andy Warren that talks about fitting in at work and conforming to the expectations of the group and that environment.
Speeding up Data Access Part 1 - Missing Indexes
In the first part of this series, learn how to pinpoint missing indexes in your databases.
Being an extremely productive DBA
In order to gain better support for learning and training opportunities, the DBA needs to prove a direct link to productivity and results, in words and numbers the CEO will understand.
Database Size Survey
Help us collect some data on the sizes and counts of databases in your environment. Take a few minutes and answer this survey.
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers