SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Limiting the Ability to Concentrate and Collaborate

I used to have an office. I guess I have an office now, but it's not mine; it's shared with my wife. As I look back at my career, I realize that I've often taken a job that switched me from a more open working environment to an office, and back. Early in my career, we had cubes, which a few of us combined into an open 4 desk space at one point. Then I took a job with an office, then back to an open plan (10 developers in a room), then my own office, before ending up with my shared office. Actually, I'm always sharing a space. When I travel to the Redgate offices, they have an open plan, so I get a desk that's open to a few dozen other people.

I've gone back and forth on whether or not I want a shared space. I've come to the conclusion that it really depends on my job. When I worked as a sysadmin, where we were constantly collaborating with others, an open, shared space worked well. We could easily talk to each other, which was an efficient way to work.

When I've worked as a developer or a manager, I've preferred having my own office. The ability to concentrate for longer periods of time is helpful for me, and while headphones separate me, they aren't as private, as there can still be visual distractions as people move around. I've had people come up to tap me on the shoulder, which can ruin my concentration at times.

There's an article at Ars Technica that talks about a study showing that open plans result in much less productivity and even less interaction. That seems counterintuitive, as I'd expect an open plan to encourage more interaction. Indeed, when I'm at the Redgate office, I find that someone will often turn and chat with a friend. Or if two people are talking, it can become a watercooler atmosphere where others join in. There seem to be plenty of interaction.

When I've been at Microsoft, where everyone has a small office and most with a window to the hallway, I find lots of open and closed doors, with the former inviting others in and the latter discouraging it. I do see plenty of workers get distracted if someone stops and looks in the window. At the same time, I also find there are lots of open spaces where people can engage with others and even work in an open space if they desire.

I don't know if one way is better or worse than the other. I know that I feel differently at different times about how I work. At Redgate, we do have some pods for private work if you choose, but they aren't completely closed off. They're more like a cube or a small space for one person. I do find that having a private space is important for me at times, and if I were to go back to a company's location on a regular basis, I'd want to ensure I had some sort of private office, even if it were only for a portion of a week and others used it when I wasn't there.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 5.1MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

ADVERTISEMENT
Webinar

How to extend DevOps practices to the database

Including the database in DevOps initiatives greatly improves performance. We will walk you through Redgate’s Database DevOps solution, showing reliable, scalable and repeatable processes for automating your database development and deployment.
Register now

SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

Featured Contents

 

Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2

Nikolai Basov from SQLServerCentral.com

In this article, 2nd of 2-part series, we will look at the 3rd approach to import JSON, recap both parts of the series and form a conclusion. More »


 

The Crimes of Chicago: Working with Data in MongoDB

Additional Articles from SimpleTalk

NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important. In this article, Phil Factor demonstrates how to work with a MongoDB database and how to use PowerShell with MongoDB so that the process can be automated. More »


 

Documenting your Database with SQL Change Automation

Generating database documentation can be time consuming. Rather than abandoning it as a routine part of the process, try generating it separately, as a parallel process to the build, using the same tools. Phil Factor explains how. More »


 

From the SQLServerCentral Blogs - SQL Server Encryption, What’s The Key Hierarchy All About?

david.fowler 42596 from SQLServerCentral Blogs

  I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt... More »


 

From the SQLServerCentral Blogs - SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)?

Solomon Rutzky from SQLServerCentral Blogs

With the additional (and annoying) configuration step required to get SQLCLR Assemblies to load starting in SQL Server 2017, some... More »

Question of the Day

Today's Question (by Steve Jones):

What is the limit for Foreign Keys in SQL Server 2016? In other words, how many other tables can my dbo.Sales table reference?

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: Foreign Keys (FK).

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

Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2

Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services.

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

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What does DBCC stand for?

Answer: Database Console Command

Explanation:

DBCC comes back from Sybase, when these were checks that DBAs used to check their systems.

Ref: DBCC - 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

Compare SQL Server Schema with Sybase Schema - Hello everyone,  Thank you for looking into my question.  I would like to know if there are any tools available in...

Slowly Changing Dimension ssis - Hello everyone Slowly Changing Dimension transformation is the cause of deadlocks? if so how can I optimize it thanks

Is it possible to view files in Filestream foder? - I am just studying filestreams, I've created one and saved a few files of different types there. I know that...


SQL Server 2017 : SQL Server 2017 - Development

Need to modify the Update statement to include two new tables instead of one table - Currently, in existing system i do have following update statement: Update ProdStg set unit_cost=case when ci.totcstperacct<ci.cst1 then ci.chk_amt1                                  when ci.totcstperacct>=ci.prc2 and ci.totcstperacct<ci.cst2...

i need to write stored proc following logic please help me the code. - i need to write stored proc following logic please help me the code. i need to get distinct prodid from prod...

Proc Fails when run in SSIS but runs fine in SSMS - Hi All,  I have the Stored procedure below which iterates through a table to decrypt RSA encrypted email addresses.  When run in...

Convert Varchar field - I have a Varchar field with units in inches :( that i need to convert to an integer (Unfortunately the " and...


SQL Server 2016 : SQL Server 2016 - Administration

Database in Full recovery mode, with NO logbackups but logshipping setup - Hi I have encountered an instance in full recovery mode with NO logbackups but logshipping setup to a standby server....

Always on Install - Hi  I am following these notes for always on install and have some basic queries: http://www.sqlservercentral.com/blogs/ganapathis-mssqllover/2017/02/20/alwayson-availability-groups-step-by-step-setup/ For step 9 Click the Add… button


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

EXCEPT - Do the fields of both objects  and/or select statements between which i use EXCEPT keyword have to be or preferably...


SQL Server 2014 : Development - SQL Server 2014

How to search in database for a specific data... Sometime you are given a screen shot of something and you don't know where it is in the data. - DECLARE  @value

Any way to reduce the execution time for 8mil + rows table with cross join - Dear All, I have following Query in my production. My Table_B has 8mil + rows. If I have 4 role in Table_C, my...


SQL Server 2012 : SQL 2012 - General

Rebuilding Indexes - How do you determine how often you need to rebuild your indexes?


SQL Server 2008 : T-SQL (SS2K8)

Compute & Rollup - This statement will produce:  Select EmpID, Yr, sum(Sales)as Sales from Sales Group by EmpId, Yr With Rollup  EmpID               Yr                            Sales


SQL Server 2008 : SQL Server Newbies

millions of users hitting our database - Good Morning Experts, There is a mega sale on a TV for 5 days, starting tomorrow. We are expecting millions of...

Prevent duplicates in a table - I am entering 'salaries' information into a sql server table called 'salaries'. Fields are : id (pk,identity),c_id (int),month,year,salary. I use a stored procedure...

How to set the primary key for each table - Hi all. I am a super noob with SQL server.  and I mean, brand spankin' new noob still with bright sparkly...


Data Warehousing : Integration Services

Insert new records from one database to another using SSIS - I have a table with Table 1 ( taskid bigint , name varchar(200),  tasktype varchar(500)) , what I trying to achieve is every...


SQL Server 2005 : SQL Server 2005 Integration Services

Copy all files from folder - How can I copy all files from folder. G:\MainFolder\Folder\ Inside this Folder has txt files. I want to move all this txt...

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.
This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com