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
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
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 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
Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.
2018-02-26
5,733 reads
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,379 reads
Are you struggling with a laggy redo and a build up in the redo...
The post Jan Vaněk: Na podpis smlouvy jsem přišel v kiltu a teď vedu...
Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers