A Scary Comparison
What changes are coming in the editions for SQL Server 2008. Steve Jones finds a rather scary piece of literature.
2008-04-02
549 reads
Editorials
April Bloopers
Steve takes a day off from the editorials with this blooper reel from the podcasts. Be sure to watch the video.
2008-04-01
193 reads
The Exceptional DBA
There are many SQL Server DBAs with an intimate knowledge of how SQL Server works, the operating system, hardware and so on. They have the skills to keep a production system running without a hitch. It is no longer enough.
2008-03-31
1,012 reads
The March Car Update
Steve Jones' bimonthly update on the state of transportation and what's happening with his Prius.
2008-03-31
286 reads
The Credit Debate
As databases grow, we store more and more types of data. This Friday's poll asks what types of data you don't want to store.
2008-03-28
119 reads
Social Software
More and more companies are looking to use social software, like Facebook, to link employees, but is this a good thing?
2008-03-27
187 reads
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-26
117 reads
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
2008-03-25
57 reads
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
2008-03-24
65 reads
Feature (In)Complete
A look at some of the interesting database news from the previous week (March 24, 2008).
2008-03-24
208 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
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...
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