Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I...
2010-05-06
3 reads
Blog Posts
Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I...
2010-05-06
3 reads
American Express PASS Card (Not What You Think)
Had logged in to American Express check my business account and noticed this on on the front page – a PASS...
2010-05-05
580 reads
Getting a Page of Results
The other day I was looking over a couple of articles on paging, looking to see if I could learn...
2010-05-05
407 reads
New SQL Server Standard: Resource Governor by Roy Ernest
The latest issue of the SQL Server Standard is available for download (login required, free registration). Volume 7 Issue 4...
2010-05-05
733 reads
Review: SSD Tweaker
Ran across this while doing some other reading, SSD Tweaker lets you change a few settings that are supposed to...
2010-05-05
572 reads
SQL 2005 TableSpace
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These...
2010-05-05
4,693 reads
SQL Server Integrity Checks – DBCC CHECKDB
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it....
2010-05-05
2,180 reads
Using CPU-Z to Discover Hardware Information
I think it is very important to be able to discover exactly what type of hardware is in an existing...
2010-05-05
1,004 reads
Winner of the April SQL Aloha Contest
This month’s question had 28 responses, and as usual, I found it difficult to select a winner because all of...
2010-05-05
495 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...
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