S3OLV August Recap
The SQL Server Society of Las Vegas meeting has come and gone once again. This meeting is held typically on...
2010-08-16
432 reads
SQL RNNR
TSQL Tuesday 009 Roundup
T-SQL Tuesday #009: Beach Time
I hope you enjoyed your time in the sun with your toes in the sand. We...
2010-08-13
793 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
743 reads
R & R
It is once again time for the blog party known as TSQL Tuesday. I am hosting this month and wanted...
2010-08-10
611 reads
August SSSOLV Reminder
Just another reminder about the Las Vegas User Group meeting coming up on August 12th.
Here is the info:
The S3OLV UG...
2010-08-10
468 reads
August S3OLV UG Meeting
It is nearly UG meeting time once again. The S3OLV UG will be meeting Thursday August 12 at 6:00. Come...
2010-08-04
477 reads
TSQL Tuesday Coming Up
The next TSQL Tuesday is only 1 week away. This month the topic covers getting a little R&R. We would...
2010-08-03
442 reads
Defensive Db Programming Chapter 03
Chapter 3 of the Defensive Database Programming Book by Alex Kuznetsov teaches us about how to “survive” changes to database...
2010-07-26
1,658 reads
5 down 4 to go
Not much ado about SQL Server here. Good things come with the number 9. For instance SQL Server got substantially...
2010-07-23
519 reads
A little Dance with SSIS and Informix
Not too many moons ago I embarked on porting some servers over from SQL 2000 to SQL 2008. On some...
2010-07-23
1,563 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