Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.
As the famous Bard once said, “To disable indexes or not to disable indexes, that is the question?”. Well maybe...
2017-09-25
151 reads
UNDERCOVER TOOLBOX: Sp_ChangeJobOwnerShip – Changing Ownership in bulk.
How many times have you seen SQL Agent jobs with random ownership? It can be very frustrating when you are...
2017-09-25
163 reads
UNDERCOVER TOOLBOX: sp_Snapshot – The Easy Way To Create Database Snapshots for One or Many Database
sp_Snapshot is a procedure that we’ve written to quickly and easily create a database snapshot of one or multiple databases.
Prerequisites
sp_Snapshot...
2017-09-20
137 reads
Blogs
Focus on Core Skills
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
A New Word: Zverism
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Forums
Move Files SSIS Task
Hi I have a task in my SSIS package that moves files from source...
Migrating mission critical database from SQL on Prem to Azure SQL
We are migrating our environments to Azure, it will be a mix of SQL...
The Inefficiencies of Kubernetes
Comments posted to this topic are about the item The Inefficiencies of Kubernetes
Question of the Day
The Backup Space Needed
How do I calculate the amount of space needed for I/O buffers during a backup operation?
See possible answers