This Blog Has Moved!
Please Follow my new blog @ http://marlonribunal.com
Here's a quick TSQL solution that you can use to find all the User Tables and their Columns, inluding Data Types, and Column size. This is useful when you need a quick way of finding info on creating your Database's documentation. Whenever I am asked to document a new system/application or review an existing one, I always want to start from the very core of the system - mostly, this is a Database backend.
Most of the people, if not all, who work around the SQL Server know how to backup their databases by heart. They can even do the task in their sleep. Some may find this article useful, though.
What we're going to do here is do the 3 backup types: Full, Differential, and Transaction Log Backups.
Here's how to backup a SQL Server Database (suppose we're backing up the AdventureWorks Database):
One of the most common business requirements for SQL Server Reporting Services is that an SSRS Report should be dynamic. Dynamic in a sense that the report consumer can query the report in a variety of ways. In this post, I will demonstrate how you can add a parameter value "ALL" to return all of the desired result.
I have four parameters in this report; all of them are…
No words can ever express how thankful this world is to you, Steve. You led the way. You left a mark. You left us a better world.
Red Gate’s “SQL in the City” will be in Los Angeles on October 28, 2011! That’s a Friday so make sure to check your schedule.
Verbatim from Red Gate’s Flyer: