I'm finding Polybase to be even more finicky than OPENROWSET, which is challenging enough.

I'm about to give up. Where Polybase has failed me, I've found success with #R and sp_execute_external_script. It has its own challenges, but the R packages are much more forgiving.

#SQLServer #Azure

Polybase for #SQLServer. 🙁

<Summons Desi Arnaz>
Lucy, you got some explainin' to do!

Microsoft releases SQL Server 2022, preferring hooks to Azure over enhancing the on-premises product.

Interesting report & analysis of the SQL Server 2022 release, including SQL Server tools and cloud vs on-prem thoughts.

#SQLServer

https://devclass.com/2022/11/16/microsoft-releases-sql-server-2022-preferring-hooks-to-azure-over-enhancing-the-on-premises-product/

Today I'll be evaluating clustered indexes. Do we choose the appropriate clustering key(s)?
Are there more cluster key scans than seeks?
Let's find out...
#SQLServer

Sigh. Playing 'Whack-a-mole' again with heaps and uncompressed tables/indexes.
#SQLServer

I'm trying to determine the trigger order for a table with eight triggers...and somehow find an answer to someone's question about a data change.

How's your day?

#SQLServer

NEW POST:
✍ Read and Write files to Azure Data Lake with SQL Server

🔎 Write files to cloud storage with SQL Server's Machine Learning Services.

#RStats #SQLServer #Parquet #Azure

https://www.davemason.me/2022/11/08/read-and-write-files-to-azure-data-lake-with-sql-server

NEW POST:
✍ Import and Export Parquet Files with SQL Server

🔎 T-SQL has no native support for parquet files. It's R, Python, and Machine Learning Services to the rescue!

#RStats #SQLServer #Parquet

https://www.davemason.me/2022/11/06/import-and-export-parquet-files-with-sql-server

NEW POST:
✍ Machine Learning Services and File System Interaction

🔎 External Python and R scripts for SQL Server Machine Learning Services have limited access to the file system.

#RStats #SQLServer

https://www.davemason.me/2022/11/04/machine-learning-services-and-file-system-interaction

NEW POST:
✍ RStudio and Package Installation for Machine Learning Services

🔎 A walkthrough for installing R packages for SQL Server Machine Learning Services

#RStats #SQLServer

https://www.davemason.me/2022/11/04/rstudio-and-package-installation-for-machine-learning-services

My day concluded with me trying to explain that #SQLServer indexes have limits with regard to how much technical debt and bad design they can overcome.

😱 #SQLServer table with 850 columns. Every one is data type VARCHAR and storing dollar amounts.

T-SQL Tuesday #155 –The Dynamic Code Invitation

This is the monthly blog party where someone hosts and you all write a response.

#SQLServer
#SQL

https://voiceofthedba.com/2022/10/06/t-sql-tuesday-155-the-dynamic-code-invitation/

Native #SQLServer backups to disk and log shipping may not be glamorous, but they're reliable AF.

Also not glamorous: outages. ☹

Your dynamic TSQL might be clever, but you'll get side-eye instead of admiration if performance sucks.
#SQLServer

BLOGGED: SQL Server Indexes With Unused INCLUDE Columns

How to find unused INCLUDE columns in nonclustered indexes for SQL Server.

#SQLServer #DBA

https://www.davemason.me/2022/09/03/sql-server-indexes-with-unused-include-columns

Hey #SQLServer folks. This took a while to code and test...and an eternity to run the TSQL scripts to completion. But it seems to work. The first iteration looks really promising.

In our biggest/busiest SQL Instance, I counted 17,732 INCLUDE columns in all non-clustered indexes across all databases.

Only 6,645 of them have query plan references in Query Store or the plan cache.

That's a lot of "over indexing"!

https://github.com/BeginTry/SQL-Server-Indexes-With-Unused-INCLUDE-Columns

Today I'm learning about the joys of restoring a database that is a publisher for #SQLServer replication.

SQL Server 2022 community technology preview 2.1 is now available.

#SQLServer #SQLServer2022

https://techcommunity.microsoft.com/t5/sql-server-blog/sql-server-2022-community-technology-preview-2-1-is-now/ba-p/3582903

New Code Snippet for SQL Server Management Studio: Inconsistent Data Types

#SQLServer #SSMS

https://github.com/BeginTry/SSMS-Code-Snippets/blob/main/Inconsistent%20Data%20Types.snippet