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
758 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
731 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
731 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,474 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
634 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
907 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,940 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,118 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,834 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers