-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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.

Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!

Planning to Increase Cost Threshold for Parallelism

When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s common to see SQL Server creating and using execution plans with parallelism. The instance configuration “cost threshold for parallelism” is what determines for SQL Server the minimum…

Read more

8 comments, 970 reads

Posted in Eitan Blumin on 27 February 2018

How to fix Orphaned Users easily

What are Orphaned Users

“Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated with its relevant Server Login.

This often happens when the Server Login is deleted (even if  it’s recreated later), or when the database is moved or restored to a… Read more

1 comments, 2,846 reads

Posted in Eitan Blumin on 3 January 2018

How to Update @@SERVERNAME to Actual Machine Name?

The @@SERVERNAME Global Variable

The system global variable @@SERVERNAME can be used to return the name of the machine the SQL Server is hosted on.
This variable is derived from the system table sys.servers, from the record with the server_id column value of 0.
You can find it using… Read more

2 comments, 2,401 reads

Posted in Eitan Blumin on 7 December 2017

DocumentDB Tutorial 2 – Working with Documents

Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents themselves. If you still haven’t, be sure to first check out Eitan’s earlier posts in the DocumentDB series:
1.      Introduction to Azure DocumentDB
2.      My First Azure DocumentDB Account
3.… Read more

6 comments, 1,921 reads

Posted in Eitan Blumin on 11 February 2016

Meet the Team- Eitan Blumin

When I was about 7 years old and got my first computer during the early nineties,
I said “This is the future”.

Now that the future is here and computers are everywhere, I take a look at the world of Data and say “This is the future”.

I started out… Read more

2 comments, 726 reads

Posted in Eitan Blumin on 31 January 2016

Automatic Roll Forward Transaction Log Backups

Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore hundreds of transaction log backups one by one in order to bring your database back from disaster? Not a bit of fun that is. Check out this useful script that… Read more

3 comments, 2,144 reads

Posted in Eitan Blumin on 25 August 2015

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, 2,108 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, 793 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, 1,168 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, 10,571 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

10 comments, 578 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, 2,255 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

10 comments, 1,031 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, 713 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

3 comments, 488 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, 577 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, 416 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, 508 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

10 comments, 461 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

10 comments, 1,027 reads

Posted in Eitan Blumin on 7 May 2012

Older posts