Culture and Performance
Culture is important at our workplace. Steve Jones notes this can be important when trying to get the most performance from your employees.
SQL, and Ye Shall Find
Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.
Exploration of SQL Server 2016 Always Encrypted – Part 3
In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.
Centrally collect replication conflicts and send an alert
Automatically capture replication conflicts and generate an automated email notification.
Who's Got a Preteen SQL Server?
This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you might have.
How to read data from multiple Excel worksheets with SQL Server Integration Services
Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.
SQL Azure Performance Benchmarking
An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.
The New Operating System
We have an operating system for how our organizations are run. Steve Jones talks about a new one that might be important for the world rules by software.
Monitoring In-Memory OLTP: What's Important?
In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Server, it pays to plan a monitoring strategy to ensure that you are alerted as soon as possible when things go awry.
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
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers