Dynamically Changing Shapes in Power BI – Alternatives
NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used...
2017-02-16 (first published: 2017-02-08)
1,717 reads
Creating SQL Containers from a Dockerfile
I’ve been playing around with SQL containers on Windows Sever 2016 a lot recently and well, building empty SQL containers...
2017-02-14 (first published: 2017-02-08)
3,346 reads
Improve performance by replacing temp tables with memory optimized tables - Part 2
Follow my last post which can be found here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/), we discussed about replacing table variable by memory optimized table, this...
2017-02-13 (first published: 2017-02-08)
8,176 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 3: Updating, Adding, and Deleting…
This is the third article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON...
2017-02-07
27 reads
Team Productivity Practices – #TAPtips
Ensuring and maintaining team productivity practices is important for any organization, especially a small and growing team. The biggest part...
2017-02-07
440 reads
Not Quite Monday Morning SQL Break – February 7, 2017
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to...
2017-02-07
29 reads
Not Quite Monday Morning SQL Break – February 7, 2017
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late...
2017-02-07
985 reads
Does Query Store Pre-Allocate Space
I love the questions I get while I’m presenting because they force me to think and learn. The question in...
2017-02-14 (first published: 2017-02-07)
1,509 reads
Would You Still Love Linux If Windows Was Free?
How often is cost the deciding factor in the case of Windows vs Linux? And what if cost wasn’t a...
2017-02-07
398 reads
Dynamically Changing Shapes in Power BI
UPDATE: I also published a blog post using a DAX only approach. Check it out here.
Recently someone had a question...
2017-02-13 (first published: 2017-02-07)
2,985 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers