MS SQL Server 2014 Mirroring – thanks for being alive!
I decided to check if there is still database mirroring option in MS SQL Server 2014
Wow! It works!
MIrroring is still...
2015-10-08
594 reads
Blog Posts
MS SQL Server 2014 Mirroring – thanks for being alive!
I decided to check if there is still database mirroring option in MS SQL Server 2014Wow! It works!However in the screenshot you see a message that new tables “in...
2015-10-08
9 reads
MS SQL Server 2014 Mirroring – thanks for being alive!
I decided to check if there is still database mirroring option in MS SQL Server 2014Wow! It works!However in the screenshot you see a message that new tables “in...
2015-10-08
8 reads
Session Event Metadata
There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to...
2015-10-08 (first published: 2015-09-29)
1,681 reads
A Long Trip Ahead
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
562 reads
A Long Trip Ahead
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
396 reads
Backup Database
One of the most important processes for a DBA is backing up and restoring a database. In its simplest form,...
2015-10-07
238 reads
Do you write ugly T-SQL?
Are your scripts littered with commented blocks of T-SQL code?
select fname,lname
from usertable
where id=1
--and lname like 'smith%'
/*
-- Who knows why...
2015-10-07 (first published: 2015-09-29)
6,367 reads
Exposing Deployed Event Metadata with PoSH
In the last article I introduced a power tool that can be used to help manage Extended Events. That tool is...
2015-10-07
509 reads
Exposing Deployed Event Metadata with PoSH
Now that some of the basics concerning how to access Extended Events via PowerShell have been covered, it is appropriate to start digging in a little deeper. This deeper...
2015-10-07
3 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