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 ›

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 ›

Viewing the SQL Server Procedure Cache with DMVs

In the previous blog, we took a quick look at query plan caching using the classic but still serviceable syscacheobjects view. A serious journey of exploration into the SQL procedure cache must, however, begin with the dynamic management view sys.dm_exec_cached_plans. While this view does provide us with some interesting information in its own right, the […]
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.