Rise of the Cognitive APIs

APIs for Machine Learning and Artificial Intelligence Almost paradoxically, software development tends to become easier the more advanced and sophisticated tasks become. In the recent past, AI development was a test not only of programming chops but also of the developer’s understanding of sophisticated algorithms. However, the explosion of interest in artificial intelligence in recent […]
Read More ›

Live SQL Server Data in Power BI: Using DirectQuery

For me, one of the most valuable features of Power BI is the ease with which I can mashup data from a variety of different data sources. This, of course, requires importing data into Power BI’s internal xVelocity engine. For many others, however, it is critical to create Power BI reports and dashboards that reflect […]
Read More ›

Deductive AI and SQL Server

Watson, IBM’s poster child for artificial intelligence, could not have been built using a single type of AI technology. This is hardly surprising. The intelligence needed to understand a question can differ quite dramatically from the intelligence needed to answer it. Indeed, upon understanding a question it takes intelligence to know what techniques are most […]
Read More ›

SET NOCOUNT ON Is More Important Than You Think

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 […]
Read More ›

SQL Server’s Graph Database for Contacts and Connections

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