Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge
Editorial
 

Bad career advice from a 14 year old

I was having a conversation with my 14-year-old grandson Thomas the other day. He was telling me that is signed up to take a programming class in school next term and sees a future career in technology. He loves playing video games, so maybe developing them would be a good choice. He also was thinking about being an “IT guy” because of certain things an IT guy can do.

I was curious about what he thought working in IT involved since most of his knowledge was probably from movies. The first scenario he came up with involved getting fired so that the company could hire someone else for less money to do the same job. It wouldn’t be long before they begged the IT guy to come back – at 20 times the old salary – since no one else could do the job.

As exciting as this fantasy sounded to young Thomas, keeping knowledge to oneself to improve job security is a bad idea. Too much job security due to hoarding knowledge means that you cannot easily take time off and never fully disconnect from the job. Documentation, automation, run books, and cross-training should be the norm.

The second fantasy scenario involved the sabotaging the company so that data and systems would be lost if IT guy was ever let go. Thomas imagined that said company was actually corrupt and doing lots of evil things. Once an investigation uncovered the misdeeds, IT guy would be a hero for taking down the company.

As exciting as that scenario sounded to young Thomas, schemes like this are criminal regardless of the wholesomeness of the targeted organization. In my opinion, anyone with intentions of hurting a company through these means doesn’t deserve the job, and IT professionals should use their powers for good and not evil

Of course, organizations should have controls in place, such as separation of duties, auditing, encryption, and well-defined policies and procedures to prevent internal attacks.

I would love for Thomas to become interested in a technology career, and I’m sure his expectations will change by then.

 

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Database Deployments and Rocky Rollback Horrors: Where Does the New Data Go?

Phil Factor describes the problem of preserving data that is left 'in limbo' when you need to revert the database to a previous version that has no way of accommodating it.

Monitoring Amazon RDS SQL Servers to Optimize Performance and Manage Costs

Israel Valverde explains the triple benefits of extending SQL Monitor to cover your SQL Server instances running on Amazon RDS, in terms of SQL Server performance optimization, controlling AWS-hosting costs, and in having a single, unified view of the health of all your SQL Servers, regardless of where they are hosted.

Have your say in the 2021 State of Database DevOps survey

Have you taken the 2021 State of Database DevOps survey yet? If you or your organization uses databases, we want to hear from you! Complete the survey for advance access to the final research report, and to be entered into a prize draw for a $500 Amazon voucher. Plus, for each submission we receive, we’ll donate $1 to the World Health Organization’s COVID-19 Solidarity Response Fund.

Administration

Virtual Log Files

Today’s post is a guest article from a friend of Dallas DBAs, writer, and fantastic DBA Jules Behrens (B|L) One common performance issue that is not well known that...

Azure SQL Database

Deploying to Azure SQL Database using GitHub Actions

After my last post I wanted to test deploying to Azure SQL Database using GitHub Actions. To check that it all runs smoothly...

Backup and Recovery

Developing a backup plan

Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should...

Computing in the Cloud (Azure, Google, AWS)

Top 10 Must-Ask Questions Before Going to the Cloud

After architecting and migrating some of the world...

Conferences, Classes, Events, and Webinars

More Gems from the SQL Prompt Treasure Chest

Join Microsoft MVP Grant Fritchey and Redgate's Owen Standage on a journey through the hidden treasures of SQL Prompt. Discover features of the unknown that will enable you to write, format, analyze and refactor your SQL effortlessly.

Improve Data Efficiency with Database DevOps Solutions

Details: Database DevOps solutions can help your organization protect business-critical data and improve the efficiency and quality of your software delivery. Register for this Microsoft hosted webinar to learn how you can rapidly implement a database DevOps solution with Azure and Redgate tools.

Join us for this year’s final Redgate Summit

With 2020 coming to a close, it's time to look at the new year ahead. Join our final 2020 summit this December 10th, to discover how to implement a generative culture for successful IT teams and how database DevOps will drive growth and ROI in a remote world. Register to tune in live or watch the recordings.

Data Mining / Data Analysis

3 compelling reasons nonprofits are relying on analytics during the pandemic

It’s no surprise that nonprofit organizations providing health-related services are overconsumed during the COVID-19 pandemic, but what about other types of nonprofits?...

Data Science

Introducing an All-purpose, Robust, Fast, Simple Non-linear Regression

The model-free, data-driven technique discussed here is so basic that it can easily be implemented in Excel, and we actually provide an Excel implementation.

IoT Unravelled Part 1: It's a Mess... But Then There's Home Assistant

Alright clever IoT folks, I've got two of these garage door openers, what do you reckon the best way of connecting them with Apple HomeKit is?...

Database Design, Theory and Development

Generally Accepted Data Modeling Principles

Click to learn more about author Thomas Frisendal. What can data modelers learn from accountants? Accounting is a solidly established practice that the world cannot live without. One of...

Normal Forms

To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In this article, Joe Celko reviews normalizing databases including commonly used normal forms.

DevOps and Continuous Delivery (CI/CD)

Challenges to Implementing Database DevOps: Where To Start With a Separate Team?

There were so many questions asked at a recent presentation that I just didn’t have time to answer them all. However, many of them were really interesting, so I...

Why Aren’t You Automating Database Deployments?

Building out processes and mechanisms for automate...

ETL/SSIS/Azure Data Factory/Biml

Global Parameters in SSIS Framework

I’m happy to announce the latest version of our SSIS Framework includes global parameters! I can hear some of you thinking, … “What Are Global Parameters, Andy?” I’m so...

General

Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners

Total: 1 Average: 5This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values. Additionally, the readers will get...

Oracle

SQL Developer – A great tool and better ways to use it

SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features of SQL Developer that can make you more productive.

Performance Tuning SQL Server

Plansplaining, part 12. Foreign keys, part 1

Welcome to part twelve of the plansplaining series, where I’ll discuss foreign keys in the context of execution plans.

Be Careful Where You Use AT TIME ZONE

Databases really do make you pay dearly for mistakes, and new linguistic functionality is not implemented with performance in mind...

Finding the One Query to Tune in a Multi-Query Batch

My annual Black Friday Sale is on now! Save thousands on the best training classes in the industry.

PowerPivot/PowerQuery/PowerBI

How to enable dataset sizes larger than 10GB for Power BI Premium or Power BI Premium Per User

In the steps below I will show you how to change this setting to allow for larger dataset sizes...

A look at Visual Data Prep in Power BI dataflows

Have you noticed the updates Power BI dataflows ha...

RANKX on multiple columns with DAX and Power BI

This article shows techniques to obtain a ranking based on more than one column. The ranking can be both static and dynamic...

DAX Formatter tool for Power BI Desktop

Last week I was honoured to take part in the latest edition of the Power BI Dev Camp which is run by my colleague Ted Patterson...

Delaying Power BI Dataset Refresh Until The Source Data Is Ready

This week a customer came to me with the following problem: they had scheduled the refresh of their dataset but their source data wasn’t always ready in time, so...

Power BI – Hungry Median

Introduction Median is a useful statistical function, which first time appeared in SSAS 2016 and in Power BI around that year as well. There are several articles on how...

Product Reviews and Articles

Book Review: SQL Server 2019 Administrator’s Guide, 2nd Ed

This book aims to give you the skills to set up, administer, and maintain SQL Server 2019 databases - how does it fare?

R Language

Working with images in SQL Machine Learning using R scripts

In the article, An overview of SQL Machine Learning with R scripts, we learned the R services integration with SQL Server 2019. We also explored a few useful external packages.

SQL Server on Linux

Creating a Virtual Machine With Oracle VM Virtual Box

Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server 2019 work on Microsoft Windows and Linux...

T-SQL

Azure SQL Database – Greatest and Least TSQL

Being in the cloud does have many benefits, from lower administration to fast scaling but another “side effect” of operating in Azure SQL Database is the cloud first nature... The...

Transact-SQL Code Snippets

There are certain T-SQL statements whose syntax I ...

Views in SQL Server

Total: 2 Average: 5 Introduction A view in SQL Server is a virtual table-like structure based on the result-set of an SQL statement. On the surface, a view is...

Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2

Total: 2 Average: 5 Outer join is at the center stage today. And this is part 2 of your ultimate guide to SQL joins. If you missed part 1,...

 
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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