Click here to Skip to main content
13,900,697 members
SQL

SQL

Great Reads

by Alex Pumpet
A simple program for compare table data from two sources - SQL databases, Excel, CSV or XML-files.
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 Christoph Buenger
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).

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 Martin Vorbrodt
SQL database access
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.

All Articles

Sort by Score

SQL 

20 Mar 2018
Alex Pumpet
A simple program for compare table data from two sources - SQL databases, Excel, CSV or XML-files.
14 Mar 2000
Tom Archer
A class to dynamically read data from any ODBC data source
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.
31 Oct 2014
Christoph Buenger
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).
5 Dec 2015
Daniel Miller
This article describes the C# implementation for a high-performance user/role security principal hierarchy.
11 Jun 2010
Evoluteur
A generic Web User Interface for CRUD applications generating all screens at run-time based on external metadata. It comes with sample applications for address book, memo pad, to do list, restaurants list, wine cellar, and database structure documentation that are easily customizable.
5 Nov 2002
Alexey
The alxBase classes for work with dbf files.
27 Nov 2009
Max Paulousky
This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.
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).
15 Jul 2014
Jesús López Méndez
This article introduces you to client side multi-column dynamic pivot, a cleaner, simpler and elegant alternative to the complex and convoluted dynamic server side pivot.
30 Dec 2015
Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
21 Sep 2016
Fred Song (Melbourne)
In this article, I want to show how to build a Single Page Application – MasterChef with ASP.NET Core MVC, Fluent Hibernate, and Angular JS.
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.
5 Jul 2016
Akhil Mittal
This article will focus on practical aspects of formatters andcontent negotiation in ASP.NET Web API
17 Mar 2013
Weidong Shen
This article describes the project setup of building a WPF sample application with Self-Tracking Entity Generator and Visual Studio 2012.
16 Mar 2017
Robert_Dyball
Adding a simple Angular 2 datagrid, adding server-side model-driven data validation and async CRUD operations to our Web API services and more ASP.net Core tag helpers.
31 Mar 2006
Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
15 Sep 2008
Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
29 Oct 2008
Ahmad Eid Salim
Provider Design Pattern is a new pattern that Microsoft formalized in .NET 2 to increase application performance where there is no need to explicitly instantiate classes.
24 Aug 2010
pinaldave
A Finale of Series discussing Computed Columns, Storage and Performance
7 Sep 2012
Shivprasad koirala
This article will discuss about SQL Server governer.
21 Apr 2013
Rob Culhane
Dynamically add access database columns at runtime using vb.net
12 Nov 2015
Fred Song (Melbourne)
In this article, we started from Generate Inserts procedure, then go through how generates inserts SQL files with this procedure and runs these inserts SQL files to import data.
27 Oct 2016
Vikas Sharma
In this article, we will focus on aggregation pipeline. I'll try to cover each major section of it using simple examples. We will be writing mongo shell commands to perform aggregation.
27 Mar 2012
Carlos Alberto Cabrera Gonzalez
This article shows a detailed approach on how to dynamically point to a given shared data source reference by setting up an RDCE and using a couple of tips and tricks.
22 Feb 2013
Scott Burkow
An exercise in algorithm analysis and design.
21 Jun 2016
Marc Clifton
A deep dive into the $lookup aggregator with examples of one-to-one, one-to-many, many-to-many, and nested relational "queries"
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.
3 Feb 2013
S. M. Ahasan Habib
Database script execution with testing
11 Jan 2015
SarmadAsghar
Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5
29 Mar 2016
wells cheung
Angular Single-Page Application, MEF, Privilege Control, WCF Restful Service, ui-router,
12 May 2017
DaveDavidson
In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.
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.
27 Feb 2018
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Users Guide
9 Jun 2013
Ravi Gadag
Azure based e-learning product.
16 Oct 2014
Gaurav Aroraa
In this step-by-step article, we will discuss all about CRUD (Create Read Update Delete) operations with Web API using Repository pattern.
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?
10 Mar 2005
Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
19 Dec 2007
Bryan Sachdeva
This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.
21 Feb 2012
Daniel Miller
This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.
12 Jun 2012
Miroslav Popovic
MSBuild database migrations/upgrades with backup and restore functionality
4 Nov 2016
Wendelius
Few CLR procedure concepts to write into a file from SQL Server database
15 Jan 2019
Evoluteur
RESTful generic endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
19 Aug 2017
Afzaal Ahmad Zeeshan
.NET Core 2.0 brings a lot of improvements to the system, and it brings a lot of pain to the developers as well. I had a lot of problems upgrading .NET Core 1.x apps to .NET Core 2.0; I yet have to feel the promise it makes about performance and so, but let us see how to upgrade our existing applica
28 Apr 2011
Niladri_Biswas
This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.
13 Sep 2012
Wendelius
This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
22 Mar 2013
Terence Wallace
TexasQuest is a 2D side scroller platform game similiar to Super Mario
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.
6 Dec 2016
_Asif_
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.
29 Feb 2016
wells cheung
Privilege Control System based on MVC and WCF.
4 May 2016
Shashangka Shekhar
In this post I am going to demonstrate how to use Angular UI Grid with server side pagination in ASP.Net MVC application.
9 Jul 2016
AJSON
A simple and useful pattern when you need to allow user access to large volumes of data
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
29 Jul 2014
DiponRoy
How to manage Entity Framework Code First in Real Time Projects
28 Dec 2014
Snesh Prajapati
In this article series, I am sharing how to create report using Report Builder by fetching data from Oracle DB.
28 Jan 2015
Vaclav Naydenov
Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.
18 Feb 2016
Kuv Patel
Debug stored procedures in Visual Studio and SQL Server Management Studio.
3 Oct 2016
Fred Song (Melbourne)
In this article I talk about how to use ASP.NET Core MVC, Fluent NHibernate and Angular JS to implement a CRUD SPA (Single Page Application).
8 Nov 2016
mblataric
Instructions on how to migrate existing XAF security system to new permission policy.
20 Mar 2017
AlexeyYakovlev
A library to emulate Oracle-style permanent temporary tables in the PostgreSQL database.
27 May 2018
Yuancai (Charlie) Ye
Application of SocketPro onto various databases for continuous inline request/result batching and real-time stream processing with bi-directional asynchronous data transferring
27 Nov 2018
Ajcek84
Using locality-sensitive hashing algorithm to improve performance of searching of musical incipits
9 Jan 2010
Niladri_Biswas
How to generate an Armstrong number between 0 and 999.
23 Oct 2011
jkrebsbach
A way to combine data from two different sources into one datasource for SSRS reporting
26 Nov 2011
gmtzgtz
Import Data from a Text or CSV file into SQL Server
9 Apr 2013
Shining Dragon
How to effectivley version your SQL Server databases using SQL Server Data Tools
20 Jun 2013
Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
14 Oct 2013
AJSON
Using SQL job agent to backup databases in virtual machines to an Azure blob container, SQL, Cloud, SQL-Server, Azure
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.
28 May 2015
syed shanu
In this article you will learn MVC, AngularJS and WCF Rest Service for Master / Detail HTML Grid
31 May 2015
Milan Matějka
Compare likenesses and differences between Temporary Tables and Temporary Variables
27 Oct 2016
Shashangka Shekhar
In this article, we will focus on how to enable CORS in ASP.NET Core application, get knowledge about CORS policy how we can share resource through different origin.
10 Apr 2017
Robert_Dyball
Covering conversion from Angular 2.40 to Angular 4.0 + Publishing the ASP.Net Core / Angular 4 SPA to IIS using VS2017
19 Apr 2017
Robert_Dyball
Publishing the ASP.Net Core 1.1 / Angular 4 SPA to Azure and external IIS hosts. Also covering code cleanup, optimization, bundling and minification. Gulp, Grunt, Webpack and some architecture and development philosophy.
30 May 2018
syed shanu
This article will explain in detail about, how to create an ASP.NET Core Blazor Filter and Sorting for HTML Table using Entity Framework and Web API.
30 Jul 2009
Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
1 May 2012
Wendelius
This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.
21 Dec 2012
mparvez
If you wanted to check the status of all your database backup then this script will do the task.
19 Sep 2013
G3Coder
Details using an ORM model to provide a common facade to multiple disparate databases.
5 Sep 2015
Maxim Kurayan
EF Dynamic Report is a small open source project which allows you to use Entity Framework mapping between types and tables as a dynamic report data source
8 Oct 2015
Anele 'Mashy' Mbanga
A look at a flexible Java MySQL CRUD PHP script generator
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.
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
21 Oct 2017
mahmood kabi
extract overlapped polygons and calculate the overlapped area and write an API for it
15 Sep 2018
Bogdan Marian
Ensure your Docker Compose services start in the correct order.
17 Oct 2007
Adam Page
Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.
13 Mar 2009
Tiago Freitas Leal
This project shows how to have a master/detail DataGridView using CSLA EditableRootListBase (or DynamicRootList) as the master list object. It shows how to have sorted list and auto save on both the master and detail DataGridView.
22 Sep 2010
Hossein Ghahvei Araghi
This article is about DSL and SQL Server Modeling
10 Feb 2014
raju melveetilpurayil
Unlimited scroll like Facebook news feed or Twitter tweets
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
29 Nov 2012
RovenetBill
ASP.NET c# component for editing SQL tables with plug-in column format adapter architecture.
23 Jun 2013
Tim Corey
Learn how to get started in Windows Azure by following the progress of an actual web application as it is constructed.
24 Jun 2013
Scott Burkow
We build the physical design from the logical design.
7 May 2015
Mr. xieguigang 谢桂纲
You see, this small utility tool save much of your time, this is another happy day! I hope you can enjoyed this code.
14 May 2015
essentialSQL
This is a case study on how to use Joins, Subqueries, and Unions to combine data in SQL.
24 Sep 2015
Dr. Song Li
This is an example to check the SQL server disk and data file usage statistics.
16 Oct 2015
Bert O Neill
Validate your Restful Service Methods using SoapUI (which can then be integrated into TFS build CI)
1 Mar 2016
Emiliano Musso
In this short article we will see how to create a SQL database using the services provided by Microsoft Azure cloud platform, and then connect to it via C # code, to perform the normal data insertion and retrieval operations
25 Mar 2016
freedeveloper
Simple Implementation of Google API IDataStore that use MS-SQL server to store your token file
12 May 2016
Sibeesh Passion
How to enable the API descriptions for better understanding of how our API controller works and what exactly it is supposed to do
4 Oct 2016
Martin Lachman
How to create a system on MS SQL Server for detection of actual changed records in a database table.
18 Oct 2016
Wendelius
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.
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format
30 Sep 2017
John Simmons / outlaw programmer
Create and run jobs kinda like SQL Server Enterprise - Interesting Coding
3 Mar 2018
Shashangka Shekhar
In this post we are going to secure our NodeJS API’s with customized security token generated by logged user and HTTP actions.
13 Jun 2018
syed shanu
In this article, let’s see how to create our own ASP.NET Core Blazor Master Detail HTML Grid with Sorting and Filtering using Entity Framework, and Web API. We also use the Dynamic Content features of Blazor to create our Master Detail Grid.
19 Dec 2018
Sibeesh Passion
In this article, we are going to see how we can set up an Azure Function as an Output job topology of an Azure Stream Analytics job. Doesn’t that sound interesting?
26 Dec 2018
Wendelius
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 Jan 2019
Don Hoang
This post describes implementing ASP.NET Gridview using Bootstrap 4
21 Dec 2009
jabit
Use SQL table data as an AutoCompleteCustomSource with one line of code
27 Sep 2010
venugopalm
Integrating database development into Visual Studio to collaborate application development team and the database designers
23 Sep 2011
smoore4
Loop through all files in a folder/subfolders and run a checksum that is stored in a database. E-mail descrepancies and results.
23 Feb 2012
Santosh P Umarani
Columnstore Index
1 May 2012
Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
2 Aug 2012
Kuthuparakkal
WMI based DirectoryMonitor triggers SSIS Package execution.
8 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
24 Jun 2013
ambilykk
GlobalMeet -An Event Management Site for all events across globe powered by Azure and ASP.Net
2 May 2013
flywheel
Sygnol your choices in surveys, straw polls, and interactive contests.
9 Nov 2014
Sacha Barber
SQL Azure
10 Apr 2015
Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
21 May 2015
Anele 'Mashy' Mbanga
Exploring the source code behind the offline CodeProject article writer CodeProject.Show.
3 Jun 2016
PIEBALDconsult
A C function that merges the content from an arbitrary number of text files into a Character-Separated-Variable-Width result file
8 Dec 2016
Kuv Patel
Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server
26 Feb 2016
Pavel Sinkevich
How to programmatically change schema name in database project before deployment
19 Jun 2017
Alexander Sharykin
LibraryCommander is a personal desktop application to manage my texts (e-book) collection, classify and search them by categories and tags.
30 Sep 2017
John Simmons / outlaw programmer
Create and run jobs kinda like SQL Server Enterprise - Architecture and design decisions
30 Sep 2017
John Simmons / outlaw programmer
Create and run jobs kinda like SQL Server Enterprise - Job Scheduling Code
1 Mar 2018
Sibeesh Passion
This is the continuation of exploring the Mongo shells, we will be performing some commands on the Mongo shells.
1 May 2018
Pero Matić
A Dockerized proof of concept application using React, Node, Python, GnuCOBOL, PostgreSQL, and Docker.
10 Mar 2019N
Rajat-Indiandotnet
Azure Logic APPS – A Simplest Way to Automate Your Business Process
3 Mar 2019
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.
25 Mar 2009
Sike Mullivan
Create a Web Part that displays the most viewed content
17 Jul 2009
Sarmak.M.C
How to invoke Stored Procedures with the FOR XML clause using BizTalk Adapter Pack 2.0 if the Stored Procedures are not in the default schema?
1 Sep 2009
merlin981
Several tips and tricks I have found during my time as a LINQ developer
13 Jun 2011
AlexCode
Converting INTs to BINARY in SQL Server
11 May 2012
infectuz.ar
Determining sunrise and sunset values for a certain latitude and longitude with SQL Server 2005
2 Jan 2013
Tomz_KV
A custom solution to transform data from rows to columns using dynamic SQL.
7 Jan 2013
joe_j
Shows you how to build up a close to real time email monitoring and visual management system.
4 Jan 2013
mparvez
How to archive all backup (Full, Diff, Log) in a single archive file using 7zip.
9 Jan 2013
Abhishek Nandy
In depth details of an Ultrabook
15 May 2013
h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
11 Apr 2013
Ivan Paniagua
This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models and not just Tabular Models.
11 Oct 2013
ASP.NET Community
Employee Info Starter Kit is an open source ASP.NET project template that is intended to address different types of real world challenges faced
29 Jul 2014
Ajit Kumar Thakur Microsoft
This article explains the step by step process to learn MDX query. It will help user to read data from OLAP cube.
31 Aug 2014
Faustino Dina
Publishes a Transact-SQL function for parsing a string containing a delimited list, similar to the ANSI C languaje strtok() function.
13 Mar 2015
Gaurav Aroraa
Introduction In these days RAD (Rapid Application Development) is growing at its large. There are numerous framework available to develop Web Applications or Web Projects. We can use either ASP.Net or ASP.Net MVC from Microsoft or any other framework. Although, NancyFx is having its own support for
24 Mar 2015
Matt Perdeck
Add a database to your web site on AWS with automatic fail over using RDS
13 Aug 2015
KASQLDBA
Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.
5 Nov 2015
Vyacheslav Voronenko
As a contractor software developer I am asked from time to time to perform audit of LAMP projects. As project configuration is different, I use so-called "umbrella repository environment" which allows me to wrap such projects into reusable vagrant environment without need to amend audited projects c
19 Nov 2015
Manjuke Fernando
How to capture and analyze deadlocks in SQL Server
4 Jan 2016
Han Bo Sun
Describe in detail how many-to-many association works with Hibernate, using MySQL and Spring
3 Feb 2016
Michael B. Erickson
Add rich reporting of exceptions to improve error reporting to users and diagnostics to development.
22 Apr 2016
Emmanouil Gimissis MSc ICSD
Calculating progressive sums in
26 Jul 2018
Dathuraj Pasarge
Mirroring setup without any DBA effort - on every new DB creation on the SQL Server !!!
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 - How Packages Are Run
10 Jan 2018
ASkaeff
A simple yet powerful tool to analyse SQL object dependencies in quite fast and reliable manner.
1 Feb 2018
Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
9 Feb 2018
Viral Surani
Snapshot Isolation Level in SQL Server
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
charles922
AngularJS and REST API Tutorial - Part 2
27 Apr 2018
Member 11896794
This custom database first approach token authentication will enable you to apply token-based authentication in your application in a simple way with no hassle.
3 Dec 2018
Han Bo Sun
In this tutorial, I will introduce the use of Spring JdbcTemplate in a Spring Boot web application. This tutorial will show how to create the necessary configuration for JdbcTemplate. And how it can be used for data insertion and retrieval.
7 Feb 2019
Don Hoang
This post describes implementing ASP.NET Editable Gridview using Bootstrap 4
12 Nov 2018
Vlad Neculai Vizitiu
How to write automated tests using entity framework core
15 Nov 2018
Srinivasa Dinesh Parupalli
Custom APIs using .NET SDK for SQL API
19 Feb 2019
Arthur V. Ratz
Introducing NLP-Samurai@0.0.10 Natural Language Processing Engine.
10 Mar 2019N
Ryan Peden
Get up and running with serverless by creating a geocoding function on Azure
21 Dec 2006
2sky
A brief overview of how the Hera Application Framework aids you in the development of data-driven applications.
31 Mar 2009
BobP1339
Explains how to do multi language reports in SSRS
14 May 2009
merlin981
How to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ
24 Jun 2009
Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
26 Jul 2009
AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
4 Aug 2009
bobleith
A generic interval range table to generate permutations
5 Aug 2009
bobleith
Bits for Event Patterns
8 Dec 2010
Gil Fink
EF Feature CTP5: Raw SQL Query/Command Support
20 Apr 2011
pinaldave
A Quick Guide to Find Potential Peformance Issue
9 Aug 2011
AnnuAbraham
A single report can be used to display different sets of data.
6 Mar 2012
nguyenannhon
This article introduces the steps to create a report with a custom search area.
8 Mar 2013
Himanshu DS
Here are some styles of source code comments in C#, SQL, XML, HTML, CSS, JavaScript
12 Apr 2013
g00p3k
Coding in SQL Server Management Studio doesn't have to be relegated to a second class citizen with the proper tools...
8 Aug 2013
h_wiedey
An approach using updatable views with check option and deferred constraint checking.
27 Jun 2013
ThatsAlok
Step by Step creation of SSIS package using C# with Conditional Split
18 Jan 2014
Petr Ivankov
Application of abstract approach to database domain
11 Feb 2014
harleydk
Linq-to-SQL enums support
7 Mar 2016
markkang
This is about how to hash your binary data that exceed the limit (8000bytes) of allowed input values of HASHBYTES in SQL Server.
23 Oct 2016
Matthew So (Hong Kong)
A task processing server with RDLC Implementation and extensible to customized handlers
4 Nov 2016
Nagaraj Muthuchamy
Design and implementation of custom pagination and cascaded filtering with rad grid.
13 Mar 2018
Paolo Parise
A show case of a dockerized postgres to improve the coupling between versioned codebase and database schema
9 Jan 2018
Nicolas Bohorquez
In this article, we’ll explore using Alibaba Cloud’s ApsaraDB for MongoDB service, which allows us to set up NoSQL databases in a simple but scalable way.
22 Oct 2018
Łukasz Bownik
How to reliably version database schemas
14 Feb 2019
Melick
This is a complete guide to install SharePoint in a three server farm using AutoSPInstaller
24 Mar 2019U
Minh Tuan Do
A considerable method to speed up query running time
18 Jul 2016
wells cheung
Standalone Privilege Control, Single Sign-On Solution
21 Apr 2004
Armen Hakobyan
Using SQL-DMO to shrink SQL Server transaction logs.
18 Sep 2016
syed shanu
In this article, we will learn how to create a simple web based music player system using MVC, AngularJS and Web API.


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