Meet Thomas Kejser in Aarhus
This is normally not a place where we advertise for events held by our friends, but today I’ll make an...
2012-09-06
759 reads
Blog Posts
Reducing Your Storage Footprint Using SQL Storage Compress
I was asked to speak at SQL in the City in New York and Austin Texas. I have used many...
2012-09-06 (first published: 2012-09-04)
1,906 reads
SQLskills joining Pluralsight is a good news for all
Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded...
2012-09-06
1,081 reads
Stressed? Need training? Take a #SQLCruise!
I can’t tell you how many times I’ve sat in a training room, in the middle of a week long...
2012-09-06
979 reads
The MERGE statement in SQL Server
The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based...
2012-09-06 (first published: 2012-09-05)
4,799 reads
This is Big Data
I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.
A day.
That’s...
2012-09-06
976 reads
“It’s Alive” - SSIS Design Patterns
I’m happy to announce that the book I’ve been working on for the past two years is complete and has...
2012-09-05
998 reads
“It’s Alive” – SSIS Design Patterns
I’m happy to announce that the book I’ve been working on for the past two years is complete and has...
2012-09-05
570 reads
Error: ACCESS DENIED on installation
Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services....
2012-09-05
897 reads
Installing SQLServer for SCCM 2012 – Some points to note on patch levels
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)
For...
2012-09-05
1,684 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