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,941 reads
Scripts
2012-02-07 (first published: 2011-12-15)
1,047 reads
2012-02-06 (first published: 2011-12-23)
1,547 reads
2012-02-02 (first published: 2012-01-20)
3,908 reads
2012-02-01 (first published: 2012-01-20)
2,214 reads
2012-01-30 (first published: 2011-12-23)
879 reads
Calculate the values for MAX Memory for SQL Server
Use this script to calculate MAX memory setting on a dedicated SQL server.
2012-01-27 (first published: 2011-12-14)
3,482 reads
2012-01-25 (first published: 2011-11-09)
1,281 reads
2012-01-25 (first published: 2011-12-15)
1,191 reads
Stored procedure to find and replace text in a text file
find and replace text in a text file using tsql
2012-01-23 (first published: 2011-12-16)
3,113 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCP Industri | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Industri II No.14, Muktiharjo Lor, Kec. Genuk, Kota Semarang, Jawa Tengah 50197...
BCA KCP Sidareja | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Jenderal Ahmad Yani No.40, Cikalong, Sidareja, Kec. Sidareja, Kabupaten Cilacap, Jawa Tengah...
BCA KCP Siliwangi | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141...
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers