Data-and-AI for Developers

AI Infused Apps- Access to Source Code & Demos

Check this blog post I wrote on building intelligent applications of the future now (with relative...

Date: 03/31/2018

PASS SUMMIT 2016 Pre-Con- "Immersion: Taking a Hands on Approach to Building Intelligence into Data Driven Applications"

In this modern era; applications must recover from user errors efficiently, must be optimized for...

Date: 09/17/2016

Windows Azure VM- Error: The Remote Computer that you are trying to connect to requires Network Level Authentication (NLA)

  Alright, this was an interesting issue! so thought of sharing with you all. It might come in...

Date: 07/06/2014

Find the Size of Azure Databases using Powershell

There is a T-SQL way of finding the size of the database and there are some public domain scripts to...

Date: 08/29/2013

[Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: The filename, directory name, or volume label syntax is incorrect. .

Few days back I got a question from one of the SQL DBA’s who was working on a SSIS project. The task...

Date: 08/14/2013

Error: SQL Azure “Grantor does not have GRANT permission.”

SQL Azure has few limitations when it comes to running T-SQL statements against the Azure User and...

Date: 07/25/2013

SQL Azure: Automated Database Export (Archived Post)- Please use automated-backup built-into Azure SQL Database

Great news for SQL Azure, looks like the feedback’s been heard. In July’s scheduled updates we...

Date: 07/23/2013

Optimal SQL MaxServerMemory Setting TSQL- All Versions (SQL 2005/SQL 2008/R2/ SQL 2012/SQL 2014CTP1)

I created a script sometime back for finding optimal MaxServerMemory setting using TSQL automation...

Date: 07/01/2013

Yellow Icon on the Plan Guides what does it mean?

One of my friend asked me about the “Yellow exclamation icon” on the Plan Guides and was curious to...

Date: 01/03/2013

SSL Security error [DBNETLIB]ConnectionOpen (SECDoClientHandshake())

This particular resolution is one of its own kind their could have been other possibilites for his...

Date: 08/12/2012

xp_sendmail query failing with Msg 17925, Level 16, State 1, Line 0

Problem Description Xp_sendmail task in SQL Serevr 2005 might not work on a cluster after upgrading...

Date: 08/12/2012

HA/DR Questions on SAN (Async/Sync) Replication

Note: The detailed analysis is based on Aysnc SAN replication. This email has a lot of information...

Date: 08/12/2012

Could not find any IP address that this SQL Server instance depends upon

Problem Description: After a NIC change of the Server there were issues with starting the SQL Server...

Date: 08/12/2012

"Microsoft document explorer" "cannot find one or more components. please reinstall the application"

Problem Description================You are trying to install Client tools on a standalone machine...

Date: 08/12/2012

Checklist for Double Hop issues {IIS and SQL Server}

Checklist for Double Hop issues and the tasks to be done to create the right set of Delegations for...

Date: 08/12/2012