Representing XML data in SQL Server
In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.
Creating or Altering an Objects with a Single Statement
Do you get tired of having your CREATE PROCEDURE statement failing if the stored procedure already exists? If you are like me then you probably hate this as much as I do.
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 […]
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers