Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what it all means. Isolation levels work to manage how my transactions may be isolated from… Locks, Blocks, and Isolation Levels
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well, in order to create and deploy code changes (software, database, you name it) outside of… Why You Need A Test Environment
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This week we will learn how to make changes to data that is already in a… How to write an UPDATE query
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
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
During a recent engagement, I was tasked with making a query faster. Since I signed an NDA (Non-Disclosure Agreement), I can’t go into detail, but it made extensive use of the STDistance() function of the… A dalliance with distance
This is part two of a short series of posts about how I assign efficient data types when designing a new table or database. Use less space with BIGINT Last week, I spoke about a… Data Efficiency in SQL Server: DECIMAL
This is the first in a short series of posts about how I assign efficient data types when designing a new table or database. Use less space with DATETIME2 We all know that the DATETIME column… Data Efficiency in SQL Server: DATETIME
This post has nothing to do with SQL Server, but if you like performance tuning, stick around. I learn technology by using it, pushing it to its limits, finding out how it breaks. I jokingly… Lazy Loading and Tries
Blob Storage Sync tool updated During a SQL Server migration this month, I found some inconsistencies in my Azure Blob Storage Sync tool, so I made several improvements, and fixed an outstanding bug. As you… Update to Azure Blob Storage Sync and Restore
This week I am continuing with the simple survey series. Today my question is, do you prefer using a dark or light background when writing code? I like a light background with dark text (usually… Survey: Light or Dark
This is my second survey for the month of December. Last week I asked about join predicate order. This week, it’s a simple question: Do you prefer tabs or spaces to indent your T-SQL, and… Survey: Tabs or Spaces