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.
2010-03-17
8,128 reads
Yakov Shlafman
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.
2008-11-06
12,878 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.
2008-05-30 (first published: 2007-06-19)
6,757 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.
2008-04-17
1,193 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).
2007-11-01
1,696 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.
2007-10-02 (first published: 2005-10-26)
76,842 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.
2007-09-27
2,241 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.
2007-09-03
3,694 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.
2005-10-12
13,167 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.
2005-09-29
16,268 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers