First SQL Server UG Meeting in Harrisburg, PA
If you work with SQL Server and live in the Harrisburg area I have some great news for you. The...
2012-07-09
657 reads
Blog Posts
Group Think (or Groupthink)
I’ve thought about writing on this topic a couple times and was reminded of it again when I read a...
2012-07-09
1,188 reads
Identify and Alert for Long-Running Agent Jobs
Being a DBA is like being a train conductor. One of the biggest responsibilities is making sure all jobs are...
2012-07-09
11,262 reads
Lost in Translation – Deprecated System Tables – sysdatabases
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-09
1,327 reads
Moving xml child elements to its parent using XQuery
I haven’t been able to do much XQuery development recently which is a shame as I love developing with the...
2012-07-09
4,536 reads
Parallel Data Warehouse (PDW) Lesson 1: – Basic Architecture Overview
I’ll begin my coverage of Microsoft’s Parallel Data Warehouse (PDW) architecture / appliance with a brief overview of the Massively Parallel...
2012-07-09
1,104 reads
Purging MSDB Backup and Restore History Tables
Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...
2012-07-09
2,441 reads
Speaker Selection for SQLSaturday Orlando-Group #5
Three more added to the stellar slate of speakers for SQLSaturday Orlando, we look forward to seeing you soon!
Ira Whiteside
Devin...
2012-07-09
510 reads
Speaking at SQL Saturday 122 - Louisville
It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been...
2012-07-09
866 reads
SQL Audit 101 – Creating a basic audit
SQL Audit was introduced in SQL 2008, and for the first time auditing was treated as a “first-class” object in...
2012-07-09
2,387 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