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

Moving On After a Technology Fail

Recently my smartwatch broke. I was coaching volleyball and demonstrating something to a few kids when a ball hit the case of my watch just right and broke a corner there the watch band attaches. I've been playing and coaching with my watch in this way for many years and never had an issue, but apparently there was enough material fatigue that this time something snapped. I was very sad as this was my ten-year gift from Redgate, which I've loved, used, and cherished for 7 years now.

I wonder if there's a 20-year gift ...

In any case, I lived for a day before I realized I really depend on my smartwatch. I quickly realized that I constantly look at my watch to check the time, run a stopwatch at volleyball, track my heart rate and exercise for health, and most importantly, wake me up with a vibration in the morning. Before I had this I set an audible alarm, which my wife hated. At the time the case broke I was very busy, and after a quick set of searches and very minimal evaluation, I just bought a Garmin Venu 2Sq as a replacement. It was inexpensive, but appeared to do most of what I wanted. If I decided I didn't like it, I wasn't out a lot of money.

I contacted Garmin, but they said they wouldn't repair or replace cases. Maybe they assume technology that is more than 5 years old is too prone to failure and not worth fixing? Maybe they just want to sell new products and not support old ones? I get all that, but this age of disposable digital tech is a bit annoying and mildly upsetting to me. I constantly fix old things on the ranch and I like keeping devices going as long as possible. Why not make cases replaceable? I feel the same way about a few devices that have embedded and built in cords. One of my Google cameras had a cord failure when a cat chewed it and the entire device is not junk because I can't repair this tiny cable and Google won't. But I'm getting distracted here.

This new watch is very different. Less buttons, more touch screen, and a different type of OS. I am having to learn how to use a new tool, which is both exciting and annoying. I am less productive in some ways as I learn a new tool, and I'm sure I'm missing things because I just want the tool to work rather than invest the time to learn about (potential) ways to use it. I know that there might be plenty of features I learn about that I'm uninterested in using, and I'll have wasted time.

I see this often in technology. Many of us get used to working with tools in a certain way, and we learn to be productive. We get comfortable, develop habits, and work around annoyances. If the tool changes, or we are forced to use a new one, often we don't like the change. We may feel lost and not see the advantages of a new tool.

I see this all the time as I work with customers. Sometimes I can see better ways they can accomplish tasks, and sometimes I see the cost of change is too high. Even a more efficient way of working can't overcome a loss of productivity for a long period of time if too much change is required. Leaning on existing tools, skills, and habits can be efficient and comfortable. Going through the hassles of change can be worth the effort. Like most things in the database world, the devil is in the details and the answer to the value of changes is it depends. Sometimes a new tool is valuable and sometimes it is not worth the effort.

Almost a month into a new watch, I'm unsure of whether I like it or not, but in the short term, I'm too busy to spend time looking for a new tool. Unfortunately, that's the state of the world often for many of us. We live with good enough.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Configuring Maintenance Plans in SQL Server

Kenneth Igiri from SQLServerCentral

See a walkthrough of setting up a maintenance plan in SQL Server.

Technical Article

Upgrade and Migrate SSIS Catalog and SSISDB to a New Server

Additional Articles from SQLServerCentral

There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.

Blog Post

From the SQL Server Central Blogs - Free PostgreSQL Performance Monitoring with pgNow

Grant Fritchey from The Scary DBA

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute Beginner.” There are several ways to get an understanding of how well your queries are...

Blog Post

From the SQL Server Central Blogs - Creating a GitHub Actions Self-Hosted Runner

Steve Jones - SSC Editor from The Voice of the DBA

I had to demo the Flyway Autopilot system recently and created a GitHub Actions runner as a part of that. This post documents how this went. First, if you...

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

Site Owners from SQLServerCentral

Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2.

 

  Question of the Day

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

 

Counting Bits III

What is the output of this code in SQL Server 2022?
select bit_count(0xEF)

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)

A Simple Choice

I have this data in a table?

CatID	CatName 3	Monitors

What is returned when I run this code?

SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c

 

Answer: NULL

Explanation: The CHOOSE function takes an index as the first parameter. This is used to pick one of the other parameters passed in. If the index exceeds the number of parameters, NULL is returned. Ref: CHOOSE - https://learn.microsoft.com/en-us/sql/t-sql/functions/logical-functions-choose-transact-sql?view=sql-server-ver16

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 2019 - Administration
SSL Certificate Chain - SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m encountering an SSL certificate chain issue when trying to connect to my SQL Server from a Power BI server. The server connects, but when I click refresh, this error appears. Below are the details: Error Message: Microsoft SQL: A connection was […]
SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI - I’m encountering an SSL certificate chain issue when trying to connect to my SQL Server from a Power BI server. The server connects, but when I click refresh, this error appears. Below are the details: Error Message: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login […]
sqlserver metrics to capture - Can this baselining and benchmarking sqlserver be done using extended events ? what are the various events from underneath which can be captured as metrics to benchmark/baseline a sqlserver ? SELECT xp.[name], xo.* FROM sys.dm_xe_objects xo, sys.dm_xe_packages xp WHERE xp.[guid] = xo.[package_guid] AND xo.[object_type] = 'event' ORDER BY xp.[name]; What are the free options to […]
SQL Server 2019 - Development
Restoring replicated data - I am a software developer using MS SQL server as my database. I have setup transactional replication between two servers (A as publisher and B as subscriber). My application is running on server A. This has been running smoothly until my server A crushed. A new server has been provisioned for data to be restored […]
blocking folks from using a linked server and plumbing one to specific dsn - hi, as we get further and further into netsuite connectivity, we want to block just about everyone (dbas, myself etc etc) from using a certain linked server that is plumbed to a production accounting instance of netsuite.   Presumably plumbed to a dsn set up with the creds to see data there. I think i have […]
blocking folks from using a linked server and plumbing one to specific dsn - hi, as we get further and further into netsuite connectivity, we want to block just about everyone (dbas, myself etc etc) from using a certain linked server that is plumbed to a production accounting instance of netsuite.   Presumably plumbed to a dsn set up with the creds to see data there. I think i have […]
SQL Azure - Administration
SQL Server backup to Azure Storage Account - Hi Does anybody know if it is possible to run a backup from a SQL Server instance (IaaS VM) to an Azure Storage Account without using a [Shared Access Signature] or [Access Keys]? IE: can it be done using an Entra Managed Identity? Thanks in advance
General
Making Additions and Changes; Getting Error Preventing Them - MS SQL Server/SSMS are my tools. As my project evolves I find I need to add data elements (Columns) to my existing tables.  I'm confident I will need to add additional tables to the database at some point.  The first time I added a column and tried to close/save the table, I got an error […]
SSMS Object Explorer Not Showing Tables - If this post doesn't meet protocol here, please tell me how to improve as I'm new here.  I thought a screenshot would best help my question. In the ss you can see that I have a database (db?) created named hutchinsCLAN.  I created - and even modified - 3 tables for it: clanPEOPLE, clanMARRIAGES, clanDEATHS.  […]
Do You Folks Mind Beginners Here? - I'm a retired IT guy in his 80s fighting boredom by trying to learn new things.  SQL is the newest topic. Am I in the right place or do you prefer not to have noobs here?
Do You Folks Mind Beginners Here? - I just joined and posted a brief profile.  This is my first post.  Please be gentle.  It'll take a minute for me to learn the ropes. I'm retired from IT having entered the field in 1965.  I'm 83.  I haven't done much more than use canned apps on a PC for the last couple of […]
SQL Server 2022 - Administration
SSMA for Oracle get error for assembly 'Oracle.ManagedDataAccess' - Hi, I am using the SSMA for Oracle v10.0. I have installed the SSMA for Oracle extension pack on the server that the SQL Server 2022 instance is running. The database 'sysdb' was created on the instance and I can successfully execute the 'Migrate Data' on the SSMA on this server. However, if I re-run […]
SQL Server 2022 - Development
Or condition in where clause works differently in MS SQL comparing with Sybase - Hello, I ran below statements in MS SQL, and got error, but fine in Sybase: create table testDiffTypeSameCol (IssueNo int null, StringNumeric varchar(30) null) insert into testDiffTypeSameCol values (1, 'this is string') insert into testDiffTypeSameCol values (2, '123.456') select * from testDiffTypeSameCol where ( ( IssueNo = 2 and convert(numeric(15,2),StringNumeric) > 1.0 )  or ( […]
ROWID in MS SQL - WHERE a.ROWID IN (SELECT rid FROM ( SELECT ROWID rid, row_number() OVER (PARTITION BY c.id ORDER BY c.id) rn FROM details c WHERE a.id = c.id AND c.id > ( SELECT max(id) FROM details d WHERE d.id = c.id AND d.cd = '2030') AND c.cd IN ( '2017','2012','2021')) WHERE rn = 1 )
ROWID in MS SQL - How to rewrite a query in MS SQL, please? WHERE a.ROWID IN (SELECT rid FROM ( SELECT ROWID rid, row_number() OVER (PARTITION BY c.id ORDER BY c.id) rn FROM details c WHERE a.id = c.id AND c.id > ( SELECT max(id) FROM details d WHERE d.id = c.id AND d.cd = '2030') AND c.cd IN […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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