Building a Data Center
A data center is a complex beast. Is it worth building and maintaining your own? Steve has a few thoughts on a data center versus a cloud.
2025-02-05
155 reads
Editorials
Words vs Data
Are you clear in your reporting. Steve notes that sometimes we might leave too much up to interpretation by the end user.
2025-02-03
93 reads
Throwing Iron at the Cloud and AI
As organizations move to the cloud, the once essential role of the Database Administrator (DBA) as the guardian of system optimization, has been overshadowed, often viewed as a bottleneck to innovation. Yet, as technology evolves, the one thing I know is history repeats itself, and optimization skills are once again emerging as a critical necessity. […]
2025-02-01
91 reads
Data Debt
The idea of data debt seems both silly and obvious to Steve. We all have too much data and it's out of control.
2025-01-31
149 reads
Creating vs. Maintaining
When you create something, do you think about the future? Steve asks the question today.
2025-01-29
141 reads
The Era of Cloned Humans
AI has tremendous possibilities but also a number of security issues. Steve highlights one scary security issue today.
2025-01-27
115 reads
Technical Pain Behaviors
In my family’s history of the past 10+ years, we have become well versed in nagging, ongoing, non-debilitating pain. In some ways, the lessons we have learned about physical pain correlate all too well to the types of pain that we technical people are involved with daily. But there is a huge difference, even if […]
2025-01-25
80 reads
Can You Become a More Productive Engineer?
Steve has a few thoughts on becoming more effective. This involves more than just becoming a better coder.
2025-01-24
157 reads
The AI Budget Assistant
Most of us don't work on budgets, but we are affected by them. Is it a good idea for IT management to use AI to help plan their budgets? Steve has a few thoughts today.
2025-01-22
99 reads
Why Tools Can Help You Do Your Job
This editorial was originally published on May 18, 2019. It is being re-run as Steve is on holiday. Back in my days as a SQL server DBA, I didn't have many third-party tools at my disposal. I remember having a monitoring tool with licenses for only three or four SQL server instances. Whenever there was […]
2025-01-20 (first published: 2019-05-18)
378 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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