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.

Concatenate many rows into a single text string using SQL Server 2008

by Ramanujam Shankar

Using COALESCE function - concatenate many rows into a single text string output in SQL Server.

Concatenate many rows into a single text string using SQL Server 2008

by e-Lopes

How to concatenate many rows into a single text string using SQL Server 2008.

Concatenate many rows into a single text string using SQL Server 2008

by Sanjay K. Gupta

How to concatenate many rows into a single text string using SQL Server 2008

Concatenate many rows into a single text string using SQL Server 2008

by PIEBALDconsult

See also Stupid CTE tricks -- string concatenation[^]

Convert RTF to Plain Text (Revised Again)

by NightWizzard

Handling for hex expressions and the trailing '}'

Create a Sample SQL Database in Less Than 2 Minutes

by Pascal Ganaye

This SQL stored procedure creates a database from scratch with some meaningful content.

Creating SQL Joins in Simple Steps

by Sreedhar Puligundla

Simple steps to create SQL joins by using SQL Server 2008 Management Studio

Drop all Triggers belonging to any schema in MS SQL Server

by Matthew Taylor

How to remove Microsoft SQL Server triggers associated with a custom schema.

Dynamic ORDER BY with multiple criteria in T-SQL

by Bob Crowley

How to use a CASE statement in ORDER BY to avoid dynamic SQL

Find Missing Date Ranges in SQL Server

by Ramanujam Shankar

Find missing date periods from a table.

Find Sp from database which is related to(using) table XXX

by Pranay Rana

Problem : - During project development I got the requirement that I have to modified the column name of the table which is used in the no of procedure i.e i have to found all procedure related to that table and modify it For the above problem following are the solution that i used First ...

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 Set Default Value or Binding for BLOB DataTypes on SQL Server

by Wonde Tadesse

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

How to setup database versioning tool RoundhousE

by Rohan Kishor Garud

RoundhousE (RH) is a database migrations engine that uses plain old SQL Scripts to transition a database from one version to another.

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.

How to update a row with another row if column values are null in SQL

by ManojKumar19

Update row column with another row column in same table SQL only if it is null.

How to Use Office365 Email with SQL Server 2000

by MAW74656

This is a drop-in solution that mimicks the functionality of xp_sendmail (including query results), without installing Outlook on the 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.

Locate SQL Server Instances on the Local Network

by Constantin Chumak

This is an alternative for "Locate SQL Server instances on the local network"

Number of different ways to get total number of rows from tables

by Pranay Rana

Getting a SQL Server RowCount Without doing a Table Scan

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.

Random Date/Time Test Data Generation

by Gene R. Browning

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

Read a file using transact-sql.

by Md. Marufuzzaman

How easy to read a file without using of the seven extended stored procedures.

SMO 101 - Getting all DB's

by bmckuhen

How to get a quick list of all DBs using SMO

Split function in SQL

by Gauri Chodanker

SQL function in SQL

SQL Group by With Joins

by Pranay Rana

How to use Group By clause when joining to table Let's consider one scenario where I have two table employees (contains employee detail) and sales (contains infomation about sales done by employee).Structure of...

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 StringPadding (String function)

by Surender Singh (CodeToastDev)

Custom StringPadding functions for SQL Server

The Best Table Finder (The BestCube Problem)

by BharatRamV

Finds the Best Table for a given set of columns

Translating ANSI Column into Unicode (Arabic Code Page)

by Emad Sammour

Mapping table is used in the translation - output in Unicode (nvarchar)

Write error log in a text file for Custom Assembly being used in Reporting Services

by alifaraze

writing error in a text file is very easy but writing error from a custom assembly in reporting services requires permissions