2022-08-03
477 reads
Database Administration
2022-06-29
471 reads
SQL Database Snapshots for Reporting, Auditing and Data Recovery
In this article we look at how to create a SQL Server database snapshot and how snapshots can be used for reporting, auditing and more.
2022-06-27
SQL Database Overview
Learn about what a SQL database is, what is stored in a database and how to interact with a database.
2022-06-17
2022-05-23
451 reads
2022-01-12
373 reads
2022-01-05
612 reads
Challenging Trends
Steve notes the changes in the world might affect how to view and use data in our work.
2022-01-05
280 reads
Data Cleanup
Steve wishes we could do some data cleanup and archival every year. Or even more often.
2022-01-03
326 reads
2021-12-06
396 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
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...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries