Power BI and Excel options for Hadoop
Below I have attempted to list the various options for reporting off of Hadoop (HDInsight, HDP, Cloudera) using Power BI...
2017-03-09
581 reads
Embrace The Missing Index DMVs - But Proceed with Caution!
One of the performance tools I use all of the time is the set of Missing Index DMVs: · sys.dm_db_missing_index_details– Detailed...
2017-03-22 (first published: 2017-03-09)
4,166 reads
Metadata Hygiene
Those who follow my blog know that I write a lot about data quality. Measuring and improving the quality of...
2017-03-09
426 reads
Create a DACPAC to Move Databases–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-08
949 reads
Identifying a row’s physical location
While you may not need to worry about the physical location of a row very often, every so often the...
2017-03-08
522 reads
Review of Azure Fundamentals class on Openedx
My company has recently adopted a Cloud first attitude. Now that’s different from Microsoft’s Cloud first. Microsoft is putting new...
2017-03-08
516 reads
SQL Browser, what is it good for? Absolutely something!
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-08
450 reads
Exporting Container Images
I’ve already covered how to push images to the Docker hub here but what if we only want to share...
2017-03-08
418 reads
Implementing Fuzzy Sets in SQL Server, Part 9: Measuring Nonspecificity with the Hartley Function
By Steve Bolton
…………Imagine how empowering it would be to quantify what you don’t know. Even an inaccurate measure might be...
2017-03-08
560 reads
SQL Server Continuous Deployment "In a Box"
What is this?
Well if you read the name aloud "SQL Server Continuous Deployment in a box" then, if I have...
2017-03-07
479 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Tanah Abang Blok B Telp:0821°8200°233
Telp/Wa 628218200233 Gedung Pasar Tanah Abang Blok B Lantai 5 Kios Nomor 3, 5,...
Alamat BCA KCP Juanda III Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Ir. H. Juanda 3 No.34, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Jembatan Lima Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Kh. Moch Mansyur No.15 F, RT.4/RW.1, Duri Sel., Kec. Tambora, Kota...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers