By analyzing log-in attempts on SQL server, admins can build the complete picture out of the sequence of events that led to compliance failure or unauthorized access.

Auto Backup Of Database in SQL Server 2008 & Above

by Harsh Aggarwal - India

It's about making back up of database in SQL server 2008 and above you can get rid of making bak file manually.

Basic Troubleshooting for Microsoft SQL Table Lock

by NaibedyaKar

How to check the query locking the table and to unlock it

Check Network V1.0

by mohamedkamaleed

Network check v1.0

Checking convertability in SQL Server

by Saral S Stalin

Avoiding conversion errors in scripts using TRY_CONVERT.

Comparison Chart for Two Different Time Frames in SSRS

by Abu Zafor Khairuzzaman

Comparison Chart for Two Different Time Frames in SSRS

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

Create, Run, Debug and Deploy SQL CLR Function with Visual Studio 2013 Database Project

by Sunil_Pawar

Learn how quickly you can Create, Run, Debug and Deploy SQL CLR function using integrated features of Visual Studio 2013.

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

Creating a SSRS Report With Microsoft Dynamics CRM On-line

by coded007

Designing reports with Dynamics CRM

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.

Custom Paging using Ajax

by HardikPatel.SE

Paging using AJAX

Custom Paging using AJAX with Sorting

by HardikPatel.SE

Paging and Sorting with AJAX

Dutch postalcode Database with geolocations from BAG

by rafaelpb

Generate a postalcode database for lookups from dutch national data BAG

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

Execute an SSIS Package Through SQL Stored Procedure

by Bert O Neill

Execute SSIS Package in C# or SQL Sproc

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?

Fast and Simple IDataReader Implementation to Read CSV Files

by shijo joseph

A simple and fast CSV reader which you can directly use against Oracle and SQL Server databases or for any direct implementation

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.

Generate XML in ASP.NET MVC5 and AngularJs using Database Value

by Md._Mehedi_Hasan

This tip will help you to generate .xml file in AngularJs and ASP.NET MVC5 using XElement of C#.

Generating and Splitting a Delimited String Column

by Tharaka MTR

This article describes the easiest way to create and process delimited row using SQL XQuery.

Get accurate age by date

by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

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 Load Data Dynamically to Html Dropdownlist

by Member 11884108

In this tip, we will learn how to load data dynamically to html dropdownlist using Ajax call.

How To Send Mail Using SQL Server: Part 1

by Manish kumar choudhary

In this article, we are going to learn the concept of mail sending using SQL Server.

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.

Identifying and Deleting Duplicate Records from SQL Server Table

by Aqeeel

Identifying and deleting duplicate records from SQL Server Table

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

Implementing UserRights in Winform App using Menustrip

by SREENATH GANGA

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.

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

Money Precision Issues

by Bohdan Stupak

This tip shows some primary issue which puts a serious limitation on SQL Server MONEY data type.

Passing JSON Data to a CanvaJS Chart in ASP.NET MVC

by Xavi Giqwa

This tip is aimed at helping anyone who encounters a similar problem like I had in displaying charts using ASP MVC and dynamic data.

Performance Tuning of Insert Query

by Member 8826598

Performance Tuning of DML Operation Insert in different scenario

Pivot Operator in SQL Server Simplified

by Gaurav_Chaudhary

This tip is a brief introduction to Pivot operator in SQL Server

Pivoting on SQL Server Varchar Data Types

by Sifiso W Ndlovu

This tip illustrates a workaround to SQL Server pivoting on variable character data types.

Populate MainMenu Dynamically in VB.NET Using Recursion

by Mike_1989

The following code populates a mainmenu within VB.Net dynamically using recursion, until all items are added to the main menu

Quick Safe SQL Snippet

by groggyjava

SQL 2012 Code Snippet for quick blank transaction

Random Date/Time Test Data Generation

by Gene R. Browning

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

Read & Insert Data Using Stored Procedures in C#

by gayani dassa

Read & Insert Data Using Stored Procedures

Read Data from the Next Row

by george bolovan

Read data from the next row

Read XML Files and Insert into Database Table

by Gunaprasad Shetty

The tip provides the code snippet for inserting a huge XML file with details such as node level, node value, node desc and node child, etc.The snippet provides the solution for recursive reading of node and provides the value of XML nodes along with its value.

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.

Relational Database Design with an Auto Insurance Database Sample

by Prakash Lekhak

Create an ER diagram for complex database

Reset SQL Server SA (System Admin) Password

by Sarathi Balakrishnan

Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.

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

Sequence Object in SQL Server 2012

by sandeepmittal11

A sequence is a user defined, schema bound object that generates a sequence of numeric values

Setting deadlock priority in SQL Server

by Saral S Stalin

Explains how to run a script with higher priority to avoid it getting terminated in a deadlock situation.

Some Common Mistakes When Querying SQL Database

by Bohdan Stupak

This tip will cover several interesting issues of SQL

SQL Server - Linked Server Query - Unexpected Catastorphic Failure

by TheSqlGuy

This briefly goes over an issue experienced when executing a query against a linked server to Oracle from SQL Server.

SQL Server : How to Keep Database Restore History

by aasim abdullah

Backup and then restore of a database is a normal job for developers and DBAs. This script will be helpfull to findout, from which path, and which backup file a database was restored.

SQL Server 2012 Metadata

by Ajit Kumar Thakur Microsoft

This tip explains SQL Server metadata information. It will provide internal details of all available SQL Server 2012 Metadata.

SQL Server Database Backup and Restore in C#

by Syed Noman Ali Shah

How to take SQL server database backup and database restoration in C# using SMO

SQL Server Database Backup Status Report

by Dathuraj Pasarge

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

SQL Server Health Check Script with Powershell

by Atul_Kapoor

Perform SQL Server Instance health check simultaneously on more than one server using Powershell

SQL Server: Automatic Query Execution at Every Instance Startup

by aasim abdullah

Automatic query execution at every instance startup.

SQL Server: Bookmark Lookups, a Query Performance Killer

by aasim abdullah

You have place indexes but still queries are slow... are you facing bookmark lookup problem ???

SQL Server: Changed data capture without using Triggers

by aasim abdullah

How to use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement.

SQL Server: Doing String Split And Join

by DiponRoy

How to do string split and join in SQL Server

SQL Server: Find Table Order/Generation And Relation Details

by DiponRoy

A utility query to find table generations in SQL Server relational database

SQL Server: Keeping Log/Alert for Job Disable/Enable Status

by aasim abdullah

How do you know, if someone disabled your job at production database server. Who is the calprit. How to send a mail alert for this change ??

SQL Server: Query to Get the Date of First Monday of September

by Mohamad Cheaito

SQL Server: Query to get the date of first Monday of September

SQL Server: TOP…WITH TIES - A Beauty of TSQL

by aasim abdullah

The TOP clause is commonly used to get the top required rows from a result set. The beauty of this clause is that it can be used with the WITH TIES clause to retrieve all similar rows to a base result set.

SSRS Report Subscription using C#

by Sandeep Kumar Tripathi

This tip is used for creating SSRS Report Subscription by using C#.

Strategy for Separating UI and Back-end Code Development

by Giancarlo Rhodes

Creating the Web UI

Strongly Typed Stored Procedures for .NET

by dibley1973

Call stored procedures in a type safe way using my StoredProcedureFramework for .NET

Template to Handle Error in SQL Server

by Jitendra Ku. Sahoo

Below is one template to handle error in SQL server.