Tagging SQL Server Changes in SQL Monitor
How to use RAISERROR() in T-SQL to send annotations to SQL Monitor, so you can observe the direct impact of application tasks, or server changes, on the SQL Server metrics.
2020-03-27
299 reads
Articles
Evaluating SQL Data Catalog using Docker Containers
Richard Macaskill shows how to use Docker Compose to get SQL Data Catalog up and running in a container, in your SQL Server test lab, and then use it to evaluate its data discovery and categorization capabilities on a containerized SQL Server instance.
2020-03-26
Virtual Reality
While we are centuries away from the Holodeck experience, we can take advantage of today’s technology for fun or education.
2020-03-26
426 reads
Storage 101: Understanding the NAND Flash Solid State Drive
Today, most organization are using solid-state drives for everything from laptops to enterprise database storage and virtual machines. In this article, Robert Sheldon explains how NAND flash solid-state drives work.
2020-03-25
816 reads
Using SQL Monitor Groups in PowerShell
Not only are SQL Monitor Groups probably the neatest and most maintainable way of ensuring that all your SQL Servers have the best possible configuration of alerts, but they represent a powerful way of categorizing your SQL Server estate. In this article, I'll show how to use the SQL Monitor PowerShell API to export these groups, save their settings onto a configuration management system, or compare groups of settings to see the differences between them.
2020-03-25
797 reads
Creating SQL containers on Azure Data Studio Notebooks with Python
Carlos Robles explains how to use Azure Data Studio Notebooks to create SQL containers with Python.
2020-03-24
2,824 reads
Avoid using constants in an ORDER BY clause
Phil Factor explains why an ORDER BY clause should always specify the sort columns using their names, or aliases, rather than using an integer to specify the position of a column in the SELECT list.
2020-03-24
Power BI Dashboard vs Report vs Workbook
There are many different ways to present data using Power BI and this tip looks at these different methods such as Power BI Dashboards, Power BI Workbooks and Power BI Reports.
2020-03-24
2020-03-23
1,546 reads
SQL ConstantCare® Population Report: Winter 2020
Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out.
2020-03-23
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
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...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers