When was SQL Server last restarted?
How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...
2010-04-29
6,178 reads
SQLSaturday #41 - Atlanta Session Recap
Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see...
2010-04-29
1,448 reads
PASS Update #29
By the time you read this we’ll have completed the transfer of the SQLSaturday web sites and data to PASS...
2010-04-29
1,460 reads
A DMV a Day – Day 29
The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as:
Returns information about the connections established to this...
2010-04-29
2,916 reads
A Identity Bug
Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
drop table aa
create table...
2010-04-29
2,226 reads
How to Tell When SQL Server Started?
As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to...
2010-04-28
1,855 reads
SQL Server Connection Strings
The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...
2010-04-28
13,587 reads
Undocumented Capabilities of Extended Event Objects
Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...
2010-04-28
2,176 reads
SQL University Post Coming Tomorrow
This is a short note to say that the SQL University post will arrive tomorrow. Today we're dealing with the...
2010-04-28
1,447 reads
Social Networking and SQLSaturday
I think we do a pretty good job of delivering technical content, but not such a great job at getting...
2010-04-28
1,467 reads
Blogs
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...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Alamat Kantor BCA KCU Pluit Telp:08218154374
Hub Via Wa:628218154374 Alamat: Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit,...
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