Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Wayne Fillis

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Conditional Flow in DTS

While SQL Server Integration Services is a huge improvement in the ETL capabilities of SQL Server, there are quite a few environments still using DTS in SQL Server 2000. Wayne Fillis brings us a method for implementing conditional logic in your packages.   Read more...
By Wayne Fillis 2007/06/07 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,953 reads

First Look: SQL Server 2005 SP2 CTP

Service Pack 2 for SQL Server 2005 is not quite here, but Wayne Fillis brings us a look at what you can expect if you install the CTP version that is available now.   Read more...
By Wayne Fillis 2007/01/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,242 reads

The Dedicated Administrator Connection

New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.   Read more...
By Wayne Fillis 2007/02/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,314 reads

The Effect of NOLOCK on Performance

Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.   Read more...
By Wayne Fillis 2007/03/23 (first published: 2007/01/24) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 52,323 reads

SQL Prompt IntelliSense for SQL Server

Visual Studio developers have enjoyed the benefits of intellisense for some time, but us SQL Server users have had to work from memory. Wayne Fillis was so enthralled with a new offering from Red Gate he wrote a short review and sent it in. Check out his thoughts and how this product can help you.   Read more...
By Wayne Fillis 2006/07/18 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 8,546 reads

An Alternative XML Solution

SQL Server 2000 added support for XML documents in a few ways. However the support was a little kludgy as it had not been designed into the product from the beginning, but added on later. New author Wayne Fillis brings us some C++ code and a new way to easily retrieve well formed XML documents from your SQL Server.   Read more...
By Wayne Fillis 2004/11/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,220 reads
   Items 1 to 6 of 6