Get Free Tips
MSSQLTips.com

Author: Dattatrey Sindol

Home » Archives for Dattatrey Sindol

Dattatrey Sindol (aka Datta) is a Business Intelligence enthusiast, passionate developer, and blogger. He started his career in November 2006 and since then has worked on various technologies including SQL Server BI, Power BI, Microsoft Azure, & Azure HDInsight within Microsoft Stack and other Cloud & Big Data technologies outside Microsoft Stack. Currently, he is working as an Associate BI Architect at a leading IT Services company in India (Bangalore).  Datta also is a Microsoft Certified IT Professional (MCITP) in SQL Server Business Intelligence 2008.

  • MSSQLTips Awards: Trendsetter (25+ tips) - 2014 | Author Contender - 2014

TitleCategoryDate
Query SQL Server Agent Job InformationSQL Server Agent2025-06-17
SQL Server Row Count for all Tables in a DatabaseScripts2024-12-30
Overview of Power BI Dashboards and Visualizations in the Cortana Intelligence SuitePower BI2017-02-21
Introduction to Azure HDInsight PowerShellBig Data2014-12-05
Getting Started with HDInsight – Part 1 – Introduction to HDInsightBig Data2014-11-26
SSIS XML Configurations Tips and TricksIntegration Services Configuration Options2014-09-03
Big Data Basics – Part 7 – Hadoop Distributions and ResourcesBig Data2014-08-14
Big Data Basics – Part 6 – Related Apache Projects in Hadoop EcosystemBig Data2014-06-20
Big Data Basics – Part 5 – Introduction to MapReduceBig Data2014-05-05
Big Data Basics – Part 4 – Introduction to HDFSBig Data2014-02-28
Big Data Basics – Part 3 – Overview of HadoopBig Data2014-01-30
Big Data Basics – Part 2 – Overview of Big Data ArchitectureBig Data2014-01-09
Big Data Basics – Part 1 – Introduction to Big DataBig Data2013-12-26
SSIS Connection Manager Tips and TricksIntegration Services Connection Managers2013-10-03
SSRS Report Manager Tips and TricksReporting Services Configuration2013-09-06
SSRS Tips and Tricks to Improve the End User ExperienceReporting Services Formatting2013-08-23
SSRS Expressions Tips and TricksReporting Services Development2013-08-08
Querying SQL Server Index StatisticsIndexing2013-06-21
Introduction to Data Explorer for ExcelMicrosoft Excel Integration2013-05-16
Creating Hierarchies in PowerPivot for ExcelMicrosoft Excel Integration2013-03-18
Working with Columns and Properties in PowerPivot for ExcelMicrosoft Excel Integration2013-03-08
Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for ExcelMicrosoft Excel Integration2013-02-25
Creating Linked Tables in PowerPivot for ExcelMicrosoft Excel Integration2012-12-31
Import SQL Data from Multiple Data Sources into PowerPivot for ExcelMicrosoft Excel Integration2012-12-26
Different ways to create Custom Colors for Charts in SSRSReporting Services Charts2012-10-31
Handling a Large Number of Categories in a SSRS Pie ChartReporting Services Charts2012-09-28
SSAS Interview Questions on Deployment, Processing, Querying, AccessProfessional Development Interview Questions BI2012-08-31
SSAS Interview Questions Aggregations, Translations, PerspectivesProfessional Development Interview Questions BI2012-08-24
SSAS Interview Questions on Measures, Actions, and StorageProfessional Development Interview Questions BI2012-07-16
SSAS Interview Questions on Dimensions, Hierarchies and PropertiesProfessional Development Interview Questions BI2012-05-11
SSAS Interview Questions Part II – DimensionsProfessional Development Interview Questions BI2012-04-10
SSAS Interview Questions Concepts, Data Sources, Data Source ViewsProfessional Development Interview Questions BI2012-03-28
Windows Services for SQL ServerSQL Server Configurations2012-03-23
Cumulative Aggregates in SSRSReporting Services Analysis Services2012-01-20

Categories

Recent Articles

  • SQL Parameter Sniffing Fix with a Covering Index

  • Format SQL Server Dates with FORMAT Function

  • SQL Server DROP TABLE IF EXISTS Examples

  • SQL Format Number with CAST, CONVERT and more

  • Random Number Generator in SQL using Marsaglia Polar

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide