All Data Readers Are Evil
The DBA's Mantra: All data readers are evil. Steve Jones talks about a proposed corollary that might be appropriate to ensure security.
2008-04-29
175 reads
Editorials
Easy or Hard
How should we build tools? Should they be easy to use? Or does it make sense to have some things hard to do so that only experienced used choose them. Steve Jones comments on usability and the implications of your choices.
2008-04-28
98 reads
The Exceptional DBA: Soft Skills
If impeccable technical skills are a "given", what are the soft shills that will make you an Exceptional DBA rather than a competent DBA?
2008-04-28
1,461 reads
Seeing Double
SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.
2008-04-25
151 reads
2008-04-24
123 reads
The April Energy Update
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
2008-04-23
100 reads
Table Level Access
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-22
547 reads
The Inmates in Charge
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-21
96 reads
The Skill Set of the Exceptional DBA
In my previous editorial on this topic, I stated that the An Exceptional DBA is defined more by what they do than what they know. Judging by the responses, there is little disputing this fact among DBW readers. However, before we accept technical knowledge as a "given", and move on, I'd like to consider the […]
2008-04-21
1,355 reads
Up or Down?
How does the job market look this year for DBAs? Steve Jones asks the SQL Server community for their thoughts on the current employment outlook.
2008-04-18
248 reads
Blogs
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
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