Using SQL Monitor to manage a growing server estate
The State of SQL Server Monitoring report found that monitoring is key to managing large estates, and as estates continue to grow the need for a monitoring solution that is scalable is increasing. German IT Service Provider Fiducia & GAD IT AG implemented Redgate’s SQL Monitor to better manage the performance of its growing SQL Server estate.
Memories of DR testing
With the introduction of the GDPR, a lot of our prospective clients are demanding more and more information regarding data disposal, retention and usage practices. Both our new and existing clients want to look at our internal ecosystem and understand how we manage it. This means that I finally got a budget for a disaster […]
Simple SQL Change Automation Scripting: The Release Object
Once you understand the SCA data objects, it can give you a certain glow of to discover, suddenly, that SCA can do some complicated and time-consuming tasks with just a few lines of code. Phil Factor demonstrates how to get the most of SCA's Release object.
Lots of data in RAM
I remember buying my first computer after college. At the time I was working part time and in graduate studies part time. My aging high school era Apple II wasn't capable of handling the load, not to mention its 300baud modem wasn't a lot of fun. I could likely have gotten a faster modem with […]
Muting the Immutable
Phil Factor on dealing with "immutable" domain data during database development and deployment.
Vagrant and SQL Server 2017 on Linux
Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017
Simple SQL Change Automation Scripting: Connections, iProjects and Builds
Phil Factor delves into some of SQL Change Automation's data objects, or artifacts, covering the DatabaseConnection, iProject and iBuildArtifact objects. He explains the useful information they contain and how to use them in a PowerShell-automated database delivery process.
Welcome to the DBA Training Plan.
8 years ago, Brent launched an email series with a 6-Month DBA Training Plan. he sent one email per week, bringing people up to speed on the most important topics that nobody taught ’em along the way. It’s hard to believe it’s been 8 years! This month, he's revisiting the emails, updating their content, and publishing ’em as blog posts too to make ’em easier to find. Buckle up: here come 24 straight blog posts to take you from zero to…well, at least a hero who’s smart enough to wear the underpants on the inside.
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
How Important Is a Google Knowledge Panel for Online Reputation?
I’ve been learning more about the google knowledge panel and it seems like one...
Which Wireless Credit Card Terminal Works Best for Small Businesses?
I’m currently researching the best wireless credit card terminal for a growing business and...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
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