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.

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

by Amogh Natu

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

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

by mazhou

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

Always Encrypted Feature in SQL Server 2016

by Manjuke Fernando

Always encrypted feature in SQL Server 2016

Analyzing Dependencies in MSSQL

by Mel Padden

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

Auditing events on SQL Server 2008

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...

Auto-incremented ID with NVARCHAR/VARCHAR datatype

by Tejas Vaishnav

Auto incremented ID using VARCHAR data type

Azure – Creating an Azure SQL Database

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

by Sacha Barber

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

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

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

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.

Built-In Functions (SQL Server)

by essentialSQL

Basic concepts of built-In functions in SQL Server

Bulk Insert in .NET Applications: Part 1

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

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

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.

Change Tracking Example -SQL Server

by Neeraj Kaushik1980

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

Checking MS SQL Server database files default paths

by skydger

Checking MS SQL Server database files default paths.

Christmas Carol: XML Signatures

by Ivan Krivyakov

Christmas Carol: XML Signatures

Common Data Types used in SQL Server

by essentialSQL

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

Commonly used SQL Server Data Types

by essentialSQL

Commonly used SQL Server data types

Comparing the Performance of AppFabric Against SQL Server

by Ben Liebert

Comparing the performance of AppFabric against SQL Server

Computed Columns in SQL Server

by Manjuke Fernando

Computed columns in SQL Server

Configuring CRM 4.0 for SSRS Without the Data Connector

by David Truxall

Configuring CRM 4.0 for SSRS Without the Data Connector

Considerations for SQL Server on Linux

by Afzaal Ahmad Zeeshan

Overview of SQL Server on Linux

Copy a table using SQL Server Management Objects

by User 6619207

How to copy a table using SQL Server Management Objects

Counting Consecutive Dates Using SQL

by Tharaka MTR

How to count consecutive dates using SQL

Create a SQL Server Management Studio Extension

by Kevin Chadney

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

Creating a Database Project with Visual Studio

by Nadege Rouelle

How to create a database project with Visual Studio

Creating a Simple Sheet Designer in C#

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)

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

by essentialSQL

Introduction to cross join - create row combinations

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

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.

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

by Rohitmssqlfun

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

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

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

Data Purity Issue After Upgrading SQL 2000 to Later Versions

by Rohitmssqlfun

Data purity issue after upgrading SQL 2000 to later versions

Database Documentation with a Data Dictionary - Part 2

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

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

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

by Vivek Johari

Basic information about the different ways of creating a table

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

by Rohitmssqlfun

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

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

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)

by Manjuke Fernando

DROP IF EXISTS in SQL Server 2016 (DIE)

Easiest Way of Cancelling All SharePoint Workflows in Progress

by Raymund Macaalay

The easiest way to cancel all SharePoint workflows in progress

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.

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

by Raymund Macaalay

How to change collation of all database objects in SQL Server

EXCEPT vs NOT IN in SQL Server

by vinothharshad

Except vs Not In in SQL Server

Fixing SSDT Unresolved Reference to Object Error

by Rui Inacio

Fixing the SSDT unresolved reference to object error

Generate insert Statements from a Specific Table Data using SQL Server

by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

Generate script from Microsoft SQL Server Management Studio

by Sadeque Sharif

Generate script from Microsoft SQL Server Management Studio.

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

by PeteBarber

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

Generic Repository Pattern MVC

by Mayur V Lohite

Generic Repository Pattern MVC

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

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.

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

by essentialSQL

Introduction to Inner Joins in SQL Server

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

by essentialSQL

Introduction to Outer Joins in SQL Server

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

by essentialSQL

Grouping results returned from your queries using the GROUP BY clause

Get Ready to Learn SQL: 7. Simplified Data Modeling

by essentialSQL

Simplified Data Modeling in SQL

Good Practices for Starting with Containers

by Kevin Mack

Few ideas for strengthening micro-services architectures

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

by MBigglesworth79

SELECT @Variable vs SET @Variable in SQL-Server

Group concatenation in T-SQL using CTE

by Johan Ohlin

Group concatenation in T-SQL using CTE.

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

by essentialSQL

How to combine results from more than one table

How Do I Use the Like Clause in SQL Server?

by essentialSQL

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

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

by Rajat-Indiandotnet

How to easily unpivot pivot data in SQL Server

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

by zidane168

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

How to Archive SharePoint List Items to SQL Server

by Raymund Macaalay

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

How to Bulk Insert Efficiently

by Rui Inacio

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

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

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

by Vivek Johari

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

How to Fix Orphaned SQL Users

by Tharaka MTR

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

How to Multicast messages with SQL Server Service Broker

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

by rusanu

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

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

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.

How to Return Random Rows Efficiently in SQL Server

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?

by Rohitmssqlfun

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

How to Shrink SQL Server Database Log File

by Ghanshyam N Patel

How to shrink SQL Server database log file

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

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

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

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

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

by rusanu

A technique to make tables with columnstore indexes updateable

How to Use columnstore Indexes in SQL Server

by rusanu

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

How to use recursive CTE calls in T-SQL

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

by Dave C Andrews

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

How We Improved Database Code Quality

by Betclic Tech

How we improved database code quality

IDENTITY Property in SQL Server

by Vivek Johari

Identity property in SQL Server

Image Handling In ASP.NET

by raju melveetilpurayil

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

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

by Duy H. Thai

Some frequently-used methods for image handling in .NET

Index REBUILD vs. REORGANIZE in SQL SERVER

by Manjuke Fernando

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

Installation of SQL Server Express 2014 on Windows 10

by Mithun Pattankar

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

Installing SQL Server Data Tools (SSDT)

by Manjuke Fernando

How to install SQL Server Data Tools

Introduction to SQL Server Data Modification Statements

by essentialSQL

Introduction to SQL Server Data Modification statements

Introduction to SQL Server Views

by Vivek Johari

Introduction to SQL Server Views

Introduction to SQL Server’s Built-In Conversion Functions

by essentialSQL

Introduction to SQL Server's built-in conversion functions

Introduction to SQL Server’s Built-In Logical Functions

by essentialSQL

Introduction to SQL Server's built-in logical functions

Introduction to SQL Server’s Common String Functions

by essentialSQL

Introduction to SQL Server’s Common String Functions

Introduction to SSDT (SQL Server Data Tools)

by Manjuke Fernando

Briefly describing the features in SQL Server Data Tools.

Introduction to Stored Procedures for SQLServer

by essentialSQL

Benefits of stored procedures and how to create and execute them

Join Hint in SQL - Guest Post by Joydeep Das

by Kunal Chowdhury «IN»

Join Hint in SQL - Guest post by Joydeep Das

Keyboard Query Shortcuts In SQL Server Management Studio

by Sibeesh Passion

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

Learn about Stored Procedures

by essentialSQL

In this blog post, you will learn about stored procedures

Learn How to Calculate the Median Value using PERCENTILE_DISC

by essentialSQL

In this puzzle, we’re going to learn how to find the person whose birthday, among others, is in the middle.

Learn How to Work Joins and Messy Data

by essentialSQL

How to join dirty data using SQL Server

Learn to Use SQL Server Date Functions

by essentialSQL

How to use SQL Server Date functions

Learn to Use the Data Dictionary in SQL Server

by essentialSQL

In this puzzle, we’re going to learn how to query the data dictionary using SQL Server.

Load XML And Show As li In Angular JS

by Sibeesh Passion

How to load an XML file and show as li using ng-repeat in Angular JS

Log4j2.xml Tweaks

by Jameson Triplett

Log4j2.xml Tweaks

Making the Best Use Out of Maintenance Plans on SQL Server

by Raymund Macaalay

How to make the best use of the SQL Server Maintenance Plans

Map Data from Database Context to Excel Sheet using LINQ & Microsoft.Office.Interop.Excel

by Debopam Pal

Using Microsoft.Office.Interop.Excel library, you can bring your data from your database against LINQ query and store them into an Excel Sheet.

Mastering NULL value in SQL Server

by Vivek Johari

This article explain key concepts and best practices related to NULL value in SQL which help in mastering the NULL value in SQL Server.. The post Mastering NULL value in SQL Server appeared first on Technology with Vivek Johari..

Merge Data in SQL Server

by Nitin Singh India

Merge data in SQL Server.

Merge in SQL 2008

by PratapReddyP

Many a times we came across situation to merge records between two tables.

Merge Statement in SQL Server 2008

by Basavaraj P Biradar

The new Merge statement in SQL Server 2008.

Microsoft SQL Server Backups & Restore: Steps Explained

by Kelum W. Ganegoda

Microsoft SQL Server Backups & Restore: Steps Explained

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool

by Vivek Johari

Migrating SQL Database To Azure SQL Instance using Microsoft Database Migration Assistant (DMA) Tool Contents Introduction Microsoft Database Migration Assistant (DMA) tool Migrate SQL Server database To Azure SQL Instance using DMA tool Detecting the compatibility issues using Assessment Type

Migrating your SQL Server Workloads to PostgreSQL

by Shameel

This multi-part article series discuss migrating your databases, applications and services from SQL Server to PostgreSQL and discusses all the important information you need to be aware of, before beginning a migration project..

Migrating your SQL Server Workloads to PostgreSQL – Part 2

by Shameel

Part 2 of this multi-part article series compares SQL Server and PostgreSQL article, database structure, language differences, data type mappings, functions and operators and other important considerations for migration..

Migrating your SQL Server Workloads to PostgreSQL – Part 3

by Shameel

Part 3 of this multi-part article series discusses the actual migration process: Schema and data migration, ETL/ELT, Reporting & OLAP, Scheduling and Applications & Services migration.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 3 appeared first on The Developer Space..

Migrating your SQL Server Workloads to PostgreSQL – Part 4

by Shameel

Part 4 of this multi-part article series discusses Maintenance and Monitoring, High Availability, Load Balancing, and Replication and Environment Stabilization.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 4 appeared first on The Developer Space..

Migration from SQL Server 2008 to 2012

by Rui Inacio

Migration from SQL Server 2008 to 2012

Mirroring a SQL Server Database is not as hard as you think

by Raymund Macaalay

Easy and simple 11 steps to start mirrored SQL Server

Modifying GhostDoc XML Comment

by Mahmudul Haque Azad

A simple trick to add to custom node to the XML commenting.in GhostDoc

New Features for Database Developers in SQL Server 2012: Simpler Paging, Sequences and FileTables

by Andrei Ion Rînea

Simpler paging, sequences and FileTables in SQL Server 2012

New High-Availability/Disaster-Recovery Solution Provided by SQL Server 2012

by yuanfeng.ma

Availability groups (AG) is used for (remote) disaster recovery

Non Recursive CTEs Explained

by essentialSQL

In this article, we explore non recursive CTEs (Common Table Expressions). This is a broad class, and basically covers every form of CTEs except those that call themselves. This other class is called the recursive CTEs; they are covered in the next article.

Online non-NULL with Values Column Added in SQL Server 11

by rusanu

Adding a new non-NULLable column with default values to an existing table in SQL Server 11

Oracle Sequence Promotes Poorly Maintainable Code

by snorkie

Oracle tables have no built-in mechanism for auto numbering. Instead, you must create a separate unique Sequence object and use it each time a record is inserted into the database.

PostgreSQL 12: New Features and Enhancements

by Shameel

This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.. The post PostgreSQL 12: New Features and Enhancements appeared first on The Developer Space..

PostgreSQL finally gets Stored Procedures

by Shameel

This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.. The post PostgreSQL finally gets Stored Procedures appeared first on The Developer Space..

PowerShell: Extracting Persisted Workflow Instances to XML Files

by Steve Psaltis

Extract variables from a persisted workflow to debug an issue or to verify your persistence

Processing SQL Server FILESTREAM Data - Part 1

by Bob McGowan

Processing SQL Server FILESTREAM Data - Part 1

Processing SQL Server FILESTREAM Data, Part 4 - Readin' and Writin'

by Bob McGowan

In this final installment, we'll finally see some C# code that I used to read and write the FILESTREAM data.

Processing SQL Server FILESTREAM Data: Part 2 - The Setup

by Bob McGowan

Utilizing SQL Server FILESTREAM capabilities from .NET

Processing SQL Server FILESTREAM Data: Part 3 - Creating Tables

by Bob McGowan

Utilizing SQL Server FILESTREAM capabilities from .NET

Programmatically Enumerating, Attaching, and Detaching SQL Server Databases

by Mohammad Elsheimy

Programmatically Enumerating, Attaching, and Detaching SQL Server Databases via SQL statements and stored procedures

Progress Bar in Cell – Excel

by johnniealan

This article describes about adding progress bar in cell.

Query Optimization and the SQL Server Cache

by Rui Inacio

This article explains the main concepts involved and then the possible options to Clean the SQL Server Cache.

Query Plan Caching - My SQL Server Nightmare

by Martin Thwaites

If you have an issue with a slow part of a site after a large dataload, that you can't replicate after a DB restore, it's likely you could be dealing with a similar issue.

Query Plans in SQL

by essentialSQL

Query plans in SQL

Random Performance Findings

by Andrei Ion Rînea

Some performance tips

Random Value Per Row in SQL

by Jeremy Hutchinson

Update table rows with varying random values in SQL

Read XML with Descendants Method (XName)

by Pranay Rana

Understanding Descendants and avoiding misconception with this method

Repeating a SQL Row Based on a Value in a Different Column

by Manjuke Fernando

How to repeat a SQL row based on a value in a different column

Repository Generator

by jgauffin

Griffin DAL Generator – Take 2

Resource: Brad's Sure Guide to SQL Server Maintenance Plans

by Bryan O'Connell

Review of the ebook: Brad's Sure Guide to SQL Server Maintenance Plans.

Revisiting XML Configurations In Unity

by Gil Fink

Revisiting XML Configurations In Unity In the past I wrote a few tutorials about Unity application block. One of the things I wrote about was how to configure a Unity container using design time configuration.

RIA Services through Web Services

by Steve Maier

The same database and the same RIA Services can be used as a Web Service by using some simple additions to the setup of your project.

ROW LEVEL Security SQL SERVER 2016

by Rajat-Indiandotnet

Row Level security SQL Server 2016

Rowversion datatype in SQL Server: Track Which Rows Have Been Modified

by SonuKSingh

SQL Server: Track which rows have been modified

RPT to CSV

by Rick Bassham

A simple console application to convert the fixed-width output from the "Output to File" option in SQL Server Management Studio to a CSV file

Saving an Image to SQL Server

by Manjuke Fernando

How to save an image to a SQL Server table

SCALA : TESTING OUR CODE

by Sacha Barber

So last time we looked at how to use Slick to connect to a SQL server database. This time we look at how to use one of the 2 popular Scala testing frameworks.

Schedule a Daily Backup with SQL Server Express

by outcoldman

Schedule a daily backup with SQL Server Express

Securing data in SQL Server

by Vivek Johari

This article explained about measures for securing data in SQL Server at various levels to protect data from unauthorized access and breaches.. The post Securing data in SQL Server appeared first on Technology with Vivek Johari..

Serialization 101 - Part III: XML Serialization

by MBigglesworth79

XML Serialization

Serializing System.DateTime for SQL Server

by Gediminas Geigalas

Learn how to serialize System.DateTime for use in SQL Server stored procedures

Shrink All Databases on SQL Server

by Manas Bhardwaj

This post is intended to be used as a hack for developers to release some disk space. Please do not use on actual production environments.

Smooth Transactions with TransactionScope

by Rion Williams

Smooth transactions with TransactionScope

Solution to the MSSQL Server “Suspect”

by Shahriar Iqbal Chowdhury/Galib

Solution to the MSSQL Server “Suspect”

Solution: The WITH MOVE Clause Can Be Used to Relocate One or More Files

by Nitesh Kejriwal

The WITH MOVE clause can be used to relocate one or more files

Some Hidden Facts: Stored Procedure and Its Optimization

by Dinesh K Mandal

Some Hidden Facts about Stored Procedure and Its Optimization

SQL COALESCE Function and NULL

by essentialSQL

SQL COALESCE Function and NULL

by essentialSQL

SQL COALESCE function and how you can test for null, and when present, substitute it for another value

SQL DISTINCT Clause For SQL Server

by essentialSQL

SQL DISTINCT Clause For SQL Server

SQL Full Outer Join

by essentialSQL

Understanding SQL full outer join and its reconstruction through other join clauses

SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority

by pinaldave

SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority

SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement

by pinaldave

Swap Value of Column Without Case Statement in SQL Server

SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object

by pinaldave

Avoid Using Keywords as an Object

SQL SERVER – Database Properties – Number of Users

by pinaldave

SQL SERVER – Database Properties – Number of Users

SQL SERVER – Database Worst Practices – New Town and New Job and New Disasters

by pinaldave

Database worst practices in SQL Server

SQL Server – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name

by pinaldave

How to find column used in a stored procedure

Sql Server - How To Write a Stored Procedure in SQL Server

by Vivek Johari

Stored Procedure in SQL Server can be defined as the set of logically group of SQL statement which are grouped to perform a specific task. This article will describe the Stored Procedure in SQL Server and their benefits.

SQL Server – Primary Key and NonClustered Index in Simple Words

by pinaldave

Primary Key and non-clustered index in simple words

SQL Server – Puzzle – Statistics are not Updated but are Created Once

by pinaldave

SQL Server – Puzzle – Statistics are not Updated but are Created Once

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion

by pinaldave

SQL Server - SmallDateTime and Precision - a continuous confusion

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35

by pinaldave

Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35

by pinaldave

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35

by pinaldave

Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types

SQL Server - Undocumented Stored Procedure sp_MSforeachtable

by Nuno M. F. Gomes

I'm not an every day SQL Server user but I use SQL Server regularly since 7.0 version until the 2005 version (not yet tried 2008 in a serious way) and from time to time I still find some nice hidden gems.A few days ago I needed to created a cleanup script for an application and one of the t

SQL Server – What Exactly are UNION and UNION All?

by Arun Ramachandran India

What exactly are UNION and UNION ALL in SQL Server

SQL Server 2005

by puri keemti

SQL Server 2005

SQL Server and Duplicate Indexes

by Martin Thwaites

SQL Server and duplicate indexes

SQL Server and Duplicate Indexes

by Martin Thwaites

Finding and removing indexes in SQL Server is an excellent way to remove bottlenecks, especially if you've "inherited" the application.

SQL Server and Set Operations

by essentialSQL

SQL set operations

SQL Server Discovery Report

by Rohitmssqlfun

SQL Server discovery report

SQL Server Hierarchical Query using the hierarchyid Type

by essentialSQL

SQL Server Hierarchical Query using the hierarchyid type

SQL Server Performance Troubleshooting for Developers

by Markus Greuel

Some tips for developers who have to deal with a slow SQL server.

SQL Server Silent unattended installation using configuration file

by Rohitmssqlfun

SQL Server Silent unattended installation using configuration file

SQL Server Table Columns Under the Hood

by rusanu

SQL Server table columns under the hood

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

by aasim abdullah

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

SQL Server: Applying Filter on sp_MSforeachDB

by aasim abdullah

How to apply filter on sp_MSforeachDB

SQL Server: Controlling SQL Server Log Information

by aasim abdullah

How to control SQL Server Log Information

SQL Server: Disable Logon Trigger Using DAC to Resolve Login Problem

by aasim abdullah

Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.

SQL Server: How Local Variables Can Reduce Query Performance

by aasim abdullah

How local variables can reduce query performance in SQL Server

SQL Server: Placing Alert for Compatibility Level Change in SQL 2005

by aasim abdullah

In SQL Server 2005, there is no way to find out WHO AND WHEN someone changed the compatibility level of a database. Here is a trick for this functionality.

SQL Server: Query to find upcoming birthdays for the current week

by aasim abdullah

To find out whose birthday is coming in a given number of days is very simple.

SQL Server: Script to Generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space

by aasim abdullah

SQL Server: Script to generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space

SQL Server: Search Stored Procedure Create/Modify Date or Text using T-SQL

by Justin Cooney

How to search Stored Procedure create/modify date or text using TSQL

SQL Server: Simple way to swap column values

by aasim abdullah

A simple way to swap column values.

SQL Server: Smarter Way of Query Load Testing at Testing Server

by aasim abdullah

Smarter Way of Query Load Testing at Testing Server

SQL Server: Three Common DDL Change Log Methods

by aasim abdullah

Three common DDL change log methods for SQL Server.

SQL Server: Why we should avoid the NOLOCK table hint in DELETE/UPDATE queries

by aasim abdullah

Why we should avoid the NOLOCK table Hint in DELETE/UPDATE queries.

SQL Server’s LocalDB Database Engine

by Steve Naidamast

SQL Server's LocalDB database engine

SQL Server’s sp_executesql Does Not Protect You from SQL Injection

by Rob Kraft

SQL Server’s sp_executesql does not protect you from SQL Injection

SQL Truncate and Delete

by essentialSQL

Truncate and Delete in SQL

Store Images in SQL Server

by Madhur Kapoor

In this post, we will look at how to save images in SQL server.

Stored Procedure Naming Conventions

by My Tech World

It is recommended that stored procedures shouldn't be prefixed with sp_ for two simple reasons.

Stored Procedures – Another look

by Gediminas Geigalas

This article reviews how my opinion on Stored Procedures changed over time and what disadvantages they bring into your application.

Struggling with System.IO.Packaging when Creating a CLR Procedure

by Wendelius

System.IO.Packaging namespace in WindowsBase may cause problems when trying to create a CLR procedure.

Table Backups and the TableArchive Database

by Andrew Zwicker

A discussion of how a separate database is used for storing table backups.

Test Cases Statistics with SSRS and TFS Data Warehouse

by Anton Angelov

Tutorial how to create test cases statistics for the automation status and their distribution by priority. Steps how to setup SSRS and TFS Data Warehose.

Testing Entity Framework Applications: Part 1

by Thomas Weller

Testing Entity Framework applications - Part 1

The Bug That Got Away

by Rion Williams

Bug stories: Exposition, action, climax, resolution, or epic failures.

The Content Database has a Schema Version which is Not Supported by this Version

by Melick

How to copy your production SharePoint database to development environment

The SEQUENCE Object in SQL Server codenamed “Denali”

by mazhou

The SEQUENCE Object in SQL Server codenamed “Denali”

Three Tricks to Get More Out of SQL Server in Common Web Scenarios

by Leland Richardson

Several little-known SQL tricks/techniques used to improve query times and enforce business rules with common everyday web-development scenarios

Three-tier .NET Application Utilizing Three ORM Technologies

by Bryan Thomas Weikel

CodeProject"LEK" is a three-tier .NET WinForms accounting application that can be configured at run time to use either LINQ to SQL, Entity Framework or NHibernate to access data in either a "main" or "testing" SQL Server database.

Transfer Users from One SQL Server to Another Including SID’s the Easy Way

by Raymund Macaalay

How to transfer users from one SQL Server to another including SID's the easy way

TSQL Recursive Split Function

by Shahriar Iqbal Chowdhury/Galib

TSQL Recursive Split function

TSQL Split a String by Delimiter

by Shahriar Iqbal Chowdhury/Galib

TSQL split a string by delimiter

Uncommon SQL Server Data Types

by essentialSQL

Uncommon SQL server data types

Understanding CDC in SQL Server

by Vivek Johari

In SQL Server, Change Data Capture (CDC) is a powerful feature that tracks changes (inserts, updates, and deletes) made to. The post Understanding CDC in SQL Server appeared first on Technology with Vivek Johari..

Understanding how SQL Server executes a query

by rusanu

This article will help you write better database code and will help you get started when you have to investigate performance problems.

Understanding JOINs in SQL Server

by Manjuke Fernando

It's very important to know what sort of JOINs are available in SQL Server and where exactly we can use them, in order to produce accurate results.

Update Progress with AJAX UpdatePanel

by Kelum W. Ganegoda

This post demonstrates how to create an update progress with the UpdatePanel, similar to the one we can see in GMail.

Uploading the Files – HTML5 and jQuery Way!

by Afzaal Ahmad Zeeshan

Uploading the files - HTML5 and jQuery way

Use a SQL script to generate well formatted stored procedures in SQL Server

by Rob Kraft

Use a SQL script to generate well formatted stored procedures in SQL Server

Use SQL Server to Create a Cross Tab Query

by essentialSQL

In this puzzle, we’re going to learn how to create a cross tab query using SQL Server.

Use SQL to Calculate Median Values

by essentialSQL

How to calculate the median value using SQL

Use SQL to view Active Directory Data

by Raymund Macaalay

If you want an easy way of viewing objects in Active Directory, one good way of doing it is creating a view or stored procedure on SQL Server.

Use Subquery with Bill of Materials

by essentialSQL

In this puzzle, we’re going to learn how to work with the AdventureWorks Bill of Materials table. Companies use a BOM (Bill of Materials) to itemize the products that are used or contained in another product. Solving puzzles is a great way to learn SQL.

Using a Staging Environment for Tracking Down Bugs

by Andrew Zwicker

A discussion why having a staging environment with data that mirrors production is vital to tracking down issues.

Using Black Falcon Software’s SQL Server Source Control for Developers

by Steve Naidamast

How to use Black Falcon software's SQL Server source control for developers

Using Docker for Local SQL Server Development

by OwenDavies

This post outlines how to use Docker image for local SQL Server development.

Using Nightly Populated Tables for Faster SQL Queries

by Andrew Zwicker

A discussion about nightly populated tables and how they have reduced SQL Server load

Using the MERGE Statement in SQL Server 2008

by Manjuke Fernando

How to use the new MERGE statement feature in SQL Server 2008

WCF: Loose coupling of WCF Service and Data Contracts

by Sky Sanders

A strategy for implementing maintaining separation of concerns and implementation hiding.

What are the Different Types of Database Backups?

by derekman9707

Different types of database backups

What are the Major Parts of a SQL DB?

by essentialSQL

This post discusses the major parts of a SQL database

What are the SQL Server Management Objects

by User 6619207

About SQL Server Management Objects

What is a Database Trigger?

by essentialSQL

What is a Database Trigger?

What is a Dynamic Pivot Table?

by essentialSQL

In this puzzle, we’re going to learn how to create a dynamic pivot table using SQL Server.

What is a SQL Server Data Dictionary?

by essentialSQL

What is a Data Dictionary in SQL Server?

What is BI Semantic model (BISM) in SQL Server 2012?

by Shivprasad koirala

BI Semantic Model (BISM) in SQL Server 2012

What is the Difference between WHERE and HAVING Clauses?

by essentialSQL

Difference between WHERE and HAVING clauses

Why is My SQL Server Query Slow?

by Rion Williams

Troubleshooting SQL performance: identifying issues, optimizing queries, utilizing tools efficiently

Why Would You Use Common Table Expressions?

by Gaston Verelst

Why you would use Common Table Expressions

Working with SQL Server BLOB Data in .NET

by Mohammad Elsheimy

Binary Large Objects (BLOBs) are pieces of data that have -usually- exceptionally large size (such as pictures or audio tracks).

WPF: Merged dictionary parser depends on XML attribute order

by Ivan Krivyakov

Attribute order should not matter in XAML, but sometimes it does...

XML Databases

by AlexTatiyants

JSON-oriented document stores like Mongo and Couch have really become the darlings of the web application crowd. Of course, JSON (or BSON) isn't the only game in town. When it comes to document store formats, the other white meat if you will is XML.

XML Manipulation With XML Copy Editor

by Keyhole Software

XML Manipulation With XML Copy Editor