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

Daily Coping Tip

Plan an act of kindness towards another

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.

Challenging Trends

I was studying for the DP-900 exam recently and in one of the Microsoft resources, I ran across this quote: "Historical data is equally important, to give a business a more stabilized view of trends in performance." This was in context of looking at database performance, but it would apply to any part of your business.

The world has changed dramatically in the last two years. In early 2020, at this point, I was finalizing work and getting ready for a sabbatical from work. I managed to get the last sabbatical before the world shut down and most people didn't see the value of one during a pandemic. I returned from sabbatical, with a trip planned to the UK in early March that I canceled. Since that time, I can't imagine the quote above applies to the airlines' business. I've flown a bit across the last year, but rarely for work. I suspect most of their models and ideas about how to manage their business had to dramatically change.

Is that quote still applicable to your business? I wonder how many businesses have started to see new trends and needed to abandon some amount of historical data from their charts and graphs. If that's the case, then is it worth archiving some of that data away, rather than needing to keep it in an online database? Do reports need beginning default dates that start sometime after the pandemic affected the world? Interesting questions.

For most of us, we don't necessarily worry about a lot of business impacts. We'll adjust to what the business analysts ask us to do. However, I wonder if the way you approach your job has changed? For DBAs, have you reset your baseline for how the performance of your systems ought to look during normal times?

For software developers, many of you are working remotely, so how do you approach work and coordination with others, has that changed? Do you need more or less lead time to work with others and get code tested and deployed? I know many developers have found work during the pandemic, especially remote, to be more enjoyable.

Lots of things in the world changed, but much of our work continues on the same path. Approaching things with the idea of adapting to change, but using the past as a guide is what has worked well for me. I have strong opinions on how I work and live, but I adapt when there's a need or evidence to support changes.

Steve Jones - SSC Editor

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

 
 Featured Contents
Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

Greg Larsen from SQLServerCentral.com

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.

External Article

Exploring Auto-fix in SQL Code Analysis

Additional Articles from Redgate

Phil Factor presents a useful but slightly flawed 'table report' script as an adventure playground for exploring SQL Code analysis issues. He demonstrates use of the auto-fix feature, to arrive at a pristine script free from wavy green underlines.

External Article

How to return multiple sequence numbers with sp_sequence_get_range

Additional Articles from SimpleTalk

Developers can work with multiple range values at once using sp_sequence_get_range. Greg Larsen explains how to return multiple sequence numbers with sp_sequence_get_range.

Blog Post

From the SQL Server Central Blogs - Installing and Configuring containerd as a Kubernetes Container Runtime

aen from Anthony Nocentino Blog

In this post, I’m going to show you how to install containerd as the container runtime in a Kubernetes cluster. I will also cover setting the cgroup driver for...

Blog Post

From the SQL Server Central Blogs - Tech Debt – Free Yourself from the Precipice

SQLRNNR from SQL RNNR

No matter how you name it, "hairball", "spaghetti code", "tech debt" or "DIY code", the result is the same - you are dealing with legacy code that nobody wants...

 

 Question of the Day

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

 

Shrink and Release

I want to use DBCC SHRINKDATABASE to get some space back after a lot of data was deleted. Which option will release free space back to the operating system?

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)

My New Resolution

Answer:

Explanation:

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
Is it possible to migrate a solution from SSMS to SSDT?? - VS 2017, SQL Server 2016 and 2017, is it possible and or making sense to migrate a solution from SSMS to SSDT? The main purpose is to incorporate large solutions with multiple files into TFS that SSMS is not supporting.
Help with query - Hi  all, This code gives 2 results SELECT distinct(AtcCode) as id, Atc_Text FROM [dbo].[Drugs_BasicData] d inner join [dbo].[ATC_CodeTexts] t on t.AtcCode = d.ATC AND t.County = 'DK' INNER JOIN dbo.Companies c on d.Distributor = c.CompanyID WHERE c.Country = 'DK' AND LEN(AtcCode) > 5 and Atc_Text like 'Cefalexin%' Order by Atc_Text;   id Atc_Text QJ01DB01 Cefalexin […]
Administration - SQL Server 2014
No objects listed for "SQL Server performance condition alert"? - Hi All, Facing a weird issue. We are trying to create some alerts in our SQL Server 2014 BI edition. Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box. SQL Server event alerts are working. Issue is only with "SQL Server performance condition […]
Development - SQL Server 2014
How to remove additional element from Nested XML - Hey everyone. I'm a bit new to XML and had an issue with some formatting. I'm nesting XML queries and it creates an additional element which I need removed.  Here is a sample of what I'm doing. select PrintOrderNo as "@PrintOrderID" ,PayGroupID as "@PayGroup" ,( select LineNumber as "@DetailNo" ,CompensationDescription as "@Description" FROM Table1 […]
SQL 2012 - General
Noob SQLServer 2012 Question - Let me preface this with I am a sysadmin working on an SCOM 2016 install and have a question regarding an error message that keeps getting thrown via application event logs. An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\ACCESSACCOUNT', […]
Execution plan not show missing index so are there are remainig point to enhance - I work on sql server 2012 my execution plan as below my query is very slow it not show missing index so please how to enhance query please ? my execution plan as below https://www.brentozar.com/pastetheplan/?id=HJbwOAkhF
are there are any thing can do after create index to enhance query speed ? - I work on sql server 2014 i need to enhance query my execution plan as below : https://www.brentozar.com/pastetheplan/?id=ryWtGAknF now i create index as execution plan analysis CREATE NONCLUSTERED INDEX MissingAttr_idx ON [dbo].[TPartAttributes] ([ZfeatureKey]) INCLUDE ([PartID],[Name]) my question are there are any thing remaining can do to improve enhance after create index as above
SQL Server 2019 - Administration
Install SSIS - Hi I am getting this error when i try to install SSIS: MainViewModel.OnBundleAction: Bundle action failed: The requested metafile operation is not supported (0x800707D3) I am downloading and installing this file: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects I already installed Visual studio 2022 and I am running SQL Server 2019. Do you know how I can fix this error message? […]
SQL Server 2019 - Development
Trying to print barchart to PDF file using Python within SQL Server ML module - There are likely to be several unrelated errors here, but I'm going to start with the first one what I can get my mind around.  I'm trying to use the "Python within SQL Server" mechanism to generate a barchart to PDF.  I get an error message that I don't have permissions to the directory I'm […]
Get Data from Internet Directly into SQL Server - Hi I am using these rates for a calculation https://www.treasury.gov/resource-center/data-chart-center/interest-rates/pages/textview.aspx?data=yield Currently, I manually update a local table and then insert that table into SQL Server.  It would be ideal if I can get SQL Server to directly access the rates from that site.  Is this possible?  If yes, how would I do that? Thank you
CASE statement and partition by - Hello everyone, I have a question if someone may know how to adjust the code correctly. I need just to edit the last outer SELECT statement. I need to change the partition by DMDUNIT, I need  outer CASE statement to look at 2 columns: 1) Start Date - if we have 3 distinct weeks worth […]
Using OPENDATASOURCE as an ad hoc Linked Server -   I'm not sure if this should be posted here or not, but I will try. We have a configuration where multiple customer databases are distributed across several servers. On occasion (not frequently), it is necessary to compare data between two databases on the same table utilized by the application.  Because there are several Servers […]
BCP adding carriage return/new line every 2034 characters - I have an SQL query that creates a JSON output.  The query works properly and gives me the output I expect when I manually run it via SSMS.  When I run it in a BCP command from an SP, the BCP utility is adding carriage returns and new lines every 2034 characters.  I can open […]
Interpolation/Extrapolation - Hi everyone I am trying to use linear and cubic spline interpolation/extrapolation to fill in missing rates.  I have never done this before in SQL.  What is the most efficient way to do this? Thank you
General Cloud Computing Questions
Cloud Storage Questions... - Hi. I own a mobile entertainment business....dj, photobooth, karaoke, etc... I have had several portable hdd failures, and am concerned about loss of data. I am hoping to find a way to host an online backup of about 5tb of files (music, video, photos, etc...) but don't know where to start looking. I have searched […]
 

 

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

 

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