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,559 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,753 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,542 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,553 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,139 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,675 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,045 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,569 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,888 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers