(Michael J. Swart) So check out this code, what’s going on here?
Tag: sql server
(Koen Verbeeck) I want to load data from different flat files stored in Azure Blob Storage to an Azure SQL Database. However, I only want to process new files. Files which already have been processed should be ignored.
(Grant Fritchey) Questions absolutely drive my blog content and I really liked this one: how does the T-SQL CHOOSE command affect performance.
(James Serra) It used to be that the only way to use SQL Server Management Studio (SSMS) against Azure SQL Database Managed Instance (SQLMI) was to create a VM on the same VNET as SQLMI and use SSMS on that VM.
(Pinal Dave) If you are a regular reader of this blog post, you probably are aware that primary business is to help people improve their SQL Server query performance while consulting service Comprehensive Database Performance Health Check.
(Chris Webb) Recently, a new set of endpoints in the Power BI REST API for exporting Power BI reports and paginated reports to files went into public preview (see the main announcement here and the paginated reports announcement here).
(Aveek Das) In this article, I’m going to discuss how to create a conditional column in Power BI. A conditional column is just another column that is generated based on a condition imposed on an existing column.
(Pinal Dave) When I start working on the Comprehensive Database Performance Health Check with my client, I usually have no idea where will I end up while looking for the root cause of the performance problem for my client.
(John Miner) There are many existing on premises SSIS packages that use the File System Task to copy and delete files. For instance, an ingestion process might save files to an inbound directory.
(Allan Hirt) I had to do something this weekend that involved the SQL Server feature backup to URL which allows you to back up databases in a SQL Server instance directly to Azure blob storage. That PowerShell there is quite the adventure … and cumbersome.