Red errors in the results pane
Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed...
2012-12-27 (first published: 2012-12-19)
2,098 reads
Kenneth Fisher
Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,032 reads
Generating multiple SQL statements from a query
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,139 reads
Logins vs Users
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....
2012-12-12 (first published: 2012-12-03)
3,660 reads
Copying Connection Managers in SSIS
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit...
2012-12-10
1,550 reads
Creating an empty table from a SELECT statement
I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W....
2012-11-30 (first published: 2012-11-26)
4,616 reads
CTEs beyond SELECT
The other day I was writing a query to pull some DMV information and I ended up using several CTEs...
2012-11-20
1,979 reads
Looping through multiple servers in SSIS Part 3
Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...
2012-11-15
2,805 reads
2012-11-15
2,054 reads
Looping through multiple servers in SSIS part 2
Last week I posted a quick example of looping through multiple servers using SSIS and being in a bit of...
2012-11-12 (first published: 2012-11-09)
2,779 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