OPENJSON – using the default schema to collect new information
We’ve looked at reading JSON from disk and also verifying that a string we have contains valid JSON data. But, naturally, we’d like to do more than that. Well,...
2020-05-27
122 reads
Blog Posts
Power BI Monthly Digest – May 2020
This month we will likely have two releases of the Power BI Desktop. In May’s Power BI Digest I will again guide you through some
2020-05-27
61 reads
SSMS Quick Tip: Never lose your script from overwrite again!
Twenty something years ago when I started my SQL Server career there was an amazing tool called Query Analyzer. Honestly I’d say if Microsoft did nothing more than bring...
2020-05-27 (first published: 2020-05-07)
899 reads
Step By Step Installation of SQL Server 2019 with all features
[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] Today, I will take you to step by step...
2020-05-27
40 reads
Step By Step Installation of SQL Server 2019 with all features
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] Today, I will take you to step by step installation of...
2020-05-27
41 reads
Three big reasons T-SQL still beats the GUI – a MinionWare snippet
We like code better than mouse clicks for three basic reasons: T-SQL lets you do more. T-SQL lets you share your process. T-SQL lets you keep a record.
The...
2020-05-27
21 reads
Three big reasons T-SQL still beats the GUI – a MinionWare snippet
We like code better than mouse clicks for three basic reasons: T-SQL lets you do more. T-SQL lets you share your process. T-SQL lets you keep a record.
The...
2020-05-27
8 reads
Using WAITFOR to Test Slow Code–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing I needed to do lately was...
2020-05-27
22 reads
Azure Databricks to Azure SQL DB
Recently I got to a stage where I leveraged Databricks to the best of my ability to join couple of CSV files together, play around some aggregations and then...
2020-05-26
27 reads
Daily Coping 26 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-26
9 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