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

What's Your Area of Expertise?

This editorial was originally published on Jun 16, 2016. It is being republished as Steve is on holiday.

I ran across a great quote that made me laugh, but also struck me as being quite true. The quote is from Scott Curie's post on the PASS Summit Speaker's Contract and goes like this: "You would laugh at a lawyer who tried to build their own data warehouse, so why would you try to write your own legal agreement?" Having used lawyers for a few contracts, I am well aware that I'm not remotely qualified to put together a detailed contract. I know if I need a business agreement, I need to either use a lawyer or make it really simple. "I'll cut your grass, and you'll give me $25" is probably the last well-written contract I wrote.

We all have strengths and useful skills, things we are really good at performing. We often improve those skills over time and may develop some level of expertise in our field. However, even if we were the best T-SQL coder in the world, or the hands-down, acknowledged world-renowned expert on replication, that wouldn't mean that we necessarily had any skill in some other area of the SQL Server platform, such as Integration Services. We might know something, we could learn, and certainly be competent quickly, but would a company that had a mission-critical, multi-TB import or export of data want us to patch their ETL process today? Probably not.

Usually, when we have a problem with a specific technology, we want someone who knows that technology well to guide us or do the work. The same thing is true in business. If an inventory specialist questions the way some system works, or a financial guru wonders about the calculations in an application, we should defer to them and ensure that we can explain how the code works, double-checking the accuracy. After all, specifications could contain bugs as easily as code, and an expert in the end user of software might have a better idea of whether a system is working properly than the developer.

We should remember that when we venture outside of our own area of specialization. Many technology professionals are quite intelligent, but they aren't going to be experts in all problem domains, and they shouldn't present themselves as such.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

My experience using the GitHub Copilot in SSMS 22

Daniel Calbimonte from SQLServerCentral

Get a quick look at Github Copilot in SSMS.

External Article

Get ChatGPT’s Advice On Your Queries with sp_BlitzCache.

Additional Articles from Brent Ozar Blog

First off, I understand if you read the headline and you have a knee-jerk reaction. I totally understand that there are a lot of people out there who hate AI, and believe me, I hate most uses of it. Lots of its advice can be misleading at best, and absolute garbage at worst.

Blog Post

From the SQL Server Central Blogs - More fun with Git: git restore

Randolph West from Born SQL with Randolph West

The setup My day job involves babysitting a lot of Git repositories hosted on GitHub. The vast majority of the commits, merges, and squashes I run on a daily...

Blog Post

From the SQL Server Central Blogs - When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages

John Morehouse from John Morehouse | Sqlrus.com

Recently, the world was reminded of just how fragile the internet can be.  Two well established cloud services, Cloudflare and Azure Front Door, both had simultaneous outages that caused...

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

Site Owners from SQLServerCentral

This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.

 

 Question of the Day

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

 

The Max PK Length

If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?

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)

UNISTR Basics

What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)

SELECT UNISTR('Hello 4E16754C') AS 'A Classic';

A:

 

B:

 

Answer: The image from B: above

Explanation: This works and returns the image from B (Hello, Sekai or Hello, world). The UNISTR() function will convert the Unicode codepoint values into the appropriate character  and insert them into the string. These need to be escaped for the function to work correctly, with the default escape charater of . Ref: UNISTR - https://learn.microsoft.com/en-us/sql/t-sql/functions/unistr-transact-sql?view=sql-server-ver17

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
Pivot but preserve all rows on Aggregate column - Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a column and creates only row, my goal is to preserve all rows. We need to pivot on DSTRCT_CODE which will have only two values {BBBB/CCCC}  on value of column PREF_PART_IND. so for below sample data : with q_data as ( select […]
SQL Server 2019 - Administration
MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn. - hi,   i have checked reducing it increasing it but could not get any thing, pls explain what exactly it means. DROP EVENT SESSION [CaptureSlowQueries] ON SERVER go CREATE EVENT SESSION [CaptureSlowQueries] ON SERVER ADD EVENT sqlserver.sp_statement_completed( ACTION(sqlserver.database_id,sqlserver.sql_text) WHERE ([duration]>(15000000))), ADD EVENT sqlserver.sql_statement_completed(SET collect_statement=(1) ACTION(sqlserver.client_app_name,sqlserver.database_id,sqlserver.sql_text) WHERE ([duration]>(15000000) )) ADD TARGET package0.event_file(SET filename=N'SlowQueries',max_file_size=(5),max_rollover_files=(2)) WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 […]
SQL Server 2019 - Development
is there a no code way to limit an ssis extract from excel to the 1st 21 rows? - is there a no code way to limit an ssis extract from excel to the 1st 21 rows of the sheet?   for now anything past that is just noise in what im doing.
any reason to avoid asking ssis to extract files from ftp - hi we have to replace talend which generally was used to move files. talend's replacement except for a handful of sql sourced etl's is an OO code based "pipeline" architecture.  the sql stuff has been converted to ssis. we have to begin extracting about 6 files daily from an ftp server and throwing them out […]
CAST datetimeoffset(7) as a datetime in UK format - I have a view where I am casting a datetimeoffset(7) field to smalldatetime or datetime as my reporting application won't accept the datetimeoffset(7) format.  Problem is I am trying to get this field to show up in UK format.   I am using CAST to get my results.  I can get the format I need by […]
what are the downsides of TDE not running vs running? - hi for the 2 years i've been here I believe we've had "encryption" turned off in what i only know as the way we tell ssms to communicate with our sql servers ...and i've always thought meant also the server itself relaxing how it communicates back to whatever client is asking for data. recently an […]
Reporting Services
Catalog max connection pool size: 100 - Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise: a) Why this is being reported so frequently? b) Does it indicate the limit is being hit? c) If b is true, how can I increase it? I've had a look through the configuration files and can't find anything specifying "100" […]
Editorials
Investing for AI - Comments posted to this topic are about the item Investing for AI, which is is not currently available on the site.
Article Discussions by Author
What is the PRODUCT - Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform - Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform - Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
SQL Server 2022 - Administration
Change Tracking – Troubleshooting - I have change tracking configured in several databases, in QA and production environments, and we have config in place to feed from these databases to data warehouse databases. It works well, but ... In a QA environment, we have been receiving the following sev-16 alert for a few days: Change tracking autocleanup is currently not […]
Help! MEMORY_ALLOCATION_EXT wait stalls - Hi I have an overnight process that moves allot of claims records Been working fine for many years. Now it hits this part of the code (across a linked server) and gets the (1596567ms)MEMORY_ALLOCATION_EXT wait type and will sit there forever and never move any records - no delta movements at all. Used to complete […]
SQL Server 2022 - Development
cant process ssas db on vm - error says source is encrypted and other things - hi i get the error you see below when trying to process my AR cube full.  it is sourced by a sql db on the same server that theoretically is being connected to by my admin acct.  my query on which sql engine db's might be  encrypted comes up false on each.   i made sure […]
This doesn't make sense to me - making me crazy - er - Hi So I have the below select query that won't return results if I have it this way:   --DOES NOT RETURN-- AND EXISTS (SELECT 1 FROM edi.dbo.PEC_RGT_EDI_834_Inbound_Exception xx WHERE (xx.SubscriberNumber = x.subscribernumber OR x.MBI = xx.mbi) AND xx.LastDateProcessed>'05/31/2022') But will return results with this very small change: --DOES RETURN-- REPLACE ABOVE WITH BELOW AND […]
 

 

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

 

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