2019-04-26
493 reads
Service Broker (SSSB)
Service Broker Part 2: Why Service Broker
The second part of this series focuses on the advantages of Service Broker over other messaged-based technologies to introduce asynchronous message processing into your database applications.
2019-04-22
16,862 reads
2019-04-19
508 reads
New Online Course: SQL Server Service Broker for Developers and DBAs
I'd love to be running Service Broker classes more often. Service Broker is one of the most powerful, yet least understood technologies in SQL Server. Many of our enterprise...
2019-04-15
Service Broker Part 1: Service Broker Basics
This article covers SQL Server 2008 Service Broker, an asynchronous messaging framework that is directly integrated within the relational engine of SQL Server. The series will provides you with the basics about implementing Service Broker applications and how you can transparently scale them out to support any required workload.
2020-11-06 (first published: 2019-04-15)
61,963 reads
2018-06-01
710 reads
2016-12-01
876 reads
2016-11-21
4,659 reads
Configuring Service Broker Architecture
Learn how to configure technically reliable, consistent, robust, efficient, asynchronous message queuing and processing mechanism to start developing highly available, scalable applications based upon the service–oriented architecture.
2018-09-07 (first published: 2015-09-03)
10,846 reads
2014-10-20
253 reads
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers