Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (2023-12-6)

SQLServerCentral Newsletter for December 6, 2023 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)]( - [Cardinality Estimation Feedback in SQL Server 2022]( - [Plansplaining, part 20. SQL Graph (part 1)]( - [From the SQL Server Central Blogs - Databricks Unity Catalog primary key and foreign key constraints are not enforced]( - [From the SQL Server Central Blogs - “Surviving the Digital Heatwave: Lessons Learned from Singapore’s Datacenter Meltdown”]( - [Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen]( Question of the Day - [A Partial Count]( The Voice of the DBA  The Stagnant Career Do you feel stagnant in your career? Or maybe the better question is do you care if you feel stagnant in your career? You might need to define what that means to you, as what might feel stagnant to one person could be comfortable to another. Apparently, there was [a study of tech professionals]( who despite a tight labor market, are citing lack of salary increases and dim promotion prospects as reasons to leave their jobs. The survey was across a number of larger technology companies, and likely answered by more talented employees. After all, good talent can usually find jobs and is less worried about leaving. Less talented people usually cling to their jobs. A lack of salary increase could be a problem. Everyone, or most everyone, wants regular raises. However, depending on where your salary bracket is and your living expenses, you might not rate this as a very important criterion for sticking with a job. Someone making USD$40,000 might be more concerned about a raise every year than someone making USD$200,000, but perhaps not. Having a career progression was more important to me at 30 than it is after 50. Again, the varies among people, but I find a lot of people like their jobs and don't really want to change. Many of them would likely be happy to keep working at their level as long as they can get raises. I see people complaining about their current position when they've bumped up against a salary limit for that position, but otherwise, they're satisfied. The work matters. I do think there are plenty of people who are unhappy with the work they do and want to be challenged, or at least interested, in the work. At the same time, lots of people are happy to just do a minimal variety of work day after day. I think this is why I encounter lots of people who seem to have 4-6 months of experience repeated 10+ times. My view is that you ought to make your career what you want, and that means actively managing it. Spend time thinking about what you want, ask others about their work, and make plans to move in the direction that matters to you. Implement those plans and find a balance between advancing your skills and living your life. It's easy to do too much of one or the other, but often that's not the problem, it's the motivation and effort to actually improve yourself. I can't tell you how to structure you career or what to learn or what to improve. You have to decide what is interesting to you and what fits in your life, and then make an effort to move in that direction. Sharpen your saw, improve your craft, and learn those soft skills that help you work with others. That's how you find the career you want, which will never be stagnant. Note: We do have a [career forum]( on SQL Server Central. If you want advice or have questions, post something and I (or someone) is happy to answer. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents [Stairway to Database DevOps]( [Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)]( Erin Dempster from SQLServerCentral The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […] [Technical Article]( [Cardinality Estimation Feedback in SQL Server 2022]( Additional Articles from MSDN Communities Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptions—known as the model. [Technical Article]( [Plansplaining, part 20. SQL Graph (part 1)]( Additional Articles from SQLServerFast Welcome to part twenty of the plansplaining series. It has been a long time since I last wrote a plansplaining post, partly because of my health, but also for a large part because I was out of ideas. But recently I decided to dig a bit deeper into a feature that was released in SQL Server 2017 and that I had so far not played with: SQL Graph. [Blog Post]( From the SQL Server Central Blogs - [Databricks Unity Catalog primary key and foreign key constraints are not enforced]( Meagan Longoria from Data Savvy I’ve been building lakehouses using Databricks Unity catalog for a couple of clients. Overall, I like the technology, but there are a few things to get used to. This... [Blog Post]( From the SQL Server Central Blogs - [“Surviving the Digital Heatwave: Lessons Learned from Singapore’s Datacenter Meltdown”]( david.bermingham from Clustering for Mere Mortals Today, we’re unpacking a real-world tech drama that unfolded in Singapore, offering a stark reminder about the vital role of Disaster Recovery (DR) planning and the often overlooked, yet... [Transact-SQL: The Building Blocks to SQL Server Programming eBook by Gregory A. Larsen]( [Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen]( Greg Larsen from SQLServerCentral Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written by SQL Server Central and Simple Talk author Greg Larsen, will give developers an understanding of the basics of the TSQL language. Programmers will have the building blocks necessary to quickly and easily build applications that use SQL Server.   Question of the Day Today's question (by Steve Jones - SSC Editor):  A Partial Count I run this code in a SQL Server 2022 version of AdventureWorks: SELECT COUNT(*) FROM Sales.Customer I get 19280 as the result. What happens when I run this? SELECT COUNT(*) FROM Sales.Customer TABLESAMPLE SYSTEM(10 PERCENT); 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) Zero Statistics Sampling What happens when I use this code on SQL Server 2022? CREATE STATISTICS stat_employee_empname ON dbo.Employee (EmpName) WITH SAMPLE 0 PERCENT; Answer: The statistics object is created, but contain no data Explanation: This is not recommended, even though this is valid syntax as the statistics object is created but contains no data. Ref: CREATE STATISTICS - [ [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 - Development [Slicing status based on conditions]( - Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points (for customers where to collect packages) . I want to flag the package That weren't collected by customers for each a relay point. To identify a left package (not collected by customer) the status need to be ("Dropoff" or "preparation") ***OR […] SQL Server 2016 - Administration [broker error]( - Hello, I install a broker under sql server 2016 and I have a message that I never recognized. In transmission_status : "24(The program issued an incorrect length command.)" The message of 25490 characters long has not been sent. Thank you in advance for any help. Administration - SQL Server 2014 [Suggestion on HA DR solution for transactional replication published database]( - Hi All, I am planning for HA DR solution for transactional replication published database. (Not for distribution DB). It is in SQL 2014 standard edition and having 4 subscriber for only one database, I am planning to have either log shipping or DB mirroring into another server. Can anyone suggest which is best to for […] SQL Server 2019 - Administration [Large number of Memory Ring buffers]( - Hi Friends, As part of collecting different stats from the SQL servers I have been asked to manage recently, I found the memory ring buffers on a server just crossed a million rows. Though I didnt get any complaints from the users, I would be glad if you can comment on this and indicate if […] SQL Server 2019 - Development [AI Tools]( - Not quite sure where to post this or how quite to ask as its early stage I am looking for two type of AI tool A tool to go through data and check accuracy/ confidence levels very simple example( millions of records ) a customer table with Company name , addresses, postcodes etc a separete […] [Openrowset & removing unwanted characters...]( - Folks I'm wondering can you help me here. I have inherited a system that populates a table from Excel using the OPENROWSET command. The table in question is called: tbl_raw_data and then the loaded data is moved on elsewhere... The excel speasheet can and does change column names and number of rows over time. The […] [Script all logins, permissions, roles]( - I found this older script by Greg Ryan in 2013 to script out all the logins, permissions, roles. however, i didn't see the role permissions. Please could some T-SQL guru help me to include the role permissions in this script as well. Truly appreciate your help. /**************************************************************** This Script Generates A script to Create all […] SQL Server 2008 - General [Reduction of installation time of sql server 2008 R2 Express]( - The installation of SQL Server 2008 R2 Express on a virtual machine takes around 12-15 minutes, whereas on a regular PC, it takes around 5-6 minutes. Are there any options to reduce the installation time ? The following approaches have been attempted: Via command line: SQLEXPR_x64_ENU /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /QS /FEATURES=SQLENGINE /INSTANCENAME=PMP /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /AddCurrentUserAsSQLAdmin /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" […] SQL Azure - Administration [SQL MI - SQL Jobs failing with User Manager\ContainerAdministrator.]( - This is strange, any SQL job that sends out Emails via 'msdb.dbo.sp_send_dbmail ' are failing with this weird execution user. Executed as user: User Manager\ContainerAdministrator. Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE 42000] (Error 22050). The step failed. It doesn't matter if I change the SQL Owner to 'SA', to a AAD […] Strategies and Ideas [data security for a data warehouse]( - I'm working with someone whose client says "Yes, we have a data warehouse. But NO you can't be granted access to it." Technically, can you not create one or more schemas and add views to the schema ( and the other necessary required objects ) so that the outsiders are granted some but not full […] Integration Services [PowerQuery in SSIS... is it only in 2023?]( - First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source, and it's flat out not there in VS 2022 (yes, I have the rest of SSIS installed). is it only in 2023? is there a good rank beginner article on getting started with it somewhere? I saw one, but I wanted […] General [Review of DB Activity]( - Hi Folks,  I have been tasked with reviewing all the activity on a SQL Server 2000 - Version 8.00.2666 (SP4) I have monitored DB's before and via execution of Master DB stored procs, watching activity and so on, however never really when in to this depth of attempting to find out all the activity […] SQL Server 2022 - Administration [Logging SQLExceptions]( - We have a web front-end which I believe in some cases is throwing unhandled SQLExceptions, like Conversion errors, or Foreign key constraint errors, etc. I realize the best approach is probably for the developers to place their code in TRY/CATCH to handle these errors, but in the meantime, I was wondering if there is anything […] [Dropping a Service from Service Broker crashes server]( - I'm having an issue trying to drop a service. When I issue the drop command, the process runs for multiple hours and then the server dies with the following silent scream (any ideas would be appreciated) This does the same thing on 2 different 2022 CU10 SQL Servers on copies of the same database: 11/27/2023 […] SQL Server 2022 - Development [sp_dropserver - Bug/behavior change - Leaves transaction open after TRY...CATCH]( - Verified on latest CU 10 for SQL 2022. Confirmed works correctly on SQL 2019 (i.e. no open transaction). When it cannot drop server because it is used in replication, the transaction count goes from 0 to 1 after the CATCH. This causes stored procedures with this code to fail, since the transaction count is unexpected. […]   [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -