Query the status of SQL Agent jobs
I’ve been involved in building a solution on top of SQL Server peer to peer replication (SQL 2014 SP1) and...
2016-03-17 (first published: 2016-03-15)
2,982 reads
I’ve been involved in building a solution on top of SQL Server peer to peer replication (SQL 2014 SP1) and...
2016-03-17 (first published: 2016-03-15)
2,982 reads
After a data centre power outage a decision was made to switch the start up mode of a bunch of...
2015-06-19 (first published: 2015-06-11)
1,764 reads
A colleague of mine discovered an interesting behaviour change from SQL Server 2012 to SQL Server 2014. We recently upgraded...
2015-06-02 (first published: 2015-05-21)
2,928 reads
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
600 reads
The page came at a reasonable hour. All of the overnight ETL and processing jobs were just winding up before...
2015-01-21 (first published: 2015-01-15)
6,537 reads
I recently came cross another great reason to enable the remote admin connections server configuration on SQL server.
If you don’t...
2014-11-06
1,027 reads
What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish...
2014-10-21 (first published: 2014-10-15)
7,645 reads
The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to...
2014-10-15 (first published: 2014-10-07)
6,040 reads
Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During...
2014-05-15 (first published: 2014-05-07)
4,193 reads
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
780 reads
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi I need to grant a user access to a DB on the server...
I have this table that unfortunately has spaces in the field, which I am...
It's been a long time since I set up a 2012 server. We have...