Why You Need A Test Environment
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… Read More »Why You Need A Test Environment
Home » Development »
Development
How to write an UPDATE query
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… Read More »How to write an UPDATE query
Normalization, The Sequel
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… Read More »Normalization, The Sequel
A First Look At Normalization
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.
Fundamentals of Data Types
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… Read More »Fundamentals of Data Types
Data Types and Collation
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.… Read More »Data Types and Collation
My surname is NULL
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… Read More »My surname is NULL
A dalliance with distance
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… Read More »A dalliance with distance
Data Efficiency in SQL Server: DECIMAL
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… Read More »Data Efficiency in SQL Server: DECIMAL
Data Efficiency in SQL Server: DATETIME
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… Read More »Data Efficiency in SQL Server: DATETIME
Lazy Loading and Tries
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… Read More »Lazy Loading and Tries
Update to Azure Blob Storage Sync and Restore
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… Read More »Update to Azure Blob Storage Sync and Restore
Survey: Light or Dark
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… Read More »Survey: Light or Dark
Survey: Tabs or Spaces
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… Read More »Survey: Tabs or Spaces
Pre-Announcement Announcement
On Saturday, 27 June 2015, I will be presenting at SQLSaturday #407 in Vancouver BC. The session is titled “Restoring a SQL Server Database from… Read More »Pre-Announcement Announcement
- « Previous
- 1
- 2
- 3
- 4
- Next »