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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana 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...
Author: Tara Shankar Jana Date: 08/12/2012