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,212 reads
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,806 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,921 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
795 reads
2012-02-03
531 reads
Blogs
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Build a Serverless Todo App With AWS, Pulumi, and Python
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Forums
Temp table security
So, I have an interesting situation that I need a double-check on. One of...
Searching a Form (using "Find") after an Access to SQL Migration
I have completed a successful migration of an access database to SQL Express. Most...
Question of the Day
Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers