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,473 reads
Eitan Blumin
- Website: https://www.eitanblumin.com
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
3,377 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,501 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
846 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
575 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
633 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
505 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
544 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
499 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,603 reads
Blogs
A New Word: Incidental Contact High
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
Azure PostgreSQL Flexible Server and Entra Groups
My company is moving from an Azure PostgreSQL single server to a flexible server....
Take the 2025 State of Database Landscape Survey
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Knowing What You Don't Know
Comments posted to this topic are about the item Knowing What You Don't Know
Question of the Day
Am I on Synapse?
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers