SQL and NOT SQL: Best of 2017
Photo by Rick Meyers on UnsplashWith only a few days left in 2017, I thought it would be fun to do a year...
2017-12-26
422 reads
Bert Wagner
SQL and NOT SQL: Best of 2017
With only a few days left in 2017, I thought it would be fun to do a year in review post. Below you'll find some of my top 5...
2017-12-26
2 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like...
2017-12-19
7,545 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like this:
And output them so that the Cars and Toys...
2017-12-19
110 reads
Learning Through Blogging and Speaking
This post is a response to this month’s T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by...
2017-12-12
163 reads
Learning Through Blogging and Speaking
This post is a response to this month's T-SQL Tuesday prompt created by Mala Mahadevan. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users...
2017-12-12
3 reads
Reducing the Number of Reads in Your Queries
“A-Bridged” – reducing reads – get it? I’m sorry you’re reading this. Photo by Jamie Street on UnsplashIn last week’s post, we went over how...
2017-12-12
214 reads
Reducing the Number of Reads in Your Queries
In last week's post, we went over how one of best ways to improve query performance was to reduce the number of reads that your query has to do.
Less reads...
2017-12-12
6 reads
How to use Statistics IO to Improve Your Query Performance
SQL Server’s STATISTICS IO reporting is a great tool to help you performance tune queries.Usually the goal of performance tuning...
2017-12-05
3,039 reads
How to use Statistics IO to Improve Your Query Performance
SQL Server's STATISTICS IO reporting is a great tool to help you performance tune queries.
Usually the goal of performance tuning is to make your query run faster. One of...
2017-12-05
59 reads
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