One of the more interesting new technologies in SQL Server 2005 is database mirroring, allowing you to implement high availability on a database with commodity hardware. Jay Dave brings us a nice description of this technology.
2008-06-18 (first published: 2007-07-17)
15,562 reads
This is a product that we have not heard much about, but Microsoft has a Data Protection Manager, designed to help ensure you can recover your databases by centralizing your backup files. Author Jay Dave brings us a short overview on this product.
2008-05-06 (first published: 2007-05-23)
5,837 reads
Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.
2008-04-14 (first published: 2007-05-10)
8,671 reads
This script will modify INI file on destops through SMS push to point server connection from A to B.
2008-01-09 (first published: 2007-10-29)
1,295 reads
XML is becoming more pervasive in all of MIcrosoft's product, including SQL Server. Jay Dave brings us a short look at how one of their lesser known tools, the XML Notepad, can be used by SQL Server DBAs.
2007-07-26
3,643 reads
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
hi i need "sample size" in my report's 4th data region which is a...
Hello experts, I want to be more organized about the SSL certificates we have...
Hi everyone, We recently upgraded our server to Sql Server 2019 (15.0.2125.1 (X64) on...
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers