What Percent Complete Is That Index Build?
SQL Server 2019 has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter.
The Next Data Decade
There are lots of predictions that people make at the start of every year. I've written quite a few over the years, but in 2020 I decided not to make any. After all, there are plenty of other people making them. One person that did make some was Jeff Clarke, COO of Dell. He wrote […]
What’s changed for database monitoring this year?
Have your say on the state of database monitoring in 2020. In this latest blog, Redgate’s Jamie Wallis reviews what we discovered from last year’s survey and how you can define the insights for 2020. Tell us and you can get early access to the report plus be entered for a chance to win a $500 Amazon voucher. Read the blog to find out more:
Create Custom Functions in Power Query
Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]
Tracking Underlying Object Changes in Views
Views in SQL Server are used to simplify writing queries and managing security, but’s it’s easy for views to eventually get out of sync with the underlying tables. In this article, Edward Pollack shows how to overcome this problem.
A Data Science Approach in Product Analytics
A significant part of product development is A/B testing. Simply put, this is where companies and product managers test to see a new version of their product versus the older one to make sure it’s worth publishing their features to the entire user base. In order to do this, an A/B test needs to be set […]
Getting Started with CQRS – Part 3
Diogo Souza completes his series on CQRS. He demonstrates Event Sourcing to capture the data as it flows through the system which can then be analyzed without affecting the source.
The SQL Community Steps up in Time of Need
Healthcare workers are some of the many heroes working bravely in the face of the Covid-19 pandemic. To protect themselves and their patients, they must wear face masks during their entire shifts. This causes a great deal of ear irritation, so a strap was designed to make wearing the masks easier and alleviate pressure on […]
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers