The Spring Event
I hope you’ve seen the note from Andy Warren (Blog | Twitter) on a PASS Spring Event, and there’s another writeup...
2010-06-22
1,128 reads
Blog Posts
Who2 Article Published
I just had my second article published on June 14, 2010 at SQLServerCentral. I will be posting a follow-up to...
2010-06-22
993 reads
Windows 2008 R2 Install Error - Using VMWare Workstation
Recently I was installing Windows Server 2008 R2 Enterprise Edition onto a virtual machine (VM) I was setting up to...
2010-06-22
2,308 reads
2010 Microsoft BI Conference: Directions in Microsoft BI
The combined Microsoft BI Conference and TechEd in New Orleans last week was a great
experience. The shear magnitude of the...
2010-06-21
1,160 reads
Feature Packs for SQL Server (and SSIS)
Some of the best extensions for Integration Services (and SQL Server itself) are found in what Microsoft has released as...
2010-06-21
2,064 reads
Football Update
Well the World Cup is now half way through, 32 games played, 32 games to go. The talk here in...
2010-06-21
492 reads
Inverter Obsession, or Why I am Starting to Hate Clouds
After getting my new grid-tied solar PV system turned on and operational on June 18, 2010, I have become temporarily...
2010-06-21
768 reads
PASS 2010 Election Nominating Committee Announced
Actually came out last week and I missed it, here is the link to the details of the nominating committee...
2010-06-21
650 reads
PASS 2011 Spring Event In Orlando
In March of this year the PASS Board of Directors began kicking around the idea of holding some kind of...
2010-06-21
878 reads
PASS RSS Feeds
Another “didn’t know” for me, we have multiple feeds from PASS HQ that focus on various areas – grab the entire...
2010-06-21
665 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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