Data Driven Subscription - SQL Server Standard Edition
A simple example of using T-SQL and the Boomerang framework to create a data driven subscription.
2012-02-08 (first published: 2012-01-04)
1,872 reads
Standard edition
RE: Crosstab aggregate error, A Stumper!
This have to do with how CASE works. One thing is that a CASE can only return one datatype - which one if there are multiple datatypes within the same CASE expression, is determined by prescedence. (if not explicitly casted) CASE also only evaluates if the expression is true or false. Now.... the column checked […]
2004-04-30
RE: System Stored Procedures
GSEC stands for GIAC Security Essentials Certification and it's a vendor-independent security certification. GIAC stands for Global Information Assurance Certification and there are several tracks. GSEC is the generic security one. GIAC is the certification series from the SANS institute. SANS is an acronym for SysAdmin, Audit, Network, Security. So there you have the acronym […]
2003-11-23
2 reads
RE: Event ID: 1069
Is this a windows 2000 cluster? More info on your setup would help us find an answer. Thanks, Wes
2003-11-17
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers