Ctrl-alt-geek

Query the status of SQL Agent jobs

• by Matt

• Ctrl-alt-geek

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

Drop down boxes not working in SQL Server 2012 Configuration Manager

• by Matt

• Ctrl-alt-geek

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

Behaviour change for delete … output … into in SQL Server 2014

• by Matt

• Ctrl-alt-geek

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

The most recent backup problem

• by Matt

• Ctrl-alt-geek

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

Space issues with SSIS temp files

• by Matt

• Ctrl-alt-geek

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

Another great reason to enable remote admin connections

• by Matt

• Ctrl-alt-geek

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

Tracking down CPU spikes using process explorer and DMVs

• by Matt

• Ctrl-alt-geek

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 full text error and why I was happy to see it.

• by Matt

• Ctrl-alt-geek

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

Migrating SQL Server logins

• by Matt

• Ctrl-alt-geek

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

Rolling back transactions with cursors and local variables.

• by Matt

• Ctrl-alt-geek

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