Option missing in NTILE function?
Just saw something interesting....we have a requirement to divide a result set into a certain number of groups that have...
2010-06-09
752 reads
SSMS 2008 and changing a SQL 2005 SA password.
You can probably tell from some of my more recent posts that I have been doing some work lately on...
2010-06-09
1,687 reads
TechEd Impressions: Day Two
It’s only day two of the four day conference, and I am already exhausted from attending sessions from 8:00 AM...
2010-06-09
499 reads
Filter Jobs using SQL Server Job Activity Monitor
Using SQL Server Management Studio (SSMS), we have the capability of quickly looking at job related information to verify things...
2010-06-09
1,739 reads
SQL Saturday #22 Pensacola Recap
Saturday I drove up to Pensacola for SQL Saturday #22. Me and several others from Baton Rouge, including my two...
2010-06-08
706 reads
More Details About Engine Improvements in SQL Server 2008 R2 (SQLTuesday)
This post is for SQLTuesday #007, hosted by Jorge Segarra (blog | twitter). The topic is to talk about your favorite...
2010-06-08
1,744 reads
TechEd 2010 – Interview With Herain Oberoi
Herain Oberoi is a Group Product Manager for SQL Server and spent 30 minutes with me talking about StreamInsight and...
2010-06-08
553 reads
PASS Summit 2010 Abstract Submissions
I submitted three abstracts for the 2010 PASS Summit this year - two "normal" (75 minute) and one spotlight (90 minute)...
2010-06-08
477 reads
A Guitar is Just a Piece of Wood
In my real-life I play guitar. Being an analytical sort-of-fella I found myself inhaling all the books, videos, advice, etc....
2010-06-08
663 reads
TechEd 2010 – Tuesday Morning
Leisurely morning, leaving for the convention center about 8 am. Bus service has been great, they have a staff person...
2010-06-08
477 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
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
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