In the blog post Azure Function with PowerShell and the Power BI REST API I explained how you could create an Azure Function using the PowerShell scripting language. This...
2022-05-16 (first published: 2022-04-27)
235 reads
In this blog post I’m going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as...
2022-05-06 (first published: 2022-04-26)
601 reads
I’m delighted to announce I’m participating in a panel discussion about data warehouse modernization. The full title is “Data Warehouse Modernization – Crafting a Successful Migration Strategy Post Pandemic”....
2022-05-05
71 reads
It’s easy to duplicate an Azure Logic App in a resource group, but unfortunately you cannot duplicate a Logic App between environments (you might try to copy paste the...
2022-04-29 (first published: 2022-04-21)
314 reads
I have a database project in Visual Studio. Inside the database, I use a couple of system views to fetch some metadata about tables. To make the project build...
2022-04-25 (first published: 2022-04-16)
521 reads
Yet another book review! I just finished the book Pro Serverless Data Handling with Microsoft Azure: Architecting ETL and Data-Driven Applications in the Cloud (what a title :), written...
2022-04-22 (first published: 2022-04-05)
225 reads
I was building a CI/CD pipeline in Azure Devops, where I was building my SSDT project into a DACPAC file and then deploying it to the development server. For...
2022-04-20 (first published: 2022-04-07)
515 reads
When I was working with Snowflake on a project, it seemed security (assigning roles to users, assigning permissions etc.) is not as straight forward as it is in SQL...
2022-04-13 (first published: 2022-04-02)
225 reads
It’s the second Tuesday of the month, so it’s time for the T-SQL Tuesday blog party! This month’s topic is chosen by Camila Henrique (blog): what T-SQL advice would...
2022-04-12
32 reads
I’m excited to announce I’m giving a webinar for MSSQLTips.com, with “Introduction to Azure Data Factory” as the subject. The webinar will take place at Tuesday May the 3th,...
2022-04-12
58 reads
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
Comments posted to this topic are about the item How Do the Experts Become...
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers