Etikett: SQL Server

User-defined scalar functions (scalar UDFs) provide SQL Server developers with an excellent means to organizer and re-use code. Unfortunately, these benefits often come at the price of poor, and in many cases horrendous, performance. Froid is a technology arising from Microsoft Research that addresses these performance problems with novel optimization techniques. In SQL Server 2019, […]

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

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

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

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