SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Informing the Internal IT Team

Somehow across the course of my career, I've morphed from a strictly technical guy to a publisher and teacher that also gets to do some technical work. I never expected this, though perhaps I should have. Despite my disdain for writing in formal schooling, I learned early on to always document and log what I did. In fact, a few times my notes and tracking ended up ensuring that we weren't chastised too harshly for our actions. Perhaps if even kept some people from being fired. I'm not sure, as I think it's hard to get fired, but having some reasoning and documentation can provide some insurance against the boss getting too upset.

In my career, I've had to send out status items at different times, with various purposes. As with many of you, I've often had to document my time and efforts for my manager. I've been a part of teams that adopted the stand-up practice of sharing your workload with others. I've had to summarize the work of my team for a director or VP above me. Some of those efforts felt valuable, but often it seemed I was going through the motions and wasting valuable time on something that was more of a cover sheet on a TPS report than anything else.

There was a post on publishing an engineering weekly newsletter that reminded me of the various status reports I've built. While I haven't had a weekly engineering letter, I have been in companies where a weekly or monthly newsletter was sent out. In fact, at one of my first jobs, we got a physical copy of monthly company newsletter delivered to our mail cubbies (anyone remember those?). While people would grumble about the contents or disbelieve them, I also noticed that many of them actually read the newsletter. I think it's natural for people to want to be informed about the company, even if they are skeptical about the data.

The idea of publishing a weekly newsletter for your staff makes sense. It's a good way to keep people on the same page, especially as your organization grows larger than a single team. I wouldn't expect everyone to read every part of each issue, but that's OK. They'll get something out of it. This is also a good way for someone to fill time during a short break, see who's out of the office, having a birthday, or changed positions. I think it's also a good reminder for items like on-call or project releases. Even if I don't have time to read it right away, finding information in a central place can be a hassle, and a quick search of email would let me check the person to call this week after hours.

Including technical content is always good, and allowing someone to peruse articles or new concepts on their own time, maybe even encouraging more learning subtlely, could improve the quality and morale of your staff. Of course, if you are an open, exciting company that employees enjoy, this works well. If management is oppressive and overbearing, then publishing a newsletter isn't going to fix your culture. You've got other problems to fix first.

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 ( 4.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.

SQL Clone

NEW product launch: SQL Clone - live stream this March!

Data Platform MVPs Grant Fritchey and Steve Jones show how to create database copies in seconds using MBs of disk space with Redgate’s NEW database provisioning tool SQL Clone! Tune in to this live stream session on March 29th 2017. Register now.

Featured Contents


Installing SQL Server vNext on an AWS EC2 RHEL Instance

Kenneth Igiri from SQLServerCentral.com

The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2. More »


Ding - The World’s Largest Mobile Top-up Network Streamlines QA with SQL Server Containers

Andrew Pruski from SQLServerCentral.com

In this case study, see how database containers can help improve a QA process. More »


How to Find Queries Using an Index (and Queries Using Index Hints)

Additional Articles

Sometimes you know a query is out there, but it’s hard to find the exact query. In this post, Kendra Little gives example code to find queries using a specific index, or using an index hint. More »


From the SQLServerCentral Blogs - Quickly Creating Test Users in SQL Server with PowerShell using the sqlserver module and dbatools

Rob Sewell from SQLServerCentral Blogs

One of the most visited posts on my blog is nearly two and half years old now – Add User to... More »


From the SQLServerCentral Blogs - VMware Updates In-Guest Clocks When You Say Not To

kleegeek from SQLServerCentral Blogs

VMware’s VMTools package has some options for synchronizing the in-guest clock with the time of the ESXi host. By default,... More »

Question of the Day

Today's Question (by Steve Jones):

I run this command:

Backup-SqlDatabase -ServerInstance .\SQL2014 -Database sandbox

I then run this:

Backup-SqlDatabase -ServerInstance .\SQL2014 -Database sandbox -Incremental

If the default backup folder was previously empty, what files are now in the folder?

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

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 Server T-SQL Recipes

SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What keyboard shortcut can be used in SSMS 2016 to hide the results pane in the query editor?

Answer: CTRL+R


CTRL+R will hide or reveal the results pane.

Ref: SSMS Keyboard Shortcuts - click here

» Discuss this question and answer on the forums

Featured Script

Find all published tables with row counts and table size

Jim Youmans from SQLServerCentral.com

Sometimes you need to list all the tables that are being published on a server.  Once you have the list it is really nice to have the table sizes too (row count and total MBs for table).  This script will do the following.

  1. It looks at all the databases, finds the ones that are published
  2. Then if grabs the row counts and table sizes for tables in those databases
  3. Then compares that to the articles in the publications and gives you a nice easy to read report

Please Note: This assumes no filters on the publication.  If you have a very large table and are only replicating 5 of 60 columns, if will not see that and will give you the numbers for the entire table.

More »

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

Include the notify operator option when scripting slerts using SSMS - Hello, I am on SQL Server 2016: @@VERSION output:Microsoft SQL Server 2016 (RTM-CU2) (KB3182270) - 13.0.2164.0 (X64)   Sep  9 2016 20:13:26  ...

Need to know what I should install for my SQL - Hi! I am trying to configure a SQL server for production. it is going to be stand alone server, could you...

Service Broker concurrency post 2016 upgrade - Hi! We recently performed an upgrade from 2012 to 2016 (13.0.4411.0) of our production environment. Among the issues we're experiencing is service...

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

Encapsulating complex logic without using a scalar UDF - I have business logic for date comparisons that go beyond the typical DATEDIFF functionality.  For example, when determining the number...

SQL Server 2014 : Administration - SQL Server 2014

Remove all leading zeros from a column of data in SQL? - I have a data table called 'ItemNum' The column is a SKU, which is all numbers...the current format is: 028200136107 I need to...

Unable to fetch result from linked server - Hi Experts, In our production server, we are using one query to fetch the result from linked server, using one particular...

Refresh table data from Prod to UAT - Hello Folks, What is the best approach to refresh UAT table from Production. Tables have foreign key constraints and identity keys....

How do I perform restore of DB which does not exist? - Hello, I have full backup of DB and transcation log backups. I select BAK file and transcation log backup in SMSS,...

DB restore stucks after recovery step - Hi, trying to restore my db for testing https://www.sqlservercentral.com/Forums/1862799/checkdb-Multiple-IAM-pages-for-object I splitted the restore process into 2 steps, i restore full with...

Downgrading from SQL Server 2014 to SQL Server 2012 - Hi, I need to know how I can downgrade to a SQL Server 2014 installation to SQL Server 2012. Thanks

SQL Server 2014 : Development - SQL Server 2014

Covering Index - When and how do you use a covering Index?

SQL Server 2012 : SQL 2012 - General

Different query plan on read only seconday replica - Hi, a user asked me why a query finishes in  <1 second on an Availability Group secondary replica but takes...

SQL Server 2012 : SQL Server 2012 - T-SQL

t-sql 2012 rank or priortize values in one column - In a t-sql 2012, I have a table that looks like the following: CREATE TABLE .(   IDENTITY(1,1) NOT FOR REPLICATION...

SQL Server 2008 : SQL Server 2008 - General

Clustered scan vs Non-clustered Seek with lookup - Hi I think the answer to this question will be "it depends" but i'm interested to know what the variables might...

SQL Server 2008 : T-SQL (SS2K8)

'Spell check' a string-valued field - Hello all, We have a field in a table that's a string-valued field. In this field are (mainly) what I'll call...

SQL Server 2008 : SQL Server Newbies

How does a SQL Script Execute - I have a project that I have inherited and the previous caretaker has made a SQL Query that should be...

Reporting Services : Reporting Services

Bypass a report filter - Is there a way to "skip over" a filter? I have a date range parameter and one other parameter. There...

Data Warehousing : Integration Services

More "ACE" driver frustrations. Large Integers loading as exponentials - Ok... well I just made a topic and I never appeared, that's really really annoying... I'm going to cut this shorter...

Data Warehousing : Strategies and Ideas

Build an architecture for highly confidential project - Hi Guru, I've a project which dealing with confidential data, such as payroll, medical information and etc. All these confidential data...

Data Warehousing : Analysis Services

Creating Date & time table help - I two tables one is master and other one is detail, its not structured yet, Please see sample data Master Table: Ticket_Num    ...

This email has been sent to {user_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.
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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com