New Improved SQL Server 2019! Now with more Spark!
If your server racks are anything like mine, they look impressive and powerful, clean and efficient. From the front, that is. Look behind the rack and there is a tangled rat’s nest of power cables, network connections, and those big clumsy things connecting to KVM switches. It’s worse on the inside. Data platforms and software […]
Batch Mode Processing for Row Data in SQL Server 2019
Batch mode processing was introduced in SQL Server in 2012, the same time as columnstore indexes. The combination of the two prevented SQL Server from needlessly processing column values not needed by a query, as it must do in classic row processing. This processing mode also permits SQL Server to take better advantage of cache […]
SQL Server: Users Without Logins?
Anna P., a student in Learning Tree’s course 8420, Querying Data with Transact SQL, asks “What good is an SQL Server user with no login?”. No good at all, if you think of users just as people. Clearly, people need to login before they can use SQL Server. However, users can also be thought of […]
UTF-8 Support in SQL Server 2019
UTF-8 has been the predominant character encoding system for the world-wide web since 2009 and as of October 2018 accounts for over 90% of all web pages. As of October 2018, UTF-8 is not supported by Microsoft SQL Server. SQL Server 2019 will remedy this situation, as current SQL Server community technology previews illustrate. The […]
Artificial vs Surrogate Keys
Shakespeare famously asked “What’s in a name?” A great deal, as it turns out, since the words used to describe things affects how we perceive them and think about them. Perhaps it’s the rapid rate of change that makes technology particularly susceptible to the effects of how we use words to describe things. Terms too […]