This Blog Has Moved!
Please Follow my new blog @ http://marlonribunal.com
I have long abandoned this blog and moved to my permanent home-blog at
But I am here again to tell you about my book: SQL Server 2012 Reporting Services Blueprints.
If you want to learn SSRS or deepen your knowledge about it, you may want to grab a copy of this book.
I have more information on my blog: SQL Server 2012 Reporting Services Blueprints
Come visit me on my home-blog: SQL, Code, Coffee, etc.
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.