High Availability - Sample Chapter
Apress has been generous enough to provide us with a sample chapter from their book on SQL Server 2005 High Availability by Alan Hirt.
2007-10-03
1,418 reads
Book Reviews
A Replication Interview Book Review
Andy Warren has had a great deal of experience with SQL Server replication and just picked up a new book on the topic. Rather than the standard book review, he decided to conduct the review as an interview with the author.
2007-08-17
4,294 reads
SQL Server 2005 Books
There have been a huge number of SQL Server 2005 books released in the last year, but which ones are worth buying? Here are reviews
of three new books from one of the SQL Server gurus.
2007-04-11
10,077 reads
SQL Server 2005: Changing the Paradigm
With the release of SQL Server 2005, the paradigm of working with this database changed. Robert Pearl brings us a book review of the highly acclaimed book from one of the premier SQL Server consulting companies in the US: Scalability Experts.
2006-11-01
4,272 reads
Performance Tuning
Performance tuning is an art or science, depending on who you talk to. SQL Server guru Joe Sack has authored a book on SQL Server 2005 T-SQL and brings us the performance tuning chapter as a preview.
2007-10-23 (first published: 2006-10-25)
14,540 reads
First Impressions of Professional SQL Server 2005 Integration Services
Impressions of this new book from Brian Kelley.
2006-03-20
2,672 reads
A Guide to SQL Server 2000 Transactional and Snapshot Replication
Two MVPs at one shot in this one. SQL Server MVP Hilary Cotter has written a book on replication, one of the very few there are on this topic. And it's presented as a review by MVP Adam Mechanic, a regular visitor to SQLServerCentral.com. If you're looking for replication help, check out this book.
2005-04-13
7,225 reads
Book Review: SQL Server 2000 Resource Kit
This 1100 page book offers something for everyone. Using Blobs, Analysis Services, Replication, High Availability. 38 Chapters plus ebook and tools on the CD. Should you get it? Read our review of this book to find out!
2002-08-30
5,046 reads
Advanced T-SQL for SQL Server 2000
A new T-SQL Bible that is a must have for SQL Server DBAs. Read a review of this book.
2002-01-23
14,635 reads
2001-10-15
3,973 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