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.

SQL

SQL-Server-2012

DBA

Remove Duplicate Rows with CTE

14 Aug 2017 by Ehtesam Ahmed

This article gives you quick tip about how you can remove duplicate rows easily using common table expression in SQL

SQL

SQL Database Access

18 Mar 2019 by Martin Vorbrodt

SQL database access

MyMDb your local IMDB store

22 Jul 2013 by Paw Jershauge

Want your own movie database??? Download IMDB in 20 minutes.

How to Format Repeating Values in SQL Result Set

13 Oct 2016 by Wendelius

A little tip on how to format repeating values in SQL output using LAG function

SQL

SQL-Server

Dev

Continuous Integration and Delivery for Beginners (DevOps)

3 Feb 2019 by Thinira

Continuous Integration and Delivery with VSTS (Visual Studio Team Services)

How to Create SQL Server Database Project With Visual Studio

4 Apr 2021 by Rijwan Ansari

Learn about SQL Server Database Project (Template) available in VS

SQL Server: Doing String Split And Join

19 Feb 2019 by DiponRoy

How to do string split and join in SQL Server

Get Top X rows from a table

23 Feb 2012 by Mahmud Hasan

How to use variable in SELECT TOP SQL command

Concatenate rows with comma separated string

6 Dec 2012 by Ravi Tuvar

Concatenate rows with comma separated string in SQL.

SQL

SQL-Server

Difference Between Two datetime Values in Hours, Minutes, etc.

18 Sep 2015 by Wendelius

This tip shows how to calculate a difference between two datetime values and to express the difference in years, days, hours, minutes and so on.

How to remove duplicate rows in SQL Server 2005 when no key is present

20 Dec 2012 by Wendelius

This tip describes how to delete duplicate rows from a table that doesn't have a key.

SQL

SQL-Server

SQL-Server-2005

See the SQL Generated by LINQ

8 Apr 2011 by Henry Minute

Or, there's always Scott Guthrie's LINQ To SQL Debug Visualizer[^].[Edit]While I'm posting links there is a nice utility that can output the generated SQL to the Debug Window in VS written by Kris Vandermotten.You can get it here[^].To use it: MyDataContext db = new...

SQL

.NET

LINQ

Steps to install Microsoft SQL Server 2008 Express Edition (Standard or with Advanced Services)

9 Aug 2011 by Jesus Carroll

This brief article show how to install quickly Microsoft SQL Server 2008 Express Edition Standard or with Advanced Services

How to find a specific string from stored procedures, triggers and functions in database

4 Feb 2012 by RasikaLB

You can find queries to find a specific string from MSSQL Server

SQL

server

database

Split comma separated IDs to get batch of records through Stored Procedure

1 May 2013 by Nasser Malik

Split comma separated IDs to get batch of records through Stored Procedure.

SQL

ADO.NET

ASP.NET

T-SQL: Most Practical Split Function

11 Oct 2013 by Brad Joss

A SQL String Split function for the real world

Extract Image Files from Database Image Data

20 Feb 2014 by PallavSingh

Converting data column (contains OLE db image binary Format) to image file (.jpg)

Pivot Operator in SQL Server Simplified

7 Feb 2015 by Gaurav_Chaudhary

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

A Beginner’s Guide to SQL Server Stored Procedures: INSERT, UPDATE, DELETE & SELECT Examples

8 Jul 2015 by Rodrick Kazembe

This is a step by step SQL Server Stored Procedures tutorial for beginners with insert, update, delete and select examples.

SQL

SQL-Server

How to Publish ASP.NETCore MVC Web Application to IIS in Less Than 5 Minutes

1 Nov 2016 by O.Nasri

A good tutorial in how you can publish your ASP.NETCore MVC web application to IIS.

SQL TVP Made Easy

26 Apr 2018 by Mason Kuck

I walk you through how to make use Table-valued parameters with one value

SQL

.NET

The Evil That is "Select *"

2 Aug 2011 by thatraja

I'm using this way. SELECT * FROM VIEW. Consider the below Table has following fields(Including Non-display columns).Table...

SQL

Using SCOPE_IDENTITY with CommandBuilder and DataAdapter

23 Nov 2011 by Antonino Porcino

How to use T-SQL function SCOPE_IDENTITY() to retrieve inserted rows identity values with CommandBuilders and DataAdapters

SQL Server: How to Get All Indexes List With Involved Columns Name

17 Sep 2012 by aasim abdullah

Get all indexes list in detail, with their involved columns

Table Value Parameters, SQL Server 2008, and ASP.NET

17 Dec 2013 by Adittya Gupta

Table Value Parameters in SQL Server 2008 with ASP.NET.

SQL

.NET

ASP.NET

Money Precision Issues

15 Feb 2015 by Bohdan Stupak

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

SQL

SQL-Server-2012

SQL-Server-2008R2

Import Images to SQL Server using SSIS

26 Dec 2015 by sandeepmittal11

Import Images to SQL Server Database using SSIS

SQL

SSIS

Build a Calendar Without Pre-Existing Tables

31 Jan 2017 by #realJSOP

Using common table expressions to build data from thin air.

Improving Backup Performance

1 Oct 2018 by Satnam Singh CapGemini

Improving backup performance

Types Don't Match between the Anchor and the Recursive Part in Column...

28 Dec 2019 by Wendelius

How to overcome the error message "Types don't match between the anchor and the recursive part in column..." for varchar columns in a recursive CTE query

Freehand Drawing using Google Map and Spatial Search

15 Mar 2021 by Pablo A Martinez

How to use Google map and Spatial search to do freehand drawing

Get Column values as comma seperated string

19 Jan 2010 by Manas Bhardwaj

Ever wondered that how to get a comma (pipe or whatever) seperated result for a column in a table.The following statement show a simple example you can take as a starting point.Select (Stuff((Select ', ' + FName From Accounts FOR XML PATH('')),1,2,''))

SQL

Get Column values as comma seperated string

13 Apr 2012 by Elina Blank

Another option:declare @commaStringList varchar(max)set @commaStringList = ''select @commaStringList = @commaStringList + ', ' + CAST(ColumnName as VARCHAR) from MyTable -- remove leading commentif len(@commaStringList) > 3 set @commaStringList =...

SQL

Use of columns belonging to tables referenced on main query in a subquery

17 Feb 2011 by John Gathogo

Catastrophic results associated with unqualified use of columns belonging to tables referenced on main query in a subquery

Quick and dirty reporting solution using Excel

21 Apr 2011 by Oshtri Deka

SQL

MS-Excel

reporting

The Evil That is "Select *"

25 Jul 2011 by Rutvik Dave

I 100% agree with this.Another trick is *if possible* add audit columns at the time of creating/designing the database, i.e.:CreatedOnCreatedByLastModifiedOnLastModifiedByThis could prevent people from using Select *, because generally we don't display such information anywhere, and...

SQL

How to fetch data from the previous or next rows in the resultset

31 Aug 2014 by Wendelius

This tip demonstrates the use of LAG and LEAD functions in SQL Server.

SQL

SQL-Server

List blocking processes in SQL server

11 Oct 2011 by Chris Maunder

A quick script to enable you to find the processes that are blocking in SQL server

SQL

SQL-Server-2008

SQL-Server

Video Tip:- Improve SQL Server performance by using SQL server profiler

16 Oct 2011 by Shivprasad koirala

If you want to quickly get index suggestions and improve performance in SQL Server, then Profiler and tuning wizard is the first place to start.

MS SQL Scripts Runner

4 Apr 2012 by sluaghtered

Script Runner that can run multiple SQL script files on MS-SQL.

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

17 Aug 2012 by ManojKumar19

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

Check if a number is a power of 2 with Sql Server 2012

19 Jan 2013 by Wendelius

This tip shows how to get rows from a table where a field contains a number that is a power of 2 using LOG function.

Running a ClickOnce app as Administrator under Windows 8

21 Jul 2014 by Phil Jeffrey

How to run a ClickOnce app as Administrator on Windows 8 when the app includes a SQL Compact database

Entity Framework Code First Migrations Alternative

30 Jul 2014 by DiponRoy

How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first

Creating a SSRS Report With Microsoft Dynamics CRM On-line

12 Jun 2015 by coded007

Designing reports with Dynamics CRM

How to Calculate the Length of the Largest Text Value in Every Table Column

22 Nov 2015 by Daniel Miller

This tip shows how to display the length of the longest string value in every table and column in your database.

T-SQL

SQL

COALESCE in SQL Server

15 Nov 2015 by sandeepmittal11

COALESCE in SQL Server

T-SQL

SQL

ASP.NET 5 - Connect to SQL Azure Database

3 Jan 2016 by JoaoSousa23

Using MVC, Entity Framework, ASP.NET5 Scaffolding, and Azure SQLServer you can create a web application that stores your information on an SQL Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a SQL Azure Database

Freeing Locks on an Oracle Database

23 Jun 2016 by jonyj

Queries and commands to discover what's locking the database

SQL

Oracle

Selecting Valid Records

7 Dec 2016 by Wendelius

This tip demonstrates how to select valid records from a table that contains validity date limits.

SQL

SQL-Server

Dev

Amount to Words

18 Dec 2016 by NightWizzard

Convert amounts to their spoken equivalents

Four Pitfalls of SQL Processing with NULL Values

1 Nov 2022 by Tomas@PawSQL

How to cope with all scenarios regarding NULL value handling in your daily work

SQL

PostgreSQL

database

A better way to count(*)

8 Jun 2010 by basementman

Or, assuming your table has an index, you could do this "old-school" as:select MAX(rows) from sysindexes where id = Object_ID('{tablename}')

SQL

LINQ

SQL-Server

Counting the number of occurrences of one string inside another in SQL

3 Jul 2010 by Andrew Rissing

Using the pattern that Microsoft SQL Server Management Studio creates, it would be something along the lines of:IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[com_CountString]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))DROP FUNCTION...

SQL

Instantiating an SqlException

20 Apr 2011 by PIEBALDconsult

Using Reflection to instantiate a System.Data.SqlClient.SqlException

SQL

Time remaining of Database Shrink

19 Apr 2011 by wizardzz

Time remaining of Database Shrink

SQL

Always close your cursor

18 Oct 2011 by Elina Blank

To see the default value of the cursor scope:select * from sys.databases(if value of "is_local_cursor_default" is 0 then scope id global, otherwise it is local).The scope is GLOBAL by default (for compatibility reasons).To change default scope use following:ALTER DATABASE...

SQL

SQL-Server

Sorting column that contains string with numeric value

18 Nov 2011 by Md. Marufuzzaman

Sorting column that contains string with numeric value

SQL

server

Download SQL Server Sample Databases including SQL Server 2012

7 Jan 2012 by Dhananjay Kumar Upadhyay

Download SQL Server Sample Databases including SQL Server 2012

SQL

server

Sorting 'Total' After Data Values

1 Jun 2016 by PIEBALDconsult

Interspersing 'Total' rows among summarized data rows in the correct order

SQL

SQL-Server

Backup Stored Procedures in SQL Server

13 Sep 2012 by CorvetteGuru

Backup Stored Procedures in SQL Server.

SSIS 2008 drop last data row from *.csv or *.txt file while import data using SSIS DataFlow Task..

19 Feb 2013 by Rajesh Manjarekar

I found out that a possible cause is the difference between the SSIS 32 bits and 64 bits environment

Paging DataGridView in C# using LINQ

5 May 2013 by mohammad amiri

Paging DataGridView using LINQ in C#.

Updating records selected using information from another table

14 Jul 2013 by OriginalGriff

If you have two (or more) tables which are interrelated, you sometimes need to update the rows of one table, selected from information in a different table. This isn't difficult, but is can take a little think about.

SQL

Run All Subscription Reports At Once in SSRS Manually

5 Sep 2013 by Mubin M. Shaikh

Manually Run SSRS Scheduled Reports

Create CSV File in Microsoft SQL

27 Jan 2017 by Rajesh_K_Sharma

How to create CSV file in SQL

SQL

SQL-Server-2008

SQL-Server

Instead of Triggers in Object-Relational (O/R) Mapping

31 Mar 2014 by h_wiedey

Usage of instead of triggers in Object-Relational (O/R) Mapping

SQL

SQL-Server

Binding of Calendar Controls from Database

8 Mar 2014 by SanSkun

How to bind holiday list and information about those holidays from database

SQL

ASP.NET

How to Get Words Separated in a String Concatenated by Delimiter

14 Apr 2014 by Ankur .K. Vishwakarma

This tip shows you a T/SQL function to split a string concatenated by a delimiter.

Arbitrary parameters in SSIS for OLE DB

1 Jul 2014 by Ryszard Dżegan

How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.

Entity and Mapping Class Generator for EF

29 Dec 2015 by Daniel Miller

This tip provides a simple solution to automate the generation of entity and mapping classes for Entity Framework.

Effective Procedure for Updating Table Primary Key Values

2 Jan 2016 by Tore Olav Kristiansen

If you need to change values of db table primary keys during ordinary operations, you probably have a design flaw in your software. In extraordinary situations, it may however be necessary. This tip helps you do so.

SQL

Dev

DBA

PostgreSQL: How to Get 'serial' Value of the Inserted Record and Use with a Variable

18 Feb 2016 by debashishPaul

How to Get 'serial' value of the Inserted Record and Use with a Variable in PostgreSQL

Replace Cyrillic Letters with Visually Similar Latin Letters Using T-SQL

28 Oct 2016 by Pavel Sinkevich

If data source is populated manually, there is a typical problem: a mix of visually similar Cyrillic and Latin letters. This tip describes how to fix it.

Create Query Shortcuts in SQL Server Management Studio

31 Jan 2017 by saddam_msp