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

The Voice of the DBA

Dealing with Supervision

This editorial was originally released on Feb 4, 2013. It is being republished as Steve is out of the office.

I've been working at home for a decade, first for my own company and now for Redgate Software. In that time, I've learned to manage myself, motivate myself, find work to do, and meet deadlines, all of which I've done without having anyone manage me. Over the last five years I've worked at Red Gate, I'd like to think that I was one of the easier people to manage since I work well on my own. I'm not sure if my various managers would agree, since I know that I can be particular about how I work and not necessarily work closely with others, but at least I haven't required much of their time.

A short while back I was talking with a friend that was under pressure to complete a deployment that was proceeding poorly and their manager stood next to their desk, watching, commenting, and asking how long each process would take. I've had to deal with that situation in the past, and it was maddening to me. It's hard enough to focus and work on a task when there are problems with the technology. Having someone that can't contribute but is in a supervisory role nearby usually makes things worse.

Ultimately I think micro-management says more about the manager than the employee. There are trust issues or control issues, or perhaps pressure from the manager's boss. It can be hard to deal with micro-management, but if you plan to continue your employment, you need to find some way to deal with it.

There is no shortage of ideas. You can search for "dealing with micro-management" and you will get a wide variety of advice. I've tried different techniques in the past and some have worked, some haven't. The best way to handle micro-management seems to vary with the situation, but it's good to have a few things to try.

Steve Jones from SQLServerCentral.com

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

NEW SQL Clone - version 1 available now!

Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free.

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial.

Featured Contents

SQL Server Cluster Automatic Memory Management

Jason Givens from SQLServerCentral.com

Don't waste memory in a cluster! Learn how to allocate memory between instances. More »

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage. More »

Clean Your Buffers for Accurate Performance Testing

In order to do accurate performance testing between multiple runs of a SQL Server command or scripts you need to remember to clean the buffer, procedure and system cache between each test run. More »

From the SQLServerCentral Blogs - Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution

Rob Sewell from SQLServerCentral Blogs

With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it... More »

From the SQLServerCentral Blogs - Delete an Azure SQL Database from PowerShell

Steve Jones from SQLServerCentral Blogs

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More »

Question of the Day

Today's Question (by Carlo Romagnano):

What's the output of the following query?

 SELECT MAX(DISTINCT [Points])       ,MIN(DISTINCT [Points])       ,AVG(DISTINCT [Points])   FROM (VALUES (5)               ,(5)               ,(3)               ,(3)               ,(NULL)        ) AS V([Points])

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 2 points in this category: T-SQL.

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

Pro Power BI Desktop

This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I want to assign the numeric value of 42 to the variable, i, in the R language. How do I do this?

Answer: i <- 42

Explanation:

To assign a variable in R, we use the <- structure. The way to do this is

i <- 42

Ref: tryr.codeschool.com - 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 2016 : SQL Server 2016 - Administration

XCOPY failing via xp_cmdshell - I am trying to copy files from our hosting site server to pur local server with XCOPY. If I log...

Database Architecture Question - Hi, I know there's always 100 different ways to skin a cat, so I thought I'd see what you recommend... My organization...

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

Getting data into SQL Server - Hi, Working for a small organisation and we now have a need to stop using spreadsheets to store data and move...

SQL Server 2014 : Administration - SQL Server 2014

Server shutdown - I see in the event logs as below. What could be the reason. Any idea? The previous system shutdown was unexpected.

SQL Server 2012 : SQL 2012 - General

Installing SQL Server: How much space to allocate for each drive? - Hi everyone, I'm in the early stages of installing a 2012 instance and am unsure how much space I should allocate for...

Management Studio freezing after writing a few lines of code - Hi all I've got a bit of an odd scenario. We're using SSMS 2012 against an 2012 Business Intelligence SQL install. Sometimes (it...

Help me rearrange the SQL statement - It works but ? - Folks I got this off of a SSRS report. This works fine. However I can't seem to make sense from this. I...

How to archive old data from sql database - I have some data being written to a sql database, by requirement I need to retain the data for 1yr....

upgrade/ migration from Sql Server 2008 R2 ent ed x64 to 2012 ent ed x64 - Hi All, i would like to hear from you advice regarding my approach on performing the upgrade/ migration of my existing...

SQL Server 2012 : SQL Server 2012 - T-SQL

Removing Reverse Duplicates - Hi all, I've been racking my brain all afternoon with this one. In their wisdom, the developers of this database many...

How to join these tables together - How to join Employee and Student tables with HR table, - using ID and date columns to join with effective dates...

SQL Server 2008 : SQL Server 2008 - General

Syntax issue in sql query - Hi , I need some help in a sql query. I have an existing query: SELECT CAPBANK.BANK_LOAN, CAPBANK.LOAN_YEAR, CAPBANK.LOAN_NUM, (SELECT TOP...

How Do I Find Who Last Edited a Record or Table in a Database? - I have the following query built: USE MyDataBase; GO SELECT DB_NAME(ius.) AS , OBJECT_NAME(ius.) AS , MAX(ius.) AS , MAX(ius.[last_user_s

SQL Server 2008 R2 CPU Blunted Spikes - Hi there, I'm looking for suggestions for statistics I could monitor to discover what could be causing the cpu "blunted spikes"...

steps to restore database - Hi Team, I'm trying to restore a database on sql2008 environment. I have the full backup. can u please let me know...

SQL Server 2008 : SQL Server Newbies

Index and or constraint - I have this table CREATE TABLE .( IDENTITY(1,1) NOT NULL, (50) NULL, (50) NOT NULL, (1) NULL, -- number of columns...

Data Warehousing : Strategies and Ideas

No PKs on fact tables - I just inherited a data warehouse where none of the fact tables have a primary key (all fact tables are...

Database Design : Virtualization

Recomended Hyper-V Memory Settings - I am seeking insight on memory management for Hyper-V. I have reviewed much of the material on Virtual Memory available...

SQL Server 2005 : Administering

SQL Server DBA Certification - Hi All: I want to become a certified DBA, i'm not sure what path is the right one. I have exprience...

QUERY: GET SPACE USED/FREE in All Databases - Hello again, I need to get the following information: - Space Allocated from each database, - Space Used and from each database and...

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.