Archive for the ‘SQL’ Category

Get Sql Server 2012 Port and connection details

Introduction This article covers how to get the port Sql Server is connected to and its connection details So, 1035 is the port the sql server 2012 is listening to The same thing can be viewed from Network configuration Email this page

July 23, 2015 · Adi · No Comments
Tags: , ,  · Posted in: General, Sharepoint 2010, SharePoint 2013, SQL

Basics – Test DB connection with UDL

Introduction Recently my SharePoint application is giving error ‘cannot connect to configuration database’. When nothing wrong with the services, do the first basic test. Check if the server is able to connect to DB. If it is succeded then it might be service issue or debug further through ULS logs. Here is the very basics […]

April 8, 2015 · Adi · No Comments
Tags: ,  · Posted in: Basics, Sharepoint 2010, SharePoint 2013, SQL

All in one Best Practices in SharePoint Server 2010

Introduction This article summarize current knowledge and research from Microsoft Consulting Services and the SharePoint Server 2010 product team into a must-read quick reference for key design decisions and operational practices. Each article briefly describes the best practices for a particular environment or product area and provides links for additional reading. This is must read […]

March 29, 2015 · Adi · No Comments
Tags: , ,  · Posted in: Best Practices, Best Practices and Standards, Sharepoint 2010, SharePoint 2013, SQL

SQL Snippet – list all databases with size

SQL – Get the list of all the databases and their size The below script will give the list of all database with name and size of respective database Output Email this page

January 26, 2015 · Adi · No Comments
Posted in: Code Snippet, SQL

Entity Framework – Raw Sql Queries and Stored Procedure execution

Introduction SQL Code snippet how to run raw SQL query and Stored Procedure in Entity Framework Email this page

November 26, 2014 · Adi · One Comment
Tags: , ,  · Posted in: C#, Entity Framework, SQL

Data Tier Generator

Introduction I am really fan of any automation that will reduce development time. Sometimes simple things might take time though not complex. One good tool I came across is Data Tier Generator in CodePlex. Email this page

February 21, 2014 · Adi · No Comments
Tags: ,  · Posted in: C#, Code Snippet, SQL, Tools

Code Snippet SQL – Get total number of records count for all the tables

Introduction SQL Code snippet how to return total number of records count for each table in a database Email this page

February 21, 2014 · Adi · No Comments
Posted in: Code Snippet, SQL

Create Stored Procedures automatically for Database table

Introduction In this article we will see how to generate basic stored procedures (select, insert, delete, update) for a table in Sql Server automatically using script. This will certainly speed up your development. Email this page

February 20, 2014 · Adi · No Comments
Tags: , ,  · Posted in: Automation, SQL

SQL Injections

Introduction This post covers various ways to handle sql injections in sql server. SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution There are quite couple of ways and is advisable to implement checks to prevent application […]

January 16, 2014 · Adi · No Comments
Posted in: Best Practices, Security, SQL