Alex Kozak

Alex Kozak is a Senior DBA/Analyst working for SAP Canada. He has more than 15 years of database and programming experience. Microsoft has included some of his articles in the MSDN Library.

Follow Alex Kozak via

Alex Kozak 16 January 2009

Estimating Disk Space Requirements for Databases

109

Database Administration

In the first of a series of Database Maintenance Tips and Tricks, Alex Kozak discusses some general issues surrounding disk space requirements for SQL Server databases and shows how to estimate Disk space usage and requirements. He gives tips on using DBCC CHECKDB consistency check and for estimating the space required for replication. … Read more

109

Database Administration

Alex Kozak 09 October 2008

The Bejeweled Puzzle in SQL

T-SQL Programming

Alex Kozak provides another SQL puzzle to hone your SQL Skills with. … Read more

T-SQL Programming

Alex Kozak 16 June 2008

Missing Date Ranges- the Sequel

T-SQL Programming

Alex Kozak returns with another Date puzzle. A readers question gives Alex the inspiration to see if is possible to list unused date ranges in one Select statement. … Read more

T-SQL Programming

Alex Kozak 10 December 2007

Numeral Systems and Numbers Conversion in SQL

T-SQL Programming

Numeral systems can be fascinating. In everyday programming, we are now becoming quite insulated from the need to convert between binary numbers and their representation, so it is a novelty to try out ways of doing it in SQL, and experiment with other number systems from the past.… Read more

T-SQL Programming

Alex Kozak 11 October 2007

Find Missing Date Ranges in SQL

T-SQL Programming

Often, the quickest way to determine whether you have missing data in a table such a ledger or journal is to see if there are gaps in the dates where one wouldn't expect them. But how do you do that in an emergency, particularly in a large table, when every minute counts? … Read more

T-SQL Programming

Alex Kozak 29 August 2007

The Puzzle of ‘Rating Decomposition’

T-SQL Programming

When reading rating information, how do you you knew how many points each separate voter gave if you only know the average rating and the number of votes? Well, you might be surprised to learn that you can figure it out using SQL … Read more

T-SQL Programming