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

Daily Coping Tip

For the next 10 seconds, think of two people you know, and think to yourself "I wish for that person to be happy."

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.

The Backlog

Software development is complex these days. Maybe it's always been complex, but the shorter timelines and vision of what is currently happening mean that a lot is going on at any particular time. Really, once you get beyond a handful of developers, the changes look like a chaotic ballet that may (or may not) keep in sync. Modern work tracking tools make this easier, and for any particular developer, it isn't too hard to look at a Kanban board linked to a git repository and track the chances that have taken place.

There is always more work to tackle than can be done at the current moment, so it is important to add new tasks to a backlog. Building those, and tracking what is needed, is a bit of an art. What do you write down, how much detail, and what level of effort is needed. Paul Andrew wrote a good post on what makes a good backlog story, using an example from his work. He looks at the need for infrastructure in this case, but that would be a common request these days when DevOps and the cloud require some blurring of the line between code and the resources it runs on.

I like the completeness of this request, and I do think this level of detail is important, with the inclusion of criteria to measure the work and test that it is done. I just don't know if this is required when we add the work to a backlog. The rapid changes in our software, as we adapt and work with customers' feedback, mean that we might get many more ideas (or issues) than we ever build. In fact, some requests/suggestions/desires that get sent to developers or project managers might be no longer needed or forgotten by the time they reach the coding stage. I know I've certainly requested some features at SQL Server Central that I later decide aren't important or needed.

My view is that ideas ought to be captured, triage ought to include enough detail to estimate how important and hard the work may be. Once we get to the point of actually performing work, then we need to flesh out details on what constitutes done and what tests can verify this. For very small levels of work, this might be just a few light tests, but even noting that a new column is in a table and associated stored procedures can help developers remember to check for dependencies and avoid simple mistakes.

Building software and managing the process across a team and over time is hard. It is easy to lose control, and it can be hard to make decisions about what to build and what to defer. A backlog is critical, and managing that backlog with regular review and attention to detail is important. However, just as we don't necessarily want to prematurely optimize code, I also don't know that we need to build out the complete story when someone has a request. Grow your stories as you grow you code with an agile approach over time.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

SSIS Environment Design Patterns

Kunal Rathi from SQLServerCentral

In this article, we will see 3 SSIS design patterns that we can use to set up SSIS configurations and deployments.

External Article

Registration is now open for Summit 2022

Additional Articles from Redgate

Now’s the time to save your seat at the world’s largest hybrid conference for data platform professionals, taking place November 15-18! Join attendees from around the globe who are gathering in-person and online for a full week of world-class training, networking, and data-platform focused events. Register today to take advantage of discounted launch pricing, available for a limited time.

Technical Article

Mental Health and Wellness Day 2022

Steve Jones - SSC Editor from SQLServerCentral

Our annual mental health and wellness day is slated to happen on 8th April 2022. We have a fantastic lineup,schedule as below. For more details on speakers and sessions refer to our blog post here.

External Article

Ordering a result set in SQL Server

Additional Articles from SimpleTalk

To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY.

Blog Post

From the SQL Server Central Blogs - The Summit is Back in Person

Steve Jones - SSC Editor from The Voice of the DBA

Registration for the Data Community Summit opens today! You can sign up and come to Seattle in November with all the other data platform pros that you’ve missed seeing...

Blog Post

From the SQL Server Central Blogs - Quick Tip: Remove CONVERTCAST from your WHEREJOIN clauses

SQLEspresso from SQLEspresso

Quick Tip Remove CONVERT/CAST from your WHERE clauses and JOINS when comparing to variables of different data types. Set their data types to match your table definitions before using...

 

 Question of the Day

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

 

Synapse Serverless

How many serverless SQL pools can you have in an Azure Synapse Workspace?

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)

Migration Help

Which of these tools is used to help assess a workload against a specific version of SQL Server?

Answer: Data Experimentation Assistant

Explanation: The Database Experimentation Assistant will help with assessing a workload on a specific version of SQL Server. Ref: Database Experimentation Assistant - https://docs.microsoft.com/en-us/sql/dea/database-experimentation-assistant-overview?view=sql-server-ver15

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
Measuring Ad-hoc workload on a per database level - Ok so I need to see how much workload on a server (per database)  is ad-hoc. Gut feel its high for one db in particular . is the following a valid way to determine this or is there a better approach ? SELECT Convert(INT,Sum ( CASE a.objtype WHEN 'Adhoc' THEN 1 ELSE 0 END) * […]
SQL Server 2016 - Development and T-SQL
Where Can I Download Install Media for SQL Server 2016? - This seems like a simple thing but I've been unsuccessful in my search thus far and figured I'd check if anyone here knows right off where I should go for this; Where can I download install media for SQL Server 2016? I've got an existing installation at work I need to add reporting services to […]
syntax error get data from linked server - This query runs but doesn't get any info. I think it's something in the syntax, but can't find the issue. If I query a table using Linked Server I can see the data I need. DECLARE @SQL VARCHAR(MAX) = '' ; SELECT @SQL += REPLACE(REPLACE(' RAISERROR("-----------------------------------",0,0) WITH NOWAIT; RAISERROR("Processing <>",0,0) WITH NOWAIT; INSERT INTO BC_Data_Capture_Staging […]
Extracting the clientapp for the victim of a deadlock report - Given a deadlock report, I need to extract the clientapp that was the victim process. The query I've written works and is below: DECLARE @path [nvarchar](MAX) SELECT TOP 1 @path = REPLACE([path] + '\system_health*.xel', '\\', '\') FROM [sys].[dm_os_server_diagnostics_log_configurations] WHERE [is_enabled] = 1 DECLARE @data TABLE ([deadlock] , [exec_time] [datetime]) INSERT INTO @data SELECT CONVERT(XML, [event_data]).query('/event/data/value/child::*') […]
Administration - SQL Server 2014
SQL Server Management 2014 Windows 10 - Hey guys I have an installation for SQL Server Management 2014 (SQLEXPRADV_x64_ENU.exe is the full name) which I used for Windows 8.1. I installed Windows 10 recently and tried to use the same installation but the rules fail where I don't have Microsoft .NET Framework 3.5 Service Pack 1. I can't find an installation for […]
Development - SQL Server 2014
I need to convert column warehouse to Wh1 and Wh2 with the corresponding on hand - I need to convert column warehouse to Wh1 and Wh2 with the corresponding on hand   select DATENAME(dw,ompRequestedShipDate) as day , omlPartID as Part , sum(omlOrderQuantity) as ordered , case when imbWarehouseID ='' then 'WH1' else imbWarehouseID end as warehouse , cast(imbQuantityOnHand as INT) as onhand from SalesOrders left outer join SalesOrderLines on omlSalesOrderID=ompSalesOrderID left […]
SQL Server 2019 - Administration
Bringing Data from SQL Server to AWS automatically - We have a requirement where we want to bring data present in SQL Server to AWS - SQL Server (i.e. AWS RDS). At present the data is present in on-prem SQL Server and on 1st of every month, the data is then transferred from SQL server to excel sheet. The excel sheet contains 7 different […]
Windows 11 Pro - Hi everyone I just got a new machine.  It is running Windows 11 Pro.  I am trying to install SS2019 but I am coming across issues.  I am getting below error: "Oops... A required file could not be downloaded. This could mean the version of the installer is no longer supported. Please download again from […]
SQL Server 2019 - Development
Performance related issue after using left join to bring new fields to the query -   i have stored procedure which was running fantastic. When ran with parameters it gives results in 25 seconds. I needed to bring new fields to the query used left join SELECT AccountNumber , payment_date ,Account_date FROM CORE.AccountData(NOlock) WHERE Prop_TYPE NOT LIKE '%Rond%' AND (CASE WHEN CAST([CreatedDate] AS Date) < CAST([ProposalDate] AS Date) THEN CAST([CreatedDate] […]
Create constraint using index - Is there a way in T-SQL to use an existing index as source for a constraint? Goal: Have a constraint with an included column In Oracle it is possible with "using index" CREATE TABLE MYTEST ( ID number(1,0) not null ,ID2 number(1,0) not null ) ; CREATE INDEX IX_ID2 ON MYTEST (ID2,ID); ALTER TABLE MYTEST […]
Trying to re-id a database table and getting error on the first select keyword - I have a small table ( < 1000 lines). I deleted the first entry ID 1 as it was invalid. I know it is not necessary to Re-ID it, however I want the first entry to be ID 1 not ID 2. I tried the following script; CREATE TABLE Codelines_backup AS SELECT ID, Rail_Road, NCS_Codeline, […]
SQL Server 2008 - General
How to get the Parameters of a Parameterized Query from dm_exec_sql_text - SELECT sqltext.TEXT FROM sys.dm_exec_query_stats AS CP CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext I ran the said sql statement and get some sql scripts and the following is one of them (@P1 nvarchar(10), @P2 nvarchar(20)) select * from purchline where purchid = @p1 and vendorcode= @p2 I tried to join with dm_exec_query_plan to get the values for […]
Amazon AWS and other cloud vendors
AWS S3 with video editing? - I'm looking for a solution where I can add the cloud storage as a shared network drive or folder on my PC and then directly edit heavy videos from the cloud via my connection. I have a 10 Gigabit internet connection and all the hardware to support that amount of load. However it seems like […]
General Cloud Computing Questions
Aws reporting question - Looking for an idea / workflow to automate reporting for system manager nodes . I know I can get a list of nodes and also get a list of running ec2 instances but what I want is to get a list of the running instances rhat are NOT showing up as managed nodes (so ec2 […]
Azure Machine Learning
performance management / other gotchas - I'm moving into a project where ML will be a component, primarily it will be as a DBA although I do have some DEV (SSIS / Tsql) experience. I'm wondering are there any good resources yet on how to admin MS ML on SQL Server , I'm finding a lot of info on how to […]
 

 

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

 

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