Distribution Database Migration
This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.
Monitoring Azure SQL Database
Marcin Policht presents different methods that allow you to monitor the performance and characteristics of your PaaS databases, ensuring that they behave in a manner that matches your expectations.
The SQL Server Container
There's an interesting idea that exists for lightweight, application separation on a host that's different from virtualization. It's Docker, and Steve Jones talks about it today.
Where in the Application Should Data Validation be Done?
Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to validation that includes database constraints, would seem to outweigh the disadvantages.
Data Mining Part 21: Excel and Data Mining,validation methods
This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.
Data Mining Part 21: Excel and Data Mining,validation methods
This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.
Removing Rows with the DELETE Statement in SQL Server
Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.
SQL Monitor Custom Metric: Possible Duplicate Indexes
When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.
Continuous Learning
It pays to continuously learn more about your job. SQL Server is so large, it really is a lifelong effort to drive yourself forward to master more and more.
Prepping for Winter
As winter approaches, many of us get ready in our personal lives, but Steve Jones notes that we might want to make sure we have regular preparation taking place on our systems for difficult times.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers