Power BI Monthly Digest – July 2020
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-07-23 (first published: 2020-07-15)
461 reads
Blog Posts
Setting up a New SQL Change Automation Project
It’s been awhile since I’ve set up a new project in Redgate’s SQL Change Automation project. I’ve mostly used this in Visual Studio, but I need to demo something...
2020-07-23 (first published: 2020-07-15)
1,051 reads
Tonight is the PASS Marathon on SQL Server Performance
The event is tonight, and it’s my first time helping out as a moderator. I got a call for volunteers, and I added my name. The event starts at...
2020-07-23
17 reads
Daily Coping 22 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-22
10 reads
Moving 1/3 of a heap
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
12 reads
Moving 1/3 of a heap
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
6 reads
The Ironic DBA—My First Year as a DBA [Part 3]
T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t) and this month’s edition is hosted by Kerry Tyler...
2020-07-22 (first published: 2020-07-14)
440 reads
The Length Limitations of LEN()?
I was using LEN() to troubleshoot an issue I was having with a dynamically constructed string truncating while inserting into an NVARCHAR(MAX) column. Since I know that NVARCHAR(MAX) has...
2020-07-22 (first published: 2020-07-14)
1,474 reads
These are the extensions I have installed on Azure Data Studio
At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked...
2020-07-22
56 reads
Azure SQL Database – Advanced Threat Detection
You should always seriously consider enabling this feature. This is part of the ADS suite – Advanced Data Security and I will show you how good this pro-active service...
2020-07-21
134 reads
Blogs
Github Copilot in SSMS can include data in its memory, simple prompt injections ahead
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers