SQL Server Performance Dashboard Reports
Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).
The Effect of NOLOCK on Performance
Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system.
The Great and Powerful Internet of Things
A look at the good, and bad, of the IoT world along with the potential future.
Understanding Graphical Execution Plans - Part 3: Analyzing the Plan
Learn how to examine and read a SQL Server execution plan in this article. This is the third part of a short series from Darren White that examines execution plans and imparts the basics on an important skill for DBA's and SQL developers alike.
Using A Block Predicate to Restrict Row Updates and Inserts
If you are using row level security in SQL Server 2016 you might find users are updating or inserting rows of data that keep them from seeing the row after they have performed the update or insert statement. If you want to prevent this from occurring, you can use a blocking predicate.
Introducing Minion CheckDB by MinionWare
Minion CheckDB completes the MinionWare maintenance and backups suite in style. Each solution is plug-and-play for the busy DBA, and deeply configurable for those shops with in-depth needs.
The Future is Now - An Internet of Things Infographic
A look at the positive and negative aspects of IoT in this infographic.
Planning for Successful Data Management
It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them, have their own lifespan. If we neglect the management of data, we risk disaster for the organisations that use it. If we take data management seriously, databases become a lot easier.
A Wide Variation in Skill
We all have different levels of skills, and it's not always because we don't try. Sometimes it's a question of timing.
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers