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,616 reads

Blogs

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Daily Coping 24 Mar 2023–The Final Tip

By

Today’s coping tip is to discover the joy in the simple things in life....

Experimenting with RedisGraph on Docker and Windows

By

I have been experimenting a bit with graph databases, trying to learn more about...

Read the latest Blogs

Forums

dbatools - Connect-DbaInstance

By rothj

I have my SQL servers name, UserID (UID) and Password (PWD) in a table...

Extracting the string before and after the given character

By sathishkm

Hi All, I want to extract the string before and after the given characters....

BULK INSERT CSV with a fixed value for a field not in the CSV

By PS_Richard

Well, I hope the title explains what it is.  Currently, I have the following...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers