Why you should not use SELECT *
A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we shouldn’t use SELECT *, which… Read More »Why you should not use SELECT *
Home » Development »
Development
Repair SQL Server on Linux after an Ubuntu distribution upgrade
SQL Server 2017 is supported on Ubuntu 16.04 LTS (Long-Term Support), however that version of Ubuntu Linux is now more than two years old, so… Read More »Repair SQL Server on Linux after an Ubuntu distribution upgrade
Performance as a feature, software developer edition
Relational database management systems (RDBMS) like SQL Server and Azure SQL Database are very good at managing normalized data. Efficient storage and retrieval of data… Read More »Performance as a feature, software developer edition
Dates and Times in SQL Server: DATENAME()
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many similarities between DATEPART and DATENAME.… Read More »Dates and Times in SQL Server: DATENAME()
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed previously that some people have… Read More »Dates and Times in SQL Server: the problem with DATETIME
Dates and Times in SQL Server: more functions you should never use
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL Database using Transact-SQL (T-SQL). We… Read More »Dates and Times in SQL Server: more functions you should never use
Dates and Times in SQL Server: T-SQL functions to get the current date and time
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data types to help you design… Read More »Dates and Times in SQL Server: T-SQL functions to get the current date and time
Dates and Times in SQL Server: DATE
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and… Read More »Dates and Times in SQL Server: DATE
Dates and Times in SQL Server: SMALLDATETIME
Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds,… Read More »Dates and Times in SQL Server: SMALLDATETIME
Dates and Times in SQL Server: DATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and… Read More »Dates and Times in SQL Server: DATETIME
The cloud is not just someone else’s computer
A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether we like it or not,… Read More »The cloud is not just someone else’s computer
Introducing Azure Data Studio
(Last edited on 9 January 2020) Note: This was originally written for the book SQL Server 2017 Administration Inside Out, but did not meet the… Read More »Introducing Azure Data Studio
MySQL has this feature that SQL Server needs
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because MySQL is predominantly used for… Read More »MySQL has this feature that SQL Server needs
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
Locks, Blocks, and Isolation Levels
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… Read More »Locks, Blocks, and Isolation Levels
- « Previous
- 1
- 2
- 3
- 4
- Next »