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

Guest Columnist: Andre Vigneau

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

Using the SQLCMD in SQL Server 2005

SQL Server 2005 has changed quite a bit about the way DBAs will work with SQL Server. One of the new tools is the SQLCMD utility that will replace isql and osql as the command line utility. Author Andre Vigneau brings us a first look at this new tool and how you can do a few neat tricks with it.   Read more...
By Andre Vigneau 2005/02/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,598 reads

Estimating Your Space Needs

How many times have you had to estimate space for a new SQL Server database? How much time did you spend on it? Was it a thumb-in-the-wind guess or did you actually examine a schema and calculate some values. If you have asked someone to estimate the space their database will need, they probably guess more than compute, but now Andre Vigneau gives us an easy way we can teach those developers to put some thought into the process.   Read more...
By Andre Vigneau 2005/01/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,485 reads

Boost Your Performance - Bad Index Detection

SQL Server depends heavily on good indexing to perform well. The optimizer requires relevant and intelligent indexing in order to do its job well. Author Andre Vigneau brings us a script that he uses to detect possible index problems in the database design as well as a number of hints to ensure that your database is performing optimally.   Read more...
By Andre Vigneau 2004/12/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 15,415 reads

Unifed Database Toolkit - Connection Definition

SQL Server 2000 is easy to administer relative to other RDBMS, but there is still plenty of room for improvement. Author Andre Vigneau has built a database toolkit to allow him to manage his cross platform databases. This is the second article in his series and deals with establishing connections to any database platform.   Read more...
By Andre Vigneau 2004/12/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,370 reads

Unified Database Toolkit - Scheduling

SQL Server has a great scheduling system in SQLAgent. But sometimes SQLAgent won't work or isn't available. Author Andre Vigneau has built a solid system for auomtating the management of SQL Server, one that he deploys with the software that his company sells. Read about the basics of this system and get some code that might come in handy for you.   Read more...
By Andre Vigneau 2004/11/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,820 reads

Controlling SQL Server Settings

Change control in SQL Server isn't the strong point of the product. And change control of server based settings is something that you might not worry about, but which can easily cause you hours of troubleshooting time. Author Andre Vigneau deploys software to other companies and has developed a solution to deal with this problem. Read on and get some code that can help you prevent or at least fix any changes to SQL Server sp_configure parameters.   Read more...
By Andre Vigneau 2004/10/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,247 reads

Versioning

How many times has an application exploded because you upgraded or patched SQL Server? How many people were aware that a patch was applied? New author Andre Vigneau has dealt with this and gives us some code that our applications can use to check to see if anything has changed. It doesn't keep the code working, but it does allow you to inform users that something has changed.   Read more...
By Andre Vigneau 2004/10/21 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,672 reads
   Items 1 to 7 of 7