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

Daily Coping Tip

Broaden your perspective: read something different

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.

It's the Engineers

This editorial was originally published on Jan 8, 2018. It is being re-published as Steve is at Technorama.

There are all sorts of articles and blogs on the Internet that try and teach you how to use a particular technique or technology to solve a problem. Plenty of this information is well written, and showcases the knowledge of that individual (or team) and how they've built a fantastic system. Every vendor building software platforms has reference case studies that show how well their system has worked for some customer. These are all good models that might give you confidence why SQL Server or MongoDB or Entity Framework or GoLang are good choices for your company.

In reality, it's not as simple as just choosing a platform or framework or language to make your application perform better. You really need the staff that understands how to use your choice of X and has some skill in building a system in that manner. It's why I think that the cost of the software is a pittance compared to the cost of your people. If you have to train them, or they need to learn how technology X works, then you're going to pay more in salary than you'd save in software licenses.

There's an article that I think illustrates this well, and might be worth passing along to your developers. It's called Why Amazon DynamoDB isn't for everyone and it's worth a few minutes of your time to read. The gist of the article is that a NoSQL system, like DynamoDB, isn't as simple and easy as you expect. It also says that for many applications, a relational database is a better choice because it's often better understood and will solve most problems at small scale. For most of us, we don't really get past what I'd consider small to medium scale, and so we should stick with relational systems.

This isn't to say that DynamoDB will be a problem for you, but there will be a learning curve for your developers if they haven't used it in production and at your scale. The same thing occurs if a development team decided to switch from MongoDB to SQL Server because they like automatic tuning. They won't necessarily configure and use SQL Server efficiently, and might not have their application perform well. Switching your development paradigm or technology is hard, and it will take time for your staff to get up to speed.

Ultimately it really comes down to having good engineers that can write good code and understands the ins and outs of administering that particular platform. The database is extremely important here as it is the central location of your information, but the same arguments apply to frameworks and languages. As much as we want to learn and try new technologies and incorporate them into our work, we need to realize that it takes time to learn to use them well. Make small experiments, try POCs and slowly build up skills before you decide that your mission critical system needs some new technology that you read about and are excited to try working with.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

How to use Images in Power BI Report Builder

Daniel Calbimonte from SQLServerCentral

Learn how you can add images to your reports in Power BI when using the Report Builder.

External Article

Getting results using less T-SQL

Additional Articles from SimpleTalk

There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways to write simpler T-SQL code.

External Article

Database DevOps: Standardize, Automate, Monitor & Protect

Additional Articles from Redgate

See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.

Blog Post

From the SQL Server Central Blogs - My job managing a calling list. : T-SQL Tuesday #150

Kenneth.Fisher from SQLStudies

I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading

From the SQL Server Central Blogs - Microsoft Graph API in Power Automate: Adding Users to Private Teams Channels

Devin Knight from Devin Knight

This is video four in a four-part series walking you through how to leverage the Microsoft Graph API within Power Automate. In this video, Devin

 

 Question of the Day

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

 

Columnstore Index Limits in SQL Server 2019

How many columns can I include in a nonclustered columnstore index 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)

Exporting the Database Encryption Key

I have a Database Encryption Key (DEK) in a database that is protected by TDE. How do I export a copy of this key for DR purposes?

Answer: You cannot export the DEK

Explanation: The DEK is protected by a certificate in master and is not available for export or backup. It is included in a backup of the database, which is what you should be doing for DR purposes. Ref: CREATE DATABASE ENCRYPTION KEY (remarks section) - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-encryption-key-transact-sql?view=sql-server-ver15

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
Migrating Always On cluster to new Domain and cluster - We are in the process of migrating to new Windows AD.  What would be the best approach for this with minimal down time?   Essentially we have several databases in AG on different nodes and a single listener name.  The idea is to move to new Windows AD/new servers and retain the listener name.  Normally if […]
SQL Server 2017 - Development
Rules based updates - I found an article that is very similar to how I would like to apply business rules to update my table. I will have 4 colname values I would like to use: Channel,ShipFrom,ProdLine,CustType Channel -- Will be only 2 values ShipFrom  - Could be single entry, or ALL, or ALL except(xx,xx,xx) Prodline -- All(*), or  […]
Missing abstrophe in dynamic SQL - Hello , I haven't been able since morning to find how to add the missing abstrophe in my procedure that uses dynamic SQL I added a print in my script to display the exec instruction and I have a missing apstrophe in the name of the proc Anyone have an idea please? USE [test] GO […]
SQL Server 2016 - Administration
'Alert- Sev17 Error:Fatal error in resource limit exceed occurred' on server - Hello! I have setup SQL Audit and it is writing to the Security log in the Event viewer. It is working but getting this error message below few times a day. "SQL Server Audit could not write in security log". What can be done to resolve this alert?   Thanks.  
SQL Audit in Always On Availability Group - Hello! I have setup SQL Audit in Always on Availability group (2 node) for ddl and dml to write to Event viewer. I have configured on both nodes using the same GUID. It writes to Event viewer in the Primary node (1) or when I fail primary and  and make secondary primary, it works. But, […]
SQL Server 2016 - Development and T-SQL
Filetred index - \hello Guys,   Mayyou help wuth the corect index filetred creation using modulo?   The query need to  assist is  select col1,col2,.........  WHERE ISRECNUM % 20 = 1  and i wish to create a filtered index on ISRECNUM column which is INT     like  WHERE ISRECNUM % 20 = 1    . Thanks, Best Regards, […]
Disabling backup Jobs - I've not done a lot with disabling jobs with script, I need to read the job names from a text a disable them or enable them on all servers within the environment? Is there any good examples for doing this?
Rows won't return using where with one of the columns - Select * from tablea where comt_dim_id  = 3947804 -- returns no rows Select count(1) from tablea where comt_dim_id  = 3947804 -- returns count = 32   Why?  How?   There are no current locks in the database.  The column datatype = INT. Selecting these 32 rows based on a different column value works and shows the comt_dim_id […]
SQL Server 2019 - Administration
PBALP User in SQL Server - Hi Everyone, Currently looking at tidying up some SQL servers and i have a number of local users (PBALP) being one of them i would like to drop. Is there a way i can check to see what if anything is dependant on that user?    
Hi everyone! - I'm Johnson, and I've just joined these forums. I was looking on Google for SQL Server Forums and found forums.sqlservercentral.com. I just wanted to say hello to everyone to start. Once I feel like I belong, I will talk more on the forum. @SQL Server Forums Munchkin Cats
Monitor SQL Server Job Failures - Ahoi, i am usually working with SSIS and SSAS, but since there is no one else i am also "in charge" if adminsitration it seems. We have multiple SQL Servers + Instances. Now i am looking for a good/central way to monitor Job failures across the entire scope of servers/instances. Since the guy who was […]
Notify with backup file name - Hello, I have the tlog bkp job that runs in every 5 mins. There is another monitoring job which checks if the tlog backup job runs for more than 30 mins and if yes, it should notify the same to dba via agent alerts (notifying  via email). Unable to find a method to notify the […]
SQL Server 2019 - Development
DateDiff - Data Type conversion Issues - Hi Experts Not able to do DATEDIFF between two dates, but it works when these dates are part of ( a.ClosingDate, calc.maxDate ) CTE and in select I use DATEDIFF , My result is taking forever so I was trying to get rid of CTE so I encounter this issue. Any help please. I attempted […]
Integration Services
Data Collection from restful web call - First off. Sorry for formatting - on a mobile device. —————— So a little back sorry - I know almost nothing about this topic, so forgive me if I use a phrase out of turn. I’m looking at being able to pull data from a training platform and dumping it into my local database so […]
Anything that is NOT about SQL!
Building a front end for a database - Hello everyone! I'm a beginner with databases and I'm getting started with building a front end for my database so that end users can add/edit data. I've been trying to find information about this online but I guess I'm not searching the right words because I can't seem to get a hit. I'd really appreciate […]
 

 

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

 

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