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,942 reads
Scripts
2012-02-07 (first published: 2011-12-15)
1,048 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,215 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,483 reads
2012-01-25 (first published: 2011-11-09)
1,282 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,115 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCU JOMBANG Telp:08218154398
WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...
Alamat kantor BCA KCU MADIUN Telp:08218154398
WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers