Find Skew in Distributed Tables
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...
2012-09-11
1,515 reads
Blog Posts
Going to San Diego (#SQLSat157)
It appears that I signed up to speak at the San Diego SQL Saturday coming up this weekend. I knew...
2012-09-11
694 reads
Quick tip: Querying database metadata with DBCC DBINFO
Page 9 in file 1 (of the primary filegroup) in a SQL Server database is the header page and contains...
2012-09-11
2,119 reads
Talking Career and Unstructured Data
The Denver SQL Saturday is coming in less than two weeks, SQL Saturday #169 is our second event in Denver,...
2012-09-11
937 reads
T-SQL Tuesday – Help! I Need Somebody
By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need...
2012-09-11
888 reads
T-SQL Tuesday #34 – Help! I Need Somebody
I couldn’t resist, so here goes….
Help, I need some data,
Help, not just any data,
Help, I was told you...
2012-09-11
983 reads
Colorado SQL - September 2012
COLORADO SPRINGS SQL
September 19, 2012 at 5:30 p.m.
Meeting Location: Hyatt Place - Garden of the Gods, 503 West Garden of the Gods...
2012-09-10
872 reads
Demystifying SQL Server Differential Database Backups
Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...
2012-09-10 (first published: 2012-09-06)
2,803 reads
EXECUTE AS USER = ‘Somebody else’
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...
2012-09-10
742 reads
Have You Seen This Error?
location: AppendOnlyVerStoreMgr.cpp:776
Expression: 0
SPID: 64
Process ID: 4912
Description: Cannot locate version record and page is not allocated. Status = 3
Msg 3624, Level 20,...
2012-09-10
1,332 reads
Blogs
TempDB Internals – What’s New (Sql Server 2016 to 2025)
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...
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