(Pinal Dave) It’s always fun to fix something when there is no meaningful error message. As you can see in the blog title, message id = 0 and it doesn’t tell me how to fix the issue. Here is my checklist whenever someone reports below severe error:
Tag: sql server
DBA Definitions: FILLFACTOR
(Kenneth Fisher) It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing the basics though right? Right??
Get That Profiler Feel in Extended Events
(Grant Fritchey) I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.
Why the Default Summarization Property in Power BI is So Important
(Melissa Coates) This post describes an issue I ran into this week on a project. If the Default Summarization settings in your data model are not correct, it results in wrong data being displayed, or even missing data, on your report.
SQL Server 2017 – Interleaved Execution
(Arun Sirpal) I worked on testing interleaved execution with Microsoft back in January, I didn’t do much, just tested the functionality against some in-house code we had.
SQL SERVER – SQL Express Installation Error – Wait on the Database Engine Recovery Handle Failed
(Pinal Dave) Sometimes I get emails from software vendors who use SQL Server as a part of their product. One of such vendor contacted me for an issue where their software install was failing because SQL Express was not getting installed. It was failing with an error.
Microsoft technology refresh touches SQL Server, integration tooling
(Jack Vaughan) Microsoft is at work on a delicate technology refresh affecting database tuning and architecture, as well as data integration and business intelligence.
Azure SQL Database Managed Instance
(James Serra) Azure SQL Database Managed Instance is a new flavor of Azure SQL Database that is a game changer. It offers near-complete SQL Server compatibility and network isolation to easily lift and shift databases to Azure (you can literally backup an on-premise database and restore it into an
Which M Functions Are Only Available To Custom Data Connectors?
(Chris Webb) Here’s one for all you M geeks out there. If you look at the example code for custom data connectors on the Power BI custom data connectors GitHub repo it’s clear that there are several M functions that are available in custom data connectors that aren’t available in Power BI Desktop. B
SQL SERVER – Adding New Database to AlwaysOn Replica is Slow
(Pinal Dave) First, let me clarify, the words in the subject of this blog are the exact words used by my client and whatever you do and say but “customer is always right!“. Here is the complete story where we faced issue related to AlwaysOn Replica.
