Creating Merge Replication Conflict Resolvers
This article describes how to create a Visual Basic application for merge replication that will handle both conflict and non-conflict changes between the affected tables.
2001-05-01
2,075 reads
Articles
Connecting to SQL Server with ASP
This article shows you the basics of connecting to SQL Server in Active Server Pages.
2001-04-30
8,643 reads
Log Your Changes
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
2001-04-30
5,407 reads
Moving Databases to a New Server
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
2001-04-30
9,436 reads
Automatically Gathering Server Information Part 8
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,659 reads
Book Review: Guru's Guide to T-SQL
This week, Brian Knight reviews the book Gurus Guide to Transact SQL.
2001-04-29
5,493 reads
Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,926 reads
Automatically Gathering Server Information Part 7
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-27
4,909 reads
Invisible Comments
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
2001-04-26
3,544 reads
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,626 reads
Blogs
Data Technology Learning Resources
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...
How to use a Script Activity in ADF as a Lookup
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have...
Create a copy of an Azure SQL DB
Where I work, we will be migrating data from one set of databases into...
Forums
What Metrics Do You Collect?
Comments posted to this topic are about the item What Metrics Do You Collect?
Updating Sensitivity Classifications
Comments posted to this topic are about the item Updating Sensitivity Classifications
Set up a Windows Server Fail-over Clusters (As a Precursor to High Availability in Standard Edition)
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Set up a Windows Server...
Question of the Day
Updating Sensitivity Classifications
I ran this code on a column in my SQL Server 2022 database:
ADD SENSITIVITY CLASSIFICATION TO dbo.Customer.ContactEmail
WITH (
LABEL = 'Highly Confidential',
INFORMATION_TYPE = 'Contact',
RANK = CRITICAL
);
GO
I then realize I've made a mistake and run this:
ADD SENSITIVITY CLASSIFICATION TO dbo.Customer.ContactEmail
WITH (
LABEL = 'Highly Confidential',
INFORMATION_TYPE = 'Contact',
RANK = HIGH
);
GO
What happens? See possible answers