Scaling SQL Server
On Friday, October 14, 2011, I had the pleasure of delivering my new Scaling SQL Server presentation at the PASS...
2011-10-17
803 reads
Blog Posts
Self Service BI and PowerPivot
Marco Russo and Alberto Ferrari have written a book called Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I finally...
2011-10-17
1,235 reads
Simple XML exist performance enhancement
I came across this really simple best practice from BOL for the xml method exist which when used will give...
2011-10-17
1,975 reads
SQL PASS Summit 2011: Session Files
SQL PASS Summit 2011: Session Files
PASS Summit 2011
This past week was the SQL PASS Summit 2011 in Seattle, WA. I...
2011-10-17
1,419 reads
SQL University Lesson 3 Page Compression
Lesson 2: Internal Structures, Vardecimal, & Row Compression
Welcome to Lesson 3 on Compression and welcome back Dear Reader. I want...
2011-10-17
1,078 reads
The Demise of Jar Jar
Today we have a guest post from Steve Jones as Brad is on vacation.
Today we have the third question from...
2011-10-17
529 reads
Understanding Kerberos, Part I
A get a lot of questions where I work about Kerberos and how it works for SQL Server, whether we're...
2011-10-17
4,317 reads
PASS Summit, more people and lots of newbies!
Once again I am back at home recovering from another PASS Summit. This year the attendance has exceeded all expectations...
2011-10-16
1,395 reads
Setting up SSIS Auditing Part 1
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...
2011-10-16
1,718 reads
SQL PASS Summit Final Day (Sessions)
Here is a summary of the final day of sessions I attended at PASS. Vertipaq vs OLAP – Change Your Data...
2011-10-16
491 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