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

All authors

All authors

Blogs

AI Step 1

By

As this is an Artificial Intelligence (AI) World, things are changing. We can see that...

Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend

By

In a containerized app, React and Chakra UI provide a robust and accessible user...

A New Word: Nachlophobia

By

nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...

Read the latest Blogs

Forums

More Funny SELECTs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Funny SELECTs

Reducing the Cycle Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reducing the Cycle Time

SQL Server migration using replication

By brianbilow

I've set up replication in my SQL 2019 environment in attempt to migrate SQL...

Visit the forum

Question of the Day

More Funny SELECTs

What does this code return? 

SELECT
  ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
    FROM Sales.SalesOrderHeader AS soh
    WHERE
      soh.OrderDate     > '01/01/2011'
      AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
    FROM Sales.SalesOrderHeader AS soh
    WHERE
      soh.OrderDate     > '01/01/2012'
      AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
    FROM Sales.SalesOrderHeader AS soh
    WHERE
      soh.OrderDate     > '01/01/2013'
      AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO

See possible answers