Versioning Over Time
How do you handle the tracking of changes across time in a database? Not auditing, but the actual structural and schema changes. Steve Jones talks about some of the issues with rapidly changing versions.
2008-12-11
353 reads
Editorial
Alone Time
Working in a distributed team can be challenging, but working in an office can be just as difficult. Steve Jones talks a bit about time management today.
2008-12-10
173 reads
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
2008-12-08
243 reads
The Need for Auditing
Is C2 auditing widely used? Should it be more widely used? Steve Jones talks about the subject of auditing in today's editorial.
2014-09-16 (first published: 2008-12-08)
666 reads
Data Vices
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
2014-09-12 (first published: 2008-12-05)
162 reads
Just Keep Going and Going and Going
The upgrade treadmill might hit you in ways that you didn't expect.
2008-12-04
135 reads
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-03
123 reads
2008-12-02
198 reads
The Full Potential of SQL 2000
Attending a conference and hearing about all the latest and greatest new features is a bit like spending holiday sampling exotic seafood and imbibing strange new cocktails. When you return, you're decidedly in the mood for a pie and a pint of beer.
2008-12-01
349 reads
The Wild Fringes of SQL Server Development
We can now clearly see two opposing trends in the way SQL Server is being used in applications. The dumb database brigade regards SQL Server as simply a 'data dump'. The 'database fanatics' think SQL Server on its own can meet the needs of all but the most demanding applications. Can these opposing trends be reconciled? Tony Davis would like to think so.
2008-12-01
227 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