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
10 reads
Blog Posts
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)
302 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
185 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
35 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
7 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
9 reads
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-06-10 (first published: 2020-05-23)
415 reads
Webcast – Principles of Data Modeling
Tomorrow, June 11, 2020, at 3 PM Eastern I’m giving a webcast on the Principles of Data Modeling. Sign up link: https://www.mssqltips.com/sql-server-webcast-signup/?id=822 Here’s what we’ll be covering: You’ve been...
2020-06-10
43 reads
Adding the Social Headline Topic
The world is changing, and the activism is infectious. I’ve tried to be fairly apolitical and unoffensive for most of my career. I definitely have not always succeeded, but...
2020-06-09
8 reads
Daily Coping 9 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-09
9 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers