Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9
Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...
2012-03-20
1,801 reads
Blog Posts
PASS for Today (and Tomorrow)
I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...
2012-03-20
582 reads
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then possibly a manager or client. Usually this comes up...
2012-03-20
1 reads
SSIS: Script Component Asynchronous Transformation
The SSIS script component can be configured to use synchronous or asynchronous outputs. If the script component is configured for...
2012-03-20
8,130 reads
24-Hours of PASS - Be on-time!
Right on the heels of the recent SQL Server 2012 virtual online launch event (as in virtually not there :-), a...
2012-03-19
1,800 reads
Another Interesting Sort
In October of 2011, I shared an example of a peculiar set of sort requirements. Today, I am going to...
2012-03-19
842 reads
Another Interesting Sort
Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:
Creative Database Naming January 2, 2020...
2012-03-19
3 reads
Columnstore Indexs
Columnstore Indexes for Fast DW
The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...
2012-03-19 (first published: 2012-03-15)
4,040 reads
Looking to Windows 9
I haven’t played with Windows 8 yet, and only a little with Windows Phone 7, but I am a little...
2012-03-19
1,394 reads
Powershell - Working with Cluster Resources - Byte Arrays
Over the next few weeks, I plan to share some of the discoveries I've had when working with Windows 2008R2...
2012-03-19
2,440 reads
Blogs
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...
Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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...
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