András Belokosztolszki is a software architect at Red Gate Software Ltd. He is a frequent speaker at many UK user groups and events (VBUG, NxtGen, Developer’s Group, SQLBits). He is primarily interested in database internals and database change management. At Red Gate he has designed and led the development of many database tools that compare database schemata and enable source control for databases (SQL Compare versions 4 to 7), refactor databases (SQL Refactor) and show the history of databases by analyzing the transaction log (SQL Log Rescue). András has a PhD from Cambridge and an MSc and BSc from ELTE, Hungary. He is also a MCSD and MCPD Enterprise. See my blogs on simple-talk.
Category: SQL Server developmentSQL Server versions: 7, 2000, 2005Level: Intermediate Naming stored procedures consistently is part of many organizational policies, still there are times when one needs to rename an already existing stored procedure. Seemingly the obvious way to rename a stored procedure would be the sp_rename system stored procedure readily supplied by SQL Server. … Read more
Category: SQL Server internalsSQL Server versions: 7, 2000, 2005Level: Advanced Well, this week I spent some time playing with defaults, and here is just a small taster of what SQL Compare version 4 does for you. Defaults are a nice thing in SQL. One can assign defaults to table columns, and when one does not … Read more