Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

Finding all the tables in all the databases on a MS SQL Server

I needed to deconstruct some one else’s report for MS reporting services in order to add some much needed detail to part of the report. I got the RDL, and RDS files (report definition, and data source description files) and extracted the SQL. Looking at the SQL code there was a reference to a table […]

Creating a Date Table in SQL

How do you create a table in SQL in your database that contains the many details about a particular date? I have encountered tables like this at various places I have worked and found then to be convenient  ways to do many date operations that otherwise would require some intricate manipulation of SQL date functions. […]