My Thoughts on PASS Virtual Summit – An Editorial
On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server...
2020-06-11
4 reads
Blog Posts
SQL Server principals – Logins & How does Login Authentication work in SQL Server?
[MSSQLFUN & Decode ITeS becomes a family of 1600 individuals across the globe. Please join us on Facebook & YouTube.] SQL Server Level Principals SQL Server level principals are the only...
2020-06-11
39 reads
SSAS Tabular – Process Add vs Partition Merge
Time keeps on running and as I promised in my last article I would like to compare the Process ADD vs Partition Merge technique. In the previous blog I...
2020-06-11 (first published: 2020-05-25)
445 reads
Azure Monitor and Azure SQL Database
This is all about enabling diagnostics telemetry for Azure SQL databases. For Azure SQL Database there are quite a few options to select from. Below shows the diagnostic settings...
2020-06-10
41 reads
Daily Coping 10 June 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-06-10
12 reads
Database Fundamentals #25: Referential Integrity
If you have been reading through all my fundamentals posts and following along, you have built a small sample database, loaded it with data, and learned how to retrieve...
2020-06-10 (first published: 2020-05-26)
306 reads
How SQL Server stores data types: floating points
In this post we are looking at how SQL Server stores floating point values (FLOAT and REAL). If you’d like to read the previous posts in this series of...
2020-06-10
190 reads
Next week is EightKB–The SQL Server Internals Conference
Next week, on Wednesday, June 17, 2020, the EightKB conference takes place. As with other events, it’s online, and it is full of high level content. It looks to...
2020-06-10
37 reads
Remote communication for fun and profit! – a MinionWare snippet
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites!
The...
2020-06-10
10 reads
Remote communication for fun and profit! – a MinionWare snippet
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites!
The...
2020-06-10
13 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers