Archives
-
sysobjects, sys.objects... what about INFORMATION_SCHEMA?
SQL Server Management Objects (SMO) is one of the coolest parts of SQL Server 2005, in my opinion. I've written about SMO before, and used it extensively in writing Data Dictionary Creator. In a nutshell, SMO is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server.
-
[tip] Use the Database Publishing Wizard to script your table data
Jeff Atwood recently asked "Is your database under version control?" Well, is it? It's not as easy as it sounds. Until now, there wasn't a good, scriptable solution to the problem. I'll run through a few of the options I've looked at in the past, but let's jump to to the punchline:
-
Things I wish I'd known before I installed VS 2005 Service Pack 1
The SP1 requires a lot of disk I/O. You can eliminate 1.3 GB of disk I/O, and cut the installation time significantly, by temprorarily disabling the Patch Cache. You can read more about it on Heath's post, but here's the basic idea:
-
Freeing up drive space on Windows XP
I just cleaned up my computer in preparation for an upgrade to Vista. Here's how I did it: -
SQL Server recovery model selection (or, what's this 3GB LDF file?!)
-
Reporting Services - Add a logo to the Report Manager
The SQL Server Reporting Services Report Manager is functional, but it's not very customizable. The ASPX pages just reference compiled assemblies, so the only real way to modify them is via CSS. -
A simple example of a fluent interface
Roiy recently released a really nice c# image enhancement filters library on CodeProject. It includes a nice collection of easy to use image transformation filters - ResizeFilter, RotateFilter, ImageWatermarkFilter, etc. They follow a simple pattern:
-
Tips for a Technical Presentation
I spoke at the local .NET user group meeting last week. I've done my share of software demos and short presentations to small groups, but this was the first time I've given an hour long technical talk to a large group. I'm making a list - partly for my future reference1- on some presentation tips while it's still fresh in my mind. -
Notes for 11/28 Talk - SMO and INFORMATION_SCHEMA
I spoke at the San Diego .NET User Group meetin on 11/28 on SQL Server Metadata (SMO and INFORMATION_SCHEMA). The complete notes should be available on the user group downloads page, but here are the rough notes:
-
Macro to add a Codebehind file to an ASPX page in VS2005
The best way to add a code file (a.k.a. codebehind) to an ASP.NET ASPX page is check the "Place code in separate file" checkbox when you create it: