2018-03-26
95 reads
Editorial
Ad Hoc Logs
We often make changes to production systems in an ad hoc manner. Steve asks how much auditing we might have in place.
2018-03-23
78 reads
More SQL Server Updates
Updates this week for SQL 2014, 2016, 2017 and SSMS have Steve thinking about the pace of patching.
2018-03-22
68 reads
2018-03-21
117 reads
Are You a Traffic Cop?
A traffic cop isn't a great analogy for a DBA, but all too often it is an accurate one.
2022-09-19 (first published: 2018-03-20)
291 reads
If only the US would follow ...
Governments are requiring better security, and Steve wishes the US would follow.
2018-03-19
96 reads
2018-03-19
99 reads
2022-09-26 (first published: 2018-03-16)
373 reads
Great Developers Use Source Control
The title says it all. The great developers will use source control. This habit might not make you great, but it will help you improve.
2018-03-15
91 reads
2018-03-14
110 reads
Blogs
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...