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)
3,174 reads
Ctrl-alt-geek
Drop down boxes not working in SQL Server 2012 Configuration Manager
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,769 reads
Behaviour change for delete … output … into in SQL Server 2014
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,933 reads
The most recent backup problem
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
602 reads
Space issues with SSIS temp files
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,913 reads
Another great reason to enable remote admin connections
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,032 reads
Tracking down CPU spikes using process explorer and DMVs
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,681 reads
The full text error and why I was happy to see it.
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,053 reads
Migrating SQL Server logins
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,299 reads
Rolling back transactions with cursors and local variables.
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
783 reads
Blogs
A New Form of Address: Mx
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
Group By Starting Characters
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
Daily Coping 22 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Maybe It Is DNS
Comments posted to this topic are about the item Maybe It Is DNS
Finding all logins that can alter DDL
Hello experts, Is there a ready-made query out there that I could run on...
Insert records with a where
I want to insert record job allocations only for selected jobs I know the...
Ask SSC