SET NOCOUNT ON Is More Important Than You Think
Apr 24,
2018
Most seasoned SQL Server administrators and developers will tell you to include SET NOCOUNT ON in all your stored procedure code. The reason generally given is to turn off the unnecessary “n rows affected” message that appears so often in the Management Studio Message pane. However, the “rows affected” message is only the visible tip […]
SQL Server’s Graph Database for Contacts and Connections
Apr 17,
2018
What are Graph Tables? Amy J, a student in Learning Tree’s course 8463, Querying Microsoft SQL Server 2014 asks “I see SQL Server 2017 has a “graph database” feature. How does a graph differ from the old HierarchyID datatype?”. Good question, Amy. While the old hierarchyID datatype can represesnt, in a very simplistic way, an […]
The Advantages of Writing Stored Procedures
Apr 4,
2018
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 […]
SQL Server! Now with Built-In AI!
Mar 28,
2018
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 […]
MS Machine Language Server for Enterprise-Grade Analytics
Mar 23,
2018
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 […]