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

Daily Coping Tip

Notice three things you find beautiful in the outside world

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

How Normal Is Your World?

The last three years have felt like a bit of a time warp. I'll run into someone or reach out to a friend, thinking that I haven't talked to them in a year or two. Then I realize that it's been 4 or 5 years because the 2020-2022 time frame felt like a year or less. A long year, but still, less than the three years that passed.

Life is mostly back to normal for me, with travel, events, vacations, coaching, work, etc. all similar to the way things were in 2019. At the same time, I've changed and my life has changed. Some of this is aging, some is life moving on, but some is from the pandemic.

Spending so much time remotely has me a little less patient or excited about small trips, even around town. I cook more and my family is more often at home. My adult kids enjoy spending time with my wife and me. I appreciate family and time off more, which was good. These are positives for me.

Work is similar to 2019, but also different. Redgate is moving to a new, smaller office, and the culture of most people being there and eating lunch together is gone. We won't have our SQL Servery in the new building, so I'll be going out with friends, or bringing some sort of meal in when I'm at the office. I don't like that.

I still get to visit customers, and more so this year than in prior years, but there are a lot more Zoom meetings and short, quick engagements than in the past. That's a good thing, and I find it exciting.

At the same time, we have fewer events. Last year saw 18 SQL Saturdays, and we're on pace to exceed that this year, but we're far below the 100 a year from 2019, even adding in Data Saturdays and other events. Every event seems smaller than in the past, which is a bit disappointing for me.

Some people still wear masks, signs from the pandemic are still posted, and I find people to both be better and worse. They are more enjoyable at times, but at other times displaying more anger, argument, and selfishness than before 2020.  It's a weird mix, and I think the pandemic has people quicker to get upset at little things while being more tolerant in general. In general, the world feels normal to me, but slightly evolved from 2019.

Is life back to normal for you? It mostly is for me, though with one big difference. I appreciate life more, the people, the trips, the time, it all means a bit more after spending a few years fairly isolated and limited in many ways.

Let us know today.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

How to Implement CI/CD in Azure Data Factory (ADF)

diponkar.paul from SQLServerCentral

Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.

External Article

On-Demand Webinar - Monitoring: The ROI of Build vs. Buy

Additional Articles from Redgate

Missed our recent webinar on ‘Monitoring: The ROI of Build vs Buy’? Catch up on demand and find out the pros and cons to building a monitoring system versus purchasing one. Watch now!

External Article

SELECT DISTINCT SQL Command to Return a Unique List of Values

Additional Articles from MSSQLTips.com

Learn about the SELECT DISTINCT SQL command to return a unique list of values from SELECT queries along with several examples.

Blog Post

From the SQL Server Central Blogs - Adding a Computed Column–#SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

Recently I needed to add a computed column to a table and realized that I didn’t remember the syntax. This short post show how to do this. Another post...

Blog Post

From the SQL Server Central Blogs - SQL Saturday Atlanta 2023 Recap

DataOnWheels from DataOnWheels

This past weekend, I had the pleasure of attending and speaking at SQL Saturday Atlanta! If you’re in the area, I highly recommend connecting with the local user group...

SQL Server 2022 Revealed

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

 

Locating the PVS

In a new SQL Server 2022 database, I want to enable Accelerated Data Recovery (ADR) to speed up recovery time. If I run this, where is the Persistent Version Store (PVS) located?
ALTER DATABASE VeryImportantDB SET ACCELERATED_DATABASE_RECOVERY = ON

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)

Deterministic Encryption Operations

In Always Encrypted, which of these operations are allowed with deterministic encryption?

Answer: Equality (=), IN, GROUP BY, and DISTINCT only

Explanation: You can use the equality, IN, GROUP BY, and DISTINCT operations with deterministic encryption. Ref: Always Encrypted Limitations - https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver16#limitations

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
Missing perf-MSSQLSERVERsqlctr.ini - I attempted to install the latest CU (31) for my SQL 2017 server but received an error message stating "Service Pack Failure: MissingRegistryKeyException" due to a missing registry key. It appears that our SQL server is missing certain performance counters as I was only able to retrieve 57 row records after executing the command "select […]
SQL Server 2017 - Development
Transaction has no commit error - All, I have an unusual scenario. A developer sent me some code that has a BEGIN / COMMIT and a rollback right before the commit. It's all wrapped in a reasonable TRY...CATCH. The script builds some dynamic SQL INSERT statements using OPEN_QUERY, dynamic because the WHERE clause depends on some variables. The INSERT statements they […]
SQL Server 2016 - Development and T-SQL
How to remove special chars? - Hi everyone, So I have a xml file from which I am trying to import data into my sql tables. I noticed there are some special characters inside the file due to which I am unable to import data properly. Look at the below screenshot: Can anyone tell me what are there square boxes and […]
Error trying to add columns to code - Hi there. Thanks for code from my previous post and so many good working options. Now I want to add 2 new columns and it gives an aggregation  error. Appreciate any help. From this table, I have the code that selects the latest doctor visit record using the MAX function. If latest client record is […]
SQL Server 2019 - Administration
SSMS is filling up our C: drive -- installed on E: - Good day.  I didn't know where else to post this, so forgive my ignorance if this isn't the place. I have a situation that involves a single Windows Server with SSMS installed that has the only permissions to hit another organization for our Data Warehousing team.  There may be as many as 4 BIDS plus […]
Trigger on update when changed only desired XML tag. - Hello! I have a task to configure for the Skype for business database logging of user status changes (Available/Away/Offline/etc). i found source for this data in XML field with content like: 15500
To get a list of un-used columns in all tables in a database - I am looking to get a list of un-used columns in all tables in a database.  I would like the output to look like something like this. DatabaseName, SchemaName, TableName, ColumnName, etc If anyone has a handy script or any link, please share.  Thanks.
DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error - Hi New server with SQL version 2019 has been created to host a DB for a Legacy App to use.  This is working fine. The App has not changed. I need to get this working on a test Server. Test Server with 3 instances on it 1. Version 2014, Development edition uses port 1433 2. […]
Hash Match performance issue - Hi I have a stored proc that is performing badly. When I look at the execution plan I can see a couple of instances where there are a large number of rows inputted into a hash match but the output is estimated to be only 1 row. The inputs into the hash match below are […]
SQL Server 2019 - Development
SQL Query to display having only values - I am having below -mentioned table1 and  I would like to display it as shown in the below table Can someone help me with the query Thanks in advance
SELECT with computed values - From a huge and ever growing table (tbl_Values) I need to select all records which conform to rules defined in another table (tbl_Rules). Each record in tbl_Values has a time_stamp (datetime) and a fvalue (float); the rules defined in tbl_Rules have a WeekDay (int), a HourOfDay (int), a MinValue (float), a MaxValue (float). Records from […]
Relational Theory
RIGHT-JOIN table not fetching all rows in WHERE clause - I'm trying to add an additional table (hrxoreturn) with RIGHT JOIN to return all records either with matching or  no matched records to other tables. When i exclude "count(distinct hrxoissue.issuedte)as 'Total Count per RX'" , the fetched rows goes to 49 rows  reading all the count in hrxoreturn table, but if i include count on […]
SQL Server 2022 - Development
Case and When Query - Hi All, I want to rewrite the below query using the Case and When statement Query 1 update [SF_Title_Update] set [Title_Proper]='Human Resource Management System Manager' from [SF_Title_Update] where ( title like '%Human%' and title like '%Resource%' and title like '%Management%' or title like '%HRMS%' ) and (job_level='Manager Level' ) and( [Title_Proper]=' ' or [Title_Proper] is […]
Dynamic Query - Hi All, I have to generate a dynamic query for the below mentioned keywords to update them in Title_Update column Keywords Recruitment Employee Engagement Performance Management Training and Development Compensation and Benefits Human Resource Diversity and Inclusion Also it should have the below mentioned Job Level Chief Level Director Level Head Level Manager Level Managing […]
Use a flag, or calculate, to retrieve counts - I'm working on a Holiday Leave system (for typically several hundred or more personnel).  Currently, a person may request leave (in the future) and each Leave request can have one of a number of Status values: Pending Approval Approved Declined Cancelled There is a report required to sum up these totals for an individual, broken […]
 

 

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

 

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