The Mentoring Class of 2023
(Meeps, one of our seven cats, helping with the selection process…) Since my first round of community mentoring back in 2015, when I mentored 54 people for six months, I’ve been asked periodically whether I’d do it again. My answer was always som …
Should You Use SQL Server 2022’s DATETRUNC?
SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example:SELECT DATETRUNC(year, ‘2017-06-01’); Truncates everything in that date other than the year, so it returns just 2017-01-01 00:00: You might ask, …
SQL Server 2022: How Auto-Drop Statistics Work
Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table structure is not blocked by the presence of the statistic. An auto-created statistics is also dropped automatic …
Resolving to Write in the New Year
It is almost New Year’s Day, that time when the optimistic at heart start thinking about making changes in their life on that magical day that ends the year. After the glorious gluttony-fest that has only recently ended in many cultures, it does …
Artificial Intelligence with Power BI
Executive Summary Artificial intelligence is transforming businesses across the world. There are several tools and technologies to realize the benefits of AI efficiently and effectively. However, one software package that most organizations already hav …
SSIS Bad Habits: Decreasing SSIS Package Performance
The post SSIS Bad Habits: Decreasing SSIS Package Performance appeared first on SQLServerCentral.
Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back
The post Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back appeared first on SQLServerCentral.
Deploy and Configure Azure SQL Managed Instance
The post Deploy and Configure Azure SQL Managed Instance appeared first on SQLServerCentral.
How to create a Power BI report using REST API data
Introduction In this article, we will learn how to create a Power BI report using a REST API. REST API is an Application Program Interface that uses HTTP requests to get data. Usually, the data is sent in JSON format. For example, you can use REST API …
[Video] Office Hours: Great Questions, Part 2
Every time I think, “There can’t be any more SQL Server questions left,” y’all post more great ones at https://pollgab.com/room/brento! Here’s what we covered: 00:21 MattC: Hi Brent. Have you check out ChatGPT’s abil …
Updated First Responder Kit and Consultant Toolkit for December 2022
Santa’s elves took a break from building toys and shipped a new version of the First Responder Kit. There are some great improvements in here, like a makeover for sp_BlitzLock and much better PSPO compatibility for sp_BlitzCache. Wanna watch me u …
Reviewing SQL Migration Files Before a Flyway Migration
The post Reviewing SQL Migration Files Before a Flyway Migration appeared first on SQLServerCentral.
[Video] Office Hours: Great Questions, Part 1
Wow, y’all have been posting some great questions at https://pollgab.com/room/brento lately! Here’s what we covered today: 00:59 Gustav: Hi Brent We recently migrated to SQL MI General Purpose, and I noticed that the default blob storage pe …
What’s new on Power BI DataMarts UI
I wrote an article about Power BI Datamarts which was released together the feature, on the exact moment it was being announced in a conference. Of course, this feature has being evolved since that time. I would emphasize the performance. The general U …
Automate Power BI desktop data model with a PowerShell script
Waiting for PBI desktop « working on it » When you know the host and port of SSAS Tabular instance, you just need to connect to it – and your entire PBI model (i.e. tables, relationships, measures, load scripts) becomes available for scripting via .NET A …