Slowly Changing Facts
This article describes a design pattern for storing “effective dated" changes to fact tables.
2013-10-18 (first published: 2010-12-22)
20,716 reads
Replication
Script to get a list of publications an article is in
Script to get a list of publications an article is in
2010-12-17 (first published: 2010-12-08)
3,747 reads
2010-12-03 (first published: 2010-11-22)
1,697 reads
Setting up Transactional Replication in SQL Server 2008 R2
Transactional Replication is used when DML or DDL schema changes performed on an object of a database on one server needs to be reflected on the database residing on another server. This article provides a step by step guide to setting up transactional replication on SQL Server 2008 R2.
2010-11-15
2,436 reads
Replication Schema Option Across Different Versions of SQL Server
My company uses replication quite extensively across SQL 2000, SQL 2005 and SQL 2008 servers. The problem with using different versions of SQL Server is that the replication options do not always behave the same way. Because of these differences we have stopped using SQL Server Management Studio and Enterprise Manager to setup replication. Also we have taken the time to look at the schema options for replication to make sure the end result is the same for all versions of SQL Server.
2010-10-27
2,218 reads
Using T-SQL to Verify Tables Row Counts in Transactional Replication
This article will help you to use T-SQL to verify that the Subscribers have the same number of rows of replicated data as the Publisher in transactional replication
2010-08-05
11,139 reads
6 Steps to setting up Replication with Mirroring
Script to setup transactional replication with updatable subscriptions when also using mirroring
2011-06-28 (first published: 2010-06-16)
5,186 reads
Poor Man's Table Difference
Given a tablename and other parameters, this procedure will return a table made of foreign keys and a checksum for each
2010-05-06 (first published: 2010-05-02)
2,010 reads
Scaling Out the Distribution Database
Replication is a great technology for moving data from one server to another, and it has a great many configuration options. David Poole brings us a technique for scaling out with multiple distribution databases.
2010-03-30
11,187 reads
Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization
In this article we summarized the experiences we gathered during the planning and upgrade of a customer's project. The customer is one of the largest retail shops in its area. Their architecture is made up of a main server, which is located at headquarters and hosts several hundred publications containing over a thousand articles. Regional stores are located all over the country acting as subscribers for the publications hosted on the main server. Based on the business needs and infrastructure limitations the customer set the following goals for the project:
2010-02-26
2,504 reads
Blogs
Regression Testing: DAX User Defined Functions
User Defined Functions is a new feature in PowerBI currently in public preview. There...
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
Forums
SQL MI Next-gen general purpose tier
Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation...
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers