SQLServerCentral.com Community Update for {date}

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

Trigger Order III

The Voice of the DBA

Technology and Privacy

There can be a big divide among tech professionals on how they view data privacy. Some don't worry too much, and some are very upset about the lack of data privacy and poor data handling practices from many organizations. Most people are probably in the middLe. I do know that every time I post about a Tesla, there are many people who mention the incredible amount of data Tesla collects, and how that makes them nervous.

Tesla discloses that they collect, and I get copies of my data with my own logger. I find the data interesting and I glance at it over time to look for trends. I'm still happy that my top destination in the last year (after home) is the gym

Other car companies collect data on you and GM is in trouble in Texas. I suspect other companies do this, likely to learn more about how to build better cars, but also to get data they may be able to sell. The same thing likely happens with most of your data. Certainly, mobile phone companies collect lots of data, and I wouldn't be surprised if a lot of your rentals/purchases/visits are being captured and sold to others from all sorts of vendors. Some of you might even be capturing usage data in your software that your customers might not like.

I don't know how I feel about this. I do think disclosure is important but not in the form of some EULA or a contract that people have to click through. I think there ought to be choice of what data is being collected and how it's used. Or if it can be used. While I often just accept or dismiss cookie banners, I do appreciate that I can refuse cookies and still use more websites. I ought to be able to easily opt out from most data collection from most companies. It really should be optional.

The world isn't going back to analog devices and actions. Digital technology, with software invading most parts of your life, is here. I wouldn't be surprised to find out most new appliances have a phone home feature that captures data and sends it back through unsecured wi-fi. A good reason to put a password on all your networks.

In portions of the world, there are restrictions on data and privacy. They could be stronger, and the laws could limit more of what companies can do. Many companies still make money or run fine.

They will be fine. Organizations always find ways to work within whatever system exists.

I think that would be a good thing for most of us if more data privacy restrictions were in place. However, I don't know how most of us would even go about helping enact them.

Steve Jones - SSC Editor

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

Featured Contents

How to Add a New Shared Disk to a WSFC as a SQL Resource

muhkam from SQLServerCentral

Adding a new shared disk to Windows Server failover Cluster is not a complex process but special care must be taken when you want to use the new disk for any existing SQL Instance. In this article, we will show you all the required steps to add the disk to WSFC and then to properly assign it to an existing SQL role in the WSFC.

Download AWS RDS SQL Server Backup

Additional Articles from MSSQLTips.com

Learn how to create a backup of an AWS RDS for SQL Server database and download the backup file to use on another SQL Server instance.

Level up your learning in 2024 with PASS Data Community Summit

Additional Articles from PASS

Connect, share and learn with the global data community in Seattle this November. Whether you're a DBA, Developer, Architect, Engineer or you're just getting started in your data career, there's a huge range of content for you to choose from (over 150 sessions and counting across 5 different tracks). Speakers this year include Steve Jones, Grant Fritchey, Ryan Booz, Bob Ward, Deepthi Goguri and Jennifer Stirrup. Check out the full program and register before September 18 to secure your ticket at the standard price.

From the SQL Server Central Blogs - Spatial Databases & Geospatial Data: A Beginner’s Guide

Tracy McKibben from RealSQLGuy - Helping You To Become A SQL Hero

Ever used Google Maps to find the fastest route home? That's geospatial data in action, turning physical locations into digital info so you can navigate efficiently. Spatial databases take...

From the SQL Server Central Blogs - Comparing Power BI Core Visual and Deneb Stacked Column Chart

Meagan Longoria from Data Savvy

One of the new features in the August Power BI Desktop release is the updated legends that are styled to more accurately reflect the per-series formatting on the visual....

SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability

Additional Articles from SQLServerCentral

Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creating a tamper-evident record of changes to data over time that you can rely on to be correct and reliable.

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Trigger Order III
I have created these triggers in SQL Server 2022: CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GO I want to be sure that the trigger with "1" runs first. I decide to run this: EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first' What happens?
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)

Setting Emergency State

Which server role(s) can set a database to the Emergency State?

Answer: sysadmin only

Explanation: Only sysadmin members can set a database to the emergency state. Ref: Database States - SQL Server | Microsoft Learn

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 Server 2017 - Development

Call Dates Effective Range - Hi Everyone, I have the data in the below form : Desired output: Here what I did is I made a range of dates of the same year in 1st image using the call date start date(in Select) and now I have the 1st date of the year starting to the day before the effective […]

Development - SQL Server 2014

Need help on results output - Hi guys. I need help with query results output. I have the following table: create table MyTable(HH int,F int,T int,Val int) insert into MyTable (HH,F,T,Val) values(2,6,7,11), (2,6,10,1), (3,7,6,12), (3,6,7,17), (4,6,7,15) I need to show those F/T values on the same HH. Something like this HH F T VAL F T […]

SQL Server 2019 - Administration

SSRS configuration issue - cannot connect to SQL Server - I had some issues with a local (development computer) Report Server where the configuration manager, Report Builder apps, etc. would not connect to the SSRS. The service was running and the DB's were accessible through SSMS. After not getting any help I decided to uninstall SSRS and reinstall. During the install process, at the Database […]

SQL Server Transaction Replication Issue: BIT Columns Not Refreshing - Hello Everyone, I have a database that is being copied to six subscribers with several publications. I have noticed that sometimes, when updating the bit data typed column, the updates are not being sent to all subscribers. Out of six, five subs are working perfectly while one is not. I've also reviewed the schema options, […]

Cluster Timeout Settings to handle transient network outages - I have an Availability group with 2 replicas on the same subnet. We've been experiencing short network outages that last a few seconds and cause connections to timeout. This causes the AG to fail completely (not failover automatically) and we have to manually bring it back online since the DBs are marked "not synchronizing" on […]

Question about SQL Certs and DNS aliases - About 15 years ago we started creating DNS aliases for each database. This allowed us to move databases without needing to change client connections. We now use these aliases in all applications, reporting, ETLs, etc... When we upgrade SQL we create new servers and migrate the databases, using the aliases made this simple. We also […]

SQL Server 2019 - Development

SSIS Package runs on one server but getting an assembly component error on anoth - I posted this over on Stack Overflow and got bupkis and was hoping someone over here would be able to help me. I have an SSIS package that has been tested, and ran in Visual Studio 2019. It was originally created, tested, and ran in VS 2017 but when I started having the issue I […]

Integration Services

Developing with SSIS outside sql server - For 15 years I worked with tens of SSIS instances with various customers, always from a remote session. I am used to setting up an RDP to the SSIS server and then using Visual Studio / SSDT (as installed on server) to develop. At my current job I want to work with SSIS , but […]

Suggestions

I don't want to be a PITA here...but - Can someone explain to me why, when I post something, so many times the first attempt rejects me with 'Are you sure you wanted to do that?' and makes me submit my comment again and even then sometimes times out and makes me try a third time? And then sometimes it even puts my comment […]

SQL Server 2022 - Administration

Trying to add some specifications to existing audit log in sqlserver but not wor - Trying to add some specifications to existing audit log in sqlserver but not working 1. Already audit log is in disabled state in server level and in database level , audit log is disabled but cannot do audit add specifications in sql server when I tried to run the specifications its giving below error Msg […]

Password change effect in SSRS - Installed the SSRS and setup the unattended execution account. After setup SSRS, changed the domain account password in AD & apply the same password in Report server configuration manager for unattended execution account. But Getting the below error. The report server has encountered a configuration error. Login failed for the unattended execution account (rsserver configuration […]

SQL Server 2022 - Development

BUY WEED Online, WhatsApp +1(615)314-6286,CANADA ONLINE, free shipping. - https://lumpysfarms.com/ BUY WEED Online, WhatsApp +1(615)314-6286,CANADA ONLINE, free shipping. ORDER CANNABIS CANADA, BUY CANNABIS ONLINE USA, UK, EU EMAIL: larrykarius247@gmail.com Telegram: https://t.me/lumpysflowere WhatsApp: +1(615)314-6286 Website: https://lumpysfarms.com/ Order weed online , buy weed online, Buy cannabis online, Order cannabis online without a medical card from Lumpys a legit online dispensary in USA, online dispensary Ohio […]

Start SSMS Activity Monitor with Task State = (NonBlanks) - I've been searching for this and cannot find any mention or discussion on it yet. So, I'll try here where I seem to have the best results for help... I would like to have Activity Monitor start with the 'Task State' column having the '(NonBlanks)' filter selected by default [rather than (All)]. Does anyone know […]

Adding rows from Lookup where not in Data - I'm trying & failing to add all possible codes from a Codes table, where those codes are not present in the data. Here is a simplified set of data: DROP TABLE IF EXISTS #Codes CREATE TABLE #Codes([Standard] VARCHAR(4), Code VARCHAR(6)) INSERT INTO #Codes ([Standard], Code) VALUES ('STDA', 'Code1'), ('STDA', 'Code2'), ('STDA', 'Code3'), ('STDA', 'Code4'), ('STDA', […]

Text column is taking More time while Querying, Need to Replace DATALENGTH - select * from dbo.resolutions r where R.documentid = 828222222 and DATALENGTH(r.resolution_text) > 0 resolution_text Text column is taking More time while Querying, Need to Replace DATALENGTH, when i replace datalength condition as "r.resolution_text is not null" the above query is returning data

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.