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

Daily Coping Tip

Plan some new acts of kindness to do in 2021

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.

Where 2021 Will Take Databases

I usually try to spend some time looking forward at the end of the year and guessing what will happen. Last year I didn't spending time looking at 2019 and then the decade. I started the year with what I thought were normal topics: learning, patches, and code comments. I was looking forward to a sabbatical and quite a few work and personal trips at this time last year. Sixty-some days in, the world changed.

We've adapted to the new world. I've watched customers and businesses become cautious, but the last few months it seems that many of them are looking for ways to not just survive, but thrive. That's been our mantra at Redgate as we close out 2020 and look forward. I suspect that many others feel the same way.

With that, I do expect that the main platform I work on, SQL Server, will take some leaps forward, and I suspect that we may see a new version in late 2021. I don't have any information here, but it seems that SQL Server news has been somewhat sparse in 2020, but I can't imagine this continuing. With the dissolution of PASS, I would bet Microsoft pushes to have a new version and some sort of event near or with Ignite in the fall that announced SQL Server.

I also expect that we will see more and more integration and movement to the cloud. I've been surprised the last few years with the number of companies going to the cloud for databases, and I think this will continue as local leases expire and companies look to take tax advantages of the OpEx for cloud services. I see and hear fewer complaints from DBAs about the cloud, and as more companies move, I expect there to be less.

I was surprised to see some comments in the last few weeks about how DevOps and cloud services aren't compatible with Sarbannes-Oxley or some other regulation. CapitalOne is a large bank, the 11th biggest in the US (by asset size), and they have not only completely embraced Devops, but they are 100% in the cloud, with no local data centers. That is the future I see for more and more companies. Local development machines, possibly local build (I like this), but everything from QA downstream to production in the cloud.

Lastly, I think the #sqlfamily and SQL community will continue to thrive and share information in the new year. I have been worried about SQL Saturday continuing. I placed a bid for the domain, but I don't know what will happen. No response from PASS, so I'm not sure they have any interest in working with me. However, a number of us have started to move forward with Data Saturdays. There are a few events and I expect more, but more importantly, I think we'll have a few live events in 2021. I'm certainly hoping to find a way to get a small one in Denver, in a safe manner.

Other than that, I think we will continue to see people use some sort of non-relational (NoSQL) database for projects. Some will work, many will find that RDBMSes work really well. We'll see more microservices work, though I'm not sure we will get a lot of change. Data has a lot of inertia, and it can be hard to make big changes to our platforms in many organizations.

One thing I know if there will continue to be a lot of opportunity for those that work with data, so keep brushing up on skills, pick up new ones, and find ways to get excited about data related topics.

Steve Jones - SSC Editor

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

 
 Featured Contents

PowerShell Day By Day: The Pipeline

Frank Dolan from SQLServerCentral

In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]

SSRS Install, Setup and Configuration

Additional Articles from MSSQLTips.com

In this article we cover all of the steps required to install, setup and configure SQL Server Reporting Services.

From the SQL Server Central Blogs - End of an Era – SQL PASS and Lessons learned

Diligentdba 46159 from Mala's Data Blog

Most of my blog is filled with posts related to PASS in some way. Events, various volunteering opportunities, keynote blogging, this or that…With the demise of the organization, I...

From the SQL Server Central Blogs - Using Azure Durable Functions with Azure Data Factory - HTTP Long Polling

Rayis Imayev from Data Adventures

(2020-Dec-21) While working with Azure Functions that provide a serverless environment to run my computer program code, I’m still struggling to understand how it actually works. Yes, I admit, there...

 

 Question of the Day

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

 

The last bit of 2020

It's been a long, hard year with a pandemic affecting most of the world. As we say goodbye to 2020, what's the last bit of time I can store about the year in SQL Server 2019?

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)

ggplot2 mapping in R

Which ggplot2 function will map columns to parts of a chart?

Answer: aes

Explanation: The aes() function is used to construct aesthetic mappings, which describe how variables in the data are mapped to visual properties (aesthetics) of geoms.  Ref: aes() - https://ggplot2.tidyverse.org/reference/aes.html Thanks and kudos to @TheStephLocke for this question.

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 2016 - Administration
Updating SQL Server 2016 - We are currently running SQL Server version: Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) - 13.0.5698.0 (X64) Feb 15 2020 01:47:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) Can we upgrade straight to CU15 for CU12? Or do we have to do each version in between? […]
Change name of a particular step in an existing SQL Agent Job - What is the easiest way to change name of a particular step in an Agent Job? SSMS does not seem to allow to do that.  
Could not find a login matching... when access granted via AD group - Hello experts, A client just reported the following puzzling error. There is a user ABC\user1 that was added to the AD group ABC\foo_db_readers. The group ABC\foo_db_readers was added to the user-defined database role db_foo_datareader, which has read access to foo_db. The client's goal with this setup is to avoid having to create the login ABC\user1 […]
always on sql server - Hi Guys, I have a question to configure always on sql server same subnet vs multi subnet. It is three node cluster, two in same DC  HA (node 1, node 2) and other in DR (Node 3). It needs a multi subnet, I am thinking to configure node1 & 2 as well into different subnet, […]
SQL Server 2016 - Development and T-SQL
Converting MONEY - Hi, running this declare @code VARCHAR( 50 ) = '748.019876'; select [code1] = @code, [code2] = CONVERT( MONEY, @code ), [code3] = CONVERT( VARCHAR( 10 ), CONVERT( MONEY, @code ) ) returns --code1                   code2              code3 --748.019876        748.0199    […]
Administration - SQL Server 2014
Full Text Search and Enablement at DB Level - Day One. - I have 2 DBs - they are 'vendor' DBs - part of an application. They both originated from a single source DB - so were identical to start with. One DB has been upgraded and has new functionality from the vendor that utilises full text search - the other hasn't. The SQL instance has Full […]
Development - SQL Server 2014
While loop - CREATE Table TABLEA(N varchar(50),Q int,R int,Dt1 datetime,Dt2 datetime) DECLARE @I int = 1 DECLARE @R int = 2 DECLARE @Q int = 3 DECLARE @Q1 int SET @Q1 =@Q DECLARE @N varchar(100) SET @N = 'NameA' WHILE (@I <= @R+1) BEGIN WHILE (@I <= @Q) BEGIN SELECT @N as Name,@I,@R,@Q SET @Q = @Q - […]
SQL 2012 - General
How to display arrange features where order by display order and column order by - How to display arrange features where order by display order and column order by are equal ? I have two features Package and Workflow have same display order nd same columnorder by so How to make order by same values ORDER BY MIN(DisplayOrder),ColumnOrderBy I need to display Workflow first so How to do that   […]
How to get parts that not have same features count on table settings by code typ - How to get parts that not have same features count on table settings by codetypeid and PLID ? I work on sql server 2012 . if face issue I can't get parts that not have all features on table settings so I will count distinct features from table settings and compare it with count features […]
How to copy Excel file from Office 365 online to local drive in SSIS? - Can anybody help me with problem how to copy Excel file from Office 365 SharePoint online to local drive in SSIS? I never worked with SharePoint before, what is the best practices? Thanks, Aleks
SQL Server 2019 - Administration
recover table data which is accidently updated all the row in employee table - Hi, I have mistakenly updated all values in employee table how to recover that
SQL Server 2019 - Development
Error: Msg 105070, The ODBC data source name was no specified or the driver is m - Hello everybody, I am trying to use external table with PolyBase for import data from Oracle to Sql Server 2019. I have an issue about creating an external table. I created external data source OracleExternalData. CREATE EXTERNAL DATA SOURCE OracleExternalData WITH ( LOCATION = 'oracle://145.145.145.145:1521', CONNECTION_OPTION = 'DSN=CData Oracle Sys' CREDENTIAL = OracleProxyAccount ) ; […]
Strategies and Ideas
Filtering Customer Specific Data - Hi all! Your help would be appreciated. We have a data warehouse that is a single tenant design with multiple reports and widgets that query the data The underlying structure of the DW is modelling invoice data - so essentially header records and line items The widgets and reports show pretty much what you would […]
Anything that is NOT about SQL!
Question about using Python in conjunction to SQL Server - In a recent months I saw a lot of job ads that require Python in addition to SQL Server. I am SQL Server DBA/developer, and recently learned some Python from videos. I can do some elementary Python coding in PyCharm, but how it is related to SQL Server, or any database coding? If anybody is […]
Article Discussions by Author
Download SQL Patch Info - Comments posted to this topic are about the item Download SQL Patch Info
 

 

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

 

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