Separation of interface from implementation
One of the supposed advantages of the EF is that it abstracts you from
your database implementation. This is considered to...
2010-07-11
1,315 reads
Blog Posts
Sunday Morning Work
Up early, the only one in the house, so I made coffee, sat down to check on SSC and the...
2010-07-11
344 reads
Making A SQLPS Module
If you’re working with PowerShell and SQL Server one of things you’ll want to to do is load the SQL...
2010-07-10
3,247 reads
Windows Search Enable Your Script Files
At the July 8th Tampa PowerShell User Group meeting, Ed Wilson (blog|twitter) gave a presentation on “PowerShell Best Practices.” One...
2010-07-10
648 reads
Another Update on Goals
I was querying the SQLServerCentral database for something else today, and I decided to take a minute and double check...
2010-07-09
407 reads
Delivering the Bad News
It’s a Friday, the day governments & companies traditionally deliver bad news. I recived the bad news earlier in the week,...
2010-07-09
719 reads
Free SSRS Training – SQL Lunch #23 (SSRS R2 – Shared Datasets & Report Parts)
Join SQL Server MVP, Patrick LeBlanc, next week on the SQL Lunch to learn about Share Datasets and Report Parts...
2010-07-09
1,552 reads
Is my SQL Server Pre-Release
I get to work with a lot of different clients and client environments and like many companies they are often...
2010-07-09
312 reads
Last Book Chapter Submitted
Whew, I just got my last chapter submitted to the editorial team for our newest book. I still have to...
2010-07-09
341 reads
PASS Sessions Submitted
Hey guys, I’m preparing a few new article series for you but in the meantime I wanted to let you...
2010-07-09
318 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