SQL Server Metadata using Powershell
If you are new at your job or a new client you would like to gather and review the sql server meta data to understand the environment and get...
2019-08-01 (first published: 2019-07-10)
642 reads
Blog Posts
Teaching DevOps in Indianapolis
There is literally nothing I like better than working on automation. Before we had all the cool toys that we have now, I was working on automating database deployments....
2019-08-01
5 reads
Automating Replication On Your Server
If you use replication, you have had the situation occur where you had to restore a replicated database. You’ve have doubtless been paged to restore a replicated database. You...
2019-07-31
70 reads
Containers make easy upgrades
I’ve been working with containers and writing a bit about them for awhile. I find them to be fascinating and useful as a technology, and I’ve come to really...
2019-07-31 (first published: 2019-07-10)
418 reads
Header Query Crossword
I did an interesting form of crossword recently and since I haven’t done one in a while I figured this ... Continue reading
2019-07-31
56 reads
How to store a password in a database
Hello, and welcome to today’s class on storing passwords in a database. Don’t store passwords in a database. Thanks for attending. Photo by James Sutton on Unsplash.
The post How...
2019-07-31
256 reads
MaxDOP Added to SQL 2019 CTP3.0 Setup
You can now set MaxDOP during SQL 2019 CTP3.0 setup. MaxDOP is the sledge hammer to Cost Threshold’s tack hammer (also MaxDOP database scoped configuration in SQL 2017+) and...
2019-07-31
123 reads
MaxDOP Added to SQL 2019 CTP3.0 Setup
You can now set MaxDOP during SQL 2019 CTP3.0 setup. MaxDOP is the sledge hammer to Cost Threshold’s tack hammer (also MaxDOP database scoped configuration in SQL 2017+) and...
2019-07-31
4 reads
MaxDOP Added to SQL 2019 CTP3.0 Setup
You can now set MaxDOP during SQL 2019 CTP3.0 setup. MaxDOP is the sledge hammer to Cost Threshold’s tack hammer (also MaxDOP database scoped configuration […]
The post MaxDOP Added...
2019-07-31
8 reads
Understanding Columnstore Indexes in SQL Server Part 2
In my last blog I explained what a columnstore index is, in this blog, we will dive into creating a clustered columnstore index and look at the performance differences...
2019-07-31 (first published: 2019-07-10)
550 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