What the heck is downtime, anyway?
There’s a lot of discussion about preventing downtime. As a DBA and IT professional, it’s my sworn duty to prevent downtime. I usually describe my job as DBA something...
2019-04-15
Database Administration
How do I let someone execute a SQL Agent job they don’t own?
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that ... Continue reading
The post How do I let someone...
2019-04-15
SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea
By default, when you run a query in SQL Server, your delete/update/insert (DUI) is finished as soon as your query finishes. That’s because the default behavior of SQL Server is IMPLICIT_TRANSACTIONS OFF – meaning, SQL Server doesn’t hold your queries open waiting for a COMMIT or ROLLBACK.
2018-03-14
3,761 reads
Changing Data Types on Large Tables: The INT to BIGINT Conundrum
Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.
2018-03-13
10,620 reads
How to Suck at Database Administration
Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.
2018-02-26
5,733 reads
Are you bad enough to join the DBA Team
If you've ever had a terrible day, send in your story and Grant and Steve will pick their favorite to be spiced up DBA-Team-style. The winner will also be given a ticket to SQL Cruise 2015. Find out how to enter.
2014-09-10
1,380 reads
Blogs
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors...
SQL Server Quickie #45 – SQL Server Availability Groups
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...
Daily Coping 21 Mar 2023
By Steve Jones
Today’s coping tip is to listen to a piece of music without doing anything...
Forums
How much RAM in an Azure Database on Pay As You Go
Ive been doing some benchmark testing using an application, running this on my local...
Centralized SSIS Server?
Has anyone every created / managed a centralized SSIS server? We have a virtualized...
Ask SSC