Entity Sync Relationship - Master Data Services 2016
Entity Sync Relationship is a new feature in Master Data Services 2016. It enables you to share entity data between...
2015-08-27
1,497 reads
Blog Posts
Getting Started With Power BI Desktop: Simple Visualization
This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation...
2015-08-27
819 reads
I am not a “wogrammer”
So apparently the COO of Facebook is trying to make the word “wogrammer” – a woman programmer – a thing. (Thanks to...
2015-08-27
766 reads
Live Query Statistics
The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option...
2015-08-27 (first published: 2015-08-19)
2,712 reads
Reblog: Force installation of 64-bit ACE OLE DB provider
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2015-08-27
763 reads
Relational databases vs Non-relational databases
I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared...
2015-08-27
1,515 reads
SQLSat403 – Recap
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event...
2015-08-27
627 reads
SQLSat403 – Recap
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event...
2015-08-27
357 reads
Studying for the 70-462 Exam: Database Mirroring
If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...
2015-08-27 (first published: 2015-08-18)
2,400 reads
Using Power BI with HDInsight Part 1: Power Query and Files
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help...
2015-08-27
711 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers