Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Alex Grinberg

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Sending a Variable Number of Elements in a Parameter

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.  Read more...
By Alex Grinberg 2014/02/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,460 reads

The Multi-valued Parameters problem in Reporting Services

Longtime SQLServerCentral author, Alex Grinberg, brings us a short piece on how to deal with multi-valued parameters in Reporting Services when you have a stored procedure call.  Read more...
Rating: |  Discuss |   Briefcase | 13,574 reads

Creating Functions for Stored Procedures

With the advent of so many new technologies in the Microsoft space, a DBA needs to learn more and more about many of them that aren't a part of SQL Server. Alex Grinberg brings us a technique he has used to create ADO functions for your stored procedures.  Read more...
By Alex Grinberg 2008/10/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,252 reads

Self Eliminated Parameters

Optional parameters are easily handled with NULL values in T-SQL, but there are cases where this doesn't always work. Alex Grinberg brings us a new technique to allow your stored procedures to be structured to deal with this situation without dynamic SQL.   Read more...
By Alex Grinberg 2006/10/09 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 9,067 reads

Working With System Tables

It's not recommended, but sometimes writing scripts against the system tables and getting information is a great way to work with SQL Server. Alex Grinberg brings us a look at some of the things you can get from system tables along with some sample scripts.   Read more...
By Alex Grinberg 2006/01/16 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 14,402 reads

The ARRAY In SQL Server 2000

SQL Server 2000 and Transact-SQL have many features, but one of the most often asked for features has been the implementation of some sort of array data type. This basic programming concept is notably absent from the development platform and results in many headaches and frustrations for DBAs. New author Alex Grinberg brings us his techniques for simulating arrays in SQL Server 2000.   Read more...
By Alex Grinberg 2008/02/15 (first published: 2005/05/16) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 141,490 reads
   Items 1 to 6 of 6