GitHub

Last Partition Not Empty.sql

OR (CONVERT(int, (@@microsoftversion / 0x1000000) & 0xff) > 13) -- SQL 2017+ OR (CONVERT(int, (@@microsoftversion / 0x1000000) & 0xff) = 13 AND CONVERT(int ...
GitHub

SQL endpoint refresh fails on empty lakehouse

Currently, refreshing a SQL endpoint using Semantic Link Labs using refresh_sql_endpoint_metadata function fails when the target Lakehouse has no tables and we don't ...
Visual Studio Magazine

Deleting all Data from a SQL Server Database (Part 2)

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...