SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Skills for Everyone in Tech

Today we have a guest editorial as Steve is on holiday.

Most technical professionals have specialized skillsets. If you are a database administrator, you need to be proficient in security, performance tuning, and high-availability, for example. You may know a bit about C#, but probably not enough to just switch to development without some training. There are, however, certain basic skills that are beneficial for everyone in tech regardless of the role. 

All technical professionals should have a grasp of programming logic. No matter what area you end up working in, you will probably write code from time to time. On the operations side, it probably means scripting to automate everything, with tools like bash or PowerShell. On the development side, well, coding is the job. The cool thing about programming logic is that it is the same from language to language. Of course, there are syntax and capability differences, but every language has Boolean logic, looping, and nesting. Once you become proficient in one language, it’s typically easier to master the next one.

Most applications are worthless without data. Typically, data will be stored in relational databases, big data stores such as Hadoop, or NoSQL databases. Regardless of the role, all techies will probably find themselves querying data from one or more of these sources. Traditional databases like SQL Server and Oracle use the SQL language. Even the newer places to store data support SQL-like languages, HiveQL for Hadoop for example.  Understanding the basics of the SQL language is important, and that skill will transfer from platform to platform.

Technologists should have a good background in mathematics. Unfortunately, the requirements and courses offered to students vary throughout the world and even within a country. Mathematics is involved with every aspect of computing from creating algorithms to writing SQL to artificial intelligence. At a minimum, technologists should be able to understand basic algebra, for example, understanding expressions and formulas, and “solving for x”. Depending on the profession, statistics and calculus may also be required.  

Soft skills are the most difficult skills for technologists to learn. Gone are the days when a coder could sit alone in a dark corner all day with a headset, pizza, and a highly caffeinated beverage. The ability to communicate with teams, managers, and stake-holders is required in today’s world and for Agile and DevOps methodologies. Technologist are intelligent folks but knowing how to act professionally and respectfully at work (i.e., emotional intelligence) requires effort, but it is possible to learn and improve.

The final skill that all technology workers need is the ability to keep abreast of advancements in their chosen field. For database professionals, that might mean learning about big data, running SQL Server in containers, and machine learning as well as understanding what’s coming up with the next version of SQL Server. Developers might need to understand IoT, serverless computing, and artificial intelligence as well as the new capabilities of their chosen language.

It’s a wonderful time to work in technology. Do you have what it takes?

Kathi Kellenberger

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

ADVERTISEMENT
GDPR

How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

RGUni

Redgate University

Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers.
Start Learning

Featured Contents

 

SSIS Basics: Data cleansing using derived columns

Eduardo Pivaral from SQLServerCentral.com

On this article I will show you how to perform a basic data cleansing using the derived column data transformation More »


 

SQL Server 2019 is Here

Additional Articles from Database Journal

On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first public preview of SQL Server 2019 (community technical preview (CTP) release of SQL Server 2.0).This new release of SQL Server is packed with many new features to improve performance, integrate your increasing volumes of corporate data, beef up security, and more. More »


 

CALMS and how it relates to Database DevOps

CALMS is the acronym for a framework which allows businesses to assess how prepared they are on their journey to DevOps, and where they can improve. CALMS are important DevOps values, which enable you to break down silos, work better together, and provide frequent value to users that can be continuously improved. These values also relate to databases and it’s important to break down this silo as well so you can really fly. More »


 

From the SQLServerCentral Blogs - Invalid value given for parameter PASSWORD. Specify a valid parameter value.

Andy Galbraith from SQLServerCentral Blogs

I still use sp_help_revlogin to transfer logins between servers.  I know there are other options, including a set of Powershell... More »


 

From the SQLServerCentral Blogs - Unexpected Shorthand Date Implicit Conversions

Bert Wagner from SQLServerCentral Blogs

I do my best work in the mornings.  Evenings are pretty good too once I get a second wind. Late afternoon... More »

Question of the Day

Today's Question (by Sergey Gigoyan):

What will be the value of TRANCOUNT after the first execution of the following query in a new query window?

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: transactions.

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

ADVERTISEMENT

T-SQL Querying (Developer Reference)

Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

If I want to use the COMPRESS() function in SQL Server 2016, what options do I have for the algorithm?

Answer: GZIP only

Explanation:

The COMPRESS function uses GZIP and you cannot change this.

Ref: COMPRESS - click here


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

Why won't SQL Server use Free memory - Hey all, I have a 2 node Availability Group running. Both servers are Enterprise 2017 64 bit with 1.5 TB of...


SQL Server 2017 : SQL Server 2017 - Development

SP with dynamic sql parameters - Hello, I have one SP CREATE PROCEDURE . @year char(4), @criteria varchar(50) = NULL, @Flag char(1) = NULL, @searchstring varchar(100) = NULL AS DECLARE...

Sql 2017 upgrade from 2014 with sequential numbers - Hi  One of my users ran the following code set nocount on ;with  R0 as(select 1 as f1 union all select 1...

How to build an app with GUI that works with SQL Server? - I have to create a project which should have a GUI because people who gonna use it don't know TSQL....


SQL Server 2016 : SQL Server 2016 - Administration

Where is the Performance Bottleneck? - Evening Guys, I am back with another performance enigma (at least for me!). I have a couple of queries (altering the collation...

Upgrade - How to upgrade a database configured in replication on both the servers.


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

Changing 1 or + in a telephone number to the correct format - Hi everyone I have various records in a database that contain US telephone numbers in different formats. Some are correctly formatted...

Compare top 2 transactions from 12 months from the current transaction date -

Memory Optimized Tables - Cross DB access - Hello, Is there a workaround to accessing a memory optimized table from another db? For a select only? DB1 -> The location...

seperate data in 1 row - Hello HOw can I separate  this data I have buch of emails in a row, I need to keep just one and...


SQL Server 2014 : Development - SQL Server 2014

TRANSACTION effects and considerations - Hi all....   I've got some code that I'm going to need to place into a transaction so that something like...


SQL Server 2012 : SQL Server 2012 - T-SQL

Stored Procedure - Issue - Hi Please help with the following stored procedure, what am I doing wrong? USE msdb GO CREATE PROCEDURE dbo.sp_getbackuphistory @DATABASE VARCHAR(50),  @TimeDiff INT OUTPUT AS  BEGIN SELECT...


SQL Server 2008 : SQL Server 2008 - General

Can't remove multiple char(32) strings - Hi, I have some double spaces in text strings that I would like to remove. I have tried the usual script and...

I need to change the value of two fields as I insert the rows into a table - So I have the source table   TdatasegTest I have the target table TdataSeg If I needed a simple insert I would use this...

Need Create View Script for all tables - I manage a SQL 2008 R2 Production environment for an application. We have a new requirement to create views( simple--select...


SQL Server 2008 : T-SQL (SS2K8)

Identify Deals Sold by W2 Employees Only - For this example assume a company has both W2 and commission employees. What I'm trying to identify is sales record...

Strange Replication Initialize a Transaction Replication from a Database Backup - Hi All Many thanks in advance for any info provided :) I have tried this out on our DEV enviroment from 2008...

Extract string between delimiters - HI I want to extract string between the delimters where data is as follows: abc_def_cet_qwe output required in only def , how...


Reporting Services : SSRS 2012

Redeploy RDL after changing sproc? - I recently made some changes to a sproc that wasn't running well to a point it runs great now! It...


SQL Server 2005 : Administering

How many clustered indexes can a table have? - The obvious answer is one, but there is something more fundamental in this. This question is even discussed at PASS...

This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected].
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.
This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected]