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)
917 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,322 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,774 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,934 reads
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
610 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)
7,481 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,035 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,699 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,062 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,512 reads
By alevyinroc
The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
By Steve Jones
Today’s coping tip is to find a new way to use one of your...
Comments posted to this topic are about the item How Important is Software?
Could you give me advice on where I should learn SQL and Python to...
Hello, I have a very simple query Select * from Employees where company...
Ask SSC