Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA

Daily Coping Tip

Set yourself on a kindness mission. Give your time to help others.

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.


For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

A Day in the Life of an Advocate

I have one of the best jobs in the world. I get to work from home, travel to lots of events, set much of my own schedule, and I work for an amazing, supportive company. I'm incredibly proud of the way Redgate Software has handled this pandemic crisis. From strong leadership, a commitment to employees, the Community Circle, and the very strong work by our Core services team to ensure technology has helped us continue to operate as a business.

We maintain an internal company blog where lots of information is shared by individuals and groups. Each week we compile a list of important posts that are sent to all employees on Friday. It's a way to understand different things that are happening inside the company, since many of us are focused on our own jobs and might not know what others are doing. Recently, I was asked to write a post for the blog on a day in the life of an Advocate. I was happy to tackle it, but included Kathi, Kendra, and Grant as well, since we all share that title, but have very different jobs.

What do we do? For the most part, we do what the title says: we advocate. We advocate among the public for Redgate, and, as Microsoft Data Platform MVPs, we advocate for people to use the Microsoft data platform. At the same time, we advocate for customer needs inside of Redgate, liaising with developers and others to influence what and how they build software. We advocate at Microsoft on behalf of all the customers that want new features and struggle with existing ones.

For all of us, this might be through meetings, presentations, written content, emails, and more. In some sense, we are communicators that move information and knowledge around. All of us have done that throughout our careers, and it's what many of you do as well. In fact, I think some of the most successful technical professionals I know are great communicators. They many have great technical skills, but they also have the ability to communicate well with others.

I saw a famous software developer once recommend that anyone really wanting to be a developer ought to major in a subject like English (or your language of choice) to learn how to analyze writing and communicate your thoughts back to others. Certainly you need technical skills, but most of us really need to learn how to work well with others. A soft skill, but a vitally important one.

That's most of my day as an advocate. Communicating. Hopefully many of you find that I do it well and have learned something, been inspired, or even entertained by my work. I look forward to continuing it for many years.

Steve Jones - SSC Editor

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

  Featured Contents

Changing the Path for the Master Database

Sadan Kumar from

We as DBAs, changing or migrating databases to a new path is important part of admin’s world. This article helps you with the steps involved to move the Critical 'master' database.

Set Statistics Time Examples for Tuning SQL Server Queries

Steve Jones - SSC Editor from

The SQL Server set statistics time statement displays the number of milliseconds to parse, compile, and execute a T-SQL query statement. This set statement is widely used to assess times to implement a query statement. The set statistics time statement reports the CPU time and elapsed time for performance tuning.

From the SQL Server Central Blogs - Dropping a Database Now–#SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I find myself doing...

From the SQL Server Central Blogs - TIL: Backup-DbaDatabase

Kevin3NF from Dallas DBAs

(This post comes from one of our Junior DBAs – @SQLDork) I’m learning how to use dbatools. Today’s command: Backup-DbaDatabase I’m using the 64-bit PowerShell ISE (running as administrator),...


  Question of the Day

Today's question (by Steve Jones - SSC Editor):


What is a measure?

What is an example of a  measure in DAX?

Think you know the answer? Click here, and find out if you are right.



  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

XEvent Events

What is an event in Extended Events (XEvents)?

Answer: A monitoring point of interest in the execution path of a program

Explanation: An event is a point that fires in code. From BOL: "Events are monitoring points of interest in the execution path of a program, such as SQL Server. An event firing carries with it the fact that the point of interest was reached, and state information from the time the event was fired." Ref: SQL Server Extended Events Packages -

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 - Administration
AWS Database Migration Service causing problem - SQL Server as Source - Hello folks, I have a problem using the AWS Database Migration Service for implementing a transactional replication from SQL Server as a source database engine, a help is highly appreciated. The 'safeguardPolicy' connection attribute defaults to 'RELY_ON_SQL_SERVER_REPLICATION_AGENT'. The tools will start mimicking a transaction in the database for preventing the log to be reused and […]
Things need to check - Hi, can anyone please suggest what are things needs to check after windows patching and Sql Server Patching on the server. Eg : Services Running like..
SQL Server 2016 - Administration
Uptime history without Monitoring tool - I could able to view the last restart of sql server using dm_os_sys_info. But checking is there a way to see the history of uptime of sql server something like graph?My understanding is that DMV loses the information after the restart of the server. Also looking to see the CPU resources  likes historical information . […]
Development - SQL Server 2014
SQL Data Flow Tool - Hi SSC, I'm looking for a tool which helps me achieve the following: Understand what happens inside a stored procedure  and in which order Here's a partial example: SET @NoOfRecordsPendingBefore = ( SELECT COUNT(*) FROM RRawData (NOLOCK) WHERE R_Status_ID = @STATUS_REJECTED ) SET @NoOfRecordsInFile = ( SELECT COUNT(*) FROM RRawData (NOLOCK) WHERE R_Status_ID = @STATUS_NOT_PROCESSED […]
SQL 2012 - General
SQl Server Security - Dear All In my company using sqlserver Standard edition.As of now we are only maintain all the client database server client premises.but now company will change the business model.they bring partner base sales model.Here after we are not directly contact with clients. We will sell use base licence to Partner. then partner sell to client. […]
SQL Server 2019 - Administration
Create a new instance SQL server 2019 - Hi, I'm kinda new to setting up MS SQL DB related stuff. I want to create a new DB instance for SQL server 2019. There's already one instance running. I assume  should go with the alternative called "Perform a new installation of SQL Server 2019"? Will this have any effect on the current running instance? […]
SQL 2008 Enterprise to 2019 ¿Enterprise or Standard? - Hello !! First, let me say im not a DBA expert, and im facing a hard decision We have a DB on SQL 2008 Enterprise. Since SQL 2008 is out of support from MS we decided to move to a newer version (2019) My main question is: Is there any performace difference between Standard and […]
SQL Server 2019 - Development
ORDER BY in the OVER clause - I am using the AVG( ) with the OVER clause and within the OVER clause I have a question about ORDER BY.  In the attached Excel file, I have two examples, one on each tab.  Both tabs show table in the FROM clause in teal green (columns A:F).  Also on both tabs, the result of […]
NVarchar field sizes - Hi, In my database I have a table with product information.  The number of records in the table varies from 10.000 to max 50.000.  There are approx. 20 text fields that are defined as NVarchar.  There are no indexes on these fields.  Activities on the table are in most cases less than 1000 times access […]
T-SQL: Pulling Different Data from the Same Table - Hi: The results of the first code below are attached as the file called "Results". Likewise, the results of the second and third code are attached as "Results2" and "Results3", respectively.  The table for both of these codes is FMItem. The first code has a field called IM.  This is equal to the FormulaID field […]
Reporting Services 2008/R2 Administration
Report Builder & RSReportDesigner.config - I installed SQL Server Report Builder 2008 2.0.  When I try to connect to a SharePoint List, I get this error: The selected data extension SHAREPOINTLIST cannot be loaded. Verify that the selected data extension is correctly registered in RSReportDesigner.config, and is installed on the client for local reports and on the report server for […]
How to get at value? - Hello, I want to pluck out the values for "" and "" but could not figure out the right syntax (don't know how to reference "<rd:"). Below is the XML code fragment, followed by the select statement. Any help is appreciated. thank you, beth - - - […]
Integration Services
API call with no wsdl - I have an API call that passes parameters via the query string and then returns either JSON or CSV. I know I can do it with a script transformation as a source but I wanted to use a web services as a source if possible? I have done some research but it seems that a […]
Articles Requested
Allow User to Run Jobs - A common question, but allow a normal (non sysadmin) to run a specific job. I'd like an article that shows 3 jobs in a system. Job 1 - User A can only run this job. User B can run this job Job 2 - User B can this job. Job 3- only the sysadmin can […]
COVID-19 Pandemic
Daily Coping 30 Apr 2020 - Take a minute to remember what really matters to you and why. My thoughts:


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 This newsletter was sent to you because you signed up at
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.


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