Click here to Skip to main content
14,921,361 members
Everything / Programming Languages / SQL

SQL

SQL

Great Reads

by Alex Pumpet
A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files
by Thomas Weller
Demonstrates how to run Python scripts from C#
by Christoph Buenger
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse

Latest Articles

by Rick Drizin
Simple structure for keeping SQL Server Auditing Tables and Versioned Records in the same set of tables, using Audit Triggers and Entity Framework
by Wendelius
How to prevent insert for record when maximum number of rows has been reached
by Giovanni Bejarasco
A walkthrough in UDT programming with primary focus on database concepts
by be05x5
SQL script that will generate XML code that you can copy paste into your RDL file and just do it that way

All Articles

Sort by Score

SQL 

Please Sign up or sign in to vote.
20 Mar 2018
Alex Pumpet
A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files
Please Sign up or sign in to vote.
26 Aug 2019
Thomas Weller
Demonstrates how to run Python scripts from C#
Please Sign up or sign in to vote.
31 Oct 2014
Christoph Buenger
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).
Please Sign up or sign in to vote.
5 Dec 2015
Daniel Miller
This article describes the C# implementation for a high-performance user/role security principal hierarchy.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
5 Nov 2002
Alexey
The alxBase classes for work with dbf files.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
29 Dec 2015
Bert O Neill
Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)
Please Sign up or sign in to vote.
6 Feb 2020
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.
Please Sign up or sign in to vote.
6 Sep 2007
aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
17 Feb 2015
DrABELL
Employment Tax computation and Payroll management app for Windows 8: contest entry
Please Sign up or sign in to vote.
20 Jun 2014
Debabrata_Das
This article will talk about how to update multiple records in a GridView on a single button click using JSON in ASP.NET
Please Sign up or sign in to vote.
1 Dec 2019
Evoluteur
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
Please Sign up or sign in to vote.
1 Jan 2021
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
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
16 Mar 2017
Robert_Dyball
Create a simple data grid that provides list, add, edit and delete and uses a simple 'parent/child' template to provide view, edit or add functionality
Please Sign up or sign in to vote.
24 Aug 2010
pinaldave
A Finale of Series discussing Computed Columns, Storage and Performance
Please Sign up or sign in to vote.
7 Sep 2012
Shivprasad koirala
This article will discuss about SQL Server governer.
Please Sign up or sign in to vote.
21 Apr 2013
Rob Culhane
Dynamically add access database columns at runtime using vb.net
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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"
Please Sign up or sign in to vote.
5 Jul 2016
Akhil Mittal
This article will focus on practical aspects of formatters andcontent negotiation in ASP.NET Web API
Please Sign up or sign in to vote.
17 Jul 2017
Vadim Loboda
Combine Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order
Please Sign up or sign in to vote.
31 Mar 2006
Dan Radu
The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.
Please Sign up or sign in to vote.
15 Sep 2008
Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
22 Feb 2013
Scott Burkow
An exercise in algorithm analysis and design.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
3 Feb 2013
S. M. Ahasan Habib
Database script execution with testing
Please Sign up or sign in to vote.
11 Jan 2015
SarmadAsghar
Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5
Please Sign up or sign in to vote.
29 Mar 2016
wells cheung
Angular Single-Page Application, MEF, Privilege Control, WCF Restful Service, ui-router,
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
27 Feb 2018
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Users Guide
Please Sign up or sign in to vote.
24 Aug 2018
Arthur V. Ratz
In this article, we will demonstrate how to create a Python web-application using Flask and PostgreSQL server, and run it in Docker virtualization platform environment
Please Sign up or sign in to vote.
23 Mar 2021
Espen Harlinn
Proven techniques for fast Oracle Database access using .NET 5.0 and native C++
Please Sign up or sign in to vote.
13 Mar 2021
Sergii Syrovatchenko
How to omit many restrictions on SQL Server Express Edition
Please Sign up or sign in to vote.
14 Mar 2000
Tom Archer
A class to dynamically read data from any ODBC data source
Please Sign up or sign in to vote.
9 Oct 2009
Ferreri Gabriele (Megasoft78)
Automatic script SQL Server 2005 objects and commit under Subversion
Please Sign up or sign in to vote.
15 May 2011
kribo
How to insert images / binary data into a database.
Please Sign up or sign in to vote.
9 Jun 2013
Ravi Gadag
Azure based e-learning product.
Please Sign up or sign in to vote.
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?
Please Sign up or sign in to vote.
4 Apr 2021
Yuancai (Charlie) Ye
Continuous SQL-stream Sending and Processing System
Please Sign up or sign in to vote.
9 Mar 2005
Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
Please Sign up or sign in to vote.
27 Jul 2009
Paul Rony
Programmer's Guide to Starting a Software Company and Building an Enterprise Application
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
12 Jun 2012
Miroslav Popovic
MSBuild database migrations/upgrades with backup and restore functionality
Please Sign up or sign in to vote.
13 Sep 2012
Wendelius
This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
30 Jul 2019
Don Hoang
This post describes implementing ASP.NET Gridview using Bootstrap 4.
Please Sign up or sign in to vote.
18 Sep 2019
Niemand25
Designing a simple yet functional database for financial accounting application.
Please Sign up or sign in to vote.
12 Mar 2003
Alexander Wiseman
A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases
Please Sign up or sign in to vote.
4 Nov 2016
Wendelius
Few CLR procedure concepts to write into a file from SQL Server database
Please Sign up or sign in to vote.
4 May 2004
Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
27 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.
Please Sign up or sign in to vote.
22 Mar 2013
Terence Wallace
TexasQuest is a 2D side scroller platform game similiar to Super Mario
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
29 Feb 2016
wells cheung
Privilege Control System based on MVC and WCF.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
9 Jul 2016
DataBytzAI
A simple and useful pattern when you need to allow user access to large volumes of data
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
23 Mar 2019
Minh Tuan Do
A considerable method to speed up query running time
Please Sign up or sign in to vote.
28 Jul 2000
Len Holgate
The ATL OLE DB Provider templates appear to rely on the fact that your data is kept in a simple array, but that's not really the case at all!
Please Sign up or sign in to vote.
19 Mar 2002
Alex Mikunov
.NET Extensions that provide an infrastructure for enforcing database-like data integrity constraints
Please Sign up or sign in to vote.
28 Jul 2014
DiponRoy
How to manage Entity Framework Code First in Real Time Projects
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
27 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.
Please Sign up or sign in to vote.
18 Feb 2016
Kuv Patel
Debug stored procedures in Visual Studio and SQL Server Management Studio.
Please Sign up or sign in to vote.
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).
Please Sign up or sign in to vote.
8 Nov 2016
mblataric
Instructions on how to migrate existing XAF security system to new permission policy.
Please Sign up or sign in to vote.
20 Mar 2017
AlexeyYakovlev
A library to emulate Oracle-style permanent temporary tables in the PostgreSQL database.
Please Sign up or sign in to vote.
27 Nov 2018
Ajcek84
Using locality-sensitive hashing algorithm to improve performance of searching of musical incipits
Please Sign up or sign in to vote.
9 Jan 2010
Niladri_Biswas
How to generate an Armstrong number between 0 and 999.
Please Sign up or sign in to vote.
23 Oct 2011
jkrebsbach
A way to combine data from two different sources into one datasource for SSRS reporting
Please Sign up or sign in to vote.
26 Nov 2011
gmtzgtz
Import Data from a Text or CSV file into SQL Server
Please Sign up or sign in to vote.
8 Apr 2013
Shining Dragon
How to effectivley version your SQL Server databases using SQL Server Data Tools
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
14 Oct 2013
DataBytzAI
Using SQL job agent to backup databases in virtual machines to an Azure blob container, SQL, Cloud, SQL-Server, Azure
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
27 May 2015
syed shanu
In this article you will learn MVC, AngularJS and WCF Rest Service for Master / Detail HTML Grid
Please Sign up or sign in to vote.
31 May 2015
Milan Matějka
Compare likenesses and differences between Temporary Tables and Temporary Variables
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
21 Oct 2017
mahmood kabi
extract overlapped polygons and calculate the overlapped area and write an API for it
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
12 Aug 2018
Sarathlal Saseendran
We will create an Angular 6 application with Cosmos DB and Web API 2.0.
Please Sign up or sign in to vote.
15 Jul 2019
DiponRoy
Conditinal filter query example in SQL, Lambda Expression, C#
Please Sign up or sign in to vote.
14 Sep 2019
Arthur V. Ratz
How to create and export TensorFlow S&P 500 Index prediction model and serve it using TensorFlow Model Server
Please Sign up or sign in to vote.
30 Jul 2009
Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
Please Sign up or sign in to vote.
30 Apr 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.
Please Sign up or sign in to vote.
21 Dec 2012
mparvez
If you wanted to check the status of all your database backup then this script will do the task.
Please Sign up or sign in to vote.
19 Feb 2013
Khorshed Alam, Dhaka
Standardization database object name with SQL Server Policy Based Management.
Please Sign up or sign in to vote.
19 Sep 2013
G3Coder
Details using an ORM model to provide a common facade to multiple disparate databases.
Please Sign up or sign in to vote.
24 Sep 2015
Dr. Song Li
This is an example to check the SQL server disk and data file usage statistics.
Please Sign up or sign in to vote.
8 Oct 2015
Anele 'Mashy' Mbanga
A look at a flexible Java MySQL CRUD PHP script generator
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
15 Sep 2018
Bogdan Marian
Ensure your Docker Compose services start in the correct order.
Please Sign up or sign in to vote.
30 Jul 2019
Don Hoang
This post describes implementing ASP.NET Editable Gridview using Bootstrap 4
Please Sign up or sign in to vote.
10 Mar 2019
Ryan Peden
Get up and running with serverless by creating a geocoding function on Azure
Please Sign up or sign in to vote.
14 Mar 2000
Tom Archer
A class for Printing and Viewing MS Access Reports
Please Sign up or sign in to vote.
26 Oct 2000
Massimo Colurcio
Explore the structure of tables (and views)
Please Sign up or sign in to vote.
3 Jul 2002
roboo
An OLE-DB DLL that you can use in ANSI-C
Please Sign up or sign in to vote.
16 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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
22 Sep 2010
Hossein Ghahvei Araghi
This article is about DSL and SQL Server Modeling
Please Sign up or sign in to vote.
10 Feb 2014
raju melveetilpurayil
Unlimited scroll like Facebook news feed or Twitter tweets
Please Sign up or sign in to vote.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
Please Sign up or sign in to vote.
29 Nov 2012
RovenetBill
ASP.NET c# component for editing SQL tables with plug-in column format adapter architecture.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
24 Jun 2013
Scott Burkow
We build the physical design from the logical design.
Please Sign up or sign in to vote.
17 Feb 2015
DrABELL
Store securely credit cards' structured meta-data, like contact info, PIN, APR on balance transfer/purchase/cash advance, and other terms/conditions
Please Sign up or sign in to vote.
9 Nov 2014
Sacha Barber
SQL Azure
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
13 May 2015
essentialSQL
This is a case study on how to use Joins, Subqueries, and Unions to combine data in SQL.
Please Sign up or sign in to vote.
16 Oct 2015
Bert O Neill
Validate your Restful Service Methods using SoapUI (which can then be integrated into TFS build CI)
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
25 Mar 2016
freedeveloper
Simple Implementation of Google API IDataStore that use MS-SQL server to store your token file
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
4 Oct 2016
Martin Lachman
How to create a system on MS SQL Server for detection of actual changed records in a database table.
Please Sign up or sign in to vote.
30 Dec 2019
Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
Please Sign up or sign in to vote.
1 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
Please Sign up or sign in to vote.
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Interesting Coding
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
19 Nov 2018
Vivek Johari
Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents
Please Sign up or sign in to vote.
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?
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
8 Sep 2019
Arthur V. Ratz
How to properly install and configure SAP-HANA and TensorFlow Model Server to predict the S&P 500 Index
Please Sign up or sign in to vote.
18 Oct 2016
Wendelius
Discussion and a few approaches to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure
Please Sign up or sign in to vote.
15 Oct 2001
Ciprian Miclaus
An article on how to improve SQL hierarchies
Please Sign up or sign in to vote.
21 Dec 2009
jabit
Use SQL table data as an AutoCompleteCustomSource with one line of code
Please Sign up or sign in to vote.
18 May 2010
JasonShort
Preparing an Entity Framework model for multi provider support
Please Sign up or sign in to vote.
27 Sep 2010
venugopalm
Integrating database development into Visual Studio to collaborate application development team and the database designers
Please Sign up or sign in to vote.
22 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.
Please Sign up or sign in to vote.
23 Feb 2012
Santosh P Umarani
Columnstore Index
Please Sign up or sign in to vote.
1 May 2012
Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
Please Sign up or sign in to vote.
2 Aug 2012
Kuthuparakkal
WMI based DirectoryMonitor triggers SSIS Package execution.
Please Sign up or sign in to vote.
7 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
Please Sign up or sign in to vote.
7 Mar 2013
Weidong Shen
This article describes the IClientChangeTracking interface generated by Self-Tracking Entity Generator and Visual Studio 2012.
Please Sign up or sign in to vote.
14 Jan 2014
Member 10280272
This article presents a database browser that can be used for multiple different databases
Please Sign up or sign in to vote.
10 Apr 2015
Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
Please Sign up or sign in to vote.
21 May 2015
Anele 'Mashy' Mbanga
Exploring the source code behind the offline CodeProject article writer CodeProject.Show.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
7 Dec 2016
Kuv Patel
Decrypt Stored Procedures, Views, Functions, and Triggers in SQL Server
Please Sign up or sign in to vote.
26 Feb 2016
Pavel Sinkevich
How to programmatically change schema name in database project before deployment
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Architecture and design decisions
Please Sign up or sign in to vote.
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Job Scheduling Code
Please Sign up or sign in to vote.
1 Mar 2018
Sibeesh Passion
This is the continuation of exploring the Mongo shells, we will be performing some commands on the Mongo shells.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
20 Oct 2019
Ravi K. Acharya
Second part of the step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus
Please Sign up or sign in to vote.
20 Oct 2019
Ravi K. Acharya
Third and final part of the step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.
Please Sign up or sign in to vote.
13 Jan 2020
koolprasadd
New features of SQL 2019
Please Sign up or sign in to vote.
28 Jul 2000
Len Holgate
Adding bookmark functionality is relatively easy and it enables our ADO recordset to be used with a greater number of data bound controls.
Please Sign up or sign in to vote.
29 Oct 2001
simulant
Transform any XML persisted ADO Recordset into a delimited text file.
Please Sign up or sign in to vote.
25 Mar 2009
Sike Mullivan
Create a Web Part that displays the most viewed content
Please Sign up or sign in to vote.
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?
Please Sign up or sign in to vote.
1 Sep 2009
merlin981
Several tips and tricks I have found during my time as a LINQ developer
Please Sign up or sign in to vote.
13 Jun 2011
AlexCode
Converting INTs to BINARY in SQL Server
Please Sign up or sign in to vote.
21 Jan 2012
Weidong Shen
This article describes how to do data validation with Self-Tracking Entity Generator for WPF/Silverlight.
Please Sign up or sign in to vote.
11 May 2012
infectuz.ar
Determining sunrise and sunset values for a certain latitude and longitude with SQL Server 2005
Please Sign up or sign in to vote.
6 Jan 2013
joe_j
Shows you how to build up a close to real time email monitoring and visual management system.
Please Sign up or sign in to vote.
2 Jan 2013
Tomz_KV
A custom solution to transform data from rows to columns using dynamic SQL.
Please Sign up or sign in to vote.
4 Jan 2013
mparvez
How to archive all backup (Full, Diff, Log) in a single archive file using 7zip.
Please Sign up or sign in to vote.
15 May 2013
h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
24 Mar 2015
Matt Perdeck
Add a database to your web site on AWS with automatic fail over using RDS
Please Sign up or sign in to vote.
13 Aug 2015
KASQLDBA
Downgrading from Enterprise to standard edition (SQL server) for those servers which are not using any of enterprise features.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
19 Nov 2015
Manjuke Fernando
How to capture and analyze deadlocks in SQL Server
Please Sign up or sign in to vote.
4 Jan 2016
Han Bo Sun
Describe in detail how many-to-many association works with Hibernate, using MySQL and Spring
Please Sign up or sign in to vote.
3 Feb 2016
Michael B. Erickson
Add rich reporting of exceptions to improve error reporting to users and diagnostics to development.
Please Sign up or sign in to vote.
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - The CSV and Excel Importer Code
Please Sign up or sign in to vote.
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - How Packages Are Run
Please Sign up or sign in to vote.
10 Jan 2018
ASkaeff
A simple yet powerful tool to analyse SQL object dependencies in quite fast and reliable manner.
Please Sign up or sign in to vote.
1 Feb 2018
Member 11127135
ETL Testing and data-validation, dynamic SQL rule generator
Please Sign up or sign in to vote.
8 Feb 2018
Viral Surani
Snapshot Isolation Level in SQL Server
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
19 Apr 2018
charles922
AngularJS and REST API Tutorial - Part 2
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
12 Nov 2018
Vlad Neculai Vizitiu
How to write automated tests using entity framework core
Please Sign up or sign in to vote.
15 Nov 2018
Srinivasa Dinesh Parupalli
Custom APIs using .NET SDK for SQL API
Please Sign up or sign in to vote.
25 Nov 2018
Vivek Johari
This post discusses how to migrate SQL database to Azure SQL database using SSMS deploy.
Please Sign up or sign in to vote.
27 May 2019
DiponRoy
Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases
Please Sign up or sign in to vote.
20 Oct 2019
Ravi K. Acharya
The complete step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.
Please Sign up or sign in to vote.
9 Jan 2013
Abhishek Nandy
In depth details of an Ultrabook
Please Sign up or sign in to vote.
21 Apr 2016
Emmanouil Gimissis MSc ICSD
Calculating progressive sums in T-SQL
Please Sign up or sign in to vote.
31 Mar 2009
BobP1339
Explains how to do multi language reports in SSRS
Please Sign up or sign in to vote.
14 May 2009
merlin981
How to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ
Please Sign up or sign in to vote.
24 Jun 2009
Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
Please Sign up or sign in to vote.
26 Jul 2009
AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
Please Sign up or sign in to vote.
4 Aug 2009
bobleith
A generic interval range table to generate permutations
Please Sign up or sign in to vote.
5 Aug 2009
bobleith
Bits for Event Patterns
Please Sign up or sign in to vote.
2 Oct 2010
bmharwani
Mobile Web Development with PHP, MySQL and jQTouch
Please Sign up or sign in to vote.
8 Dec 2010
Gil Fink
EF Feature CTP5: Raw SQL Query/Command Support
Please Sign up or sign in to vote.
20 Apr 2011
pinaldave
A Quick Guide to Find Potential Peformance Issue
Please Sign up or sign in to vote.
9 Aug 2011
AnnuAbraham
A single report can be used to display different sets of data.
Please Sign up or sign in to vote.
6 Mar 2012
nguyenannhon
This article introduces the steps to create a report with a custom search area.
Please Sign up or sign in to vote.
8 Mar 2013
Himanshu DS
Here are some styles of source code comments in C#, SQL, XML, HTML, CSS, JavaScript
Please Sign up or sign in to vote.
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...
Please Sign up or sign in to vote.
8 Aug 2013
h_wiedey
An approach using updatable views with check option and deferred constraint checking.
Please Sign up or sign in to vote.
26 Jun 2013
ThatsAlok
Step by Step creation of SSIS package using C# with Conditional Split
Please Sign up or sign in to vote.
18 Jan 2014
Petr Ivankov
Application of abstract approach to database domain
Please Sign up or sign in to vote.
11 Feb 2014
harleydk
Linq-to-SQL enums support
Please Sign up or sign in to vote.
6 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.
Please Sign up or sign in to vote.
23 Oct 2016
Matthew So (Hong Kong)
A task processing server with RDLC Implementation and extensible to customized handlers
Please Sign up or sign in to vote.
4 Nov 2016
Nagaraj Muthuchamy
Design and implementation of custom pagination and cascaded filtering with rad grid.
Please Sign up or sign in to vote.
13 Mar 2018
Paolo Parise
A show case of a dockerized postgres to improve the coupling between versioned codebase and database schema
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
4 Jul 2018
Krishna P Seetharaman
Issues faced and learnings found during the generation of pipe delimited flat file generation
Please Sign up or sign in to vote.
22 Oct 2018
Łukasz Bownik
How to reliably version database schemas
Please Sign up or sign in to vote.
13 Nov 2018
Vlad Neculai Vizitiu
ASP.NET Core 1.1 and Identity Adventures
Please Sign up or sign in to vote.
14 Feb 2019
Melick
This is a complete guide to install SharePoint in a three server farm using AutoSPInstaller
Please Sign up or sign in to vote.
16 Aug 2019
Marijan Nikic
An HTML tool written in JavaScript to convert a regular Oracle SQL query into a spooling script
Please Sign up or sign in to vote.
4 Apr 2020
Venkatesh Subbarao
How to copy tables with Stored procedure data from one database to another in AZURE SQL.
Please Sign up or sign in to vote.
10 Dec 2020
Leif Simon Goodwin
Simple WPF app that shows how to use PetaPoco library to manage an SQL database
21 Dec 2006
2sky
A brief overview of how the Hera Application Framework aids you in the development of data-driven applications.
Please Sign up or sign in to vote.
7 Apr 2021
Eric Bishard
In this article, we hope to provide resources that will help you hit the ground running on your path to learning about document databases and Couchbase.
Please Sign up or sign in to vote.
20 Feb 2000
Len Holgate
The ATL OLE DB Provider templates only seem to support read-only rowsets and making them support updating of data isn't as easy as you'd expect!
Please Sign up or sign in to vote.
8 Nov 2005
fstrahberger
How to do full text search with Oracle Text
Please Sign up or sign in to vote.
5 Feb 2007
Pman75
A 2 tier menu generator that can be navigated forwards and/or backwards.
Please Sign up or sign in to vote.
15 Oct 2007
Tijoy Tom
Deadlock analysis in SQL Server 2000.
Please Sign up or sign in to vote.
4 May 2008
AKA MAJO
The MySQL engine permits user level locks. This article explains how to manipulate these lock types.
Please Sign up or sign in to vote.
9 Oct 2008
docsmaker
A new free tool to easily manage database users, their privileges and more.
Please Sign up or sign in to vote.
11 Jun 2009
ColinBashBash
Templates to fix changes in sort-order as they occur.
Please Sign up or sign in to vote.
9 Jul 2009
bobleith
How to dump SQL data in pivoted format
Please Sign up or sign in to vote.
5 Oct 2009
merlin981
How to create T-SQL CASE statements with LINQ to SQL
Please Sign up or sign in to vote.
17 Nov 2009
Ramy Mahrous
Microsoft SQL Server 2008 R2 November CTP - Database Engine feature #1
Please Sign up or sign in to vote.
11 Jan 2010
Divan van der Watt
Column search functionality that works as easy as sp_help.
Please Sign up or sign in to vote.
7 Apr 2010
BarrySolomon
Support for Reading XML in MySQL
Please Sign up or sign in to vote.
1 Jul 2011
zenwalker1985
This article explains a refactored code snippet on passing parameters for a stored proecedure via SP schema rather than hard coding the column/param names.
Please Sign up or sign in to vote.
20 Sep 2011
Wendelius
This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
Please Sign up or sign in to vote.
11 Oct 2011
KP Lee
Specific example for improving some SQL performance problems
Please Sign up or sign in to vote.
7 Nov 2011
Paul_Gordon
An easy way to call and manage Stored Procedures in .NET.
Please Sign up or sign in to vote.
10 Nov 2011
Phani Krishna Kollapur Gandla
How to solve performance issues in data migration to SQL Server.
Please Sign up or sign in to vote.
30 Jan 2012
abhijit.dalvi29
This article describes how to get the Menus Based on Role in XML Format and Bind them to the Menu Control in ASP.NET
Please Sign up or sign in to vote.
9 Aug 2012
Alexandros Pappas
This article provides a program to measure the performance of the different transaction isolation levels. It also examines the effect of using the UPDLOCK hint in SQL.
Please Sign up or sign in to vote.
25 Apr 2013
Robert William Gates
Azure based repository for Major Technical Celebrity and Public Figures
Please Sign up or sign in to vote.
28 Apr 2013
JoewyCodes
White Stone Helps Businesses Give Their Customers Greater Value for their Money.
Please Sign up or sign in to vote.
13 May 2013
jluhman
How to take an existing Windows 8 and Windows Phone 8 Modern app and extend it to the web.
Please Sign up or sign in to vote.
30 Apr 2013
MartinDGut
An Azure Database to hold a Knowledge Base
Please Sign up or sign in to vote.
3 May 2013
mf81
This will be a lightweight site that helps the user track their weekly comics subscriptions.
Please Sign up or sign in to vote.
3 Jun 2013
Mark Kestenbaum
An entry to the Windows Azure Developer Challenge.