Profile cover photo
Profile photo
Lalit Jain
73 followers
73 followers
About
Posts

Post has attachment
SSIS: Auto mapping Latitude and Longitude for an Address using Google API
If you are looking to generate Latitude, Longitude and other
information related to a particular address automatically through google Maps
api, given that you have an address (obviously) with the help of SSIS, you are
at safe hands. This logic is courtesy o...
Add a comment...

Post has attachment

Post has attachment

Post has attachment
Connecting different DBMS (MySQL, Postgres, Oracle) to Microsoft SSIS
Lately found that people are facing issues with connecting there databases to Microsoft SSIS who has only good support to its native SQL Server As a matter of fact, even though your machine is 64 bit, SSIS packages will not support the same architecture bec...
Add a comment...

Post has attachment
**
        Below script is an ideal PowerShell script to deploy
MasterPages or PageLayouts to SharePoint Online/ Office 365 This is been tested on Windows 10, Windows 8 platform and
works without issues Prerequisites: 1)       Copy
the script below in a .ps1 f...
Add a comment...

Post has attachment
Fine Tuning SQL Server for SharePoint Configuration (Best Practices for SQL Server Configuration)
MAX Server Memory Config Item Do not use Default Value Use Correct Standard Max Server Memory 2,147,483,647 MB (2 PB or 2048 TB. Basically means unlimited) Non-default upper bound, based upon the total
memory installed on the server. By default the Max
Se...
Add a comment...

Post has attachment
Top Solutions - Windows 8
Here are the top
Microsoft Support solutions for the most common issues IT Pros experience when
using or deploying Windows 8 or 8.1 (updated quarterly). 1. Solutions related
to installing Windows updates or hotfixes: Repair a Windows Image Fixing component ...
Add a comment...

Post has attachment
Connect to the SQL instance hosted on cloud (Azure and AWS)
Below table will give you an perfect example on how to connect SQL instances like Database and Analyasis service hosted on cloud Connection
Scenarios : SQL on AWS Connection
Type Prerequisite/Requirement Connection
using Client SSMS Recommendations @
...
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...
Wait while more posts are being loaded