András Belokosztolszki

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.

Follow András Belokosztolszki via
01 August 2008
01 August 2008

The unexpected behaviour of DirectoryInfo.GetFiles() with three letter extensions

0
3
There is a documented, but certainly counterintuitive issue with the DirectoryInfo.GetFiles() method in .Net. This method returns a list of files that match a particular pattern. For example in the following example it will return us all the files on drive Z: that have the exact extension “.foobar” DirectoryInfo folder = new DirectoryInfo(@”z:”); FileInfo[] files … Read more
0
3
28 February 2008
28 February 2008

Type less in SQL Server 2008 (variable initialization and multiple row inserts)

0
0
Among the large number of new features in SQL Server 2008 there are two, almost insignificant features, that I use almost constantly. These are variable initialization and the values clause of insert statements that now accept multiple rows. When playing with SQL one inevitably declares some variables. After the declaration, and as per the SQL … Read more
0
0
24 September 2007
24 September 2007

The GO command can have a parameter?

0
0
I have mixed feelings about the GO command. It is not a T-SQL statement, it is just something that Management Studio and the other SQL Server tools understand as a batch separator command. Indeed, you can change it to whatever you wish in Management Studio under Tools->Options->Query Execution->SQL Server->General->Batch separator.So you can write queries like … Read more
0
0
29 May 2007
29 May 2007

Source Control and Databases

0
41
András's article on Source Control shows a lot of the thinking amongst the developers at Red Gate at that time that eventually crystallized into SQL Source Control. It identified several problems that had to be overcome before the task could be done properly. Andras's suggestions for the use of SQL Compare are now built-in to SQL Source Control, but it remains a fascinating explanation of the complications along the way. … Read more
0
41
15 May 2007
15 May 2007

SQL Compare 6.0 beta – read and sync to and from SQL scripts

0
0
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
0
0
10 May 2006
10 May 2006

Altering CLR assemblies in SQL Server 2005

0
2
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
0
2