The 2019 State of SQL Server Monitoring report showed how instrumental monitoring is to managing server estates. In this guide, we go further, demonstrating how monitoring can benefit your entire organization. From development to IT management, and from finance to the C-suite. Download your free copy of the guide today
2019-08-05
In this article, we discuss how schema swapping method can be used to keep tables online during the load process.
2019-08-02 (first published: 2017-12-05)
7,612 reads
Your company is ignoring the news: SQL Server 2008 and 2008R2 are officially out of support as of today, but nothing’s changing at your company. You still have SQL Server 2008 in production, and you’re a little nervous. How should you approach the conversations with management? Brent Ozar will help: he;s been there too.
2019-08-02
If you plan to make production data available for development and test purposes, you'll need to understand which columns contain personal or sensitive data, create a data catalog to record those decisions, devise and implement a data masking, and then provision the sanitized database copies. Richard Macaskill show how to automate as much of this process as possible.
2019-08-02
In this article, learn how one DBA solved a query timeout issue with an application by examining the effects that different temporary objects have on query performance.
2019-08-01
11,106 reads
Redgate's Will Sharman explores ways that database MSPs can save time, minimize effort and work more efficiently, while at the same time providing more value to their customers.
2019-08-01
Polls and surveys are increasing in use. If you are a DBA, developer, or data scientist, then it is good to understand how to structure your systems for transparency and proper use.
2019-08-01
In this tip we look at how to fill gaps in dates and times for SQL Server query output when no data exists for specific dates or times.
2019-07-31
Your strategy for loading a freshly built database with data will depend on how much you need. If just a few rows, then single-row INSERT statements will be fine, but for more than that you'll need to build insert the rows using native-format BCP. Fortunately, SQL Change Automation (SCA) can be used with either strategy, as Phil Factor demonstrates.
2019-07-31
In this article, see one of the ways in which a container can be created and used for in SSRS as the source for reports.
2019-07-30
3,613 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers