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,281 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)
3,813 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,818 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,938 reads
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
631 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)
8,897 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,100 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,875 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,088 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)
5,815 reads
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I'm using the below connection string using providing UserID and password on their respective...
Comments posted to this topic are about the item Knowing Your Total Reward