Your Password has Failed the Test
Your data is in the public domain and as a DBA you need to be very familiar with what it is possible for the sinner to do with a handy password, and how easily that sinner can get hold of it.
2012-10-08
152 reads
Editorial
Fragmentation Fear
Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?
2012-10-01
393 reads
Challenge Yourself
Challenge yourself to find new tools and use them in your work. That's today's message from Steve Jones. (This editorial was originally published on Aug 5, 2007. It is being re-run as Steve is away on the SQL in the City US 2012 tour.)
2012-10-01
305 reads
Outsourcing Security
Companies may look to outsource security in order to take advantage of experts' skills at a lower price. What will that mean for data professionals?
2012-09-27
113 reads
Pair Programming
Today Steve Jones talks about pair programming and when it might make sense for data professionals.
2012-09-26
187 reads
Trade-offs
When working on a project, you have to make trade-offs. Unfortunately, some managers don't realize this. Steve Jones says we need to help them understand that doing things the right way, and working with trade-offs, makes for better systems.
2012-09-25
137 reads
Rewrite the Coding Rules
If we rewrite the coding rules, will software be more secure? Steve Jones thinks it might and that we should be constantly looking to change the techniques, patterns, and skills we have.
2012-09-24
209 reads
IT is Looking Good
The forecast for IT work is growing. That's good for those of us working in the field.
2012-09-24
169 reads
Teammates
This Friday Steve Jones wants you to have some fun and compare yourself to an athlete or media figure, or even a fictional character.
2012-09-21
139 reads
Data Worms
Worms have been around a long time in computer systems. However changes in the global policies of governments and the possible retaliation for cyber warfare should have DBAs concerned.
2012-09-20
154 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