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,396 reads
Blogs
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
A Small LLM Fail
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
SQL Server Versions: Out With the Old, In With the Supported
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?)
We have an issue where SSIS packages are failing with a status of "ended...
SQL Newbie HELP: The query references an object that is not supported in distr..
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
Question of the Day
Slip Streaming Installs
What does a slipstream installation mean?
See possible answers