A community of more than 1,600,000 database professionals and growing

The Voice of the DBA

Framework Fatigue

I think that there is an issue with frameworks today. I am especially talking about web based ones. I am speaking mostly of web application frameworks, but the same can be said of data repositories (databases etc.) and many other things. We are seeing technology churn in this area. Or perhaps more simply people are changing the frameworks they use frequently. So frequently sometimes that I have seen frameworks changed midway through a project.

Many are open about the issue. Matthew Jones talks of the difficulty of framework selection (What is JavaScript Fatigue?) whereas Samuel talks of it be a natural order of things (Angular, React, and Javascript framework fatigue). It doesn't stop it being technology churn when a framework disappears overnight. Open Source Software (OSS) is not the solution for many enterprises either. They want their developers to develop business solutions. Not maintain frameworks.

The problem with technology churn, regardless of the technology involved, is that it leads to development in a vacuum. Almost by definition there will be a serious lack of experience and expertise. Little help is available, if anything, in the way of online communities or any other form of online help. I have been at the bleeding edge of some technologies and, whilst you can bring general experience to the table, I could not help feeling a bit of a charlatan. Whilst I have never claimed expertise under these circumstances, I did agree to deliver on something I was not certain of, nor could I be. How could I be so confident? So sure?<

But perhaps I am wrong. Perhaps the issue is not with the proliferation of frameworks and our lack of experience but with our attitude towards them. What is your attitude? Proliferation of what plagues your professional life?

Gary Varga from SQLServerCentral.com

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

Track schema changes for free

DLM Dashboard tracks SQL Server databases to show you exactly what schema changes have been made, by who, and when. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. Download free tool.

Featured Contents

vCenter Server fails to start, Purge and Shrink Vcenter SQL Database

Ganapathi varma Chekuri from SQLServerCentral.com

In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required. More »

Data masking survey and prize draw

The Foundry team at Redgate know that managing sensitive and regulated data can be both challenging and problematic. They want to solve these problems, but first need your help to better understand them in context. What do you find frustrating? What would save you time? Please fill out this short survey to let them know, and as a thanks for your time, at the end you'll be entered into a draw to win a $100 Amazon gift card. More »

Lists With, or Without, Ranges in both T-SQL and PowerShell

Additional Articles from SimpleTalk

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them. More »

From the SQLServerCentral Blogs - Dynamically Changing Shapes in Power BI – Alternatives

Koen Verbeeck from SQLServerCentral Blogs

NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used... More »

Question of the Day

Today's Question (by Steve Jones):

I need to change the password on a linked server on a regular basis. I decide to use a T-SQL script to do this. What commands should I use?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Linked Servers.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload.

Pick up your copy of this great book today at Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

One of the things that can be helpful in editing code in SSMS 2016 is highlighting a vertical selection of code. What key combination allows me to highlight a box of code, as shown below? ( I have highlighted "Customer" below)

Answer: Hold ALT while selecting text

Explanation:

The way you can select vertical sections of code is by holding the ALT key while you move the cursor (or mouse).

Ref: Quick Tips - Select a Block of Text - https://voiceofthedba.com/2014/05/29/quick-tipsssms-select-a-vertical-block/

SSMS Tip - How to Block Select Text - https://blogs.msdn.microsoft.com/davidlean/2009/09/18/tip-ssms-how-to-block-select/

» 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 : SQL Server 2016 - Administration

xp_cmdshell File Copy Failing - "Access Is Denied" - 2 New Windows Servers 2016 running SQL 2016 Standard. No Active Directory. Logged on as my local account (in Windows Administrator...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Query never completes with CXPACKET waits - Hi, I have a query that runs in under 40 minutes on our test server but never completes on the production...

Is not null 2 columns... - Hello ALL! I have this table CREATE TABLE .( NOT NULL, NULL, NULL, NOT NULL )

SQL Server 2014 : Administration - SQL Server 2014

Performance improves after reboot - I am an ETL Developer who was asked to look at SQL Server performance problem. We have two DBA's but they're...

SQL Server 2014 : Development - SQL Server 2014

Trouble with openxml query - Hello, I have an XML document formed like the attachment. I have it in a table which ddl is: CREATE...

SQL Server 2012 : SQL 2012 - General

SPROC Stored Proc vs SSIS for Enterprise Wide Dev - Hi ...been awhile since I last signed in... new job back to my favorite db platform SQL Server :-) I'm stuck...

AlwaysOn Availabilty Group listener connection issues - Hi, I'm hoping someone can offer some suggestions on what to look at here as we're getting a little stumped. Currently...

SQL Server 2012 : SQL Server 2012 - T-SQL

Use variable in the Identity Seed of create table - There are several tables that were created using a lookup Table to get the Primary Key as opposed to defining...

Remove partitioning - We have a large table where development created a partitioned unique non-clustered index years ago. The table itself shows as...

SQL Server 2008 : SQL Server 2008 - General

Reducing the size of a 500 Gb database on standard edition - One of my clients has requested to find any options to reduce the size of some of the tables in...

How to break down time span in Categories - Basically I have list of the tickets (records) in the db table ticket, and I need to find how long...

Rename instance name in SQL Server 2008 R2 - How to rename a instance name, and let me know do we need to restart the server to be affected

SQL Server 2008 : SQL Server 2008 Administration

Restore Database Question - Hello, My predecessor left this bit of code in an SSIS package and I can't understand how one restores a database...

Using TLS 1.2 - We have SQL Server 2008R2 SP3 and I did the following A: Enabled TLS 1.2 B: Installed SP 3 B: Installed the...

Reporting Services : Reporting Services

SSRS Email Subscription - Newbie here in SSRS :) Is there a way that i can run an email subscription based on column value? Example SQL: Select...

Data Warehousing : Integration Services

Moving data from Excel file with different name to SQL table using SSIS - Hi, Am new to SSIS. i have a requirement. Everyday Excel file will be uploaded into one folder with naming convention as...

connection manager time of day configuration - Microsoft Visual Studio Premium 2012 Version 11.0.61219.00 Update 5 Microsoft .NET Framework Version 4.6.01055 Microsoft SQL Server Integration Services Designer Version 11.0.3369.0 Microsoft...

Database Design : Relational Theory

Is having a lookup table that is for multiple entities a common practice? - I've been programming and designing databases of various sorts for several years. And I've been on teams who have designed...

SQLServerCentral.com : SQLServerCentral.com Announcements

FAQ: Using the new forum Software (Jan 2017) - After we completed the forum upgrade on Jan 12, 2017, quite a few things changed, so this thread is a...

Career : Retired Members

Retiring from one team and onwards - Hi I came across this interesting area of Forum as I think the people with experience might have some advice for...

This email has been sent to newsletter@newslettercollector.com. 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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.