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

The Voice of the DBA

The Remote Balance

This editorial was originally published on Feb 20, 2014. It is being re-published as Steve is out of town.

I still have hope that we will see more and more remote workers in the future. As large companies downsize and choose smaller facilities, and as many new companies start from scratch, we'll see many of them considering telecommuting to find the best technologists for their openings as well as reduce their infrastructure costs. As noted in the book, Remote: "Today, the new paradigm is move work to the workers, rather than workers to the workplace."

I don't know if we'll ever get the majority of people working remotely from offices or at home, but I do know that I see more and more people able to get work done outside of a traditional office. I see people checking email and responding to trouble tickets in all sorts of situations, and with all sorts of jobs. I suspect that businesspeople continue to do this more and more as devices and software expand to allow it.

I saw that quote from Remote in a blog from Scott Hanselman where he also commented on that idea, but noted that we need to strive for some balance. It is great that you can fix a problem at your kid's soccer game or dance recital, but it's also important that you attend and enjoy those events.

Like most tools, our remote access can be good or bad. If you check too often, become tethered to devices, and ignore the real world, that's bad. However if you leave the office early, get to the game, and get some work done before the action starts, that's good. Just don't forget to prioritize the important stuff, which is usually not work. It's the event you're attending.

Steve Jones from SQLServerCentral.com

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

Database migrations inside Visual Studio

Want to work on SQL Server databases in Visual Studio alongside your application? Use Redgate ReadyRoll to develop & deploy databases using SQL migration scripts. Try it free

Do a lot more with Redgate tools

You probably have a favored Redgate tool but if you’ve been using it for a while, you may not be making the most of the latest features. Keep track of features and releases on the new Redgate Hub. Discover the Redgate Hub

Featured Contents

A Tale of Partition Schemes and Disappearing Dragons

Porter James from SQLServerCentral.com

A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death. More »

Overview of Azure Data Lake

Additional Articles from Database Journal

Azure Data Lake stores petabytes of data and analyzes trillions of objects in one place with no constraints. Data Lake Store can store any type of data including massive data like high-resolution video, medical data, and data from a wide variety of industries. Data Lake Store scales throughput to support any size of analytic workload with low latency. Read on to learn more. More »

From the SQLServerCentral Blogs - Azure SQL Database Level Firewall Rules

Arun Sirpal from SQLServerCentral Blogs

I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog... More »

From the SQLServerCentral Blogs - New Features in SSMS 17.3

Wayne Sheffield from SQLServerCentral Blogs

SSMS 17.3 SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention: Import Flat... More »

Question of the Day

Today's Question (by Steve Jones):

I want to create a Python list and then add the first 3 values of the Fibonacci sequence to it. I have this:

 Fib = []

Which of these completes the code?

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

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

SQL Practice Problems: 57 beginning, intermediate, and advanced challenges

It's easy to find basic SQL syntax and keyword information online. What's hard to find is challenging, well-designed, real-world problems—the type of problems that come up all the time when you're dealing with data. Learning how to solve these problems will give you the skill and confidence to step up in your career. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What's the limit on text in each row returned by sp_helptext()?

Answer: 255 characters

Explanation:

The limit is 255 characters.

Ref: sp_helptext() - 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 - Development

Shared stored procedure with very complicated input - So, the basics of what I want to accomplish is simple...I have a stored procedure that has some really complex...

SQL Server 2014 : Development - SQL Server 2014

Selective change tracking in a column - Hi, I have to count how many times a record changed from group 2 to group 1 or 3 per ID...

Trying to speed up this 'GetWorkingDays' function. - I'm trying to redesign one of our working days functions. The idea is to calculate weekends (easy enough) but holidays...

How to get columns which has null's - Hi Experts, Need some tsql help. I wanted all the column names from all below 3 tables which has nulls. i.e....

Having trouble displaying a date in a certain format... - Select Invoice_Exceptions.Invoice_Number, Invoice_Exceptions.ItemNum, Inventory.ItemName, Invoice_Exceptions.Amount, Invoice_Exceptions.Quantity, Invoice_Exceptions.Reason_Code, Invoice_Exceptions.LineNum, Invoice_Exceptions.EmpName, Invoice_Exceptions.DateTime AS Day_Voided, Invoice_Totals.Payment_Method From Invoice_Exception

SQL Server 2012 : SQL 2012 - General

MS SQL 2012 with 2 nodes Cluster - Hi, I have a question regarding sql 2012 cluster 2 nodes OS: Windows 2012 with AD SQL: MS SQL Server 2012 Cluster: 2 nodes First...

Connection Encryption - Protocols not showing the certficiate - Following https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine to setup SSL connections. Have got through to the part when you need to enable the certificate in the...

SQL Server 2012 : SQL Server 2012 - T-SQL

OPEN TEXTFILE FROM T-SQL - Hai Friends, I have this TXT FILE And I want to create Stored Procedure to insert to TEMP TABLE With each name of...

Performance Optimization: Can a varchar(max) be "SPLIT" into 8K chunks at the nearest delimiter AND quickly? - I've got a scenario where it might be almost impossible to change a data type for an existing stored procedure...

SQL Server 2008 : SQL Server 2008 - General

Handling string column with dates - I imported a csv file that has a column with dates. The column is a varchar type and it has...

SQL versus program - Hi all, I'm posting my question in this 2008 forum because we're running SQLServer 2008R2, but it is more a general...

Programming : General

Data in a row is being updated somewhere else during a stored procedure - Hi all, I have code in a stored procedure that is like this: IF EXISTS(SELECT * FROM table_a WHERE ID=@ID AND StatusID = 1)...

django (not the movie) - Does anyone have any experience with django and how it works with databases in development? I am getting thrown in to...

Data Warehousing : Integration Services

Argument "" for option "maxconcurrent" is not valid. The command line parameters are invalid. - Hello We have a strange problem, using SQL Server 2016, project development model. High level, the flow is as follows: Generate a...

Data Warehousing : Analysis Services

Need help creating offline SSAS cube (2012) using Excel 2016 - I have an OLAP cube that I can display data from using an Excel Pivot Table and there seems to...

Database Design : Design Ideas and Questions

Table Index - I have a potential table CREATE TABLE dbo.Preferences ( EmailAddress VARCHAR(100) NOT NULL, ChannelID INTEGER NOT NULL, ContactTypeID INTEGER NOT NULL, AllowContact BIT NOT NULL, GDPR...

SQLServerCentral.com : SQLServerCentral.com Website Issues

Extreme slowness - The site is extremely slow. It's taking as long as 2-3 minutes for a link to work.

SQL Server 2005 : Data Corruption

Data row does not have a matching index row in the index - Hello, I have this problem. At monday found this, so drop and recreate index, then execute dbcc check and without problem. Today...

SQL Server 2005 : SQL Server 2005 Integration Services

Using Windows Task Scheduler to detect SSIS package failure - I'm using Windows Task Scheduler with 32 bit dtexec.exe to execute an SSIS package and I was wondering how I...

Career : Presentations and Speaking

Potential presentation idea: SQL Server for absolute beginners - So, I took today off from work to prepare and travel to SQL Saturday #517, and something occurred to me...

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.