I've had a LinkedIn account for years. Never posted. Until now. It's Thursday afternoon. Someone needs a column added to a production table. So you write an ALTER script, test it against a dev copy ...
# Migrate normalized database schema from Azure SQL Database to Azure Cosmos DB denormalized container This guide explains how to take an existing normalized database schema in Azure SQL Database and ...
A few months ago a new option was added to the Sql.Database and Sql.Databases functions in Power Query in Power BI and Excel which allows Power Query queries that combine data from different SQL ...
In this article, I would like show you how to migrate a database platform from Azure SQL DB to Databricks Delta. This use case would be interesting for many teams working on migration, platform ...
This tool is currently only supported on Windows and PowerShell. It has not yet been tested on PowerShell Core. It will though work remotely against SQL Server on Linux. NOTE: For SQL Server 2014 and ...
When you connect to a relational database like SQL Server in Power BI/Power Query/Excel Get & Transform you have two choices about how to get the data you need: You can choose a table from the ...
Try new SQL Server command line tools to generate T-SQL scripts and monitor Dynamic Management Views
We are excited to announce the public preview availability of two new command line tools for SQL Server: The mssql-scripter tool enables developers, DBAs, and sysadmins to generate CREATE and INSERT T ...
This post was authored by Jos de Bruijn, Senior Program Manager, SQL Server. A release the magnitude of SQL Server 2016 deserves a new sample. AdventureWorks, which has been around since the SQL ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results