Azure Database for MySQL
SQL Server is not the only database you build and deploy into Azure. Another very popular option is MySQL. Going back many years, this was actually my first database...
2022-01-11
47 reads
Blog Posts
Daily Coping 11 Jan 2022
I 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...
2022-01-11
26 reads
How to modify SQL Server Analysis Services Modes
This article explores the process modify SQL Server Analysis Services Modes between Tabular, Multidimensional and SharePoint.
2022-01-11
17 reads
PowerShell Script to restart SQL Services
Learn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of SQL Server.
2022-01-11
24 reads
Updated Pluralsight Course – Configuring and Managing Kubernetes Storage and Scheduling
My updated course “Configuring and Managing Kubernetes Storage and Scheduling” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here,...
2022-01-11
37 reads
Daily Coping 10 Jan 2022
I 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...
2022-01-10
27 reads
Data and DevOps Predictions for 2022
All the Advocates at Redgate (Kathi, Grant, myself) got asked about some of the future predictions we might have, based on some of the data from The 2021 State...
2022-01-10
37 reads
How to configure a static port for SQL Server?
One of the first things to do for securing your SQL Server is to change its default TCP port. Read more to configure it.
2022-01-10
977 reads
PowerShell Script to configure SQL Server static Port
Read the article to use a PowerShell Script for configuring SQL Server static Port
2022-01-10
9 reads
SQL Server STUFF
The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...
2022-01-10
11 reads
Blogs
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Forums
To View or not to View, that is the question...
I've read lots of the horror stories about nested views in databases where they're...
Grant user read-write permission to a single database
Hello! How do I grant a user to read-write to a single database and...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers