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

How Wrong is Stack Overflow?

I chose the title slightly to poke at Stack Overflow (SO), but the same take expressed in this tweet could be said about SQL Server Central. It's not quite the same as anyone can answer questions on SQL Server Central.

The tweet is a (long) hot take from Jerry Nixon, a C# developer and MS evangelist in Denver. Essentially he says that a lot of the SO answers are wrong, especially as the software and languages change. Old answers are upvoted, and remain at the top of the list, even as newer answers might be better. People don't like the behavior on SO of moderators and people who post, which is something we've tried to avoid or limit here at SQL Server Central. We want there to be professional discussions. SO also doesn't allow much discussion or nuance in the questions or answers.

This isn't just a SO problem or am SSC one. It's a problem when we have lots of documentation, blogs, etc. on the Internet that search engines find and surface when it's popular. Across time, these popular outdated posts remain, just like older documentation that doesn't apply to a current version and this can be frustrating. I am even starting to get annoyed by the MS Learn docs for SQL Server as some functionality change across versions. It isn't easy to determine what applies to which version, especially when subtle changes are made in how things work. If something is new, usually that's clear, but when things change, it isn't. The examples aren't well maintained, or there are too many of them to really understand how and why a change in versions can affect your code.

I do wonder if we ought to somehow limit content that we see by default to more recent content. Or maybe Google/Bing/et al ought to let us set that as a preference. In general, I want more recent content, but at the same time, I don't want to say "give me blogs about something from the last month only." It's possible I use something that's rare and the most recent blog is 7 months old.

More, I wish we had better ways to tag content online as relevant for certain things or not. I can't think about the entire world and all the different types of content, but I can think about technology and software. I'd like to know if someone write a highly popular and useful post on PowerShell 5 that was written and tested on that version. I can understand that it's not necessarily tested on PoSh 7, though it could work. It could even be the best solution. The same thing applies to Python 3.8 or T-SQL for SQL 2016 or any other software.

The challenge of keeping things up to date is a big one, especially as more companies move to release software more often. I'm always pointing out issues in the RG docs. Since we release every week or two, each product team has a busy job in ensuring documents are up to date, which is easy for the reference pages. This is a bit harder when there are articles were we explain how to use a feature or we have a walkthrough of the software. I don't know if AI will help here, but I do think this is a place where AI might be able to help vendors at least keep up with changes. When code changes, update docs, all the docs including examples.

I do also think dating content is important. Microsoft tried to stop doing this with some things and many people complained. Content needs a date. It might still be valid or useful, but without a date, we have no idea of the context in which it was produced. That might help us decide if it's still relevant, useful, or if we need to continue searching further.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Upserts in Amazon Redshift

Rahul Gupta from SQLServerCentral

This article discusses different approaches of Upserts (update+inserts) in Amazon Redshift

External Article

Ordered Columnstore Indexes in SQL Server 2022

Additional Articles from SimpleTalk

One of the more challenging technical details of columnstore indexes that regularly gets attention is the need for data to be ordered to allow for segment elimination. In a non-clustered columnstore index, data order is automatically applied based on the order of the underlying rowstore data. In a clustered columnstore index, though, data order is not enforced by any SQL Server process. This leaves managing data order to us, which may or may not be an easy task.

Technical Article

Meet the Summit 2023 Sponsors

Additional Articles from PASS

Preparations for Summit 2023 are fully underway! We thought what better way to introduce you to some of this year’s sponsors than sit down with them and find out what they have in store for you in November…

Technical Article

Standard Sponsor Rates End August 30!

Additional Articles from PASS

Secure your Sponsorship package before the rates go up. PASS Data Community Summit 2023 is where the database community meets every year to make life-long connections with peers, network with industry leaders, and advance their careers. With over 170 technical sessions, and a great line-up of sponsors, this is your time to secure your space before August 30 and get a preferred booth location.

Blog Post

From the SQL Server Central Blogs - SQL Agent job history on a Managed Instance

Kenneth.Fisher from SQLStudies

The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them ... Continue reading

Blog Post

From the SQL Server Central Blogs - Options for Data Source Credentials When A Service Principle Owns A Power BI Dataset

Angela Henry from SQL Swimmer

In today’s world of wanting to automate everything, specifically, automating your CI/CD process for your Power BI datasets and dataset refreshes, you need to understand your options when it...

Microsoft Power BI Quickstart Guide cover

Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, 3rd Edition

Steve Jones - SSC Editor from SQLServerCentral

Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in color.

 

 Question of the Day

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

 

Finding Encrypted Stored Procedures

How can I tell if the dbo.NewprocOne is encrypted?

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)

Checking a SchemaBound View

I have this code in SQL Server 2019:

CREATE TABLE moduletest(
   col1 int, col2 int, col3 int)
GO
CREATE OR ALTER VIEW dbo.GetModuleTest WITH SCHEMABINDING
AS
  SELECT col1, col2
    FROM dbo.moduletest
 GO

I now execute this:

EXEC sp_refreshsqlmodule 'dbo.GetModuleTest'
GO
EXEC sp_refreshview 'dbo.GetModuleTest'
GO

What is returned?

Answer: Two messages that metadata is not updated as these objects are schemabound

Explanation: No error is returned. Instead, each call returns this message:

Metadata was not updated for the schema-bound object 'dbo.GetModuleTest'.

Ref:

   

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 2016 - Development and T-SQL
How to identify changed values from a history table? - We have several tables with system_versioning set to on. There is a requirement now to produce a solution (function / stored procedure) to return a list of changed columns of a given table within a range of days. Below is an example of one of the tables - customer_sites and a bit of data: /**** […]
Run Stored Procedure on the first Monday if each month of Tues if Mon Holiday - Hello, I need to setup a Stored Procedure to run on the first Monday of each month that is not a holiday.  If the first Monday of the month is a holiday, than I need the PROC to run on Tuesday.  Via Scheduled Jobs, how is this possible?  Can someone help with a query on […]
SQL Server 2019 - Administration
repeated login failures. - Do repeated login failures into SQL affect performance.  Surely some resources are used with each attempted ack & nack?  Certainly log writes.  I have careless app owners who repeatedly fall foul of my attempts to stop this happening as their apps try access every 10 seconds or so.  They failures fill my logs & I […]
SQL SERVER AUDIT LOG can scheduled job be placed and get file in .csv format - Hi Team, SQL SERVER AUDIT LOG can scheduled job be placed and get file in .csv format we can see the audit logs using view logs rather than is there any way we can set the audit to run in frequency for every one hour and schedule it in a job where we can get […]
Deadlock - implicit transaction - Hi, We are experiencing deadlocks. The process not being the victim is doing an update by stored procedure which has begin tran,  commit tran. However the transactionname in the deadlock graph is implicit_transactions. Could this be potentially causing the deadlock issue and from the application implicit_transaction is on?  
File does not close: VerifyShareWriteAccess.txt - Hi Folks. We have two  SQL Server 2019 Enterprise in an High Availability Group (always on).  The OS is Windows server 2019. For the witness of the failover cluster we use a file share.  The cluster itself runs perfect. But we have some troubles with the file VerifyShareWriteAccess.txt. The cluster service opens the file (read, […]
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided.  see error below: I'm trying to login into a sql server on another domain (DEV).  I run a command to launch SSMS and then login to a DEV server as follows: %windir%\system32\RUNAS.exe /smartcard /user:ABC@dev.com /netonly "C:\Program Files (x86)\Microsoft […]
Why would user account authentication issues arise in Azure? - Through a series of events too long to go into here, last year I was involved in helping to move a test SQL Server 2019 database from on-premises, to a VM in Azure. However, after it was migrated, they no longer needed me and that was the last I heard of or knew about it, […]
SQL Server 2019 - Development
Using Dynamic SQL to execute Select from Openrowset with JSON - I have some code which will load in and process a JSON file using Select..from Openrowset as follows: Declare @JSON varchar(max) SELECT @JSON = BulkColumn FROM OPENROWSET (BULK 'C:\Users\User1\DR\staging\returns\RET02022203.JSON', SINGLE_CLOB) as j select @JSON i tried to turn this into Dynamic SQL  so that I can pass in the path to the JSON file as […]
xp_cmdshell problem - Hi, i'm trying to run this command from within the SQL but i get this error 'C:\Program' is not recognized as an internal or external command, operable program or batch file. here is my code DECLARE @CONVERT_HTML_TO_PDF VARCHAR(4000) SET @CONVERT_HTML_TO_PDF = '"C:\Program Files\Microsoft SQL Server\MSSQL15.PRI\MSSQL\monitor_binaries\wkhtmltopdf.exe" "c:\new folder\1.html" "c:\new folder\1.pdf"' EXEC xp_cmdshell @CONVERT_HTML_TO_PDF what is wrong […]
Best way to handle incremental duplicate data in SQL Server? - I am processing .csv files daily which has persons data. Every person has a unique ID. My table has FileID and PersonUniqueID columns; it is working fine and saved to parsed table, i.e. with duplicate rows. Now would like to copy the unique data to new tables which is used by other applications. I can […]
CosmosDB
To change the maximum throughput of an Azure Cosmos DB for NoSQL container - Hello,   I have a question, and please advise. When I wish to change the maximum throughput of an Azure Cosmos DB for NoSQL container from 4000 RU/s to 5000 RU/s, would that be sufficient if I use command: az cosmosdb sql container throughput update command --max-throughput ‘5000’ ???   Tanks in advanced  
Reporting Services
Custom Authentication SSRS 2019 - When trying to setup custom authentication on ssrs 2019 getting "ERR_CONNECTION_REFUSED " and this in the logs   ERROR: Error loading configuration file: The configuration file contains an element that is not valid. The #text element is not a configuration file element. library!DefaultDomain!13d0!08/02/2023-09:54:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: , Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration […]
SSRS Integration with Power BI - I am trying to integrate SSRS 2022 with Power BI.  One of the steps is to go into Report Server Configuration Manager and go to the Power BI integration tab;  however, I am not seeing a Power BI integration tab.  Is there something special I need to do or install to see that tab?   […]
Analysis Services
Date Difference of current record and its relative record using MDX - Dear All, I have a some rows where it points to another row in same table based on RelativeId column value. I need to find the difference of these two records date values using MDX. for ex.  sample table structure with some values ID - HasRelative - Date - RelativeId 1 - False - 2023-01-01 […]
 

 

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

 

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