Synchronizing SQL user in Database Mirroring- Abi Chapagai
Synchronizing SQL user in Database Mirroring:
If a login used in an application that involves database mirroring has SQL Login, there...
2010-08-16
2,336 reads
Justin H-Davies
Different High Availability Solutions in SQL Server
Different High Availability Solutions in SQL Server.
While working on finding different High Availability solutions, I did quite a bit of...
2010-08-12
5,550 reads
Different High Availability Solutions in SQL Server – By Abi Chapagai
Different High Availability Solutions in SQL Server.
While working on finding different High Availability solutions, I did quite a bit of...
2010-08-12
3,371 reads
Log Shipping By Abi Chapagai (Revised)
Log Shipping By Abi Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...
2010-07-29
2,386 reads
SQL Bits 7 – Registration is Open !
Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...
2010-07-29
1,489 reads
SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai
Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...
2010-07-28
31,941 reads
“One of the Pack to Top Dog”
My first guest editorial published !
http://www.sqlservercentral.com/articles/Editorial/70725/
Would appreciate any comments you have.
2010-07-15
579 reads
Curb those Cursors !
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
687 reads
From “One of the Pack” to “Top Dog”
A guest editorial today from Justin H-Davies examines the change to management from the perspective of someone going through the transition. How do you deal with those former co-workers?
2010-07-15
443 reads
Enabling Memory Support for over 4GB of Physical Memory
This is something we had to do again recently and its improved our performance and query speeds on one particular system....
2010-07-12
944 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers