Be Prepared with Baselines
Analyzing performance often requires you to understand what is normal and what is not. Steve talks about the importance of baselines.
2018-06-11
72 reads
Editorial
Better Comments
Is there a best way to comment code? Or maybe just different styles. Steve Jones asks what you think today.
2018-06-08
98 reads
2018-06-07
80 reads
2018-06-06
153 reads
2018-06-05
65 reads
2018-06-04
127 reads
Do We Understand Data?
With the recent issue of Facebook/Cambridge Analytica and GDPR, I ask do we really understand "data"?
2018-06-01
173 reads
2018-05-30
75 reads
2018-05-29
70 reads
Are you GDPR Ready?
With the GDPR in effect, Steve Jones talks about the changes that are taking place for many organizations.
2018-05-28
74 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