Heartbleed bug: immediate security threat for both IT, and consumer sites and services
“An encryption flaw called the Heartbleed bug is already being called one of the biggest security threats the Internet has...
2014-04-10
694 reads
Blog Posts
I’m a Traveling Man
We are coming into quite a busy time for my speaking schedule. I’m hitting the road. It does one thing...
2014-04-10
790 reads
Rolling back transactions with cursors and local variables.
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
799 reads
Smart Moves with SQL Server VMs – Data Movement
Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to...
2014-04-10
960 reads
Webcast Follow-Up: Introduction to Columnstore Indexes
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-04-10
836 reads
Analyzing CXPACKET waits
One of the most common wait types you will see on a SQL Server is the CXPACKET wait type.
This...
2014-04-09 (first published: 2014-04-04)
4,806 reads
Dedicated Administrator Connection
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-09
695 reads
this isn’t thunderdome
When I received my first MVP award for SQL Server it was fairly abstract to me until I went to...
2014-04-09
730 reads
Vote for me at SQLBits
SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted...
2014-04-09
818 reads
Webcast Follow-Up: Introduction to Clustered Indexes and Heaps
Last month, I presented a session for Pragmatic WorksTraining on the T’s titled Introduction to Clustered Indexes and Heaps. I’d meant to...
2014-04-09
763 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