Table Space updated again
Today we have another update for an age old script on this site. You can find the last update to...
2014-03-28
794 reads
SQL RNNR
Table Space updated again
Today we have another update for an age old script on this site. You can find the last update to the script here. This time we have a bit...
2014-03-28
7 reads
T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been...
2014-02-19
1,786 reads
T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made. At close, we saw 17...
2014-02-19
3 reads
Locks, Blocks, and Deadlocks Oh My!
Abstract
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out...
2014-02-12
831 reads
Locks, Blocks, and Deadlocks Oh My!
Abstract Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this...
2014-02-12
7 reads
Risking Health, Life and Family
Since announcing the topic last week for T-SQL Tuesday, I have thought about many different possibilities for my post. All...
2014-02-11
830 reads
Risking Health, Life and Family
Since announcing the topic last week for T-SQL Tuesday, I have thought about many different possibilities for my post. All of them would have been really good examples. The...
2014-02-11
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-02-06
823 reads
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-02-06
2 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