Blogs Louis Davidson in Blogs Generating Repeatable Sets Of Test Rows In order to test graph structures, I needed a large set of random data. In some ways, this data will... 30 September 2022 11 min read
Blogs Louis Davidson in Blogs T-SQL Tuesday #154 – SQL Server 2022, IS DISTINCT FROM Despite my recent job change from full time T-SQL code jockey/architect to website editor for Simple-Talk, I will always be... 13 September 2022 5 min read
Blogs Dennes Torres in Blogs Synapse Analytics: When you should use (or not use) Synapse Synapse is a great data lake house tool. This means in a single tool we have resources to manage a... 05 September 2022 5 min read
Editorials Louis Davidson in Editorials Starting my dream job… “ A new adventure, there in your eyes. It’s just beginning, Feel your heart beat faster. Reach out and find... 01 September 2022 3 min read
Blogs Louis Davidson in Blogs Into the unknown, sort of Over half of my life ago, I was looking for a job. I had written a bunch of triggers and... 31 August 2022 5 min read
Blogs Dennes Torres in Blogs .NET App Services: Containers or not containers, that’s the question The app services in the title can be function apps, web apps or more. We can deploy the app services... 30 August 2022 5 min read
Blogs Dennes Torres in Blogs Creating Azure Policy to setup Virtual Machine Auto-Shutdown The Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what we planned for... 25 July 2022 3 min read
Blogs Dennes Torres in Blogs What’s new in T-SQL in SQL Server 2022 There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a few as well... 04 July 2022 8 min read
Blogs Ben Brown in Blogs Boost productivity with ‘Solution Summary’ cards Solution Summary cards are the name I have given to simple 1-page documents we provide to developers to get up-to-speed... 02 July 2022 3 min read
Blogs Phil Factor in Blogs Searching through a database via SQL Imagine that while developing or testing a SQL Server database, you get an error message mentioning a database object, and... 29 June 2022 13 min read
Blogs Dennes Torres in Blogs Parameterizing Azure Policy and Ensuring Azure SQL AD Authentication I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, only auditing if... 27 June 2022 3 min read
Blogs Louis Davidson in Blogs The Job of a Technical Editor (as Louis sees it) One of the most essential parts of producing a great technical article, blog, or even a book, (referred to from... 30 May 2022 9 min read
Dennes Torres in Blogs Power BI: When a Power Query Native Query is not enough In Power BI, when importing data with Power Query, one basic performance concept is the use of native queries. The... 23 May 2022 8 min read
Blogs Dennes Torres in Blogs Template for automating Power BI Refresh I wrote before about Automating table Refresh in Power BI. On that article I explained how to schedule a refresh... 02 May 2022 3 min read
Blogs Dennes Torres in Blogs Power BI Last Refresh Time Visualization Tool On the article Automating table refresh in Power BI I explained many methods to automate refresh of individual objects, which... 25 April 2022 2 min read
Blogs Dennes Torres in Blogs Azure Blueprints: Defining the order of artifacts deployment Blueprints are (or should be) an important feature for Azure Cloud provisioning. Probably you already know about ARM templates. We... 18 April 2022 6 min read
Blogs Dennes Torres in Blogs Migrate all your Azure Storage Gen 1 to Gen 2 Need to migrate your Azure Data Lake Storage Gen1 before Microsoft retires the service? This post from Dennes Torres explains... 11 April 2022 5 min read
Blogs Dennes Torres in Blogs Updating Powershell version in Azure CloudShell Azure Cloudshell uses PowerShell 7.2.1. However, Powershell 7.2.2 is already available and we have also a PowerShell version 7.3.0 in... 04 April 2022 3 min read
Blogs Dennes Torres in Blogs Azure Storage: Mapping File Shares and Powershell drives Mapping an Azure Storage Account file share on a local machine is a powerful feature. In this post, Dennes Torres... 28 March 2022 4 min read
Blogs Louis Davidson in Blogs SQL Server Graph Tables – Cross Database Surprises Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.… 21 March 2022 3 min read
