Data modeling in Power BI using XML file with Parent and Children nodes

[2017-Aug-08] Support for XML structured files as a data source has been available in Excel, then was introduced into the Power...

Exploring SQL Server With Powershell And SMO Basics

SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You...

How to be a bad interviewer

In the monthly SQL blogging party that is T-SQL Tuesday (brainchild of Adam Machanic), Kendra Little has invited us this...

I Hate Interviews – TSQL2sDay

This month’s T-SQL Tuesday is hosted by Kendra Little and is on the topic of interviews 
I hate interviews as an interviewee....

Interview Patterns and Anti-Patterns Combined

It’s that time again. T-SQL Tuesday. The monthly blog party started by Adam Machanic (b/t) seven and a half years...

Interviews and Oranges

What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/

The topic being: Interviewing Patterns and Anti-Patterns....

Learn How to Recover Deleted Records from SQL Server 2014

Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a...

Learn How to Recover Deleted Records from SQL Server 2014

Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their...

Microsoft Big Data Certification Exams

I previously blogged about Microsoft certification changes, and since then there have been some new Microsoft Big Data certifications exams released:
Already...

Power BI – Problem, Design, Solution (Text Search Slicer)

There is a video that walks you through the solution in depth, please find the video at the end of...