SQL Server 2008 CTP Available

Today the first publicly available CTP for the next version of SQL Server was released.  It will be called SQL Server 2008, it was formerly known by its codename – Katmai.   You can download the CTP here:  https://connect.microsoft.com/sqlserver?wa=wsignin1.0.  You can also see a webcast by David Campbel here:  http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032341071&EventCategory=2&culture=en-US&CountryCode=US. Enjoy!   Reed


Sharing a printer connected to an XP machine with a remote Vista machine

I know this has nothing to do with SQL Server, but I wanted to put it out ther and hope it helps someone, somewhere. If you are like me and you disabled the UAC prompts when you installed Vista, and then you try to add a network printer (in my case the printer was connected…


Management Studio Timeout Issues

Timeouts are a real pain, and I was helping someone debug their problems and found this useful info, its from Andy on the SQL Server newsgroups: A couple of other possibilities worth checking.   In Object Explorer right click on the SQL Server 2005 instance select Properties. I am assuming that you may be attempting…


Full Text Search using a column that contains a list of keywords

Apparently I am the first person on the Internet to need to do this, which I find hard to believe, but I couldn’t find anything about this, so I had to make a solution myself.  The problem I was trying to solve was this:  I have a table with a column, and I want to…


Philadelphia SQL Server User Group Meeting

If you are in the Philadelphia area and want to attend the Philadelphia SQL Server User Group meeting, you’ll find all the details below.  I can’t be there this month, but have fun without me.  -Reed   October PSSUG Meeting October 11th, 2006 MicroEndeavors 8001 Lansdowne Avenue Upper Darby, PA  19082 Directions: http://www.microendeavors.com/directions.htm   Welcome…


How to remotely execute an SSIS package

There is a lot of confusion around SSIS and how and when you can execute packages, so hopefully I can help clear this up. If you just have the SQL Server management tools on your desktop (Management Studio and Business Intelligence Development Studio aka. BIDS) then you can build a package in BIDS and run…


Custom Code in Reporting Services Reports

If you like to write custom code and Reporting Services doesn’t do something you want it to, then you can  write custom code to make it do whatever you want.  Find out how here:  http://msdn2.microsoft.com/en-us/library/ms155798.aspx.   -Reed


How to Troubleshoot SQL Server 2000 Performance Problems

If you are having trouble performance tuning SQL Server 2000, there is one whitepaper you need.  It’s called “SQL Performance Tuning using Waits and Queues” and it’s written by Tom Davidson.  It takes the guesswork and voodoo out of tuning.    The way it work is you run a stored procedure (it’s in the whitepaper)…


How to Write to Office SharePoint Server 2007 (MOSS 2007) from SSIS

If you are not a SharePoint Admin (I am not) but need to interact with MOSS 2007 and SSIS, this guide should walk you through the basics.   First, and this is the most important part,  you must enable a service on the Windows Server 2003 box.   The service is WebClient – enable it, then…