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

Daily Coping Tip

Go for a walk to clear your head when you feel overwhelmed

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 Dedicated Space

Years ago I had a friend that was starting a consulting business. This person had worked for various organizations over the years and was ready to run a solo business. The city where this person resided was somewhat expensive, so they decided to convert a garden shed into an office space. They followed a similar process to this one, adding some interior finishing and electricity.

This individual struggled to work alone in this space, after years of working in offices. While it provided separation from children and other home distractions, it was hard to get used to working alone the majority of the time. Eventually the moved their office back into the house.

I was reminded of this when I saw a tweet from David Perell, noting that a good business model might be building recyclable, transportable offices. This pandemic has changed the way many people work, and while some have offices, I've had many of my colleagues working in bedrooms, dining rooms, and even in part of a kitchen area.

The way we work has changed for much of the technology world and plenty of us have adapted well. People that hated being stuck at home with distractions are growing used to the idea, though I suspect that not having a permanent space of your own is likely growing old. I wonder how many people would like a shed like structure in their yard or garden, with about 100sq ft/9sq m of personal room for your desk and whatever you need for your job. There are some really small, neat designs with lots of windows, porches, even fancy designs. Interiors can be simple or designed just for you.

Would any of you want to give up a little garden space to get a private office? With the changing world, and the chance that you might work at home for a long time, perhaps some of you would like a private space that's just your own, perhaps even one that you could take with you if you moved to a new residence. Or maybe one that you can take to a shared space in a town. I could even see pods like this in an office park. Instead of a shared office space, maybe there would be outdoor pods near each other, where we can work near each other, but still in a safe, private way when we need to do so. Perhaps this is the next evolution of BYOD, as a Bring-Your-Own-Office.

Steve Jones - SSC Editor

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

 Featured Contents

Loading data in Azure Synapse Analytics using Azure Data Factory

Sucharita Das from SQLServerCentral

This article shows a basic Azure Data Factory pipeline to load data into Azure Synapse.

Getting Started with GitFlow

Additional Articles from SimpleTalk

In this article, Diogo Souza explains GitFlow, a branching model for Git. He demonstrates how to work with GitFlow to create and deploy a feature and a hotfix to GitHub.

Power BI Incremental Refresh for SQL Sources

Additional Articles from SQLServerCentral

In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.

From the SQL Server Central Blogs - Database Fundamentals #27: Creating a Primary Key in the Table Designer

Grant Fritchey from The Scary DBA

Defining primary keys is the hardest part of the operation. You will need to work very closely with the business in order to define exactly what column or columns...

From the SQL Server Central Blogs - Getting a List of Tags from the Microsoft Container Registry–#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. I needed to write this post because I...


 Question of the Day

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


Restoring Different Sizes

I have a large database (1TB) with one MDF file on SQL Server 2019. I want to restore a backup of this to a new instance, but I don't have 1TB of space. The database only uses 300GB, and that is roughly the size of the backup file. Can I restore this backup and change the file size during the process?

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)

Logging Event Permissions

I want to allow a user to use the xp_logevent procedure to log messages in the log for various events from an application. What rights do I need to give this user to do this?

Answer: The user needs to be a db_owner in master or a member of the sysadmin role

Explanation: The documentation notes that users need to be db_owner in master or a sysadmin. This is true by default, though you can explicitly grant rights to this stored procedure to users. Ref: xp_logevent -

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
The transaction log for database 'mydb' is full due to 'LOG_BACKUP' - I got an alert The transaction log for database 'mydb' is full due to 'LOG_BACKUP', it fills the log. And I checked the database is 32 GB, and set to grow 64 mg for data file and log file. Unlimited growth. I also do transaction log backup every 3 hours. and I see them successful. […]
What do you like for third party database backup/restore for SQL server & Azure - Hi all, my company currently uses SQL server native tools to perform nightly backups.    We are a small company and unfortunately do not have an actual DBA - our network admin and group of developers are working together on the backups.   But we are looking into other vendors, such as RedGate's SQLBackupPro, Idera's SQL […]
Disk space - I noticed the system volume information is consuming the disk space on database server log drive. Also found that shadow copy is disabled but maximum size is not configured to use limit. My understanding is that during the setup of server someone would have not configured properly to use limit. Do you agree with me? […]
SQL Server 2017 - Development
MDS multiple domain based attributes for one member - Hi SSC, I wonder if I can select multiple domain based attributes for one member record and if so, How would I do that? We have a SharePoint list which we would like to replace by MDS, the only issue I see right now is that there are multiple checkboxes for the same "which of […]
Find the last occurrence of \ character and get the left of string. - How to find the last occurrence of '\' in the following  string  and get left  part of it? DECLARE @V  VARCHAR(max)='O:\Z\P_Metrics\Inbox\07-13-20200702_abc_enroll.csv' DECLARE @V1  VARCHAR(max)='O:\Z\P_Metrics\Inbox\07-14-20200702_abc_complete_enroll.csv' The  Final output I need is O:\Z\P_Metrics\Inbox. Thanks in advance.
Creating a Dimension with no Primary Key - Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and SSAS.  The cubes were originally constructed in SQL 2000.  It's been going well so far until I try to recreate a "Calculated Time" dimension that worked so well in the old build.  The dimension table was linked to the fact table […]
SQL Server 2016 - Development and T-SQL
more effecient query - hi I have a simple query that needs better performance.  I have added primary key into the temp table which helped, but here is the root of the problem below..  There has to be a cleaner and more efficient way to write this,  any thoughts? Thanks INSERT INTO [dbo].[WeeklySalesReportTempTable] ([Location Code] ,[Profit2YrsAgo] ,[ProfitLastYear] ,[ProfitLYMTD] ,[ProfitMTD] […]
Code signing a dll with certificate for use in SQL Server 2016 - I have a dll that will perform some webservice calls function. in order to use in SQLServer 2016 i would like to create a user called sqlex from a certificate. When I try to do this I get the below error: USE [master] GO /****** Object: Login [sqlRext] Script Date: 10/07/2020 12:06:30 ******/ CREATE LOGIN […]
Administration - SQL Server 2014
Do changes User Defined Data Types get replicated by default in Tx Replication? - Just as the title says. I have a database that heavily uses UDDT's. We replicate it to a RDB for business intelligence, etc. We recently had a schema change that increased the length of a VARCHAR UDDT from 30 to 60. During deployment, we dropped the publication containing that article, applied the dacpac, and recreated […]
Logshipping - i configured logshipping b/w two servers , when i checked the file location of secondary database , showing the primary  databse file location  , drives are not identical in both the servers. what is the reason for this  or any issues?
SQL Server 2019 - Administration
Oracle linked server mixing up result values - Hi all, I am having a very strange issue with Oracle linked servers. The linked server is created based on the Oracle Ole DB provider. I can reproduce this issue on any SQL server instance. Whenever I retrieve somewhere around 500-600+ rows and large binary data is included the returned rows are mixed up: meaning […]
SQL Server 2019 - Development
Execute SSIS generates error "create_execution has too many arguments specified. - We recently upgraded our Dev server to SQL 2019.  Since upgrading, whenever we run an SSIS package from the catalog we get an error "Msg 8144, Level 16, State 2, Procedure SSISDB.catalog.create_execution, Line 0 [Batch Start Line 0] Procedure or function create_execution has too many arguments specified." I scripted out the execution in our 2019 […]
SPMail Not Working For All Users - Hello~ I'm sure there's a very simple solution, but it seems to be eluding me -- I have a db application (MS Access Front End/Azure SQL Back End) -- I have triggers written on certain tables (for example, if an error occurs, a record is added to an error log table)  that send an email […]
Integration Services
Help needed in getting all AD users and groups - I have very limited knowledge with server management. I need to extract AD users and groups. Specifically, all AD users and groups. Questions I have: if this is going to be done through PowerShell, does the script need to run on the DC server? what privileges do I need to run the script? How will […]
How to analyze massive OLTP databases - I've just started a job and I'm responsible for administrating (will define later) a few massive OLTP databases. These are not direct transactional systems, but they are published directly by the main OLTP system (so they mirror the production tables). I am responsible for these tables. Precisely I need to accomplish the following: 1- Create […]


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.


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