Reblog: July 18 to July 24
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-07-25
811 reads
Blog Posts
Speaker Buddy System
SirSQL made a rather stirring post recently. He talked about a speaker buddy system to help out new speakers in...
2014-07-25 (first published: 2014-07-21)
7,998 reads
Speaking on ETL Security
I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.
Securing...
2014-07-25
875 reads
SQLBits XII Recap
There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones.
There is a technological event...
2014-07-25
207 reads
SQLSaturday Porto Edition 2014 Selection Process Results & Voting
This blog post is a continuation of the initial announcement almost a month ago about the session selection process that...
2014-07-25
211 reads
SSIS: Value does not Fall Within the Expected Range
Every now and again I find myself working with SSIS for one reason or another. Every now and again I...
2014-07-25 (first published: 2014-07-17)
32,267 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
630 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
131 reads
Webinar Q&A: Getting Started with Change Data Capture
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics...
2014-07-25
1,464 reads
Clustered Columnstore Indexes – part 35 (“Trace Flags & Query Optimiser Rules”)
Continuation from the previous 34 parts, starting from http://www.nikoport.com/2014/07/20/clustered-columnstore-indexes-part-34-deleted-segments-elimination/
This blog post is about controlling some of the Columnstore Indexes behaviours...
2014-07-24
382 reads
Blogs
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
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