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: Default sql server port, Sql Server Network Configuration, sql server port · 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: Test DB connection with UDL, UDL file creation · 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: SharePoint 2010, SharePoint 2013, SharePoint Best Practices · 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: Entity Framework, SQL, Stored Procedure · 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: DAL generator, Data tier generator · 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: Automation, SQL, Stored Procedure · 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