Database Documentation Using Red Gate's SQLDoc
Longtime author David Poole has written an excellent article about using SQLDoc, from Red Gate Software. Learn how you can document your own databases in this sponsored article.
2009-08-10
3,567 reads
Product and Book Reviews
Monitoring Your Servers : Data Collection vs. Performance Advisor
An article sponsored by SQL Sentry that compares how the Data Collector in SQL Server 2008 and SQL Sentry's Performance Advisor can be used with your SQL Server. Written by MVP Aaron Bertrand.
2009-03-19
6,767 reads
SQL Data Generator
A new tool from Red Gate software that helps you generate realistic test data for testing your SQL Server applications.
2008-04-17
3,546 reads
Applying Your Scripts across Multiple SQL Server Databases
This review of RedGate's new SQL Multi Script tool that aids you in deploying a script across multiple databases.
2008-03-20
3,555 reads
The SQL Internals Viewer
Danny Gould has written a very interesting piece of software that gives you a view into the storage of your data inside SQL Server. And it's FREE!!! He brings us a description of this software in this short article.
2007-08-27
13,152 reads
XML Notepad with SSMS
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,676 reads
Writing SQL Faster
All of us would like to code faster and with fewer mistakes. While a third party tool usualy won't help with the latter, there are a few to help you increase the speed at which you build readable code. New author Tom Fisher brings us a short tutorial on using a couple of Red Gate's tools.
2007-06-28
11,048 reads
Web Data Adminstrator
Accessing your SQL Server without Enterprise Manager or Management Studio can be a difficult task without a custom application. Especially if you are not in the office. Jacob Sebastian brings us an open source application that can make this much easier for DBAs.
2008-05-27 (first published: 2007-06-27)
7,577 reads
Security Tool Survey
Red Gate is looking to expand upon their ever-growing list of extremely helpful tools and asking for help from you DBAs out the real world. They have a survey with 20 questions on Security Tools and 5 people will be chosen to win a goodie bag. I have no idea what's in the bag, but it should be interesting.
2007-06-21
2,771 reads
Microsoft DPM
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,894 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers