Alexander Chigrik

I would like to offer consultation on MS-SQL by E-Mail

I am from Rostov-on-Don in Russia.I work for a firm Bis Ltd (Banking Information Systems) as a Microsoft SQL Server DBA and developer. I have more than 4 years solid experience
with version 6.5 and more than 2 years experience (since december 1998) with version 7.0.


Current Certifications:

  • Brainbench:Master MS SQL Server 6.5 Administration

  • Master MS SQL Server 6.5 Programming
  • Master MS SQL Server 7 Administration
  • Master MS SQL Server 7 Programming

All exams on Brainbench

I am in the list of 15 top experts on MS SQL under the version of experts-exchange:http://www.experts-exchange.com/jsp/qList.jsp?ta=mssql


Technical Article

Generate Insert Statements Easily

This script will generate insert statements for the given tables. You can pass the tables names, separated by commas, into sp_DataAsInsCommand stored procedure as in the example below: EXEC sp_DataAsInsCommand 'employee,titleauthor,pub_info' Updated on 5/25/01 to correct an issue with columns that are short like a column defined as char(1), to correct another issue with the […]

3 (9)

2001-08-09

4,613 reads

Blogs

SQL Server Query Tuning and Optimization by Benjamin Nevarez

By

I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...

Slides from SQL Saturday Los Angeles 2022

By

If you attended my talk at SQL Saturday Los Angeles 2022, then you can...

Creating a HEAD utility for Windows 10

By

One of the things I did often in my first career job was create...

Read the latest Blogs

Forums

How to use PowerShell to set secure SA passwords for bulk servers

By Vincent92

Comments posted to this topic are about the item How to use PowerShell to...

Substitute 0 and 1 values in 1 column

By pedroccamara

Hello everyone, Hi have this column named Sex and it only has value 0...

Finding difference in two databases/tables

By yrstruly

I have compared two tables with the same data in two different databases(aslo the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers