Browse by Tags
All Tags »
SQL Server (
RSS)
I saw a cool post recently from Jon Galloway called " Passing lists to SQL Server 2005 with XML Parameters ". This is a pattern I've used several times while building the new version of Channel 9 . If you'd like to learn how to pass...
So I'm working on improving the performance of the next version of Channel 9 . For those of you not familiar, our team created a new platform for our department to build community sites (blogs, forums, videos, tagging, etc). You can see an example...
My boss, Jeff and Scoble just blogged about the launch of 10 ! The short answer for 10 is that it's a site for technology enthusiasts. That may seem very general, but it is on person. We will be covering pretty much anything that's interesting related...
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...
Curious about the upcoming MIX conference? Not sure if you should be excited or not? Check out the video on Channel 9 about it .
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...
I'm at home this weekend slamming out some code for fun using SQL Server 2005 and Visual Studio 2005. It's a lot of fun and it's great to finally get to use the RTM bits to build an application. I noticed though that on my machine (XP SP2) SQL Server...
Just a quick idea and some interesting posts I came across from Kent . He recently posted a message on recursive CTEs (great stuff if you haven't looked at it yet in SQL Server 2005). This allows you to bring back hierarchial data from say a single table...
A friend asked me if I remembered the system stored procedure to change the owner of an object. I didn't, so I googled it, but also came across a handy MSKB, INF: SQL Server Procedure to Change Object Owner
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...
More Posts
Next page »