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

Eitan Blumin

Eitan Blumin is a SQL Server database expert and a senior consultant at Madeira SQL Server Services. He has more than 10 years of experience in all fields of the SQL Server DBA role, including but not limited to: Database design, management, development, tuning, replication, backup management, security management, SSIS, SSRS, encryption and more. Eitan also has 10 years of experience in ASP web development, and some experience in a wide variety of development environments such as PHP, C, C++, C#, VB, Java, Perl, Assembler and more.

Getting Started with Azure DocumentDB Programming

In my previous post in the series, I provided a short explanation on how to register your very first Azure DocumentDB account and play around in the Azure Portal.

If you haven’t read it yet, please read it first here: http://www.madeirasql.com/my-first-azure-documentdb-account

In this post, I’ll help you get started with… Read more

0 comments, 841 reads

Posted in Eitan Blumin on 28 June 2015

My First Azure DocumentDB Account

In my first post in the series, I provided a basic introduction to Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.
If you haven’t read it yet, and you’re still unfamiliar with DocumentDB, then I recommend you read it here.

In this post, I will… Read more

0 comments, 178 reads

Posted in Eitan Blumin on 22 June 2015

Introduction to Azure DocumentDB

This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.

What is DocumentDB?

DocumentDB is a new “Big Data” database engine created by Microsoft and managed as a service within their Azure Cloud framework (currently available in their Azure Preview… Read more

0 comments, 260 reads

Posted in Eitan Blumin on 11 May 2015

Let SQL Server Write Code for You

Introduction

Many times I happen to find myself in a situation where, as a DBA, I need to write some long and cumbersome code (usually for maintenance purposes).

For example:

  • Write a script to copy a bunch of tables from one database to another.
  • Import the tables from one database…

Read more

1 comments, 9,723 reads

Posted in Eitan Blumin on 4 August 2014

Service Broker Sample: Asynchronous Triggers

Introduction

Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so it’s hardly “new” any more. But in reality, many DBAs and database users are still not aware of this feature, don’t know how to utilize it, or are afraid… Read more

15 comments, 120 reads

Posted in Eitan Blumin on 4 December 2013

Service Broker Sample – Asynchronous Triggers

Introduction

Service Broker is a cool feature new since SQL Server 2005. Yes, SQL 2014 is just around the corner so it’s hardly “new” any more. But in reality, many DBAs and database users are still not aware of this feature, don’t know how to utilize it, or are afraid… Read more

0 comments, 433 reads

Posted in Eitan Blumin on 4 December 2013

Generate MERGE Statements for Your Tables

Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply it on an identical table somewhere else, or on the same table in a later point in time.

This script uses two useful concept which, when combined, can give you… Read more

2 comments, 207 reads

Posted in Eitan Blumin on 23 December 2012

SSIS Tips & Tricks

For your convenience, below is a download link to get the presentation and relevant materials for the SSIS Tips & Tricks presentation by Eitan Blumin presented during Madeira’s PASS Pre-Conference event on October 23rd, 2012.
It includes the material that we didn’t have time to cover as well:

Also, clicking… Read more

0 comments, 142 reads

Posted in Eitan Blumin on 23 October 2012

Protect Against SQL Injection Using Triggers

Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes maintain the websites I still have. Fix things, add things, and most importantly – clean up the mess left in the database after a nasty SQL Injection attack.

Recently one… Read more

2 comments, 133 reads

Posted in Eitan Blumin on 4 August 2012

Fully Dynamic Search Conditions vs. SQL Injection

SQL Injection is a widely known issue with databases that work as back-ends for websites and applications. In the most part, protecting your website from SQL Injection is fairly easy and you can find a lot of resources on that around the internet.

Usually, this issue is solved by using… Read more

0 comments, 165 reads

Posted in Eitan Blumin on 1 August 2012

Dynamic Stored Procedure Execution in SQL Server

In my previous blog post: Suggestion: “USE” Keyword with Linked Servers, I talked about the suggestion I’ve posted on Microsoft Connect which allows easy execution of dynamic code on linked servers.

I’ve received a surprising reply from Umachandar of the SQL Programmability team, revealing to me an amazing feature… Read more

0 comments, 123 reads

Posted in Eitan Blumin on 20 May 2012

Suggestion: “USE” keyword with Linked Servers

Using special functions for querying and executing commands at linked servers is not very convenient, and sometimes even very problematic.
For example, I need to execute some code on several linked servers but the linked server names are dynamic (queried from a table for example).
On each such linked server… Read more

0 comments, 119 reads

Posted in Eitan Blumin on 16 May 2012

Service Broker Sample: Multi-Threading

Introduction

Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly “new” anymore. But in reality, many DBAs and DB users are still not aware of this feature, or don’t know how to utilize it, or are afraid to do… Read more

0 comments, 106 reads

Posted in Eitan Blumin on 7 May 2012

Service Broker Sample: Multi-Threading

Introduction

Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly “new” anymore. But in reality, many DBAs and DB users are still not aware of this feature, or don’t know how to utilize it, or are afraid to do… Read more

0 comments, 230 reads

Posted in Eitan Blumin on 7 May 2012

Using Reporting Services as your Software Frontend

Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to reports of all shapes and sizes.

Technically, this platform is meant for nothing more than reports. It’s true that reporting is a huge field and you can do all kinds of cool… Read more

0 comments, 160 reads

Posted in Eitan Blumin on 8 February 2012

LOOP, HASH and MERGE Join Types

Today I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences, best practices and complexity.

For the samples in this post, we’ll use the free AdventureWorks database sample available here: http://msftdbprodsamples.codeplex.com/releases/view/4004

Introduction: What are Join Operators?

A join operator is a… Read more

7 comments, 381 reads

Posted in Eitan Blumin on 5 January 2012