Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

The Power of Data and Privacy

I tend to be fairly careful with data, especially data on this site. When we started the site, we were worried about potential issues and worked hard to ensure we kept our systems safe and limited the attack surface area for personal information. We also declined the various offers we had to sell our list of subscribers to marketing firms. We know that some places add value for marketing, but some abuse the trust of their users and our approach was always to be careful.

When we sold the site to Redgate, we emphasized the need for this trust, and to date, Redgate has been a great steward of your personal information. I regularly field requests for uses of data from other marketing people, and almost all get declined. I've had a number of great managers who have supported me on this because we value your privacy.

Recently I saw a piece from Troy Hunt, asking who deserves privacy. He runs HaveIBeenPwned, which tracks data breaches. There have been some sensitive breaches, like the Ashley Madison breach, and he has decided to handle some of those differently. I appreciate that, even though I don't visit any of those sites, I do think there can be unintentional consequences from revealing too much data.

We certainly have plenty of problems with public data, which was never intended to be accessed at scale. Once someone can query lots of data from one place, they can correlate and use it in ways we never imagined.

In the piece Troy notes that he has been attacked by some people because he has chosen to redact certain information. This is censorship of a sort, but a) this is a private site, and b) there are good intentions. This service was never intended to be a weapon, and I agree with that. I have rarely censored anyone at SQL Server Central, but it has happened when someone becomes harassing and unprofessional. Our forums are great for civil debate and disagreement, but not for personal attacks.

I am glad for the restrictions that the GDPR and similar legislation has placed on how companies used data. It has made many individuals and organizations more responsible with how they handle data internally. It hasn't necessarily helped with data breaches, but at least there are less intentional abuses.

Data has tremendous power at scale and my view is similar to Troy's: we all deserve some level of privacy.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform

John Miner from SQLServerCentral

This next articles gives you a few quick ways to access data in remote storage.

External Article

Using REGEXP_COUNT to Count Strings in SQL Server 2025

Additional Articles from MSSQLTips.com

We need to find out how many times certain strings appear in a column. We’ve used the LEN and REPLACE functions for years, but recently heard about REGEXP_COUNT and want to evaluate it, since we plan to upgrade to SQL Server 2025. How can we test this new feature?

Blog Post

From the SQL Server Central Blogs - SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS

aen from Anthony Nocentino Blog

Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now runs successfully on Docker Desktop for macOS without needing OrbStack.

Blog Post

From the SQL Server Central Blogs - Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes

SQLPals from Mission: SQL Homeostasis

Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes

After tempdb, msdb is often the most abused system database, growing unchecked until it tanks...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

Site Owners from SQLServerCentral

A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

What's the Date?

In SQL Server 2025, there is a new function that returns the current date without the time. What is it?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Changing the AG Listener

In SQL Server 2025, if I want to remove an IP from a listener, what do I do?

Answer: Use ALTER AVAILABILITY GROUP with the REMOVE IP option

Explanation: ALTER AVAILABILITY GROUP has a new option, REMOVE IP, to change this. Ref: ALTER AVAILABILITY GROUP - https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-availability-group-transact-sql?view=sql-server-ver17#remove-ip--four_part_ipv4_address--ipv6_address-

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Azure - Administration
Huge frustration - Database watcher with two elastic pools - Think there's a reason why this is still in preview, but have someone manage to get this to work properly with two Elastic Pools on one Virtual SQL Server? Regardless how I try to add the target, it always end up collection databases from the first Elastic Pool. Dashboard would say number of databases equal […]
Reporting Services
SSRS shared dataset parameters not showing in expression builder - I am creating shared datasets that our executive staff can use for creating reports in Report Builder. I need to pass parameter value to the shared dataset query such as "Location" and "AddressType" I can define parameters for shared dataset. They are set to be used in query. When i go to expression builder, they […]
SSRS shared dataset parameters not showing in expression builder - I am creating shared datasets that our executive staff can use for creating reports in Report Builder. I need to pass parameter value to the shared dataset query such as "Location" and "AddressType" I can define parameters for shared dataset. They are set to be used in query. When i go to expression builder, they […]
Editorials
Expensive CPUs - Comments posted to this topic are about the item Expensive CPUs
25 Years of SQL Server Central - Comments posted to this topic are about the item 25 Years of SQL Server Central
Article Discussions by Author
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance - Comments posted to this topic are about the item SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE() - Comments posted to this topic are about the item Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Creating JSON I - Comments posted to this topic are about the item Creating JSON I
Tame Those Strings (Series) - Comments posted to this topic are about the item Tame Those Strings (Series)
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes - Comments posted to this topic are about the item Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Databricks Data Intelligence Platform: Unlocking the GenAI Revolution - Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking the GenAI Revolution
Storytelling with Data: Let's Practice! - Comments posted to this topic are about the item Storytelling with Data: Let's Practice!
Fundamentals of Data Engineering: Plan and Build Robust Data Systems - Comments posted to this topic are about the item Fundamentals of Data Engineering: Plan and Build Robust Data Systems
SQL Server 2022 - Development
Is it uncommon for Dev's to have a data model of the source data - This is a generic question. To the moderators, I wasn't sure where to place this. I mostly work in the BI space now. Is it common in the industry for the team managing an app or data source to maintain an ERD? The places I've worked in the past few years are no longer doing […]
ROLLUP to calculate Month total for all Categories - Good Afternoon, I have built a table with four columns:  Period(Month), Category, Numerator, Denominator. Period(Month) is an Alias name, and Numerator and Denominator are calculated columns: SELECT ,convert(NVARCHAR,Date,3) as 'Period(Month)' ,[Category] , sum([X]) as 'Numerator' ,SUM([Y]) as 'Denominator' FROM Tabl1 GROUP BY [Category], convert(NVARCHAR,Date,3),CAST(Date AS date) ORDER BY convert(NVARCHAR,Date,3) desc Now I want an additional […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -