IoT Hub vs. Event Hub
There can sometimes be confusion, in IoT scenarios, between IoT Hub and Event Hub, as they can both be valid...
2017-02-08
348 reads
Deadlock priority
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who...
2017-02-17 (first published: 2017-02-08)
2,916 reads
Speaking at SQLSaturday Chicago – 600!
Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow, 600 SQLSaturdays! This one won’t let you down....
2017-02-08
6 reads
Speaking at SQLSaturday Chicago – 600!
Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow,...
2017-02-08
317 reads
Power BI Custom Visuals Class (Module 37 – Gap Analysis)
In this module you will learn how to use the Gap Analysis Power BI Custom Visual. The Gap Analysis visual...
2017-02-15 (first published: 2017-02-08)
2,420 reads
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,348 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,181 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
28 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
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers