Practical SQL Server

  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • How to create an XML config file for an SSIS package (SQL Server 2005 Integration Services)

    Being able to have a config file for your packages is one of the huge improvements in SSIS over DTS. However, it’s a little hidden and the Books Online are absolutely no help here, which is unusual because they are pretty good on most stuff. If...
  • 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...
  • Welcome to Practical SQL Server!

    Welcome to Practical SQL Server. The idea behind this blog is to try to put as much of the awesome informatio about SQL Server that is scattered all over the place in one easy to use location. As whitepapers and case studies and other useful documents...