Time-Series Data Analysis with Apache Druid
Learn the basics of Apache Druid and how it can be used to ingest data into a data lake.
2023-11-10
13,767 reads
Management Data Warehouse
Removing the SQL Server Management Data Warehouse
SQL Server 2008 introduced a new feature, Management Data Warehouse (MDW), which allows users to collect metrics on their servers over time to aid in performance troubleshooting. A lot of people try this feature out, because it is easy to set up, and then find that it is not so easy to remove. In fact, removing MDW is not supported; in SQL Server 2012, though, a new system stored procedure was added to make this process easier. The problem is that this stored procedure (as well as several of the workarounds I've seen published) can leave several objects behind.
2012-08-09
2,418 reads
Analyzing Product Growth with the Management Data Warehouse
This article presents a case study of using the Management Data Warehouse feature in SQL Server 2008 to analyze disk usage trends by product.
2010-11-29
3,810 reads
Blogs
SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Forums
Dropping a Service from Service Broker crashes server
I'm having an issue trying to drop a service. When I issue the drop...
SQL MI - SQL Jobs failing with User Manager\ContainerAdministrator.
This is strange, any SQL job that sends out Emails via 'msdb.dbo.sp_send_dbmail ' are...
Tempdb: is it being used?
hi so i have a really old application that is used to process data...
Ask SSC