Andre Vigneau

  • Interests: Hunting, alpine skiing and science fiction. Nothing against a good bottle of wine…

SQLServerCentral Article

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.

1 (1)

You rated this post out of 5. Change rating

2005-02-02

15,906 reads

SQLServerCentral Article

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.

1 (1)

You rated this post out of 5. Change rating

2005-01-25

11,772 reads

SQLServerCentral Article

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.

5 (1)

You rated this post out of 5. Change rating

2004-12-08

16,096 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2004-12-01

5,375 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2004-11-04

5,855 reads

SQLServerCentral Article

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.

5 (1)

You rated this post out of 5. Change rating

2004-10-26

11,327 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2004-10-21

5,754 reads

Blogs

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books

By

I try to keep an eye on the Humble Bundle bundles for books. The...

How Redgate’s Test Data Manager Can Enhance Automated Testing

By

A brief overview of the benefits and challenges of automated testing and how Redgate’s...

Read the latest Blogs

Forums

Upgrading the SQL version

By Jay@Work

Hi we have an old sql server 2012 box that (among other things) hosts...

SSMS - Consistency in Scripting Options Across Team

By chris.o.smith

Hi, We use SSMS' "generate scripts" feature to script out all DB objects for...

Sql 2022 Alway ON

By aresblade

Hi i need to setup a sql server 2022 onprem replicated with sql always...

Visit the forum

Question of the Day

Updatable Views II

I have this view:

CREATE OR ALTER VIEW dbo.City 
AS
SELECT TOP 10 
 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
 WITH CHECK OPTION
GO
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers