Newsletter Subject

Database Dashboards in Azure Data Studio (2024-05-03)

From

sqlservercentral.com

Email Address

subscriptions@sqlservercentral.com

Sent On

Fri, May 3, 2024 08:00 AM

Email Preheader Text

SQLServerCentral Newsletter for May 3, 2024 Problems displaying this newsletter? . Featured Contents

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

Marketing emails from sqlservercentral.com

View More
Sent On

11/11/2024

Sent On

28/10/2024

Sent On

16/10/2024

Sent On

09/10/2024

Sent On

07/10/2024

Sent On

05/10/2024

Email Content Statistics

Subscribe Now

Subject Line Length

Data shows that subject lines with 6 to 10 words generated 21 percent higher open rate.

Subscribe Now

Average in this category

Subscribe Now

Number of Words

The more words in the content, the more time the user will need to spend reading. Get straight to the point with catchy short phrases and interesting photos and graphics.

Subscribe Now

Average in this category

Subscribe Now

Number of Images

More images or large images might cause the email to load slower. Aim for a balance of words and images.

Subscribe Now

Average in this category

Subscribe Now

Time to Read

Longer reading time requires more attention and patience from users. Aim for short phrases and catchy keywords.

Subscribe Now

Average in this category

Subscribe Now

Predicted open rate

Subscribe Now

Spam Score

Spam score is determined by a large number of checks performed on the content of the email. For the best delivery results, it is advised to lower your spam score as much as possible.

Subscribe Now

Flesch reading score

Flesch reading score measures how complex a text is. The lower the score, the more difficult the text is to read. The Flesch readability score uses the average length of your sentences (measured by the number of words) and the average number of syllables per word in an equation to calculate the reading ease. Text with a very high Flesch reading ease score (about 100) is straightforward and easy to read, with short sentences and no words of more than two syllables. Usually, a reading ease score of 60-70 is considered acceptable/normal for web copy.

Subscribe Now

Technologies

What powers this email? Every email we receive is parsed to determine the sending ESP and any additional email technologies used.

Subscribe Now

Email Size (not include images)

Font Used

No. Font Name
Subscribe Now

Copyright © 2019–2025 SimilarMail.