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...

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...

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...

SSIS Tips & Tricks

For your convenience, below is a download link to get the presentation and relevant materials for the SSIS Tips & Tricks...

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...

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...

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...

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...

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...

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...