The Advantages of Writing Stored Procedures

Perhaps the title should be the disadvantages of sending SQL batches from client applications. Many people think that the primary advantage to stored procedures arises from the fact that they are optimized and compile once and then remain in memory, hopefully to be used again and again. While this can be an advantage, there are […]
Read More ›

SQL Server! Now with Built-In AI!

Microsoft asserts that SQL Server is the first database with “built-in” artificial intelligence. Of course, no phrase suffers more definitions than “artificial intelligence”, so rather than quibble about AI, we’ll just take a look at the technologies that support Microsoft’s claim. Moving Machine Learning to the Server-Side Great excitement followed the introduction of the integration […]
Read More ›

MS Machine Language Server for Enterprise-Grade Analytics

R Server is dead! Long live Machine Learning Server! The introduction of Microsoft R Server with SQL Server 2016 was tremendously exciting for data scientists and analysts working with “Big Data”. When SQL Server 2017 was released, many were shocked to see that R Server was gone. They were, however, relieved to discover that R […]
Read More ›

Quick Guide to SQL Server Data Types

Like supporting actors and actresses who never enjoy the spotlight, data types in SQL Server play critical roles and yet rarely receive attention. In fact, selecting the best data types for columns is one of the most important decisions during SQL Server table design. For that reason, let’s take a few moments to review some […]
Read More ›

The SQL Server Interview Questions that Matter

If you’re worried about interviewing for a SQL Server job, here’s some advice from the former head of an IT department on what matters (along with examples from the three critical areas where you need to have answers ready). As an instructor for Learning Tree’s Querying SQL Server 2014 and 2016 courses, I’ve worked with […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.