Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Yakov Shlafman

SQLServerCentral.com profile

   Items 1 to 11 of 11   
 

An Urgent Ad Hoc Report

In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.  Read more...
By Yakov Shlafman 2010/03/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,043 reads

A Little DOS for a Poor DBA

Yakov Shlafman brings back the world of the command prompt to make life easier for a DBA that must deploy a series of scripts to their servers.  Read more...
By Yakov Shlafman 2008/11/06 | Source: SQLServerCentral.com | Category: scripting
Rating: |  Discuss |   Briefcase | 12,444 reads

Reverse engineering alias data types - Part 5

Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.  Read more...
By Yakov Shlafman 2008/04/17 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 1,148 reads

Reverse Engineering Alias Data Types in SQL Server 2000 - Part IV

In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).  Read more...
By Yakov Shlafman 2007/11/01 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 1,623 reads

Reverse Engineering ADTs in SQL Server 2000 - Part 3

Continuing on with his series on ADTs, Yakov Shlafman takes a look at working with schema changes when your ADT is on a column used as a primary or foreign key.   Read more...
By Yakov Shlafman 2007/09/27 | Source: SQLServerCentral.com | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 2,190 reads

Reverse Engineering Alias Data Types in SQL Server 2000 - Part II

Continuing with his series on Alias Data Types, Yakov Shlafman shows us how to work wtih ADTs when constriaints are involved.   Read more...
By Yakov Shlafman 2007/09/03 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,658 reads

Reverse Engineering Alias Data Types in SQL Server 2000

In SQL Server 2005 there is the concept of alias data types, which are similar to user-defined data types in SQL Server 2000. Yakov Shlafman brings us the first part of a series looking at these structures in SQL Server 2000.   Read more...
By Yakov Shlafman 2007/06/19 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 5,795 reads

The Best Kept Secret About SQL Query Analyzer

It has been nearly 5 years since SQL Server 2000 was released and almost seven since Query Analyzer was introduced in SQL Server 7. Surely every trick, tip, technique, or secret has been published by now? Perhaps, but this might be a new one from Yakov Shlafman. Check out what he thinks is the best kept secret.   Read more...
By Yakov Shlafman 2006/01/27 (first published: 2005/10/26) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 76,549 reads

Starting Query Analyzer

Next in his series on Query Analyzer, Yakov Shlafman brings us a few ways that we can save more keystrokes working with SQL Server 2000's most popular tool. Learn how to customize your environmenty on startup so you can get to work.   Read more...
By Yakov Shlafman 2005/10/12 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,356 reads

Query Analyzer Extended

SQL Server has the best client tools for a DBA of any RDBMS and SQL Server 2000 includes Query Analyzer, an amazing tool. There are a few places where this tool could use some improvement and Yakov Shlafman brings us a few ways that you make your work with Query Analyzer even smoother.   Read more...
By Yakov Shlafman 2005/09/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,008 reads

Getting Help on Query Analyzer

Query Analyzer has been a great tool in SQL Server 2000 and while it is superceeded in SQL Server 2005, lots of us will be using it for some time to come. New author Yakov Shlafman brings us some references and tricks for this essential DBA tool.   Read more...
By Yakov Shlafman 2005/09/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,054 reads
   Items 1 to 11 of 11