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

Daily Coping Tip

Appreciate the good qualities of someone in your life

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.

Less is More

The world of Information Technology has changed a lot during my career, but in some ways, many things remain the same. There are still mainframes in use, and plenty of jobs. Lots of companies maintain their infrastructure in data centers, even though some are turning to private clouds for their infrastructure. There are plenty of jobs in that area as well.

There is a trend to consolidate resources into a bucket and then allocate those as needed for various applications and services. This is what mainframes do, albeit at a very high degree of reliability (and cost). The cloud seeks to replicate this, not with high reliability, but with redundancy, expecting systems to fail. In fact, plenty of the data centers these days involve a lot of similar hardware systems tied together with software, with failed systems being left in place rather than replaced.

This trend aims towards a lights-out data center, where humans don't work inside the location with servers. As someone that used to keep a coat by my desk in the summertime for trips inside the locked "computer room", it's a welcome trend. While a few people might actually need to check a cable or service an AC or UPS unit, most of us these days never see the systems we work on, whether those systems are owned by our company or rented in the cloud.

This doesn't mean that we won't have as much work. In fact, I think that most of the trends in computing over the last three decades have opened up opportunities for workers. This article talks about some of those changes that allow workers to morph along with technology to tackle different aspects of similar jobs. I certainly expect that anyone who wants to improve their skills and adapt to the new data center of the future to have plenty of work.

This reminds me of a scene from Aliens, where workers use enhanced suits to load heavy crates. I think this is the type of future I see, where humans work alongside new technology rather than being displaced by it. The need for humans to monitor, manage, adjust, and configure software systems and physically work alongside high-tech software is not going away anytime soon. The more that we adapt new technology, the more it seems that we add humans to work alongside it in some new way.

Continue to learn, adapt, and adjust your skillset and you can remain employed for a long time.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Creating an SSRS Report from an Azure SQL Database

Daniel Calbimonte from SQLServerCentral

Introduction  

External Article

Power BI Designing with Diagrams

Additional Articles from MSSQLTips.com

In this article learn about how to use the new diagram view along with a schema view in Power BI to make Power Query online editing easier on report designers.

External Article

Can Continuous Compliance Automation transform data protection in your organization?

Additional Articles from Redgate

Continuous Compliance Automation aims strike a balance between baking compliance requirements into daily operations, and business demands for speed and agility. Redgate's Security Lead, will be joined by a panel of peers to discuss this mindset change and the impact it can have on your organization.

Blog Post

From the SQL Server Central Blogs - SQL Server Execution Plan - Displays Estimated and Actual number of rows

rajendragupta16 from DBBlogger

This article focuses on getting the Displays Estimated and Actual number of Rows from the SQL Server Execution Plan. Read More

Blog Post

From the SQL Server Central Blogs - Extent Management in SQL Server

Klaus Aschenbrenner from Klaus Aschenbrenner

Today I’m talking about Extent Management in SQL Server, because this is a very important topic, especially when you deal with TempDb in SQL Server. On a very high...

 

 Question of the Day

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

 

Azure Monitor Storage

If I use the Azure Monitor service to gather metrics and then alert based on data, how long is the data stored in this service before I would need to archive it to another storage location?

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)

Data Analytics Classification I

If I am searching for the answers to question about why something happened, what type of data analytics activity am I performing?

Answer: Diagnostic Analytics

Explanation: Diagnostic analytics helps answer questions about why things happened. Ref: Explore Data Analytics - https://docs.microsoft.com/en-us/learn/modules/explore-concepts-of-data-analytics/4-explore

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
Help with proper indexes - I am new to sql server and hav been researching indexes but I am still not sure on the best practice for indexes for one of my tables.  The table currently has over 12 million rows and has a primary key that is just and auto id field. I have several fields we usually search […]
SQL Server 2016 - Administration
Installed SQL 2019 and trying to uninstall 2016 stuff and am unsuccessful. - I have 2 items left in Add remove programs: SQL 2016 and 2016 setup I have ran through the SQL 2016 uninstall several times but it does not allow me to remove SQL Client Connectivity SDK. I check it and then it goes to the Ready to Remove and Edition is blank and Action is […]
Avg Disk Queue Length Issues - Hi All, We are running a production system with MS SQL2016 Std and for the past year or so things have been going well... Then all of as sudden about 1 month ago I started recieving complaints about Server Timeouts. I used Perfmon to analyze the Server and found that Avg Disk read and write […]
SQL Server 2016 - Development and T-SQL
Question About Deadlocks - Hi, my understanding of deadlocks is that 2 queries become deadlocked if query 1 locks table A and then wants a lock on table B while query 2 locks table B and then wants a lock on table A. We have had a deadlock where one of the queries only uses a single table, so […]
SQL 2012 - General
How to get rows that have sourctype 484456 only when group by GivenPartNumber_No - I work on sql server 2012 i need to get rows that have source type 484456 when group by two columns group by GivenPartNumber_Non and vcompanyid so i need to make select query display every group of rows by GivenPartNumber_Non and vcompanyid have source type 484456 only may be this group one row or 2rows […]
DML STATEMENTS ON OLTP TRANSACTION - Hi Good morning. What is the better approach when applying DML statements on the OLTP transactions? when updating the rows in a table delete the rows and insert new rows or update the rows with a new column value. Please give your valuable advice. Thank you.
SQL Server 2019 - Administration
Using Availability groups with a named instance - Hello, I'm working on migrating from an existing multiple FCIs to Instances with availability groups.  I'm attempting to keep the impact to my customers as small as possible so I'm wondering about connection strings with availability groups. Current Environment, multiple instances some as named instances in existing FCI SQL1 and SQL2\NamedInstance Proposed new environment. Physical […]
Upgraded SQL 2008 to 2016 years ago and never removed 2008 correctly. - Upgraded SQL 2008 to 2016 years ago and never removed 2008 correctly and now on 2019 I am having issues uninstalling 2008. I removed the setup files by accident and now in the add remove programs is SQL 2008 but I can't get it uninstalled correctly. Is there a way to do this? Also, I […]
Cannot add SQL Listener to Always On - Hi all Hope someone can assist with my issue. I have a two node cluster running SQL Server 2019 ENT Edition CU14 and the nodes are on different subnets. Always On has been added and working fine however I can't add the SQL Listener, keep getting the following error: "None of the IP addresses configured […]
SQL Server 2019 - Development
Sub Query with incorrect column name doesn't error - Hi, Is there a reason that the following query doesn't error? select * from sys.objects where parent_object_id not in (select parent_object_id from sys.columns) The column parent_object_id doesn't exist in the sys.columns table, yet the query runs without an error. If it's a "not in" query, then an empty resultset is returned, whereas if it's an […]
Update records used in Group By - I have this query to create a summary of donations SELECT [DonorId], SUM([DonationAmount]) AS TotalDonation FROM [dbo].[Donation] GROUP BY [DonorId], [DonationYear] What I need to do is then create a single receipt for those records.  The receipt creation process can be run at any time (not just at year end) What method should be used […]
Amazon AWS and other cloud vendors
Facing issue with Step Function - I want to run a function every 2 mins but I want to start those 2 mins only after the excution of that function is complete. I saw that this is a usecase of Step Function so when I created my workflow. Start -> Run ECS Task -> wait(2mins) and now I want to run […]
General Cloud Computing Questions
Noob questions about Cloud computing - What made it so prevalent? - We're seeing everything going to the cloud these days, from data storage to phone systems. I don't fully understand what technologies have made cloud computing so prevalent and easier to implement. Is it due to Internet bandwidth? Better software?
Powershell
create file from xcel layout - I have an xcel file that based upon Cells defined will be used to create an output file with a .txt extension. All of the columns in xcel file are defined as "TEXT". The key to building the output file is based upon the xcel file definition. Xcel file example: A         B  […]
Analysis Services
Today my SSAS server died and I lost 500 DBs but I still have all DB files - The title sounds like a name to a new anime, and it's my daily life. All of a sudden, today after an update of Symantec Antivirus on the server (no relation, this was just the most recent change event), my poor SSAS server with 500 databases refused to start. The config of the server is: […]
 

 

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

 

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