Category: SQL Server

What is Keras? Keras is an API (Application Program Interface) originally designed to allow Tensorflow developers to focus their attention on the deep-learning problems of interest rather than concern themselves with minutia of how to implement their model in Tensorflow. Since its introduction, Keras has become popular not only among Tensorflow developers, but also among […]

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 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 […]

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 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 […]