Putting the ORM debate to bed
Hopefully this should put the ORM debate to bed, either use an ORM or don’t but please don’t access tables...
2015-05-20
56 reads
Blog Posts
Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance...
2015-05-20 (first published: 2015-05-06)
5,889 reads
SQL F.A.D. – Daily Identity Reset - WaterOx Consulting
Reading Time: 3 minutesSometimes you have to do some things considered pretty strange in your...
The post SQL F.A.D. – Daily Identity...
2015-05-20
372 reads
SQL server 2014 Service Pack is available (AGAIN ) !!!!!!!!
Yes after its initial release and pull out Microsoft has again made the Service pack 1 for SQL SERVER 2014...
2015-05-20
470 reads
SQL Server 2016 public preview arriving this summer
SQL Server 2016 was recently announced. Top new features include:
Always Encrypted protects data at rest and in motion. With Always...
2015-05-20
700 reads
SQL Server Virtualization Stairway Level 3 at SQLServerCentral
The third Level in my Stairway to Virtualization series is now live at SQL Server Central! In this Level, we will...
2015-05-20
468 reads
SqlSaturday 377, Kiev, May 23 - only 3 days left
Hello everyone!
As you may already know - on 23rd May in Kiev will be held SqlSaturday 377.
Hurry up!
You can meet many...
2015-05-20
458 reads
Temporary Post Used For Theme Detection (d2df4373-a605-4b61-86ee-a1afe06d7e22 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (af8cc091-a628-437f-8918-348486ad1d80 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
The post Temporary Post Used For...
2015-05-20
422 reads
ASP.NET 5 Unit Testing With xUnit.net
This post is part of a series on ASP.NET 5, the index for this can be found here ASP.NET 5...
2015-05-19
45 reads
Database snapshot captures only data changes or it will also save real database from DDL changes ?
Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure,...
2015-05-19 (first published: 2015-05-11)
5,622 reads
Blogs
TempDB Internals – What’s New (Sql Server 2016 to 2025)
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