I was recently taking a SQL Server 2000 database and moving it over into SQL Server 2005. I did it the old fashioned way and unfortunately the login that our application used to access the DB wasn't in the new SQL Server. I was silly and tried adding the login to that server instance. Fine. Authentication...

There are a ton of interesting things you can do with the new Xml data type in Sql Server 2005. The first quick thing that came to mind was to pass in an Xml document into a stored procedure to have many rows deleted at one time in a batch without having to use a loop with a transaction outside of Sql...

Ok, before I say anything I just want to say that SQL Server Reporting Services is one of the coolest and crappiest things ever! :P It is a really neat product and tons easier than Crystal Reports, but man oh man is it hard to setup. Here's a great little article on how to set Reporting Services on a...

Here's just a quick tip I came across (this is actually a good read on Whidbey Data Beta 2 features), which is pretty handy (and not so obvious) even if that's not what the article is really about. If you have a field in a table that you need to search on, but the field allows nulls AND you want to be...

I'm currently creating a wizard engine in ASP.NET that we can reuse. The data is saved in Sql Server tables and associated with users. Creating new wizards just involves setting up some new rows in the database and any custom UI you need. A big part of this that I needed was a PlaceHolder Control that...

This is mostly just a post for me so I never forget this, but to change the owner of an object in sql server, use sp_changeobjectowner , just pass it the name of the object (as a string) and the name of the new owner (as a string) UPDATE : Thanks to Matthew Gibson for correcting my typo on the stored...

This usually isn't necessary, but I'm setting up some Views for a customer doing some reports in Access and the customer needed two fields, one with just the Date and another with just the Time. At first search on Google, it came up with using the DATEPART Function to get each part of the date or time...

I was recently taking a SQL Server 2000 database and moving it over into SQL Server 2005. I did it the old fashioned way and unfortunately the login that our application used to access the DB wasn't in the new SQL Server. I was silly and tried adding the login to that server instance. Fine. Authentication...

There are a ton of interesting things you can do with the new Xml data type in Sql Server 2005. The first quick thing that came to mind was to pass in an Xml document into a stored procedure to have many rows deleted at one time in a batch without having to use a loop with a transaction outside of Sql...

Ok, before I say anything I just want to say that SQL Server Reporting Services is one of the coolest and crappiest things ever! :P It is a really neat product and tons easier than Crystal Reports, but man oh man is it hard to setup. Here's a great little article on how to set Reporting Services on a...