As a product owner, you always worried about the different security aspects of your application and SQL Server Database is one of the main important parts for which you might worry.

SQL

Azure

SQL-Server

surface

Ad-hoc Pagination Support with SQL Server codenamed “Denali”

16 Nov 2010 by mazhou

Ad-hoc pagination support with SQL Server codenamed “Denali”

T-SQL

SQL

SQL-Server

Adding Items in Comma-separated String into Separate Rows in SQL Server

2 May 2013 by Amogh Natu

This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.

Always Encrypted Feature in SQL Server 2016

19 Oct 2016 by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Analyzing Dependencies in MSSQL

24 May 2011 by Mel Padden

A script that analyzes the text of each individual object and builds a tree of what depends on what.

SQL

SQL-Server

database

Auditing events on SQL Server 2008

28 Jun 2010 by Raymund Macaalay

If you want to audit what's happening on your SQL Server, then look no further. SQL Server 2008 has a built in function for that...

All-Topics

SQL-Server

Auto-incremented ID with NVARCHAR/VARCHAR datatype

19 Jul 2012 by Tejas Vaishnav

Auto incremented ID using VARCHAR data type

Azure – Creating an Azure SQL Database

27 Dec 2018 by Vivek Johari

Creating an Azure SQL Database Contents Introduction Creation of Azure SQL Database Step 1: Select Database Name Step 2: Select Azure Subscription Step 3: Choose Resource Group Step 4: Choose Database Source Step 5: Choose SQL Server Step 6: Choose Elastic Pool Option Step 7: Choose Service Tier for

Better WPF Circular Progress Bar

4 Jan 2010 by Sacha Barber

A while back I posted a blog post about a simple Circular Progress Bar that I did for WPF.

SQL

SQL-Server

Building a Better mouse-trap – Improving the Creation of XML Message Requests using Reflection, XML & XSLT

18 Jan 2013 by Paul S. Chapman

How to improve the creation of XML message requests using Reflection, XML and XSLT

Building a plug-in model to load VistaDB - Part II

22 Jun 2010 by JasonShort

Plugins are used in data applications to support more than one provider from a single codebase. The Provider Factories in ADO.NET is one such example, but you cannot work with the provider specific features when you use these factories since they only implement generic ADO.NET functions.

ADO.NET

All-Topics

SQL-Server

Built-In Functions (SQL Server)

11 Jan 2016 by essentialSQL

Basic concepts of built-In functions in SQL Server

SQL-Server

Bulk Insert in .NET Applications: Part 1

26 Mar 2012 by Rui Jarimba

This is the first of a two part series about how to perform bulk inserts in your .NET applications, using a SQL Server database.

C# SQL Injection Detection – Especially for Legacy .NET Code

7 Mar 2020 by Rob Kraft

The benefit of this approach is that you can then regularly scan your entire code base for the use of .ExecuteReader and .ExecuteNonQuery knowing that there should be no cases of those methods, other than the exception cases you expect.

C#. Static Cache and Multithreading

22 Sep 2017 by Anton Burtsev

A few months ago, I had to optimize web portal (classified ad). The portal was built on ASP.NET 1.1. It seemed that portal had two main problems. Here is how I solved them.

SQL-Server

ASP.NET

Change Tracking Example -SQL Server

1 Mar 2017 by Neeraj Kaushik1980

Following are the step by step instructions to enable and use the change tracking feature in SQL Server.

SQL-Server

Checking MS SQL Server database files default paths

18 Nov 2013 by skydger

Checking MS SQL Server database files default paths.

SQL

SQL-Server

Christmas Carol: XML Signatures

30 Dec 2015 by Ivan Krivyakov

Christmas Carol: XML Signatures

Common Data Types used in SQL Server

13 Mar 2019 by essentialSQL

Examples of common data types in SQL Server and how to define them

SQL

SQL-Server

Commonly used SQL Server Data Types

5 Jan 2016 by essentialSQL

Commonly used SQL Server data types

SQL-Server

Comparing the Performance of AppFabric Against SQL Server

19 May 2011 by Ben Liebert

Comparing the performance of AppFabric against SQL Server

SQL-Server

Computed Columns in SQL Server

29 May 2018 by Manjuke Fernando

Computed columns in SQL Server

Configuring CRM 4.0 for SSRS Without the Data Connector

15 May 2011 by David Truxall

Configuring CRM 4.0 for SSRS Without the Data Connector

SQL-Server

Considerations for SQL Server on Linux

18 Dec 2016 by Afzaal Ahmad Zeeshan

Overview of SQL Server on Linux

Linux

SQL-Server

Copy a table using SQL Server Management Objects

10 Aug 2010 by User 6619207

How to copy a table using SQL Server Management Objects

Counting Consecutive Dates Using SQL

17 Feb 2013 by Tharaka MTR

How to count consecutive dates using SQL

Create a SQL Server Management Studio Extension

2 Jul 2021 by Kevin Chadney

Creating a simple SSMS extension which accesses the query window and object browser.

SQL

SSMS

SQL-Server

Creating a Database Project with Visual Studio

2 Aug 2011 by Nadege Rouelle

How to create a database project with Visual Studio

SQL-Server

Creating a Simple Sheet Designer in C#

11 Apr 2010 by Mohammad Elsheimy

Give the user the flexibility to design his sheet, report, bill, invoice, whatever.

Creating Custom Key Store Provider for SQL Always Encrypted (Without Key Vault Example PoC)

16 Oct 2016 by Z Kavtaskin

How to create a Custom Key Store Provider for SQL Always Encrypted (Without Key Vault Example PoC)

Cross Join Introduction – Create Row Combinations

29 Dec 2016 by essentialSQL

Introduction to cross join - create row combinations

Cumulative Update – 8 for SQL Server 2008 R2 Service Pack 2 Is Now Available!

31 Jan 2014 by Rohitmssqlfun

The 8th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site.

SQL-Server

Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available!

29 Jan 2014 by Rohitmssqlfun

Cumulative Update – 9 for SQL Server 2008 R2 Service Pack 2 Is Now Available!

Windows

SQL-Server-2008

SQL-Server

Data Import from Excel File and Build an Automated Insert Script to Export into Excel File or to Export into SQL Server Table

21 Jan 2013 by MJ Ferdous

Data Import from Excel File and building an Automated Insert Script to Export into Excel File or to Export into SQL Server Table

SQL-Server

Data Purity Issue After Upgrading SQL 2000 to Later Versions

31 Jan 2014 by Rohitmssqlfun

Data purity issue after upgrading SQL 2000 to later versions

SQL-Server

Database Documentation with a Data Dictionary - Part 2

13 Jun 2011 by Andrew Zwicker

A continuation of the data dictionary discussion with information about how the documentation is done

Database Table Documentation with a Data Dictionary

10 Jun 2011 by Andrew Zwicker

Why table and column documentation is useful and some SQL for setting up the data dictionary tables

Deploying Full Stack ASP.NET Core with API and SQL Server Databases to Docker Containers

1 Dec 2022 by DotNetLead.com

Deploy existing ASP.NET Core UI, API, and SQL Server to Docker containers

Different Ways to Create a Table and Insert Data into the Table

17 Nov 2010 by Vivek Johari

Basic information about the different ways of creating a table

DMV-6: How Well Is My Stored Procedure Doing?

18 Apr 2013 by Rohitmssqlfun

This DMV allows you to discover a lot of very interesting and important performance information about your cached stored procedures.

SQL-Server-2008

SQL-Server

Do you know how to maintain your Google ranking while moving to a new site structure?

12 Jan 2010 by Martin Hinshelwood

From time to time your website structure may change. When this happens you do not want to have to start from scratch with your Google rankings, so you need to map all of your Old URLs to new ones.

DROP IF EXISTS in SQL Server 2016 (DIE)

24 Aug 2016 by Manjuke Fernando

DROP IF EXISTS in SQL Server 2016 (DIE)

Easiest Way of Cancelling All SharePoint Workflows in Progress

7 Nov 2013 by Raymund Macaalay

The easiest way to cancel all SharePoint workflows in progress

SQL

SQL-Server

Easy 8 Step HTML To SQL Data Transfer in a ASP.NET Web Form using jQuery, JSON, XML, Web Methods, node() Methods and Extension Methods.

7 Feb 2013 by Patrick Cunningham

This article uses 8 steps to create example of how to read and write from HTML to a SQL database in a .NET web application using jQuery, JSON, and XML.

Easy Way to Change Collation of All Database Objects in SQL Server

19 Dec 2011 by Raymund Macaalay

How to change collation of all database objects in SQL Server

EXCEPT vs NOT IN in SQL Server

10 Jul 2013 by vinothharshad

Except vs Not In in SQL Server

SQL-Server

Fixing SSDT Unresolved Reference to Object Error

21 Mar 2013 by Rui Inacio

Fixing the SSDT unresolved reference to object error

SQL-Server

Generate insert Statements from a Specific Table Data using SQL Server

27 May 2013 by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

Generate script from Microsoft SQL Server Management Studio

25 Oct 2013 by Sadeque Sharif

Generate script from Microsoft SQL Server Management Studio.

SQL-Server

Generating a SQL Server CE Database Schema from a SQL Server Database using Entity Framework

28 Jun 2012 by PeteBarber

How to generate a SQL Server CE database schema from a SQL Server database using Entity Framework

SQL-Server

SQL-CE

Generic Repository Pattern MVC

29 Apr 2016 by Mayur V Lohite

Generic Repository Pattern MVC

Get Ready to Learn SQL Server 20: Using Subqueries in the Select Statement

6 Feb 2015 by essentialSQL

This is the second in a series of articles about subqueries. In this article, we discuss subqueries in the SELECT statement’s column list. Other articles discuss their uses in other clauses.

SQL

SQL-Server

Get Ready to Learn SQL Server: 13. Introduction to Inner Joins

22 Oct 2014 by essentialSQL

Introduction to Inner Joins in SQL Server

SQL

SQL-Server

DBA

Get Ready to Learn SQL Server: 14. Introduction to Outer Joins

22 Oct 2014 by essentialSQL

Introduction to Outer Joins in SQL Server

SQL

dbase

SQL-Server

Get Ready to Learn SQL Server: 6 – Group and Summarize Your Results

29 Oct 2014 by essentialSQL

Grouping results returned from your queries using the GROUP BY clause

Get Ready to Learn SQL: 7. Simplified Data Modeling

23 Oct 2014 by essentialSQL

Simplified Data Modeling in SQL

Good Practices for Starting with Containers

2 Jun 2020 by Kevin Mack

Few ideas for strengthening micro-services architectures

Gotcha #121008: SELECT @Variable vs SET @Variable in SQL-Server

23 Oct 2012 by MBigglesworth79

SELECT @Variable vs SET @Variable in SQL-Server

SQL-Server

Group concatenation in T-SQL using CTE

15 Nov 2013 by Johan Ohlin

Group concatenation in T-SQL using CTE.

How Do I Combine Results from Several SQL Tables (Hint: There Are Three Ways)

14 Aug 2019 by essentialSQL

How to combine results from more than one table

SQL

SQL-Server

How Do I Use the Like Clause in SQL Server?

30 Dec 2017 by essentialSQL

In this video, we'll walk you through how to use the LIKE clause.

SQL

SQL-Server

How Easily You Can Unpivot the Pivot Data in SQL Server?

22 Apr 2018 by Rajat-Indiandotnet

How to easily unpivot pivot data in SQL Server

SQL-Server

How to "Monitor Data Changes in SQL Server Tables with Triggers"

7 Aug 2023 by zidane168

Use SQL triggers to keep track of the changes made to your data

How to Archive SharePoint List Items to SQL Server

4 Nov 2013 by Raymund Macaalay

This post will show you how to archive SharePoint List Items to SQL Server

SharePoint

SQL-Server

How to Bulk Insert Efficiently

23 Jul 2012 by Rui Inacio

To bulk insert efficiently, the SqlBulkCopy class must be used.

ADO.NET

SQL-Server

How to Connect ASP.NET Website to Remote Database for CRUD Operations

10 Jan 2015 by Afzaal Ahmad Zeeshan

An overview for connecting an ASP.NET website or a web application to a remote SQL Server database

How to Find Duplicate Values in a Table

16 Nov 2010 by Vivek Johari

This article will try to show how to find duplicate values in a table.

How to Fix Orphaned SQL Users

26 May 2013 by Tharaka MTR

This post will show you how to fix orphaned SQL users.

How to Multicast messages with SQL Server Service Broker

22 Jul 2011 by rusanu

How to Multicast messages with SQL Server Service Broker

How to pass a NULL value in a message to a queue in SQL Server

22 Jul 2011 by rusanu

How to pass a NULL value in a message to a queue in SQL Server

SQL-Server

How to Retrieve the File Size Used by a SQL Server Database on Hard Disk

17 Dec 2012 by Nitesh Kejriwal

How to retrieve the size of data files of all databases present in SQL Server and the actual amount used in these files.

SQL-Server

Dev

How to Return Random Rows Efficiently in SQL Server

2 Dec 2010 by Nadeem Afana

Illustrates an efficient method of returning random rows from a SQL Server database

How to Save Deadlock Graph Events as .xdl file in SQL Server?

19 Feb 2013 by Rohitmssqlfun

This post discusses how to save deadlock graph events as .xdl file in SQL Server.

SQL-Server

How to Shrink SQL Server Database Log File

2 Nov 2019 by Ghanshyam N Patel

How to shrink SQL Server database log file

SQL

SSMS

SQL-Server

How to Solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017

26 Jan 2013 by Shahriar Iqbal Chowdhury/Galib

This post shows you how to solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017

How to unit test SQL Server 2008 database using Visual Studio 2010

22 Aug 2010 by atverma

In this article I’ll discuss about unit testing SQL Server 2008 Database project using Visual Studio 2010.

How to Unit Test SQL Server 2008 Database Using Visual Studio 2010 – Part 2

23 Aug 2010 by atverma

In this article I will explore the important features that can be configured to build comprehensive database unit tests.

How to unit test SQL Server 2008 database using Visual Studio 2010 – Part 3

23 Aug 2010 by atverma

This is the last article of the series “How to unit test SQL Server 2008 database using Visual Studio 2010”.

How to Update a Table with a columnstore Index

15 Jul 2011 by rusanu

A technique to make tables with columnstore indexes updateable

How to Use columnstore Indexes in SQL Server

15 Jul 2011 by rusanu

A very simplified explanation of how column store indexes can be used

How to use recursive CTE calls in T-SQL

15 Nov 2013 by Johan Ohlin

How to use recursive CTE calls in T-SQL.

How to Use ROW_NUMBER() to Enumerate and Partition Records in SQL Server

31 Dec 2011 by Dave C Andrews

Use ROW_NUMBER() to enumerate and partition records in SQL Server

How We Improved Database Code Quality

4 Sep 2013 by Betclic Tech

How we improved database code quality

SQL-Server

IDENTITY Property in SQL Server

29 Aug 2010 by Vivek Johari

Identity property in SQL Server

SQL

Windows

SQL-Server

Image Handling In ASP.NET

2 Feb 2012 by raju melveetilpurayil

Explaining how to store,display, create thumbnails and add watermark on image

Image in C#: Save, Resize, and Convert to Binary

28 Apr 2010 by Duy H. Thai

Some frequently-used methods for image handling in .NET

Index REBUILD vs. REORGANIZE in SQL SERVER

16 Feb 2016 by Manjuke Fernando

What is the difference between Index REBUILD and REORGANIZE and when exactly should you use it

SQL-Server

Installation of SQL Server Express 2014 on Windows 10

6 Oct 2015 by Mithun Pattankar

Step by step process of installation of SQL Server Express 2014 on Windows 10

Windows

SQL-Server

Installing SQL Server Data Tools (SSDT)

3 Sep 2012 by Manjuke Fernando

How to install SQL Server Data Tools

SQL-Server

Introduction to SQL Server Data Modification Statements

4 Nov 2016 by essentialSQL

Introduction to SQL Server Data Modification statements

SQL-Server

Introduction to SQL Server Views

16 Nov 2010 by Vivek Johari

Introduction to SQL Server Views

Introduction to SQL Server’s Built-In Conversion Functions

2 Jan 2016 by essentialSQL

Introduction to SQL Server's built-in conversion functions

SQL

SQL-Server

Introduction to SQL Server’s Built-In Logical Functions

4 Jan 2016 by essentialSQL

Introduction to SQL Server's built-in logical functions

SQL-Server

Introduction to SQL Server’s Common String Functions

2 Jan 2016 by essentialSQL

Introduction to SQL Server’s Common String Functions

SQL

SQL-Server

Introduction to SSDT (SQL Server Data Tools)

20 Sep 2012 by Manjuke Fernando

Briefly describing the features in SQL Server Data Tools.

SQL

SQL-Server-2008

SQL-Server

Introduction to Stored Procedures for SQLServer

30 Dec 2017 by essentialSQL

Benefits of stored procedures and how to create and execute them

SQL-Server

Join Hint in SQL - Guest Post by Joydeep Das

29 Jan 2012 by Kunal Chowdhury «IN»

Join Hint in SQL - Guest post by Joydeep Das

SQL

SQL-Server

Keyboard Query Shortcuts In SQL Server Management Studio

12 May 2016 by Sibeesh Passion

Some shortcuts that may be useful to you when you work with SQL Server Management Studio

SQL-Server