Creating A SQL Server 2008\2008 R2 Failover Cluster
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
2013-12-23 (first published: 2011-01-19)
18,555 reads
Perry Whittle
Repairing a Broken Log Shipping Plan From a Differential Backup
This article details how to reinitialise a Log Shipping scenario from a primary differential backup
2013-12-20 (first published: 2012-09-27)
4,028 reads
Moving Database Files in SQL Server
A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.
2013-02-11
8,666 reads
Combining AlwaysOn Groups With Failover Cluster Instances
This article discusses failover cluster instances and AlwaysOn groups
2012-09-04
12,399 reads
AlwaysOn Availability Groups in SQL Server 2012
This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.
2012-08-28
9,937 reads
2012-08-16
7,021 reads
Implementing Microsoft iSCSI Initiator Policies & Multi Pathing
Impementing iSCSI multi-pathing and redundancy policies
2012-03-09
4,022 reads
SQL Server Log Shipping Between Standalone\Workgroup Computers
This article describes the requirements to log ship databases between workgroup computers
2012-01-30
5,468 reads
Using and Creating Mount Points in SQL Server
This article talks about the use of mount points on Windows server for SQL Server installations and shows how you can create them.
2011-11-10
19,554 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3
This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed.
2011-08-12
5,682 reads
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers