Database Recovery Models in SQL Server
This article discusses in detail the three database recovery models and how to choose the appropriate recovery model
2008-10-30
2,867 reads
This article discusses in detail the three database recovery models and how to choose the appropriate recovery model
2008-10-30
2,867 reads
Steve Jones is taking a break on this fine holiday, enjoy a few bloopers before you head out with the kids for trick-or-treating.
2008-10-30
541 reads
Steve Jones is taking a break on this fine holiday, enjoy a few bloopers before you head out with the kids for trick-or-treating.
2008-10-30
595 reads
This technical article provides an overview of how to produce specific levels of index fragmentation. Useful for creating test plans.
2008-10-29
6,706 reads
One of the configuration options for Database Mirroring is the High Availability mode. With this option three servers are put in place the principal, mirror and witness servers. This is the only option that allows for automatic failover. One of the things that I have noticed is that when there are periodic network issues a failover occurs even though there are no issues with the Principal server. Are there any options to delay the failover?
2008-10-29
3,626 reads
Databases often contain sensitive information and cell-level encryption is a very effective method to protect this information from those who should not have access to it. Although, encryption is not without its challenges.
2008-10-29
3,815 reads
The bimonthly update on the world of energy from Steve Jones talks about wind power.
2008-10-29
797 reads
The bimonthly update on the world of energy from Steve Jones talks about wind power.
2008-10-29
545 reads
The bimonthly update on the world of energy from Steve Jones talks about wind power.
2008-10-29
514 reads
This SQL School video will show you how to use Management Studio to restore a database in SQL Server 2005.
2008-10-28
3,951 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers