Failover consederations on Database Mirroring
These topics will give you the brief idea of what happens behind the scenes during failover occurs in Database mirroring....
2012-06-18
1,210 reads
Sanjeev SQL Master
Database Mirroring
Introduction
This blog covers the High Availability Solutions provided by SQL Server i.e. Database Mirroring.
Database mirroring is a solution in SQL...
2012-03-05
1,782 reads
How to Upgrade SQL Server 2000 Instance to SQL Server 2005
Introduction
The purpose of this tutorial is to lay out the general guidelines for planning a SQL Server 2005 upgrade. As...
2012-02-21
1,888 reads
Recovery Modals in SQL Server
Being a SQL Server DBA, one should be able to understand how many recovery modals do we have in SQL...
2012-02-03
790 reads
2012-02-03
524 reads
Blogs
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Forums
Delegated rights to Enable/Disable TSQL Jobs (Specific Jobs)
All, In attempts thinking that I am smarter than your average bear, I attempted...
Hello i am new to Sql and idk why i get this error and also not getting results.
CREATE DATABASE dbsubjects; CREATE TABLE tblstudent( ID INTEGER PRIMARY KEY, TheName Varchar (100), TheAddress...
Identifying the process that is backing the databases to virtual device
We have about 20 SQL Servers. We use Net backup or Native backup for...
Ask SSC