Adam is a Microsoft MVP and a Microsoft Certified Professional. He speaks at Code Camps and has just become an independent consultant for SQL Server.… Read more
Determining how you will upgrade your DTS packages to SQL Server Integration Services (SSIS) is the first step in creating a DTS-to-SSIS migration strategy.… Read more
Itzik Ben-Gan is a writer and mentor, he writes a monthly column for SQL Server Magazine and co-authored Advanced Transact-SQL for SQL Server 2000.… Read more
Low-cost software is almost always a better solution, but if you must purchase the high-cost stuff, don't get caught with blood in the water. … Read more
This article discusses three common problems DBAs are likely to encounter when columns have an identity property that will auto-increment its value when data is inserted. These problems are humorously referred to as the identity crisis.
… Read more
In addition to being a Microsoft MVP, Wally is an ASP Insider and one of the authors of a new book from Wrox called Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL .… Read more
Stored procedures are not the be-all and end-all of managing changes in a database, but they can be very important tools in allowing changes to be made to a database whilst not breaking client applications...… Read more
Euan Garden is a Microsoft group program manager for SQL Server, prior to that he spent four years as the manager of Microsoft's SQL Server Tools development team.… Read more
Red Gate Software is offering free downloads of the book, Best of SQLServerCentral.com, Vol. 2, a collection of the best articles from SQLServerCentral.com.… Read more
Ken is a consultant who often works for high-profile customers, including the U.S. Navy and Air Force, as well as H&R Block. In addition to books, Ken writes articles covering all aspects of SQL Server.… Read more
Jim has been publishing articles related to computers and electronics since at least the early 1960s. He runs a thriving consulting business helping folks repair their Btrieve/Pervasive SQL data files.… Read more
There have been a number of discussions about whether to use SPs or not, often shedding more heat than light, Doug Reilly takes a look at the debate.… Read more