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.

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, 1 read

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, 40 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, 19 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, 24 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, 26 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, 21 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, 27 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, 18 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, 0 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

4 comments, 20 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, 18 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

0 comments, 41 reads

Posted in Eitan Blumin on 5 January 2012