Using Technology In New Ways
An interesting reuse of technology in a completely new way caught Steve Jones' eye. See if you agree that this is rather amazing.
2012-07-19
148 reads
Editorials
Geeky Books
Today Steve Jones talks about one of his pastimes: reading. He recommends you read more, and share the books you enjoy.
2012-07-18
243 reads
Time Zones
Today Steve Jones complains a bit about time zone support in SQL Server and why it seems so cumbersome. Shouldn't it be easier in 2012?
2012-07-17
307 reads
A Cool Job
Today's editorial was originally published on August 21, 2007. It is being re-run as Steve is traveling. What a cool job it must be to try and tune and get the most performance out of a system.
2012-07-16
164 reads
Write Better Code
Better security can be achieved by writing better code. Steve Jones agrees, but doesn't think it's as easy as it sounds.
2012-07-16
267 reads
Kill a SPID
This editorial was originally published on Sept 5, 2007. It is being re-run as Steve is traveling. Today Steve talks about the potential problems with killing SPIDs in SQL Server.
2012-07-13
317 reads
One Single View
This editorial was originally published on Oct 9, 2007. It is being re-run as Steve is traveling. When I worked at JD Edwards, one of the goals of our business intelligence system was to house a single view of the truth. I recently saw a blog post by Andrew Fryer that does a good job of explaining what this actually is.
2012-07-12 (first published: 2007-10-09)
542 reads
Why It's Good To Be Wrong
Today we have a guest editorial from Hakim Ali. Being wrong is not as bad as you may think.
2012-07-11
455 reads
It's the Journey...
The story of how Shawn McGehee's journey to becoming a DBA started is just one among many thousands, so let's hear yours too!
2012-07-09
145 reads
Starting to Program
This Friday Steve Jones asks what resources might help the new DBA learn to program better. Pick the language of your choice and let us know what resources have worked well for you.
2012-07-06
309 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