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.
It is a good practice to store creation scripts for the database organized in a way that there is a single SQL file for each database object. The problem starts when one wants a single script that creates all of these database objects. I’ve seen a solution in which the creation SQL files are concatenated, … Read more
We have just released the first public beta for SQL Compare 6.0. The full version of SQL Compare 6.0 is scheduled for release towards the end of June 2007. For the forum and download information visit http://www.red-gate.com/MessageBoard/viewforum.php?f=65 So what is new in SQL Compare 6.0 beta? SQL Compare 6.0 beta introduces a new data … Read more
Following a very successful beta program we have now released the first version of SQL Refactor. SQL Refactor is an Add-In to Microsoft Management Studio, with a large number of features that include laying out SQL, renaming views, stored procedures, table, functions, their parameters and columns and handling all their references, table split, encapsulate as … Read more
Until the release of SQL Server SP1 I though I had a good understanding of how deadlocks can occur in SQL Server. Well, SP1 has changed this view quite dramatically by introducing self deadlocking transactions. Let us look at a very simple example, in which I create an XML schema collection, and then create something … Read more
Category: SQL Server development SQL Server versions: 2005 Level: Advanced SQL Server 2005 introduced support for .Net in SQL Server. While this is a very powerful feature, it does come with a high cost. The CLR support allows writing stored procedures, functions, triggers using programming languages like C#. It allows creating complicated user defined types, … Read more
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