Is It that Time Again?
Yes, it is. As I mentioned a few months back, it is important to pay attention to when Microsoft releases...
2010-09-23
500 reads
StrateSQL
Index Black Ops Part 3 – Index Usage
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...
2010-09-22
1,449 reads
September PASSMN Meeting Tonight
As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location. This is a ...
2010-09-21
434 reads
SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
820 reads
September PASSMN Meeting This Week
Enjoying the fall here in Minnesota? The leafs are changing a bit and temp has been dropping. Has that left...
2010-09-20
507 reads
Share Your Experiences at #SQLSAT58
Ever thought about sharing your experiences with SQL Server to more than just your immediate peers and colleagues? Up here...
2010-09-20
630 reads
Index Black Ops Part 2 – Page IO Latch, Page Latch
As I mentioned in my TSQL2sDay index summary post, the I am writing a few posts on the information that...
2010-09-16
3,101 reads
Index Black Ops Part 1 – Locks and Blocking
As I mentioned in the my TSQL2sDay index summary post, the next few posts will be on sys.dm_db_index_operational_stats and the...
2010-09-15
1,395 reads
September PASSMN Meeting Next Week
Ever feel like you are all alone? Maybe a little isolated? This month’s PASSMN meeting might bring up these feelings...
2010-09-15
618 reads
An Index on Indexing #TSQL2sDay
Here we are with another T-SQL Tuesday and time for my entry into the fray. This month we are talking...
2010-09-14
717 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...
AI: 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