SQLServerCentral Newsletter for May 3, 2024 Problems displaying this newsletter? [View online](. [SQL Server Central](
Featured Contents - [Database Dashboards in Azure Data Studio](
- [Managing Failed Pipeline Runs in Azure Data Factory](
- [From the SQL Server Central Blogs - Check your regions people](
- [From the SQL Server Central Blogs - Using Git Pruneâ#SQLNewBlogger](
- [Learn T-SQL Querying]( Question of the Day - [Two Table Hints](
The Voice of the DBA
 The On-Call Load For most of us working in technology, I think we understand that if something is broken we might need to work. Not that we have to, or we need to, but we might need to. Perhaps you feel differently, or your company approaches on-call in another way. If so, let me know today how you deal with staff being on-call. In my career, there are jobs with formal on-call, informal on-call, or even no on-call. In the latter situation, there isn't anyone who is prepared to handle issues outside of normal working hours, but that doesn't mean if management calls you can ignore them. It's that the organization didn't expect issues. I worked in a small company (< 50 people), where we primarily had systems for people who worked in the office, and nothing was running at night (outside of backups). Normally no one knew if there was an issue overnight or on weekends, but I did get called by the owner when he went in one weekend and couldn't receive a fax on our computer system. So I guess I was the emergency-on-call person. In both large and small companies, I've had formal on-call situations where humans or automated systems would know I was assigned as the person to contact for issues. These might be 24-hour periods, weeks, or even a month at a time. In informal situations, usually, there was a list of technical people's contact information and anyone needing help would just pick one and call, often based on who they thought could solve the problem. For most of my career, being on-call hasn't been a large burden. I've been interrupted during some events, dinners, or holidays, but relatively rarely. My wife and I have felt it wasn't too burdensome, especially given compensation and other flexibility. At the same time, there have been some places where on-call is a disruption to my life. Usually, I've tried to leave those positions as quickly as I could, though that might take months. I always ask about on-call responsibilities when I interview for positions. It's not that the answer is a deciding factor, but it is a factor. If on-call is more demanding, I would ask for something in return: perhaps comp time, more salary, or some other flexibility. What is your on-call situation? Is that acceptable to you? Have you never been called outside of working hours? Let me know today. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](
Â
 Featured Contents [SQLServerCentral Article]( [Database Dashboards in Azure Data Studio]( Steve Jones - SSC Editor from SQLServerCentral Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the database dashboards and how you can customize them. The other articles in this series on ADS works [â¦] [External Article]( [Managing Failed Pipeline Runs in Azure Data Factory]( Additional Articles from MSSQLTips.com In this article, we look at how to setup different ways to handle pipeline failures and notifications when working with Azure and Azure Data Factory. [Blog Post]( From the SQL Server Central Blogs - [Check your regions people]( Koen Verbeeck from Koen Verbeeck Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came up. I mentioned an F2 is only around â¬250 a month, but a colleague... [Blog Post]( From the SQL Server Central Blogs - [Using Git Pruneâ#SQLNewBlogger]( Steve Jones - SSC Editor from The Voice of the DBA As Iâve been working with SQL Saturday and managing changes to events, Iâve accumulated a lot of branches. Even though Iâm a solo developer, I decided to use branches,... [Learn T-SQL Querying]( [Learn T-SQL Querying]( Additional Articles from SQLServerCentral Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers   Question of the Day Today's question (by Steve Jones - SSC Editor):  Two Table Hints What happens when I run this code: SELECT p.ProductName
, p.ProductCategory
FROM dbo.Product AS p WITH (NOLOCK, TABLOCK); 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) Post Restore Tasks for the Resource Database I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database? Answer: CU 4 must be reapplied Explanation: Only CU4 needs to be applied. Ref: Backing up and Restoring the Resource Database - [ [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
[Principal owns a service?]( - This is one I haven't seen before. I'm trying to drop a database user and got the below message. The login doesn't own any roles or schemas or other objects and everything I google on the error comes up with "principal owns a schema" which is not what this error is. When I try googling [â¦]
[Degraded Performance in 2017 vs 2008 R2 with inserts]( - We're finally upgrading from SQL Server 2008 R2 Enterprise to SQL Server 2017 Standard and have moved our test database to the new server. Both VMs are on similar hardware with 4 vCPUs. Of course, given the chasm of versions we expected much better performance. Unfortunately, that's not the case. Our inserts on the 2008 [â¦]
SQL Server 2016 - Administration
[User permissions and showplan]( - All, I'm trying to find a way to let some of our users see at least some details of a query plan particularly whether an index is being used. I looked at the set statistics statements because the user only needs permissions to run the query but they only specify tables and not indexes? I [â¦]
SQL Server 2016 - Development and T-SQL
[Slow update on temp table]( - I have a job running each night starting at 4:30AM and usually finishing at around 6:30AM or shortly thereafter doing some number crunching. Occasionally, this job slows down taking much longer...today it ran until about 8:45AM. This statement, normally would take a second or two...the table is about 250,000 rows with 8 columns...today it took [â¦]
SQL Server 2012 - T-SQL
[Insert using table unput]( - I have a table that I need to run off a different server\db and looking for the most efficient way to call from an SP. I need to execute. the field(sqlToExec) as it's loaded with 1000's of Insert statements like below to update this same table on a different server and DB. If something error [â¦]
SQL Server 2019 - Administration
[Table Partitioning - remove null range]( - hi guys,  I have a partitioned table AM_ITM_INSTNC_MSS and I want to get rid of MYDW_TPData2015 filegroup, how can I achieve that?
[Backup of encrypted databases failing]( - I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName' detected an error on page (10:12345) in file 'D:\path\DBName_File.ndf' The databases were originally encrypted on a production server and restored to a DEV environment, which may be relevant. All the databases on the DEV server are encrypted, but only two were [â¦]
SQL Server 2019 - Development
[Create Copy of DB in same server.]( - Hi I want to create a copy of a DB on the same server. The account that creates the copy DB should NOT be able to read from the original DB but have full rights to the copy DB. Cannot use a snapshot, Changes will be made to the copy and the copy will be [â¦]
[Find the problematic Sql Query Caused Application Crash]( - Hi, Is there anyway I can find out the sql script ran on a particular date and which might have causes application down? I mean my application was down on 12 April 2024 and based on investigation it was found some sql query running causing the application down. How I can find out what all [â¦]
[Does it make a sense to update statistics right after tables truncated?]( - Hi all, We have a lengthy process that uses 30 tables, some of them are large. In the beginning we truncate them, then ETL data into them, then massage, perform some calculations, and finally reporting. I am tasked to clean up this process. Right after initial truncation we update statistics on all these tables. Does [â¦]
SQL Azure - Administration
[zero downtime deployments]( - Hello, We have azure MI business critical. active read/write, secondary read /only. from what I see most of the HA is handled behind the scenes using Always ON. We have a 30 min downtime every month during product deloyments but one high profile customer wants 0 downtime. How to achieve that with Azure MI Business [â¦]
Reporting Services
[SSRS Expression IIF Zero then ... Got #Error]( - Hello, Need some help for SSRS. The column % expression is =iif(sum(Fields!ColumnA.Value) = 0 or sum(Fields!ColumnB.Value) = 0,0,sum(Fields!ColumnB.Value) / sum(Fields!ColumnA.Value)) But I am getting #Error if ColumnA is zerro and no error if ColumnA and B had no value. Please advise. Thank you. Â Â
Analysis Services
[Issues backing up Analysis Services databases - silent failures]( - I have a PowerShell script that I use to automate the backup of Analysis Services databases - allows for handling new/dropped databases, dynamic filenames, etc. However, on some occasions the backup fails but no output is reported stating why. I get a success message when it works but nothing when it fails. I've tried adding [â¦]
Strategies and Ideas
[Do I need a recursive query for this? bill of materials (sort of)]( - I am working on a data warehouse project for a bakery. For the most part, the basic structure is like this: Purchase--(M,1)--Ingredient--(1,M)--Recipe--(M,1)--Product with one exception the "Recipe" part works fine. (IngredientKey, ProductKey, Weight). The part I'm having trouble with is that one ingredient (starter) consists of other ingredients (kinda like a subassembly, if you wanted [â¦]
[Do I need a recursive query for this? bill of materials (sort of)]( - I am working on a data warehouse project for a bakery. For the most part, the basic structure is like this: Purchase--(M,1)--Ingredient--(1,M)--Recipe--(M,1)--Product with one exception the "Recipe" part works fine. (IngredientKey, ProductKey, Weight). The part I'm having trouble with is that one ingredient (starter) consists of other ingredients (kinda like a subassembly, if you wanted [â¦]
  [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -