Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Declare Sysname
MSSQL Replication By T-SQL & Docker containers on Linux
This article will provide an overview of the configuration steps on a Linux machine, without delving into the specifics of replication. By the time you've finished reading this article, you'll be able to set up MSSQL database replication for multiple instances of Docker containers on an Ubuntu machine (Linux distribution). Ubuntu (Linux distribution) Docker MSSQL (you can find here how to setup MSSQL on Linux by docker container).
Configuring Service Broker Architecture – SQLServerCentral
Introduction The Service Broker framework provides a Transact-SQL interface for sending and receiving messages, combined with a set of guarantees for message delivery and processing. It guarantees that a program receives each message in a conversation exactly once in the order in which the message is sent, not the order in which the message enters the queue. Service Broker is designed around the basic functions of sending and receiving messages.
Let SQL Server Write Code for You
Skip to main content Eitan Blumin Eitan Blumin Microsoft Data Platform MVP, Solutions Architect, DBA Team Leader Published Apr 16, 2018 Introduction Many times I happen to find myself in a situation where, as a DBA, I need to write some long and cumbersome code (usually for maintenance purposes). For example: Write a script to copy a bunch of tables from one database to another. Import the tables from one database to another database. Rebuild a bunch of indexes. Update a bunch of statistics.
A Simple Recursion Finds Joins – SQLServerCentral
There are many production databases that in practice follow a set of rules such as these: All tables must be created with an integer column named '%ID' to be used as the primary key for the table. Wherever the name of such an '%ID' column is used in another table, it must have a logical foreign key relation to the same-named primary key column, but do not create the physical foreign keys in the database.
Asynchronous Procesing with Service Broker – SQLServerCentral
Introduction When I first heard of the mysterious service broker I was intrigued to find out what it was and what it could do. So I did some reading up and discovered it can play a part in building a range of enterprise solutions. One feature that generated a great deal of interest for me was the asynchronous stored procedures. When writing asynchronous architecture in the past I’ve had to use application languages to orchestrate asynchronous database operations.
A Collaborative Approach To Table Compression – SQLServerCentral
I would like this paper to be a collaborative approach to attaining an end result - improved query performance. I am going to propose an approach to how to identify tables for compression and the resulting SQL statements to implement that compression. What I would from the rest of the community is your thoughts and ideas about this approach. I strongly profess to not knowing all the ins and outs, but offer this approach as a starting point for a very interactive discussion.
Reverse Engineering ADTs in SQL Server 2000 - Part 3 – SQLServerCentral
Reverse Engineering ADTs - Part III Foreign key constraint. In this article we are going to see how to change ADT that is linked to columns defined as Primary and Foreign Keys.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Declare
Contact Declare, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack