This is one of them little options that I see which quite often gets little consideration or gets set to a user database without consideration of what the consequences...
2020-12-09 (first published: 2020-11-30)
395 reads
This is the seventh post in my retrospective attempt to answer every T-SQL Tuesday invitation. In the beginning of June 2010, Jorge Segarra invited us to write about our...
2020-12-09
37 reads
Many conferences have moved online this year due to the pandemic, and many attendees are expecting captions on videos (both live and recorded) to help them understand the content....
2020-12-08 (first published: 2020-11-24)
141 reads
I 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-12-08
20 reads
This exercise demonstrates the installation and configuration of Microsoft SQL Server on Linux environment, this is a standalone deployment . Step 1 – Create “mssql”(more...)
2020-12-08
5 reads
In CentOS 7 Linux MariaDB is by default installed, due to this you may face issue installing MySQL. If you want to install MySQL, first(more...)
2020-12-08
17 reads
This exercise demonstrates the installation and configuration of Postgres database on Linux environment using source tar file. Step 1 – Download Postgres tar file wget(more...)
2020-12-08
11 reads
When I was appointed to serve as a Director at Large for the PASS Organization a year ago, it was with great passion, excitement and enthusiasm. I had some...
2020-12-08
35 reads
Introduction Median is a useful statistical function, which first time appeared in SSAS 2016 and in Power BI around that year as well. There are several articles on how...
2020-12-08 (first published: 2020-11-24)
332 reads
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
14 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers