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
Database Administration
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,374 reads
Blogs
It’s 2021, so why are you reading this?
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
Daily Coping 20 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
[Coping] Hidden Wounds
By Brian Kelley
Through high school and college, I carried deep wounds due to what was going...
Forums
update using self-join - confirm it looks at old values
I'm doing an update using a self-join, and just want to confirm something. If...
Representative Data Challenges
Comments posted to this topic are about the item Representative Data Challenges
The CAST operator in PostgreSQL
Comments posted to this topic are about the item The CAST operator in PostgreSQL
Ask SSC