SQL Server Reserve 1 user connection for DAC (Dedicated Administrator Connection)……want to confirm ?
Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm...
2013-01-21
760 reads
Blog Posts
Photo cataloguer
If you are anything like me, by know you will have a few thousand digital images spread across multiple directories...
2013-01-20
733 reads
Good Bye 2012 and welcome 2013
Hey Everyone….. from quite some time I have not written Blogs due to some personal and transiting from my old company...
2013-01-19
740 reads
Got "Cannot generate SSPI context" error message after changing sql service account
Today I changed a sql server service startup account during testing, then when I tried to connect sql server with...
2013-01-19
12,476 reads
2013 Polar Plunge #SQLPlunge
Next month… on March 2… I’m going to jump into a lake in Minnesota. Now it’s cold in Minnesota. In...
2013-01-18
645 reads
Day 16 of 31 Days of Disaster Recovery: Disaster Recovery Gems From Around The Net
It’s day 16 of my series 31 Days of Disaster Recovery. I’ve seen a lot of great DR related posts...
2013-01-18
914 reads
Example of SQL Server table partitioning
Recently, one of my favorite customers asked me some very thought-provoking questions about using database partitioning to move transactional data around. Their...
2013-01-18 (first published: 2013-01-14)
14,962 reads
New Year Aspirations – Mark Broadbent – SQLSaturday
I’ve known you for quite a while now through Twitter and later at SQLBits (your mum was right kids, don’t...
2013-01-18
1,121 reads
Reblog: January 11 to January 17
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-18
593 reads
Variable Scope in SQL Server
The way variable scoping works in SQL Server has been well documented on MSDN, but I have seen related issues...
2013-01-18
2,838 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
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers