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...
2013-12-04
2,455 reads
Eitan Blumin
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...
2013-12-04
990 reads
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...
2012-12-23
1,096 reads
SSIS Tips & Tricks
For your convenience, below is a download link to get the presentation and relevant materials for the SSIS Tips & Tricks...
2012-10-23
756 reads
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...
2012-08-04
511 reads
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...
2012-08-01
620 reads
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...
2012-05-20
442 reads
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...
2012-05-16
540 reads
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...
2012-05-07
484 reads
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...
2012-05-07
1,115 reads
Blogs
A simple Machine Learning process example (supervised) – just to start with
By damianwidera
I have just written the fifth article of the Machine Learning topic. !!! This...
Always On: Troubleshooting Consolidated
By Vinay Thakur
Working on Always On and configuration/setup of AG we have observed many errors. especially...
Changing Git Credentials in Windows
By Steve Jones
tl;dr For Windows when you need a different account. I had to work with...
Forums
Failed to installing Failover Cluster
Hello everyone, I Have SQL Server 2017 Developer edition, Windows 10, and I'm trying...
Storing JSON data
Comments posted to this topic are about the item Storing JSON data
Memories of DR testing
Comments posted to this topic are about the item Memories of DR testing
Ask SSC