It began with an error thrown by a linked server. The linked server is on our warehouse server and connects to our SSIS server using the “login’s current security...
2021-12-03 (first published: 2021-11-23)
1,320 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)
4,280 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,868 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,953 reads
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
647 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)
9,315 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,171 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)
8,018 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,110 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)
8,015 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Hi I have an overnight process that moves allot of claims records Been working...
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Comments posted to this topic are about the item Putting the Player with the...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers