Git Push in SQL Source Control
I’m excited. Git support is growing in SQL Source Control and the release recently contains Git push/pull support. If you...
2015-10-22
1,953 reads
Blog Posts
Histograms and Events
In this article I show how to use and configure the histogram target. In addition, I explain how to get to the data trapped into this target. Lastly, I...
2015-10-22
8 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
41 reads
Performance and using of VARCHAR boxes as filters in SSRS reports
Very few people have thought about this performance killer. It is all about report parameter of text type. The initial situation There was a table with about 45 million...
2015-10-22
42 reads
Step by Step SSIS–Derived Column Transformation TIP # 120
Dear Friends,
In the series of Step by Step SSIS , Zero to Hero in SSIS this is another post in which...
2015-10-22 (first published: 2015-10-18)
2,519 reads
Working with “special” names
What do you do when you need to use a special character in a name? Well, I guess I should...
2015-10-22 (first published: 2015-10-19)
1,509 reads
ZOOMIT!
Guilty.
I’m at least one of the people who yelled Zoomit during a keynote at PASS Summit.
I want to take a moment...
2015-10-22
567 reads
10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-10-21
486 reads
Consequences of Timeout/Error on a Delete statement
Hello Guys,
Lately, one of my friend asked me a Question, “If Delete is in progress and query get erred out or...
2015-10-21
459 reads
Goodness-of-Fit Testing with SQL Server, part 1: The Simplest Methods
By Steve Bolton
…………In the last series of mistutorials I published in this amateur SQL Server blog, the outlier detection methods...
2015-10-21 (first published: 2015-10-17)
2,530 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers