Speaker Issues: The Quandry of Double Submitting
This is in response to yesterday’s Twitter conversation, and subsequent blog by Eddie Wuerch, about submitting to more than one...
2012-05-01
791 reads
Blog Posts
Thank God I Chose SQL Server part II: How to Improperly Install Oracle 11gR2
As part of my ongoing effort to teach by bad example and pass on what little I’ve learned about programming...
2012-05-01
3,545 reads
The 2012 Powershell Scripting Game(shows) in review
Over the past few weeks, those around me know that I’ve been talking a lot about Powershell, how much it...
2012-05-01
1,190 reads
When Will You Upgrade to SQL Server 2012?
This is a reprint from my editorial in Database Weekly. Also, check out the May Question of the Month, as...
2012-05-01
1,240 reads
Blogging Tools: BlogDesk Review
As a blogger, you have several options available to you when it comes to writing posts. You can write them...
2012-04-30
2,211 reads
Changing DB_CHAIN Can Clear the Plan Cache
If you make changes to the settings of a database, it can cause the procedure cache to be cleared. Microsoft...
2012-04-30
1,763 reads
Generate restore script automatically by backup history table
I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select...
2012-04-30
6,972 reads
Less Energy through Better Design
When I attended SQL Saturday #131 at the Chandler Gilbert Community College, I was struck by a few design elements...
2012-04-30
1,997 reads
Locked out of SQL Server.
This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...
2012-04-30
2,633 reads
SQL Saturday #131 Recap
This past weekend I attended a SQL Saturday in the desert. SQL Saturday #131 was held in Phoenix, AZ
It’s April,...
2012-04-30
1,918 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