Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming PASS community events in the province of Alberta. I will be presenting at SQLSaturday #594… Upcoming SQLSaturdays in Alberta, Canada
A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before, was reading through the first five posts of this Database Fundamentals series, and asked a great question:… So, like, what is a byte?
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system without the relationships is nothing more than a place to store your stuff. Last week… Normalization, The Sequel
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting warmed up. This week’s post is over 2,000 words long!
Over the last three weeks, we’ve gone fairly deep into data types, and now we are going to see how they come into play with normalization.
If we go back to the first post in this series, I mentioned normalization, and then apparently I forgot about it in the next two posts. What you didn’t see is that I was talking about it all along.
Last week, we discussed storing text in a database. This week we will dive deeper into data types. When storing data in our database, we want to make sure that it’s stored accurately and that… Fundamentals of Data Types
Last week we started with a very simple definition of a database: a discrete set of information, with a specific structure and order to it. We briefly looked at normalization, which is a way to… Data Types and Collation
What is Microsoft SQL Server? To answer that, we have to ask what a relational database management server (RDBMS) is. To answer that, we have to ask what a relational database is. To answer that,… What is a Database?
(This post was last updated on 1 August 2022.) Everything changed for SQL Server Standard Edition on 16 November 2016, and how memory limits work. On that day, a slew of Enterprise Edition features made… Max Server Memory and SQL Server 2016 Service Pack 1
On 28 February 2017, I will be speaking at Microsoft Calgary as part of a roadshow for AMTRA Solutions. Lunch will be provided. You can reserve your place for my session on Eventbrite, and there… SQL Modernization and Cloud Migration Talk in Calgary
For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped and recreated, or modified as needed. Last week we covered… Testing for Object Existence: CREATE OR ALTER
For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped and recreated, or modified as needed. This is especially common… Testing for Object Existence: DROP … IF EXISTS
(Last updated 2020-01-07) This is more for my own reference than anything. On newer versions of Windows desktop and Windows Server, we may find that the shortcut to SQL Server Configuration Manager is missing. According… Configuration Manager Shortcut on Windows 10 and Server 2016
In my November 2015 post, An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean, I wrote: The HIDDEN property is optional and will hide these columns from a standard SELECT statement for… Temporal Tables and Hidden Period Columns
Last Wednesday on Twitter, Abayomi Obawomiye (@SQLAmerica) wrote: https://twitter.com/SQLAmerica/status/819252286274695168 I just met someone with the last name NULL today. I really want to ask if they had issues with the last name but worried might… My surname is NULL
I’m a huge fan of Temporal Tables in SQL Server 2016. I first wrote about them, in a four-part series in November 2015, before SQL Server was even released. I don’t always get this excited… Temporal Tables and History Retention