XQuery
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
227 reads
Blog Posts
A Rickety Stairway to SQL Server Data Mining, Part 10.2: DMX DML
by Steve Bolton
The three introductory posts in this series of self-tutorials on SQL Server Data Mining (SSDM) and the...
2013-03-26
2,228 reads
Chicago SQL Saturday (#SQLSat211) Coming Up
We’re less than three weeks away from the Chicago SQL Saturday. This will be my fourth time heading to Chicago...
2013-03-26
652 reads
Office Space–Not The Movie
I’ve worked in a lot of different offices and office layouts over the years. Looking back I’ve been lucky (or...
2013-03-26
989 reads
PASS Business Analytics presents MVP Jessica Moss: Putting the Business Into Business Analytics
I saw Jessica Moss presenting at the PASS Summit a couple of years ago on Reporting Services. She has been...
2013-03-26
993 reads
Policy Based Management On Change: Prevent not available
Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE...
2013-03-26
1,863 reads
Six top SQL Server 2012 management tools you should know about
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities,...
2013-03-26
1,466 reads
SQL Saturday #187–Richmond Recap
I’m late writing this, and I did mean to get to it earlier, but life got in the way.
TL;DR: It...
2013-03-26
1,085 reads
SQL Server: Purging msdb History Tables to Control msdb Database Growth
From time to time, I see the following question posted on various SQL Server forums by different users asking why...
2013-03-26
1,550 reads
Sub query pass through
Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...
2013-03-26 (first published: 2013-03-22)
3,586 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
Alamat BCA KCU Pantai Indah Kapuk Tlp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal...
Alamat Kantor BCA KCU Taman Duta Mas Tlp:0817825533
Hub Via Wa:62817825533 Alamat: ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, RT.14/RW.11,...
Alamat Kantor BCA KCU Tanjung Priok Tlp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers