Tableau is one of the powerful reporting tool which is on the market for over a decade. Here's a quick tour in designing BI reports with Tableau using Microsoft Dynamics AX 2012 R3/ Microsoft Dynamics 365 Finance and Operations.

Autogenerate Unit Tests For Your Database Objects - Visual Studio 2019 & 2022 (amd64) Extension

by Bert O Neill

Features and functionalities associated with Autogenerate DB Unit Test app

SQL-File Technology for Transact-SQL

by Sergei Y.Kitáev

Introduction to statically parameterized SQL language

All Articles

top

SQL Server

.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code

16 Aug 2010 by Shivprasad koirala

.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code

C#3.0

C#2.0

.NET

SQL-Server

Visual-Studio

ASP.NET

Architect

.NET Installer that automatically installs MSDE

26 Jul 2008 by John Kenedy S.Kom

This project enables developers to create a setup package that automatically installs MSDE and attaches database

.NET Installer that Automatically Installs SQL 2005 Express

28 Jul 2008 by John Kenedy S.Kom

This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it

10 Steps to Creating a Windows Mobile Database Application Using .NET and SQL Anywhere 10

24 May 2007 by Liam Cavanagh

The purpose of this article is to help get a user started in building a mobile database application using SQL Anywhere and Visual Studio .NET (C#)

101 with the Interactive Feature of SQL Server Integration Services

22 Dec 2011 by Keshav Singh

This demo session demonstrates a little POC as to how can you make your SSIS talk to you.

SQL-Server

Dev

DBA

11 important database designing rules which I follow

25 Feb 2014 by Shivprasad koirala

This article will discuss about 11 important database designing rules.

12 Important FAQ’s on VSTS Testing (Unit testing, load testing, automated testing, database testing and code coverage)

9 Dec 2009 by Shivprasad koirala

This article has 12 important FAQ’s which covers unit testing, automated testing, data driven test, load/ performance test, code coverage , database testing and ordered testing.

13 disasters for production web sites and their solutions

6 Aug 2007 by Omar Al Zabir

Learn about 13 production disasters that can bring down your business

3 Kinds of Comparison and Snchronization for SQL Server Database

16 Mar 2011 by dingoishere

This article introduces you to 3 kinds of comparison and synchronization for SQL Server Database.

SQL

SQL-Server

DBA

5 Tips for Accelerating Your Web Site Development in ASP.NET

11 Jan 2006 by Petr Palas

Did you know there’s an easier way how to create dynamic web sites? Learn how Kentico CMS for ASP.NET will increase your productivity and help you win more clients.

6 Steps to Enable Transactions in WCF

23 Jun 2021 by Shivprasad koirala

6 steps to enable transactions in WCF

6 Steps to Implement DUAL Security on WCF using User name + SSL

20 May 2010 by Shivprasad koirala

6 steps to implement DUAL security on WCF using User name + SSL

7 Questions You Always Wanted to Ask about Content Management Systems

23 May 2007 by Petr Palas

What is a content management system? Does it really work? Why should I use it? How does it help me? This article answers the most common questions developers ask about content management systems (CMS).

7 Simple Steps to Connect SQL Server using WCF from SilverLight

12 Aug 2010 by Shivprasad koirala

In this article, we will look at how we can do database operations using SilverLight.

7 Simple Steps to Run Your First Azure Blob Program

26 Feb 2014 by Shivprasad koirala

7 simple steps to run your first Azure Blob Program

99.99% available ASP.NET and SQL Server SaaS Production Architecture

11 Jun 2011 by Omar Al Zabir

Production Architecture for a SaaS web application built using ASP.NET and SQL Server that guarantees 99.99% availability and super performance

A .NET Windows Application To Generate SQL Server Scripts

1 Oct 2009 by Deepankar Malik

Generates SQL Server Stored Procedure and Table Defination Scripts

A Closer Look Inside RAISERROR - SQLServer 2005

15 Aug 2009 by Abhijit Jana

This article describes how to use RAISERROR in SQL Server 2005

A Comparison on Data Access Methods - Part 3

12 Oct 2013 by Dr. Song Li

This is the part 3 of a comparison on Data Access methods in the .NET environment.

A complete guide to object oriented application development using MyGeneration Framework and Visual Studio C# .NET

22 Aug 2014 by Gurdeep Singh Toor

A Complete Guide to develop aplication using MyGeneration code genration framework. We will develop a Meeting Room Booking web application in this Article.

A Connection String Manager for Multi-Environment Ecosystems

9 Mar 2021 by #realJSOP

This library is intended for use in a multi-environment system, but it certainly be used under less stringent environmental confines, even down to a single desktop machine taht needs to connect to a single database server.

A convenient DataGrid Pager Control

20 May 2005 by zhengdong jin

It's very easy to use and the most conventient DataGrid pager control.

A conversion of the popular DotNetNuke web application to C#

11 May 2007 by andrewcates

In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#

A Crontab Linux like Windows Service

30 Aug 2009 by marcominas

A Windows Service that uses interface to work like the Linux Crontab service

A Customized Crosstab Report

23 Feb 2008 by Nanaa

An approach on how to organize your data into tables that will help you generate large ‘Crosstab’ Reports using SQL Server.

A Fairly Capable Authorization Sub-System with Row-Level Security Capabilities (AFCAS)

12 Feb 2009 by Kemal Erdogan

An implementation of role-based authorization control (RBAC) model with row-level access control capabilities at the database server level

A Fast and Lightweight Solution for CQRS and Event Sourcing

8 Apr 2020 by Daniel Miller

Describes a fast, lightweight implementation of the CQRS+ES pattern using C#

A general-purpose service engine for unattended processing execution

23 Sep 2015 by Alberto Venditti

Using a .NET Windows service as an engine for specialized custom plug-ins execution

A generic bulk insert using DataSets and OpenXML

14 Apr 2005 by poodull76

Create T-SQL command text to update a table with OpenXML quickly and with minimal effort.

A generic loading of data in a DropDownList using caching mechanism

6 Apr 2005 by santosh poojari

This article shows you how to make use of DataAccessLayer and caching.

A guide to using Paneled Forms, Multi-Splash Screens, SQL Express, and many more in Windows Application Development

19 Sep 2005 by msalmank

A quick hands-on application to guide you in using paneled forms, multi-splash screens, SQL Express, and many more....

A helper object to migrate SQL Reporting Service items

10 Sep 2004 by Mark Brandon

A helper object library to automate migration of SQL RS items from development to production servers.

A lightweight AJAX.NET-enabled grid control

28 Jun 2008 by Simon Gulliver

A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.

A LINQ Tutorial: Adding/Updating/Deleting Data

11 Dec 2009 by Abby Fichtner (Hacker Chick)

A tutorial that walks through adding/updating/deleting data in your database with LINQ to SQL while keeping your class relationships (M:M, 1:M, and M:1) synchronized.

A LINQ Tutorial: Mapping Tables to Objects

12 Dec 2009 by Abby Fichtner (Hacker Chick)

A beginner's LINQ tutorial that walks you through mapping your SQL Server database tables and relationships to objects, and how to retrieve that data via simple LINQ queries.

A LINQ Tutorial: WPF Data Binding with LINQ to SQL

11 Dec 2009 by Abby Fichtner (Hacker Chick)

A tutorial and application on using WPF Data Binding with LINQ to SQL classes. This is part 3 of a three-part tutorial on using LINQ to SQL.

A Master-Detail Solution Using Single Input Controls

25 Nov 2005 by TofuBug24

Shows a solution for creating a Master-Detail relation using textboxes.

A method to migrate and automate exisitng DSTX SSIS package from SQL server 2005 to 2008 R2

9 Mar 2011 by santosh poojari

This article will provide the first step towards migrating error free dtsx package to higher version of sql server ssis

A Model to Represent Directed Acyclic Graphs (DAG) on SQL Databases

26 Jan 2021 by Kemal Erdogan

Addressing the general problem of representing directed acyclic graphs (DAGs) in SQL databases

A Naming Scheme for Database Tables and Fields

16 Jan 2008 by Robert Pittenger, MCPD-EAD

This article presents a naming scheme for database tables and fields.

A Neat Solution to GridView Custom Paging

5 Jun 2007 by Fadrian Sudaman

This article shows how to easily extend the GridView to support custom paging and remove the restriction of using ObjectDataSource as the data source.

A not so simple firewall.

21 Jun 2004 by gamitech

A not so simple firewall if I can call it so. This application will ask you if you want a certain program to start.

A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation

27 Apr 2011 by Niladri_Biswas

This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

10 Feb 2016 by 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.

A Practical Example Of Using The New Features Of ASP.NET 3.5

22 Jul 2008 by Mike Borozdin

Tutorial on using LINQ, ListView, LinqDataSource, DataPager, ASP.NET AJAX

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 5

19 Sep 2009 by Paul Rony

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application

A propertymapping Extension for DataReaders

26 Jan 2016 by Jörgen Andersson

A propertymapping extension for DataReaders

A Quick look at the new functoids in BizTalk Server 2006

20 Mar 2006 by Naveen Karamchetti

This article describes the new functoids in BizTalk Server 2006.

A scheduler GUI for SQL Server Agent

10 May 2012 by Alberto Venditti

An alternative to SQL Server Management Studio for scheduling SQL Server Agent jobs

A scripted SQL query generation framework with IDE: SQLpp (v1.4)

12 Sep 2003 by Jonathan de Halleux

A helper framework for generation of SQL queries in C++ and Lua

A set of ADO classes - version 2.20

6 Sep 2005 by Carlos Antollini

Simple database access using an ADO class.

A Set of ADOX Classes

19 Jun 2002 by Carlos Antollini

Simple database catalog access using a set of ADOX classes

A Set of MFC Wrapper Classes for ADO - Version 2.20J

16 May 2013 by Joffrey Brouillet

This is an alternative for "A set of ADO classes - version 2.20"

A set of ODBC Classes

27 Aug 2001 by Carlos Antollini

Two classes that make easy to work with ODBC

A simple count() query class

10 Jun 2005 by Paul S Ganney

A class to easily do count() queries.

A simple Database Viewer - DBViewer

18 Apr 2005 by Uri Lavi

A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).

A simple example of SQL server admin tools.

13 Sep 2009 by Md. Marufuzzaman

A simple example of SQL server admin tools.

A Simple GUI Tool for SQL 2005 Reports Deployment Without using BI Development Studio

25 May 2008 by Ahmed IG

A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio

A Simple RSS News Generating Tool

28 Apr 2005 by Stephan Pilz

A tool to generate/manage news and provide news via RSS.

A Simple Use of SQL CASE Expression

19 Aug 2009 by Md. Marufuzzaman

This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.

A Simplified SQL-CSV Import/Export Functionality

20 Oct 2005 by codeajay

A simplified SQL-CSV import/export functionality.

A SQL Management Console for MSSQL 2000 & 2005, MySQL 5.0,...

20 Apr 2008 by gan.gary

An article on a SQL IDE for different type of RDBMS databases

A SQLProcedure For MSSQL 2005 Of CustomPaging With RowNum And CustomPaging Without RowNum Both For MSSQL 2000 And MSSQL 2005

29 May 2009 by qubing

WITH Clause AND EXEC sp_executesql Clause Used In MSSQL 2005

A Standard ETL Sample in SSIS

6 Jan 2012 by Keshav Singh

This video demonstrates a standard extract-transform-load in SSIS

SQL-Server

DBA

SSIS

A T-SQL Regular Expression Library for SQL Server 2005

13 Dec 2008 by Steve Abraham

This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.

A Tool to Compare SQL Database Schema Versions

26 Feb 2009 by Lindsey Lewis

An article about a tool for comparing SQL database schema versions

A uniform interface for large texts for a C# SQL client

26 Jul 2009 by AlexS9999

The article provides a simple interface for handling large text in SqlClient and C# file streams.

A very simple example for creating a media gallery using VS 2005, C#, and SQL Server 2005

26 Sep 2006 by code-frog

Provide a very simple set of instructions for creating your own media gallery and loading your images from SQL Server 2005.

A web based application configuration wizard

18 May 2008 by defwebserver

A wizard that allows you to FTP an application to a remote server and then launch the configuration wizard from the web browser to update the database connection.

ABCs of Pro*C

23 May 2007 by vipulparmar

Basic understanding of Pro*C

About transaction log and its truncation in SQL Server

9 Aug 2012 by Wendelius

Article describes basic information about transaction log behavior and truncation of the log.

Abstract Nonsense in Software Development. Databases

18 Jan 2014 by Petr Ivankov

Application of abstract approach to database domain

Abstracting the ORM Framework

8 Jul 2013 by JP van Mackelenbergh

Abstracting the ORM Framework via Repository/Unit Of Work patterns

Accelerate Web Site Development with Kentico CMS - Content Management System for ASP.NET

10 Apr 2007 by Petr Palas

Do you spend days and nights developing dynamic web sites in ASP.NET? Do you need to simplify your job, get more sites done and gain more clients? Kentico CMS for .NET will help you.

Access .NET assembly through SSIS (Script Component)

8 Oct 2006 by Malpani Amol

Here is some cool stuff to call .NET assembly from SSIS

Access SSIS package activities and variable through .NET application

8 Oct 2006 by Malpani Amol

This article will drive you, how to access and update properties and variable of SSIS package using .NET application

Accessing dBase Files

1 Jul 2003 by thomask

How to access a dBase file

Accessing MS SQL Server CE v1.0/v2.0 without ADO

2 Mar 2003 by CT CHANG

Add, edit, and delete records/table/database in MS SQL Server CE v1.0/v2.0.

Accessing MSMQ from Microsoft SQL Server

26 Mar 2007 by Wojtek Jeziorczak

How to send/receive MSMQ messages in SQL Server using CLR Integration

Accessing the Borland Database Engine (BDE) from Visual C++

17 Nov 1999 by Robert Pittenger, MCPD-EAD

Accessing the SQL Server Virtual Device Interface via .NET (C#)

3 Jul 2007 by Steve Abraham

This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language

Active Directory change tracking

9 Jan 2016 by 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.