Virtual SQL Playground Adventure: Introduction
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...
2013-06-13
1,485 reads
Blog Posts
Why should we upgrade off of SQL Server 2000?
A good many companies still have servers chugging along on SQL Server 2000 (or even, as some of us noted...
2013-06-13
903 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
354 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
1,312 reads
Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site
In the final part of this series, we will create a BI subsite in our site collection. You can use...
2013-06-12
3,078 reads
Building an Effective Data Warehouse Architecture Presentation
I will be presenting the session “Building an Effective Data Warehouse Architecture” this Thursday, June 13th at 11:00am EST for Pragmatic Works. Below is...
2013-06-12
931 reads
Centralized SSIS solution to monitor failed SQL Server Agent Jobs across the enterprise
SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business...
2013-06-12
881 reads
Looking to SQL Server 2014 High Availability In Standard Edition
During the keynote for TechEd North America 2013, Microsoft announced the planned release of SQL Server 2014. As part of...
2013-06-12 (first published: 2013-06-10)
3,623 reads
Monitoring Blocked Processes with Event Notifications
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...
2013-06-12
1,213 reads
Security Questions: SQL Agent Permissions
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-12
628 reads
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