Getting It Right First Time. Almost?
Mistakes happen but how can we minimize them and deal with them whey they do happen?
2014-08-05
228 reads
Editorial
A DBA at the Opera
In opera, tragedy or absurdity happens because the characters are incapable of standing back, and making a difficult decision. Instead, at every stage, they just drift towards their fate by taking the easy option. Don't let the same fate befall you, as a DBA.
2014-08-04
124 reads
Using Views
Views can be a great way to abstract away details for clients, but they can also make development much more flexible.
2014-08-01
345 reads
Monitoring for Non Existent Events
Many DBAs monitor for those events they expect to happen, either successfully or failed. However many DBAs wouldn't be aware of an event never occurring.
2018-02-28 (first published: 2014-07-31)
208 reads
Elevation of Privileges
The elevation of privileges is a large security problem and Steve Jones discusses his fears. Would you know if someone successfully attacked your instance?
2018-03-01 (first published: 2014-07-30)
285 reads
2014-07-29
187 reads
Frustration with Bad Design
It can be very easy for technology experts to get frustrated when they see bad design and practices, but you must be careful with how you go about trying to influence change.
2014-07-28
27 reads
Frustration with Bad Design
It can be frustrating to deal with poorly implemented systems, but Steve Jones notes that you can't take things into your own hands.
2014-07-28
305 reads
Summer, Summer, Summertime
This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?
2014-07-25
111 reads
2018-03-02 (first published: 2014-07-24)
201 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers