Power BI Custom Visuals Class (Module 35 – Box and Whiskers (Jan Pieter))
In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual. This...
2017-01-31 (first published: 2017-01-24)
1,754 reads
What Is Your Career Investment Portfolio?
Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes...
2017-01-23
737 reads
Useful #SQLPrompt Tips
One of the tools that Redgate write is SQL Prompt. This might be my favorite product, and I’m constantly impressed...
2017-01-23
710 reads
How to Exclude Entire Sections in VS Schema Compare
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the...
2017-01-23
6,242 reads
SQL Server 2016: JSON integration
Abstract
This article helps to explain the application of JSON data and the use of new SQL 2016 constructs that enable...
2017-01-23
5,409 reads
Data About Execution Plans
If you look at the Properties for the first operator of a graphical execution plan, you get all sorts of great...
2017-01-23
534 reads
Analysis of DBA professionals salary’s 2017 using PowerBI
On the 5th of January, Brent Ozar (b|t) launched a survey on “Tell Us What You Make: The 2017 Data Professional...
2017-01-23
424 reads
Creating a connect entry.
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...
2017-01-30 (first published: 2017-01-23)
1,127 reads
Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,048 reads
Bad Idea Jeans: Query Optimization Through Minification
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...
2017-01-23
225 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