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

Cranky Curmudgeons

Today we have a guest editorial from Grant Fritchey as Steve is away on his vacation. This editorial was originally published on Jan 23, 2020. 

If you’re haunting the internet as I do, you probably hear how DBAs are an aging population. Further, because we’re aging, we’re not ready to embrace all the wonderful new technologies that are clearly superior in every possible way. Hence, this is why ElasticSearch and MongoDB haven’t taken over the world.

Now, I’m not going to argue. The DBA demographic is aging. We’re getting older. Yes, also, that means that a certain section of us are becoming cranky curmudgeons (CC). The CC will regale you with all the ways that they had to use stone knives and bear skins for disaster recovery back in the day. However, this is not applicable to everyone.

Let me sidestep for a moment. I little while ago I finally got off my behind and got my Ham radio license (KC1KCE, that’s my call sign). If you think the DBA population is aging and creating CC at a surprising rate, you should see the Ham community.

Over the recent holiday break, I took the time to really play with my radio. What was I doing you ask? OK, you’re probably not asking, but I’m going to tell you anyway. The first thing I did was get my Raspberry Pi 4 set up with a newer version of Raspbian (Debian Unix specific to the Raspberry Pi). With that I was able to configure Winlink, a software for sending email through the radio. I also was experimenting with FT8, a digital mode where the radio is controlled by a computer. In FT8, you send extremely short signals (28 characters max, and you thought Twitter was a pain). The whole idea is to use low power, small signals, as a way to make communication across large distances easier. I was also using another digital mode, PSK31, where you can type into a computer program and it gets transmitted through your radio. Yet another way to extend the reach of the radio beyond what’s possible through voice (called Single Side Band) or Morse code (called CW). All this through a tiny box that fits in the palm of my hand.

Anyone still here? Why am I talking about all this boring radio junk? Because, this CC was expanding his Linux skill set while learning new programs, new hardware, and new ways to communicate using a computer and a radio.

TLDR: CC can learn.

Same thing goes for data and databases. Don’t assume that because the population is aging that it’s not keeping up. Besides, the whole reason we’re not letting you implement ElasticSearch is because you youngsters haven’t properly secured it.  See, we CC have been around the block a time or two, so we’re watching out for you.

Grant Fritchey

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

 
  Featured Contents
SQLServerCentral Article

How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB

Koen Verbeeck from SQLServerCentral

This article shows how to configure database mirroring from CosmosDB to Microsoft Fabric.

External Article

How to Sort String Date Values on a Power BI Slicer Visual

Additional Articles from MSSQLTips.com

In this article, we look at how to build a slicer visual in Power BI and how to create a custom sort order for the slicer values.

Blog Post

From the SQL Server Central Blogs - Data-driven vs. Data-informed: Let’s Acknowledge the Truth

Meagan Longoria from Data Savvy

This comic was retweeted into my timeline on Twitter (I refuse to call it X). Here’s the dialog from the comic, for those that don’t want to click through...

Blog Post

From the SQL Server Central Blogs - A word about IT/cybersecurity and mental health

K. Brian Kelley from Databases – Infrastructure – Security

Just as it's important to take care of our physical health (and I'm guilty of neglecting that), it is important to take care of our mental health, too. Also,...

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 Collins):

 

Is date zero valid and if so what day is it?

You run this code in SQL Server
select datename(weekday, 0);
What is the result?

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)

Multi-Database Marked Transactions

I run a marked transaction across multiple databases with this code:

BEGIN TRAN onemorenewdbTran WITH MARK 'mark from 3 dbs' USE sandbox2 INSERT dbo.AddressTable (AddressID, AddressValue, AddressPostal) VALUES (12, '123 three St', '4444') GO USE sandbox3 INSERT dbo.Logger (logdate, logmsg) VALUES (GETDATE(), 'tran message') GO INSERT sandbox4.dbo.logger (uid) VALUES (700) COMMIT TRAN onemorenewdbTran GO 

How many marks are inserted into msdb.dbo.logmarkhistory?

Answer: 3

Explanation: There is only a dbo.logmarkhistory table in msdb. For cross database transactions, a mark is inserted into each log, which means a row for each in msdb. This gets 3 rows into the table. Ref: Recovery of Related Databases that Contain Marked Transaction - https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-of-related-databases-that-contain-marked-transaction?view=sql-server-ver16#transact-sql-syntax-for-inserting-named-marks-into-a-transaction-log

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 - Administration
DB stuck in restoring state - A developer tried restoring a test DB 3 times and each time it was getting stuck at restoring. And when I tried restoring the DB "Restore database DBName from disk '' with recovery I ran into the same issue and I saw DB, stuck in restoring state. Sys_dm_requests doesn't show any records because I could […]
The backup to one location fails but is successful on another - Dear Friends, Would be glad if any of you can help in a backup related issue I am stuck in. I am trying to take a database backup to two network locations , and mapped drives. The difference between the two targets is the domain. The source SSMS session from \\a.b.c.d\backup to target \\a.b.c.e\\backup works […]
How to set execution timeout in SSMS for SQL Server - I tried to set the execution timeout in SSMS using multiple methods. Initially, I tried changing the query execution time through the tools option, as described on the website https://stackoverflow.com/questions/1137190/changing-the-commandtimeout-in-sql-management-studio Subsequently, I tried a second method from the link. In the tools design settings, we can configure values for the execution timeout in seconds. https://stackoverflow.com/questions/1137190/changing-the-commandtimeout-in-sql-management-studio […]
SQL Server 2012 - T-SQL
Adapt the query to 2012 - Hello I have a query that works as a loop but it is slow. How can I do this with a standard query? -- LINES tablosunu oluşturma IF EXISTS (SELECT 1 FROM SYS.tables WHERE name = 'LINES') BEGIN DROP TABLE LINES END GO CREATE TABLE LINES ( ID INT IDENTITY(1,1), CODE NVARCHAR(100), DATE_ DATETIME, TIP […]
SQL Server 2019 - Administration
sysmail_event_log last_mod_user has a disabled login - Hello experts, We routinely disable sa after a SQL install. However, while troubleshooting a database mail issue (test mail not received), I saw that the sysmail_event_log entries have last_mod_user of sa for some rows. How can that be if the login is disabled? How can I change it so that sa is not used here? […]
LinkedServer error - I getting the bellow error when runing query on linkedserver from another server after adding linkedserver. OLE DB provider "MSOLEDBSQL" for linked server "xxx.xxx.x.xxx" returned message "Protocol error in TDS stream". OLE DB provider "MSOLEDBSQL" for linked server "xxx.xxx.x.xxx" returned message "Communication link failure". Msg -1, Level 16, State 1, Line 11 Session Provider: Connection […]
SQLCMD and the permissions needed - Hey all, Hopefully this is a simple question. I am trying to figure out what permissions are needed for an account to use SQLCMD. I understand sysadmin allows use of it, but we are trying to not grant this non-user account sysadmin. I have been googling and either I'm not using the right keywords or […]
SQL Server 2019 - Development
Filtered index prerequisites to be used - Hello, After few videos and  showing how filtered indexes works, what are the prerequisites to be used and so on still I am not able to make my query using it. Now, I have table CDPOS which is over 100 milion rows. There is a statement which will run automatically, we are still in deciding […]
Monitoring if something is deleted in DB - Hello, I have long-term task, which came one year ago, and just now I have a little free time to start working on it. I will explain a little bit of the task, and then what I have done so far. Some time ago, even before I worked here, colleagues of mine using the web-application […]
Powershell
Invoke-SQLCMD - If my server has dashes seems like that is throwing an error -serverinstance at-ts-cblsql   is server name Anyway to get around that? THanks
Continuous Integration, Deployment, and Delivery
Red Gate SQL Change Automation - Hi, What's happened to this product has it now become Flyway?
Red Gate SQL Change Automation - Hi, What's happened to this product? has this now become Flyway?  
Suggestions
How to change password - How can I change login password of this website? I don't see option under my profile, and google give no result. Is it even possible to change password?
SQL Server 2022 - Development
singleton is interferring with getting multiple nodes in xml - Hi we have an xml doc shaped essentially as shown in image 2 below.   Unfortunately we are so used to using the singleton structure to avoid problems  that we dont know how to get multiple nodes  like those inside featuresandoptions .  At the moment we are only getting one occurrence of each for each line […]
Calculating moving moving averages for different ranges in one query - I have this query, which is gives result I want (may be not, i have not checked extensively yet), i feel like it could be written in more effective way. I have to calculate moving average, for 7 , 90, 365 days, and for 3 and 12 month, for every one of them I have […]
 

 

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

 

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