SQL-Server-2014

Great Reads

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

by Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

A Simple Example of Microsoft SQL Server Pad String

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

ADO.Net Connectivity using Stored Procedure and Output parameters

by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Amazon Web Services part 2 - Adding a database to your web site

by Matt Perdeck

Add a database to your web site on AWS with automatic fail over using RDS

Latest Articles

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

by Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

A Simple Example of Microsoft SQL Server Pad String

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

ADO.Net Connectivity using Stored Procedure and Output parameters

by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Amazon Web Services part 2 - Adding a database to your web site

by Matt Perdeck

Add a database to your web site on AWS with automatic fail over using RDS

All Articles

top

SQL-Server-2014

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

by Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

A Simple Example of Microsoft SQL Server Pad String

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

ADO.Net Connectivity using Stored Procedure and Output parameters

by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Apply Operator in SQL Server Simplified

by Gaurav_Chaudhary

This tip is a brief introduction to Apply operator in SQL server

CLR Stored Procedure in SQL Server

by Jignesh G Trivedi

This tip will help you to understand CLR procedure.

Create Insert SQL Statement from the Records in an Existing Table

by markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

Creating a SQL Server Database Project Use in Visual Studio 2012 and Use TFS for Version Control

by Diluka Wittahachchige

Creating SQL Server database project use in Visual Studio 2012 and maintain versions use in TFS

CURSOR in T-SQL

by Prakash Lekhak

Dynamic SQL to get the list Table names

Cursors Vs. Sets

by Sums Mohs Eds

A brief discussion of when to use cursors and when to use sets.

Dynamic Pivot Query in SQL Server

by Chetan Naithani

Transforming dynamic row-level data into columns

Easy Database Table Change History

by Johnny L Washington

Capture data changes in history table

Executing Stored Procedure with User Defined Table Type Parameter in Entity Framework Using EntityFrameworkExtras

by AshishShukla6

This tip describes step by step implementation of executing stored procedure having user-defined table type as a parameter in entity framework using EntityFrameworkExtras package.

Export Primary, Unique, Foreign Key and Default Constraints in SQL Server

by Anil kumar Bhardwaj

Export all the primary, Unique, Foreign key and default constraints from existing database

Extracting the filename from a full path in SQL Server

by OriginalGriff

Sometimes, you want to extract the filename (with or without the extension) from the full path of a file. It's easy in C# and so forth - just use the Path.GetFileName method. But what if you want it in SQL?

Fill factor in SQL server.

by Jitendra Ku. Sahoo

In this article we will discuss about fill factor and its effect on query performance.

Find the Size of Database mdf and ldf File in sql server

by Arvind Singh Baghel

I show a SQL query which finds the size of database mdf and ldf file in SQL Server.

Get accurate age by date

by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

How to Change Date Format in Crystal Report

by Mian Adnan

Using Microsoft Visual Studio Professional 2012, .NET 4.5 and Crystal Report Version regarding .NET 4.5 and VS 2012

How to Conditionally Filter the data in text file in Java

by Member 10843807

An example to illustrate how esProc Helps Process Structured Text in Java–Conditional Filtering

How to fix "LocalDB - Requested Login failed"

by Ed Nutting

How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"

How to place an even-numbered SSRS report parameter at the start of a new row

by Karsten Krug

A workaround for reporting services' missing ability to customize report parameter placement.

How to Split Microsoft SQL Server Table Row Data

by Md. Marufuzzaman

This tip shows you an easy way to split Microsoft SQL Server table row data.

Implement Split A/B pages in your ASP NET project

by TheCardProject.co.uk

Quickly set up the ability to serve up several pages and record which was served in SQL Server

Import CSV or txt File Into SQL Server Using Bulk Insert.

by Arvind Singh Baghel

Import CSV or txt File Into SQL Server Using Bulk Insert.

Integrate Google Analytic Data to Local Database using SSIS

by Asanka Perera

This process shows how you can integrate Google analytic data into your reporting server database in order to have daily reports and analysis to include data of your Google analytic account using a free available plugin for SQL Server Integration service called SSIS GoogleAnalyticsSource.

Microsoft SQL: Increase Existing Value In Row Or Add New Row If None Exists

by furytrader

Yes, Virginia, You Can Do This All With One Simple SQL Statement

Random Date/Time Test Data Generation

by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

Recursive CTE in SQL Server Simplified

by Gaurav_Chaudhary

This tip is a brief introduction to Recursive CTE in SQL Server and how to implement it.

Resource Governor Enhancements in SQL Server 2014

by CharlieBrown1433

Resource Governor Enhancements in SQL Server 2014

Restart a SQL Server Scheduled Job If Hanged

by anki.mathur

Restart hanged SQL Server scheduled job

Run Single Page Applications (SPA) Template using AngularJS, Web API, Owin Token Based Authentication and Mediator Design Pattern

by Ahmet AYDIN

This post describes step by step how to run a Single Page Application template using ASP.NET Web API 2 and angularJS and how to use Web Application Project whose name is Dalyan.

Running the SQL Script File By Using The System.Diagnostics.Process Class

by madhusudhanReddy

Running the SQL Script File

Save your Data from LDAP Injection Attack

by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

SQL Server Database Backup Status Report

by Dathuraj Pasarge

Know whether your databases are backed up successfully in the last 24 hours or not !!!