Updating an expired SQL Server TDE certificate
Simon Liew explains how to generate a new TDE certificate to replace the previous, and also looks at the steps needed if the database is in an Availability Group.
2018-02-13
2,865 reads
Additional Articles
How to Implement Dynamic Data Masking in Azure SQL Database and SQL Server
Anoop Kumar shows you the SQL Commands (T-SQL) to secure PII/PHI data using the SQL Server Dynamic Data Masking (DDM) feature and explores DDM's built in functions to mask all critical data elements. DDM restricts unauthorized users from accessing critical data with no changes in the application.
2018-02-12
2,929 reads
Azure Cosmos DB Consistency Levels
The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. Azure Cosmos DB extends the range of consistency options by providing support for bounded-staleness, session, and consistent prefix models.
2018-02-09
2,650 reads
Mobile Report Publisher – Dashboards Everywhere
The new feature, Mobile Reports, was added to SSRS in 2016. It provides the ability to create attractive and useful dashboards that can run on devices and most browsers. Robert Cain shows you how to get started building Mobile Reports with the Mobile Report Publisher.
2018-02-08
3,562 reads
Heaps, Deletes, and Optimistic Isolation Levels
Erik shows that heaps have even more drawbacks under optimistic concurrency.
2018-02-07
2,743 reads
Building a Custom Blocked Process Report
Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of poor performance. SQL Server contains a vast amount of information that can help when troubleshooting performance issues like blocking, but understanding and gathering that information when you need it is a lot of work. Darko Martinovic explains his solution for a custom blocking report.
2018-02-06
3,868 reads
Add a SQL Server Database to an Existing Always On Availability Group
In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.
2018-02-05
2,385 reads
Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3
In this tip, Edwin Sarmiento looks at how to create the Always On Availability Group with a listener name when using SQL Server on Linux.
2018-02-02
3,045 reads
Historical Stock Prices and Volumes from Python to a CSV File
Python is a versatile language that is gaining more popularity as it is used for data analysis and data science. In this article, Rick Dobson demonstrates how to download stock market data and store it into CSV files for later import into a database system.
2018-01-31
2,873 reads
Network Issue or THREADPOOL waits?
Tara Kizer talks identifying THREADPOOL waits and what you can do about them.
2018-01-30
3,043 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers