FUN – Self-Assessment of your social presence in fb using Power BI

If you read the title of this post & were wondering, What the hell is that ? , Trust me I have no clue how I made this up but I felt it would be an appropriate title when someone wants to perform data analysis on their fb data to understand how much active they… Continue reading FUN – Self-Assessment of your social presence in fb using Power BI

My book on SQL on Azure succintlly released

I feel extremely excited to share the latest release of my book on SQL on Azure Succintly with Syncfusion publications which talks about the deployments of SQL Server to Azure. You can download the latest version of the ebook from the following link http://www.syncfusion.com/resources/techportal/details/ebooks/sqlazure In recent years, we have witnessed how information technology has contributed… Continue reading My book on SQL on Azure succintlly released

Disabling Non-Clustered Columnstore Index doesn’t appear to execute in Stored Procedure in SQL 2012

Consider the following scenario, you have a large fact table with non-clustered columnstore index. In SQL 2012, Columnstore index is not updatable hence at night when you load or purge the table, the first step would be to disable non-clustered columnstore index followed by insert/update/delete to the table and the final step would be to… Continue reading Disabling Non-Clustered Columnstore Index doesn’t appear to execute in Stored Procedure in SQL 2012

Added Auto Indexing & Indexing Mode parameters in Add-DocumentCollection Cmdlet

Couple of weeks back I released Powershell cmdlets for DocumentDB in Github (Further info on this can be found in my blog here). Today I merged & added  Automatic Indexing & IndexingMode parameters to the Add-DocumentCollection Cmdlet to the project in the module. https://github.com/savjani/Azure-DocumentDB-Powershell-Cmdlets Azure DocumentDB collections are auto-indexed by default allowing the developers  to… Continue reading Added Auto Indexing & Indexing Mode parameters in Add-DocumentCollection Cmdlet

Releasing Powershell Cmdlets for Azure DocumentDB in Github

Azure DocumentDB is Microsoft’s new budding NoSQL Schema Free database offering which is relatively a recent addition to the mammoth Microsoft Data Platform Stack. Azure DocumentDB provides great flexibility to the Developer world who feels a lot restricted with RDBMS data model, adhering to the data types, schema, index designs & patterns. Azure DocumentDB gives… Continue reading Releasing Powershell Cmdlets for Azure DocumentDB in Github

Ungrouping Column using DAX in PowerPivot or SSAS Tabular

To start this blog post, let me first explain the problem. Consider a scenario where you receive an excel sheet or data in the following format Category SubCategory Bikes Mountain Bikes Road Bikes Touring Bikes Components Handlebars Bottom Brackets Brakes Chains Cranksets Derailleurs Forks Headsets Mountain Frames Pedals Road Frames Saddles Touring Frames Wheels Clothing… Continue reading Ungrouping Column using DAX in PowerPivot or SSAS Tabular

Where to host my SQL Server Instance ? (On-premise v/s Azure)

Enterprises now has four options to host SQL Server in environment SQL Server on Physical Machines SQL Server on VMs in DataCenters SQL Server on Azure VMs (IaaS) SQL Server on Azure SQL Database (PaaS) The following presentation can be used as a reference to decide on where to host your SQL Server Instance

SQL Server AlwaysON Group Failover in Cluster causes Node to lose network connectivity

Last week, I worked on an issue which might sound weird or strange when you hear it for the first time. “Whenever we fail SQL Server AlwaysON Group from Cluster, Node A loses its network connectivity.” (Sounds weird, Right ???) Here is the email which I received from my customer We’re able to re-create the… Continue reading SQL Server AlwaysON Group Failover in Cluster causes Node to lose network connectivity

Consideration for changing the default port of default SQL instance on Multi-subnet Failover Cluster

Security Hardening or Security Audits in an enterprise are some of the motivation for DBAs to run SQL Server default instance on a non-default port. For standalone instances, there are no challenges in changing the default instance port to non-default port, however for clustered instance there are some considerations since cluster.exe performs IsAlive check by… Continue reading Consideration for changing the default port of default SQL instance on Multi-subnet Failover Cluster