2018-12-03
72 reads
Editorial
Data with Provenance
File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.
2018-12-03
385 reads
Understanding a Database
The ways in which you might try and reverse engineer a database design are on Steve's mind today.
2025-03-10 (first published: 2018-11-30)
317 reads
2018-11-29
79 reads
Mitigate Issues Early
When you know there's a problem, it's better to solve it early rather than late.
2018-11-28
59 reads
Building Better Training Opportunities
Finding training opportunities can be a challenge in many organizations.
2018-11-27
60 reads
Choosing a Career
Learning about new jobs is a good way to help decide if you want to change careers.
2018-11-26
78 reads
Moving to Query Store
Steve is looking for people to use the Query Data Store and share their stories, good or bad.
2018-11-26
74 reads
2018-11-22
43 reads
Another Reason to Care About Security
Just before the US holiday, Steve wants you to think about the security of our systems.
2018-11-21
54 reads
Blogs
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...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
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