Browse by Tags

All Tags » SQL Server 2005 (RSS)

Extract RDL's from SSRS by Plip

With my recent source control issues it appears I lost several RDL's, I came across the Reporting Services Scripter which allowed me to extract all the RDL files from my reporting server - very sexy.

SQL Server team - Are you smoking crack? by Plip

Okay, so rule number one of user interface design is consistency - make sure people don't have to learn new things too often and be sure to use the same design (bad or otherwise) everywhere. So why in gods name did the SQL Server team feel the need to...

Red Gate - SQL Doc by Plip

Crikey - they've done it again! Red Gate have *yet again* released another stunningly simple product jam packed full of features! http://www.red-gate.com/messageboard/viewtopic.php?t=3592 Download it and have a play!

SQL Server 2005 Backups by Plip

This post is more for my memory than anything else but ... I've had issues restoring a SQL 2005 database from a backup today using the SQL Workbench with the following error message: - The backup set holds a backup of a database other than the existing...

Migrations - they're lovely by Plip

We're not talking about swallows (African, European or otherwise) but Database Migrations that ship with Ruby on Rails. There's a cool bit of functionality which lets you stores database schema and incrimental changes in code files as well as a framework...

SQL Refactor from Red Gate - FANTASTIC! by Plip

Well, Red Gate have done it again , they've come up with another fantastic product ! This time they've addressed and area which has been ignored for a *long time* with a tool which will help you refactor that *horrible* SQL code you crank out...

Microsoft Documentation - Where is the sample code? by Plip

I've recently been working heavily with Reporting Services, but there have been one task I've been putting off as I've done it once before (two years ago) and it scared the crap out of me. Creating a Custom Security extension to work with...

Some SQL Server DBA's are odd ... by Plip

I recently blogged about a small but frustrating bug in SQL Server relating to creating new columns of type varchar . Douglas Reilly linked to my blog posting about the bug , and it consequently got picked up and placed at the top of the Dr. Dobb's...

SQL Server 2005 doesn't like numbers less than 50 by Plip

I've been creating a database for a client and it requires the creation of some fields which are of type varchar(10). Nothing weird there I'm sure you'll agree. In creating these tables I'm using SQL Server Management Studio and I've...
More Posts