Michelle's space

Michelle's profileMichelle's spaceBlogListsNetwork

Tools

Help

Michelle Gutzait

Occupation

Database consultant

Location

Montreal

I have been involved in IT for almost 20 years as a developer, business analyst and database consultant. I worked exclusively with Microsoft SQL Server for the past 10 years, consulting for many and diverse clients. My skills include infrastructure and database design, performance tuning, security, high availability and clustering, consolidation analysis, disaster recovery, very large databases, Replication, T-SQL coding and optimization, DTS/SSIS packages, administrative and infrastructure tools development, Reporting Services, Amalysis Services, MIIS, training developers and DBAs and more.
Before SQL Server, I have been working as an Oracle developer, Business Analyst and development team lead for 9 years.
As a consultant, I am also familiar with a variety of languages, tools and environments. I am a business-oriented consultant with a high-level vision.
I am also writing technical articles in the SearchSqlServer WEB site, on a regular basis.

View profile details

My published articles

The list of all my published articles


Find all database files for a drive and auto generate database attach and detach scripts for SQL Server Often, you have a SQL Server instance containing many databases. It may happen that over time, you have added disk drives or LUNs and placed different database files on separate disk letters. Now you need to know which databases reside on which drive.

SQL Server 2005 transaction log backup maintenance plan via SSIS In SQL Server 2005, when you configure a transaction log backup maintenance task for "all user databases", there is no automatic check for the Recovery Model. This article shows a simple way to overcome this issue.

Do SQL Server User Defined Datatypes (UDT) affect performance? There is a legend among SQL Server developers and DBAs saying that UDTs may degrade performance. In this article I prove whether this believe is right or wrong.

Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008 There are few possible solutions out there for paging through a large result set. In this tip, I focus on three examples and compare the performance implications.

Can you shrink your SQL Server transaction log files to death? Transaction logs tend to grow more often than database files, and as a result, database administrators shrink them more often. In this tip, I tested the impact when a transaction log file grows during a transaction.

How to Minimize Downtime When Moving to a New SQL Server Environment How to Minimize Downtime When Moving to a New SQL Server Environment. It can be applied when upgrading from one version of SQL Server to another or when moving SQL Server environment/instance to a new hardware.

Sarbanes-Oxley compliance checklist: IT security and SQL audits When you are a SQL Server DBA and is required to make sure that your server is secured and/or SOX compliant, this article might help you go through the right steps

Using full-text search for symbols in SQL Server Symbols (non letters) are not being indexed by the Full Text Search agent, the article describes the ways to work around this feature

Can you shrink your SQL Server database to death? Analyzing the performance implications of database file growth during a transaction

Stored procedure: Determine last database backup

Optimize database triggers in SQL Server 2000

SQL Server collation conflict fixes

Merge replication pros and cons in SQL Server 2000

Reporting Services performance analysis and tuning

Log shipping in SQL Server 2000 can provide for automatic failover

T-SQL and PL/SQL common languages for database-independent applications

Upgrade to SQL Server 2005 and maintain old database while stabilizing

Targeting SQL Profiler to determine performance problems

Migrate and consolidate Access databases to SQL Server

SQL Server INSIDER: The ezine with tips for SQL Server pros – New security Model in SQL 2005

Mimic the Management Studio reports in Reporting Services

Clustering and SQL Server - Architectural design - One big cluster vs. small clusters

SQL Server 2000 and 2005: Six compatibility concerns

Stored procedure to find fragmented indexes in SQL Server Jul. 11, 2007

XML AUTO function vs. T-SQL commands

XML Data type in SQL Server 2005 vs. VARCHAR(MAX)

Monitoring long-running jobs in SQL 2000

Track changes to SQL Server 2000 and 2005 with one simple utility

Blog

May 14

לדוברי עברית - יש לי בלוג בקבוצה הישראלית

http://sqlserver.co.il/

לינק ישיר --> http://www.sqlserver.co.il/?cat=31

January 09

I was speaking in the Ottawa SQL Server Users Group on January 15th

The link: http://ottawa.sqlpass.org/

Topic: Management Studio Enhancements & the new Performance Studio

Management Studio:

Activity Monitor
Object Explorer Details
Object Search
Custom colors for connection
Error when trying to modify table definition
Speed Enhancements for SSMS
UI Framework Enhancements
"Open Table" enhancements
Register servers at a central location
Wizard for Table Partitioning Setup
Service Broker UI enhancements

Query editor and debugger:

Multi-Server Queries
Intellisense added to the Query Editor
- Collapsible window
Customizable tabs
Error list
New Right-Click options on Results Grid
Showplan - new options
The debugger

Performance Studio

Two of my articles are in the 2008 Top 10 in TechTarget

#6 (Top 10 development tips): http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1343978,00.html

#9 (Top 10 SQL Server tips): http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1340930,00.html

November 18

I was speaking in the Montreal .NET and SQL Server User's Group on November 17th 2008

The presentation was targeting the development community and it's goal is to introduce what's new in SQL 2008.

I focused on the following items, including demo's:

The FILESTREAM datatypes
The new DATE and TIME datatypes
The new Merge command
Table Valued Parameters
Large UDTs
User-Defined Aggregates
Hierarchical data
New Dependency Management
Filtered Indexes

I also showed some new enhancements in the SQL Server Management Studio 2008.

The presentation includes additional topics such as: enhancements in the query editor and , working with the new version of SQL Profiler and query editor's debugger, the PowerShell integration and Performance Studio.

For more information:

http://www.dotnetmontreal.com/dnn/Activit%c3%a9s/Calendrier/tabid/61/ModuleID/379/ItemID/5/mctl/EventDetails/selecteddate/2008-11-17/language/fr-CA/Default.aspx

August 11