2012-04-09
54 reads
Editorial
The On-call Demands
This Friday Steve Jones asks about your on-call responsibilities and the load you face from after hours calls. If you're a DBA that doesn't work strictly 9-5 every week, let us know.
2012-04-06
169 reads
Treat the Database like Code
Steve Jones reminds us that our databases contain code, and as such, they ought to be under some type of version control.
2012-04-05
219 reads
My Little Friend
Today Steve Jones talks about his favorite feature in SSMS 2012 and why everyone should use it.
2012-04-04
627 reads
Too Many Bricks, Too Much Data
Too much data can be as much of a problem as too little. Today Steve Jones talks about some problems that we have in working with lots of data and how we might address the issues. Those that do well, will succeed in the future.
2012-04-03
194 reads
Skipping April Fools
No April Fool's jokes from SQLServerCentral this year and Steve explains why today.
2012-04-02
283 reads
Replace existing Database? JFDI!
Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…
2012-04-02
153 reads
Backup and Restore
Today's editorial was originally published on May 13, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about the need to train yourself, just like people in other professions.
2012-03-30
214 reads
The Mechanical Turk
Today's editorial was originally published on Apr 17, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve talks about the Mechanical Turk process at Amazon.
2012-03-29
223 reads
Is Computer Science Dead?
Today's editorial was originally published on Apr 27, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve talks programming.
2012-03-28
374 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