Is Data Modeling Common?
Today Steve tasks data modeling and wonders how many people still build and maintain models.
2025-11-24
124 reads
Editorials
Personal Contact Is Vital
I'm writing this while in hiding at the PASS Data Community Summit that's taking place in Seattle this week. I just had a real surprise, finding out that DocumentDB is PostgreSQL under the covers and always has been. However, as much as I enjoy talking PostgreSQL, for the moment, I'll shut up about it. Instead, […]
2025-11-22
72 reads
2025-11-21
150 reads
The case for "Understanding our business" training
Today we have a guest editorial reminding us that business knowledge is important, and we could all use some training.
2025-11-19
134 reads
Don't Create Workslop
AI can help us do more, but do we need to do more? Or more importantly, are we doing a good job of producing more useful stuff?
2025-11-17
186 reads
2025-11-15
98 reads
Being Mindful of Design Time
Do you take the time to model and design your database? Steve thinks this is important, even while trying to make changes quicker to adapt to changing requirements.
2025-11-14
95 reads
Internal Staff Growth
How do you approach adding to your team? Steve asks if you look internally or externally as a default.
2025-11-12
84 reads
Do You Really Need HA?
Steve asks the question about whether or not a particular environment really needs HA implemented.
2025-11-10
140 reads
Economics of AI: What is the Real Cost to Profit?
Artificial intelligence is everywhere: It’s in our tools, our workflows, our marketing pitches…and increasingly, in our bottom lines. But a thought-provoking article published recently on the AI bubble asks a far more sobering question: What’s it really going to cost to profit from AI? Many people will roll their eyes and say, “Isn’t that obvious? […]
2025-11-08
97 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers