Click here to Skip to main content
13,900,747 members


Great Reads

by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
by Tom Archer
A class to dynamically read data from any ODBC data source
by Jovan Popovic(MSFT)
Complex properties in entity Framework models such as arrays, dictionaries, and objects can be serialized in SQL Server database in JSON format. In this article I will show you how to map your properties in EF model to database columns that contain JSON.
by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

Latest Articles

by Minh Tuan Do
A considerable method to speed up query running time
by John-ph
Microservices sample architecture for .NET Core Application
by essentialSQL
In this video we’ll walk you though the common data types used in SQL Server; you’ll see examples of each type’s values, and how to define them.
by Rajat-Indiandotnet
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.

All Articles

Sort by Updated


24 Mar 2019U
Minh Tuan Do
A considerable method to speed up query running time
10 Mar 2019N
Azure Logic APPS – A Simplest Way to Automate Your Business Process
3 Mar 2019
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.
14 Feb 2019
This is a complete guide to install SharePoint in a three server farm using AutoSPInstaller
3 Feb 2019
SharePoint 2016 Installation using AutoSPInstaller Online - how to set up the environment and service accounts
27 Jan 2019
How to resolve the issue: AppFabric installation failed because installer MSI returned with error code: 1603
10 Jan 2019
Andi Kleinbichler
Illustrates the implementation of a .NET Core app, running in a Linux container, connecting to a SQL Server database with integrated security.
9 Jan 2019
Vivek Johari
This article discusses the step by step process of point in time restore for Azure SQL database, Azure automatic backups as well as database backups retention period.
3 Jan 2019
Document SQL Server Databases with CatFactory.UI
30 Dec 2018
Add Debug/Release deployments to SQL Server database projects using build events and powershell
26 Dec 2018
This article shows a custom SQL Server function to split a string delimited by a character or a set of characters. The function also contains a few handy enhancements.
19 Dec 2018
In this article, the creation of dynamic pivots are explained. This works on SQL Server from version 2005 and above!
11 Dec 2018
Vivek Johari
This article “SQL Triggers – An Introduction” will give you the detailed knowledge about the SQL Triggers which can be very helpful in your work.
25 Nov 2018
Vivek Johari
This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.
19 Nov 2018
Vivek Johari
Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents
17 Nov 2018
Terence Wallace
A brief article on how to utilize NBA Stats API in a WinForm application
13 Nov 2018
Vlad Neculai Vizitiu
ASP.NET Core 1.1 and Identity Adventures
13 Nov 2018
Vlad Neculai Vizitiu
LINQPad - a developer’s best friend
8 Nov 2018
Srinivasa Dinesh Parupalli
Importing Documents from SQL Server to Azure Cosmos DB
5 Nov 2018
Jovan Popovic(MSFT)
In this article, I will show you how to create powerful REST API with just a few lines of C# code using MsSql.RestApi package. If you follow this approach, it might be a huge time saver for you.
24 Oct 2018
Creating Web API in ASP.NET Core 1x
9 Oct 2018
Akhil Mittal
The intent of this article is to explain the concept of entity framework core, code first migrations and data annotations in entity framework core.
6 Oct 2018
Vincent Maverick Durano
A step-by-step demo on how to build and dockerize ASP.NET Core and Blazor apps on MacOS.
1 Oct 2018
Redgate Software
This article describes a few of the important planning considerations, and then provides a simple walkthrough of how our team brings an existing database under version control using SQL Source Control.
28 Sep 2018
Redgate Software
This article explains some simple steps to create a GitHub database repository and get your database code in there, using SQL Source Control.
28 Sep 2018
Redgate Software
This article presents a method that allows us to use SQL Provision to build consistent, compliant, useful databases, on demand, for development and test environments.
26 Sep 2018
Redgate Software
This article describes what was required of our database source control solution, the challenges we faced and how we approached them, and how using Redgate SQL Source Control as a template helped.
11 Sep 2018
Steven L. Wentworth (12896862)
Using combination arithmetic to improve quality of SQL table design and execution
29 Aug 2018
Micah Nikkel
SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.
17 Aug 2018
Narapareddy Shyamprasad
SQL Dynamic Pivots
26 Jul 2018
Dathuraj Pasarge
Mirroring setup without any DBA effort - on every new DB creation on the SQL Server !!!
18 Jul 2018
Robert Crockett
Use safe Destructive Editing techniques to load a SQLITE table
6 Jul 2018
Manjuke Fernando
How to replace sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities
18 Jun 2018
Dan Letecky
Weekly HTML5 event calendar with CSS themes, drag and drop support, date navigator. PHP/AJAX and ASP.NET MVC backends.
7 Jun 2018
Gunnar S
Third article in a series of three regarding NServiceBus, WebAPI and Azure Service Fabric
5 Jun 2018
Artem Moroz
Simple utility for creating backups of SQL Server databases on a schedule
4 Jun 2018
Shayne P Boyer
Why should we care about containers for development
10 May 2018
Stefan Timovski
A short tutorial on how to get started with creating SSMS extensions
2 May 2018
Shashangka Shekhar
In this post, we will get an overview and generate a basic level code using our database table column that will help in development.
30 Apr 2018
Ryan G Conrad
Using Powershell and Windows Task Scheduler API to detect malicious login attempts on a remotely accessible SQL Server database
19 Apr 2018
Michael Abramovitch
A flexible way to generate unique numbers for things like invoice numbers
12 Apr 2018
Saineshwar Bageri
In this article, we are going to learn how to create a simple API in Node.js and using MS SQL as a data source on which we are going to perform CRUD operation.
26 Mar 2018
Ryan G Conrad
More configurations and auditing tools
25 Mar 2018
Ryan G Conrad
Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL
25 Mar 2018
Ryan G Conrad
Additional logging and data collection
27 Feb 2018
Create and run jobs kinda like SQL Server Enterprise - Users Guide
10 Feb 2018
Changming Wang
A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar
9 Feb 2018
Viral Surani
Snapshot Isolation Level in SQL Server
7 Feb 2018
This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems. This is done by enabling snapshot isolation.
6 Feb 2018
Viral Surani
To make sure your read data won't be altered during the current transaction.
1 Feb 2018
Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
30 Jan 2018
Quest Software
If you wanted to ramp up database DevOps, which development tasks would be most important for you?
10 Jan 2018
Amir Jalilifard
In this article, you are going to learn about P2P Network and Windows Communication Foundation to share your files between peers through a P2P network.
3 Jan 2018
Member 11127135
The ETL Process and Range Lookups
21 Dec 2017
Miguel Diaz Kusztrich
A database tool for search text in procedures, views and tables using regular expressions
11 Dec 2017
Steven L. Wentworth (12896862)
Straightforward generation of and ensuring accuracy for DimDate values.
14 Nov 2017
Haroon Ashraf
This article helps beginners to generate over million records of random test data for a database object like books in SQL.
5 Nov 2017
The XDLStarViewer application is a database viewer for the XDLStar Database System. It is designed to facilitate the creation of an XDLStar database, creation of its tables, and entry of its data. 
30 Oct 2017
Theo Kand
An original AngularJS implementation of the most famous video game ever
24 Oct 2017
Sreekanth Mothukuru
Create a Data-Tier Application Package (DacPac) to easily manage, deploy and deliver chronological database changes onto multiple environments
22 Oct 2017
You're still concern about what is the modern software architecture at the moment? You're searching around to the Best software architecture for applying for your project. Go deeply into this article, it's going to help you answering by your own.
11 Oct 2017
Vincent Maverick Durano
This article is the first part of the series on Getting Started with Entity Framework Core. In this post, we will build an ASP.NET Core MVC application that performs basic data access using Entity Framework Core.
30 Sep 2017
John Simmons / outlaw programmer
Create and run jobs kinda like SQL Server Enterprise - The CSV and Excel Importer Code
30 Sep 2017
John Simmons / outlaw programmer
Create and run jobs kinda like SQL Server Enterprise - Job Scheduling Code
30 Sep 2017
John Simmons / outlaw programmer
Create and run jobs kinda like SQL Server Enterprise - How Packages Are Run
30 Sep 2017
John Simmons / outlaw programmer
Create and run jobs kinda like SQL Server Enterprise - Interesting Coding
30 Sep 2017
John Simmons / outlaw programmer
Create and run jobs kinda like SQL Server Enterprise - Architecture and design decisions
19 Sep 2017
Igor Krupitsky
Application lets you copy tables from Paradox to SQL Server
7 Aug 2017
Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code?  You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!
26 Jul 2017
Ed Wiebe
Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?
17 Jul 2017
Vadim Loboda
How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
10 Jul 2017
This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
13 Jun 2017
Adam O'Neil (Travelers Rest, SC)
Introduction to Postulate, a code-first ORM for SQL Server made with Dapper
6 Jun 2017
This article explains how to use data source for representation of data in TreeView structure using ASP.NET MVC and Gijgo treeview JQuery plug-in, The TreeView control can display a hierarchical (or nested, or recursive) collection of data in a tree of expandable nodes.
2 Jun 2017
A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format
29 May 2017
Tomáš Bauer
Capture of a Typical SQL Server Database Workload
24 May 2017
Zahid Nawaz Ch.
SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.
23 May 2017
Alejandro Xalabarder
An efficient and flexible layout mananger.
19 May 2017
Christian Luketa Kanyinda
This article will allow you to govern your resources and to control them to optimize your server
18 May 2017
Securing table data at column level using AES-128 encryption
12 May 2017
In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.
7 May 2017
Michael Lockwood
This article illustrates how to call a web service using SQL Server Integration Services (SSIS), store the XML results in a SQL Server database table then query the XML using XQuery.
1 May 2017
1 alternative  
This article explains the problem, when another transaction (concurrent or not) accidentally overwrites previously modified data and how to prevent this from happening.
16 Apr 2017
Vadim Loboda
A way to deliver more details about an error or exception from an SQL Server database through an ASP.NET web application to a web client.
31 Mar 2017
Alternatives to using procedural loops in Transact SQL, demonstrated by examples.
21 Mar 2017
Dave Clemmer
Mo+ is the first technology that fully supports model oriented development, allowing software developers to powerfully scale the work they already do.
14 Mar 2017
You can create database driven .Net Core applications using JavaScriptServices, and PrimeNG.
13 Mar 2017
Keep the view state out of the web page and store it in SQL Server
9 Mar 2017
How to keep your SPA code DRY! Why shouldn't everything be code first? Code-first database and code first code! ASP.Net Core tag helpers can kick start your SPA to create HTML and Angular 2 dynamically from your data model. Source now includes VS2015 and VS2017 versions.
7 Mar 2017
Data transfer tools to transfer data and database scripts between two SQL Server databases.
14 Feb 2017
Download files using T-SQL server which is very much faster then any other option.
9 Feb 2017
Redgate Software
A case study where Republic Bank introduced Redgate SQL Compare; the industry standard for comparing SQL Server schemas and creating deployment scripts in minutes.
7 Feb 2017
Jovan Popovic(MSFT)
This article describes how to get messages sent to Azure Even Hub and load them into Azure SQL Database using Azure Functions.
6 Feb 2017
Anuja Pawar Indore
Multi-Tenancy means same instance shared amongst all customers.
30 Jan 2017
Dan Letecky
How to build an AJAX Event Calendar (Scheduler) using the open-source DayPilot Lite for ASP.NET MVC library (Apache License 2.0).
25 Jan 2017
Nesreen Maged
Angular 2 Type Script Custom Controls Integrated with ASP.NET Core web API
20 Jan 2017
Ole Oren
Fast and simple REST development for SQL devs
18 Jan 2017
Jovan Popovic(MSFT)
Complex properties in entity Framework models such as arrays, dictionaries, and objects can be serialized in SQL Server database in JSON format. In this article I will show you how to map your properties in EF model to database columns that contain JSON.
16 Jan 2017
Dan Letecky
Create an AJAX monthly event calendar (with drag and drop support) displaying data from SQL Server database in just 10 minutes (including a coffee break).
9 Jan 2017
Dan Letecky
Day/week AngularJS event calendar/scheduler with drag and drop support. PHP and ASP.NET MVC backends.
16 Dec 2016
Daniele Fontani
that is the question. A comparison between these two technologies and some tips to chose the best that suits your needs.
11 Dec 2016
Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
8 Dec 2016
Kuv Patel
Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server
8 Dec 2016
Kuv Patel
A quick and simple way of generating POCO classes and EF mappings for database tables.
6 Dec 2016
This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.
25 Nov 2016
This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.
8 Nov 2016
Instructions on how to migrate existing XAF security system to new permission policy.
4 Nov 2016
Few CLR procedure concepts to write into a file from SQL Server database
31 Oct 2016
Generic data manager provides thread specific IUnitOfWork repository tailored for your entities and takes care of all the plumbing and cleaning in a thread safe way.
26 Oct 2016
A simple explanation of the recursive CTE concept of T-SQL
18 Oct 2016
Discussion and a few approaches how to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure.
9 Oct 2016
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
8 Oct 2016
Shamim Uddin
In this article, we are going to learn how to get geolocation address by using Google geolocation API in ASP.NET Web API.
4 Oct 2016
Martin Lachman
How to create a system on MS SQL Server for detection of actual changed records in a database table.
3 Oct 2016
Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
23 Sep 2016
Lee Stott
The Microsoft Data Science Virtual Machine jump starts your analytics project. It enables you to work on tasks in a variety of languages including R, Python, SQL, and C#.
22 Sep 2016
Alexandros Pappas
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
21 Sep 2016
Use SQL Server to manage completely databases backups, network copy and deletion using only stored procedures
18 Sep 2016
Using SSRS report, generate the PDF, save it into DB and send it through mail using C#
17 Sep 2016
Snorri Kristjansson
A SQL server CLR Stored Procedure that can query the Active Directory directly in T-SQL code
12 Sep 2016
Redgate Software, Dan Nolan
In this article, I’m going to show you how you can continue using EF Code First to model your database, while also using ReadyRoll to do the actual deployment of T-SQL change scripts and overcome the challenges of the Code First approach.
7 Sep 2016
Emanuel Santos
In this article i will show how to create a basic application to detect and recognize faces using EmugCV.
2 Sep 2016
Microsoft .NET 4.5 introduced new "async and await" methods to provide an easy way of implementing asynchronisity using .NET tasks objects.
1 Sep 2016
SQL Server database project creation using Visual Studio 2013
26 Aug 2016
sajidur rahman
This article describes about CSV/Excel File import in SQL Server with common problems.
26 Aug 2016
Neeraj Prasad Sharma
This article deals with performance difference with literal values
24 Aug 2016
Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
20 Aug 2016
SQL Server 2016 - Security Feature - Always Encrypted
18 Aug 2016
Vincent Maverick Durano
A quick demo that highlights how to upload and import CSV file to SQL Server database in ASP.NET WebForms.
16 Aug 2016
Alexandros Pappas
An SQL script to see the table hierarchy in a database.
16 Aug 2016
Suvendu Shekhar Giri
We'll see how sensitive data in SQL Server 2016 can be masked from outer world using Dynamic Data Masking.
26 Jul 2016
Dahal Mahesh
Migrate cold data from your table to Microsoft Azure for cost effective and efficient storage of data, without any code level changes.
17 Jul 2016
Richard Drizin
Simple structure for keeping SQL Server Auditing Tables and Versioned Records in the same set of tables, using Audit Triggers and Entity Framework
12 Jul 2016
When considering to use NOLOCK hint, there are a few things that should be kept in mind.
8 Jul 2016
Jovan Popovic(MSFT)
In this article you can see how easily you can easily expose your database data via REST services developed using ASP.NET Core Web API and new JSON support in Azure SQL database and SQL Server 2016
6 Jul 2016
Sreekanth Mothukuru
The idea is to implement the latest and first of its kind “Always Encrypted” feature provided by Microsoft SQL Server 2016 designed to encrypt/decrypt sensitive data on back-end database engine
4 Jul 2016
Shashangka Shekhar
In this article, we are going to explore the security issue which will help us to prevent unauthorized access of web API access using custom Authorization Filter.
16 Jun 2016
Jovan Popovic(MSFT)
In this article is shown how to easily compare two rows in SQL Server using new JSON functionalities.
28 May 2016
Aless Alessio
Reat time Spreadsheet, updating and retrieving data through a Web Service. Using SQL Server DB.If two or more users are working on the same spreadsheet, they can see what the other users are doing. Mouse pointing is highlighted by filling the cell with diagonal stripes, while data saved is highlight
27 May 2016
Rednet Software
Rednet.DataAccess is yet another component to work with data that simplifies your use.
14 May 2016
POCO generating application for SQL Server
7 May 2016
Explain how to use a SQL CLR function to overcome the limitation of a standard SQL user-defined function to execute ad-hoc SQL query.
2 May 2016
Android on Intel
In this article, I will talk about applications’ good performance and three developers’ behaviors that prevent it.
28 Apr 2016
Sharad Chandra Pyakurel
Generic repository application of employee with documents
26 Apr 2016
Jose Segarra
Support routines for handling JSON in SQL Server
22 Apr 2016
Emmanouil Gimissis MSc ICSD
Calculating progressive sums in
19 Apr 2016
Ankita Biswas Bhattacharya
Here, I will explain how you can work with SQL views in lightswitch and how you can save data on screens which are created on Views.
12 Apr 2016
How to bring CSV and XML data into MS SQL server
12 Apr 2016
Having not ONE but TWO Identities in a single SQL Server Table
5 Apr 2016
SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.
27 Mar 2016
Manish kumar choudhary
In this article, you will learn how to select data from a table and send that data to an email using SQL Server 2008.
26 Mar 2016
Mahesh Rajaram Shinde
This project is designed for addressing SQL Server Script deployment on multiple servers and databases.
21 Mar 2016
Dan Letecky
How to display AJAX Gantt Chart in ASP.NET application.
17 Mar 2016
Daniel JXHV
No more ORM, EF, A Stored Procedure direct Access framework for JavaScript.
7 Mar 2016
Importing Excel & Delimited Files into a Junk Database
3 Mar 2016
Eric Lapouge
An other way to export data from a SQL-Server to use them to call a web service
3 Mar 2016
Gene R. Browning
Get a quick look at your data characteristics using this tool.
2 Mar 2016
Akhil Mittal
Enterprise level application architecture with Web APIs using Entity Framework, Generic Repository pattern and Unit of Work.
23 Feb 2016
Sreekanth Mothukuru
In this article, we are going to look at one of the most useful features in Visual Studio that is often ignored or to be frank, many people don’t even know about its existence. We are going to look at Free SQL Server Schema Comparison Tool in Visual Studio 2013.
21 Feb 2016
Abdullah Al-Muzahid
This is a RAD tool which can be used to generate codes for CRUD operation in ASP.NET and C# automatically based on Database Model Diagram.
10 Feb 2016
Jesus Carroll
SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.
3 Feb 2016
Useful things to know for developers put in charge of an MS database server
27 Jan 2016
Jörgen Andersson
A propertymapping extension for DataReaders
26 Jan 2016
Bert O Neill
Develop your own SSMS ObjectExplorer\CommandBar menus, within SQL Server 12
24 Jan 2016
This is an alternative for "SMO Tutorial 3 of n - Scripting"
23 Jan 2016
Shashangka Shekhar
In this article we will get a short overview on AngularJS, then we will create a ASP.Net MVC-5 CRUD application using AngularJS(v1.4.8).
22 Jan 2016
Kevin Griffin
Why could there not be another tool that allowed a development team to harness their existing source control systems, but make database changes a part of the workflow? Enter SQL Source Control by Redgate.
9 Jan 2016
Snorri Kristjansson
Active Directory change auditing solution. A Windows Service that stores selected AD change events from the Security log of all Domain Controllers to an SQL database.
30 Dec 2015
Daniel Miller
This article describes standard naming conventions for tables and columns, and it provides code that leverages the conventions to visualize dependencies and automatically validate and generate foreign key constraints.
15 Dec 2015
A sample infrastructure project such as erp, mrp, crm, admin panel.
13 Dec 2015
Miljan Radovic
Script to generate DimDate for specified date range
11 Dec 2015
Jovan Popovic(MSFT)
In this article, you will see how to compress data in SQL Server using GZip algorithm and send it via node.js to browser.
8 Dec 2015
Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
2 Dec 2015
Rajesh Kumar
This article is all about how to identify the worst performing queries in the running application or some specific module of the aplication.
30 Nov 2015
Sreekanth Mothukuru
The idea is to use Dependency Injector (DI) framework Ninject to dynamically target our application to SQL Server or Oracle database either by using Entity framework (EF) or Dapper ORM using global settings
7 Nov 2015
Syed Hasan Hyder
Provides plausible and high performing data display, for very large data ( over a million records ).
4 Nov 2015
Fred Song (Melbourne)
Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
13 Oct 2015
Ben Emmett
When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server with ANTS Performance Profiler.
8 Oct 2015
App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine
24 Sep 2015
Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
16 Sep 2015
Jaime Olivares
Classes to store, handle, and retrieve geodesic coordinates, in memory, database, and XML, according to the ISO 6709 standard.
30 Aug 2015
Mahsa Hassankashi
Best approach for have more secure channel to transfer user information throughout the web
30 Aug 2015
Murugan Sivananantha Perumal
Self Hosted WCF Service as Windows Service with custom User Authentication over Http.
25 Aug 2015
XSD 1.1 support in Liquid XML 2014
10 Aug 2015
Alessandro Alpi
MVP and DBA Alessandro Alpi discusses the advantages of source controlling databases, and shows why SQL Source Control is the best tool for SQL Server Management Studio users.
3 Aug 2015
Rooney (Deepak Bisht)
How to use tSQLt for writing unit test cases in SQL (for stored procedures & functions)? This article can be treated as a tutorial as well.
2 Aug 2015
syed shanu
In this article we will create a simple dynamic project scheduling from a database using a Stored Procedure using MVC and AngularJS.
28 Jul 2015
A stored procedure that searches for a text in the SQL Server database (DDL)
27 Jul 2015
syed shanu
In this article we will see how to create a simple web application using MVC 5 ,Angular JS ,WEB API 2 to perform CRUD(Create/Read/Update and Delete) Operations using Entity Framework with Stored procedure.
26 Jul 2015
Sumit Tech Brain
Fluent Migrator makes the database migration very easy. It is a database migration framework for .NET and uses fluent interface to manipulate database.
6 Jul 2015
Alaa Ben Fatma
Explore your MMSQL server tables in a professional way .
1 Jul 2015
Frank J. Yang
This article provides code for decoding strings that have been encoded for URL transmission in pure T-SQL that works properly for all URL encoded strings.

Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.190306.1 | Last Updated 24 Mar 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid