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.

Convert RTF to Plain Text (Revised Again)

by NightWizzard

Handling for hex expressions and the trailing '}'

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.

Dynamically Setting a Parameter from a C# Variable in Crystal Reports

by Kinyanjui Kamau

I have written this tip to help developers automatically set Crystal Report parameters from variables in code (WinForms) at report run time.

Get accurate age by date

by Md. Marufuzzaman

Get accurate age by date using MS 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.

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.

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.

SMO 101 - Getting all DB's

by bmckuhen

How to get a quick list of all DBs using SMO

Solution to annoying error 0029 - Cannot convert type 'T' to 'System.Data.Linq.Link'

by Itai Basel

Finally found a solution to the annoying LINQ to SQL dbml error: CS0029 : Cannot implicitly convert type 'int' to 'System.Data.Linq.Link'.

Using Effort - Entity Framework Unit Testing Tool

by Roger C Moore

This tip is a guide for using the Codeplex project Effort for testing Entity Framework applications without requiring the unit tests to actually hit the SQL Server database.