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,471 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,352 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,484 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
841 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
565 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
631 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
500 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
497 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,583 reads
Blogs
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Webinar – Microsoft Fabric for Dummies
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Forums
Extend Event with sqlserver.login
My knowledge of Extended Events is limited, but I am trying to capture some...
ghost backups processed 0 pages
I've got something I'm not aware of performing backups of my dbs at random...
Stored Procedures - passed string than variable length
Dear all, I was just wondering: Can you change the default behaviour as illustrated...
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers