Redistributing Data Across Files (2021-02-19)

 SQLServerCentral Newsletter for February 19, 2021 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Redistributing Data Across Files]( - [Dynamically Generate Replication Tasks with Biml and Custom Connectors]( - [Mastering TempDB: The basics]( - [From the SQL Server Central Blogs - Data Mesh defined]( - [From the SQL Server Central Blogs - Learning A Little Oracle]( Question of the Day - [Setting Git flags for all repos]( The Voice of the DBA  Daily Coping Tip Stop and look at something in a new way today 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. Coding Tips I really like Visual Studio Code. The more I use it, the more I get comfortable in it, and the more I appreciate the design and flow of using the editor. I didn't feel that way early on, preferring the comfort of Visual Studio, but now I most often use VS Code. The other day I saw an article from one of the PMs for the product, with [a number of tips and tricks](. I like some of these, and have already found a few to be handy in my work. I've even started to search out a few more of these, and found [this repo with items in it](. This reminds me of a few articles at SQLServerCentral on SSMS ([tips](, [tricks](). I've written a bit on [Azure Data Studio]( and [git](, often to help cement some skills in my mind, as much as to help you learn more. I'm sure many of you have your own tips and tricks today, for both data platform tools and others, so I'm asking you to share a few in the comments. If you have a large collection of tips, on tools or just how to write code, [write us an article](. I'm sure others would love to know how to be more productive. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Redistributing Data Across Files]( Steve Jones - SSC Editor from SQLServerCentral When adding files to a filegroup, SQL Server doesn't automatically balance the data across the files immediately. See how this works and how you can speed this up. [Dynamically Generate Replication Tasks with Biml and Custom Connectors]( jerodj from SQLServerCentral.com This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS. [Mastering TempDB: The basics]( Additional Articles from SimpleTalk Mastering TempDB is a critical skills for SQL Server DBAs. In this article, Monica Rathbun explains the basics of TempDB including configuration. From the SQL Server Central Blogs - [Data Mesh defined]( James Serra from James Serra's Blog The two latest competitors in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of... From the SQL Server Central Blogs - [Learning A Little Oracle]( Grant Fritchey from The Scary DBA As part of my job, I’ve been tasked with doing some of my work in Oracle, so I’m learning Oracle. Allow me to share a little of my pain...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Setting Git flags for all repos What should I add to "git config" to ensure a change takes effect for all repos? 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) Accelerated Data Recovery Editions In SQL Server 2019, which editions can use Accelerated Database Recovery? Answer: Enterprise, Standard, and Web only Explanation: This is available in Enterprise, Standard, and Web, but not Express. Ref: Features and Editions of SQL Server 2019 - [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 [Extended events query plan]( - All, Firstly apologises as I'm sure I'm missing the obvious but I've searched and I can't work it out. I have setup extended events and included both the plan_handle and query_hash actions. I'm retrieving the results with the following: set dateformat dmy SELECT n.value('(action[@name="query_hash"]/value)[1]', 'nvarchar(128)') as query_hash, n.value('(action[@name="plan_handle"]/value)[1]', 'nvarchar(max)') as plan_handle from ( select cast(event_data […] SQL Server 2017 - Development [Error number 2812 Store procedure not found]( - Hi Expert,  Have migrated database 'northwind' from Server A to Server B Server A Configuratioun- ms sql server 2012 developer edition 64 bit windows nt 6.1 build 9200 Server b configuration -ms sql server 2012 standard edition 64 bit windownt 6.2 service pack 1 hypervisor I am able to run the store procedure on […] SQL Server 2016 - Administration [Migrate from AWS SQL Server RDS to EC2]( - Hello, I could not find any documentation on how to migrate SQL server RDS to an EC2 instance. I have a requirement to migrate a large DB to ec2. Can anyone help me with the steps to migrate the DB with low downtime, please? Thanks in advance [Dynamic Data Masking and Adhoc queries.]( - This is the first time we are implementing this, Data Masking that became available in SQL Server 2016. I am not sure that this is a best Data Masking solution though. Because documentation says that a non-privileged user can run an ad-hoc query, using some functions like CAST, and data becomes visible. Is my understanding […] [Availability Group Help]( - I had something occur with my availability groups that has me concerned. My primary failed on me, due to the inclement weather and ice storms, the ISP lost connectivity and will be down for some time. But my secondary didn't failover and handle the traffic. Instead, I found it in "Recovering Mode" and when I […] SQL Server 2016 - Development and T-SQL [Question related to architecture]( - Hello Fellow DBA friends, Currently I am working on a project where a system has to be migrated to our system. I just want to know whether I should go with creating a new DB schema for its objects in current database or should I create a new database altogether ? What are the specific […] [Preventing duplicate execution plans]( - Hi all, Our application has some parameterised dynamic SQL that looks like this; SET NOCOUNT ON; DECLARE @HOST VARCHAR(500); SELECT SOME, STUFF FROM MYTABLE WHERE MAINHOST = @HOST OR BACKUPHOST = @HOST When I look at the execution plan cache it is caching an execution plan every time this is executed because it is defining […] Administration - SQL Server 2014 [Who modified my Database?]( - Hi, we have an issue where entire cubes are sometimes deleted from our SSAS database. I am assuming a human has done this, but I cant find any way of determining who did it or when it has happened. Does anyone know where (if at all) Database schema modifications would be logged? Thanks! SQL 2012 - General [How to get PartId from table #trades where it have parts that have only map from]( - I work on SQL server 2012 I have issue I can't get Part Id  that have only map code type from and code value from and not have map code type to and code value to depend on table #map ? every part id must be found on table trades two times first row for same part […] SQL Server 2019 - Administration [Subscription owner and multiple subscriptions]( - We are using reporting service 2019 Enterprise. There is an issue with running the subscription the other people created. For example two user are both content manager role. And the first user created the subscription, and she becomes the owner of the subscription automatically. She runs the report with no problem. But when the second […] [SQL Server Standard Edition]( - Hi All Hi have a problem and need help I am out of ideas on this one. I am managing my company's Production SQL Server, there are 30 Databases I need to maintain. Specs of the server: Windows Server my TEMPDB does not want to release the unallocated space and it's getting to a […] SQL Server 2019 - Development [Vague job scheduler support for SQL Server on Linux]( - I’m having some trouble figuring out the kind of support for Linux that the SQL Server 2019 job scheduler has. It’s clear that the job scheduling procedure API, and SQL Server Agent have both been ported to Linux and appear to work. But there are a limited number of kinds of job steps supported. These “kinds” of […] [SQL query to find last date a product was checked before it was installed]( - I have two tables, one covers jobs for a product and the other covers the last time a product was checked over and by who. What I am trying to do is get the most last date the product was checked before it was installed. There is no set time period that the check could […] CLR Integration and Programming. [Problem programming with clr]( - I have created a project in visuall C ++ version 2008 of clr type called calculat and I have a text box and a button in the form. When I click on the button, its click event is activated in the form1.h file and I want to This event calls a function called compare that […] The Future of Community [We need to move beyond SQL Server...]( - I think we should have a discussion about topic. First, the future is more data. SQL Server is just one place it is put. We need reflect the needs of our customers and prospective clients. How do we get there? We do SQL Server now and add others annually. Postgres, MySQL, Oracle and Vertica have […]   [RSS Feed]([Twitter]( 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 webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -