Click here to Skip to main content
14,882,622 members
Everything / Database Development / SQL Server

SQL Server

SQL-Server

Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by Jovan Popovic(MSFT)
Mapping properties in EF model to database columns that contain JSON
by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse

Latest Articles

by Ralf Meier, Shah Samiur Rashid
Codeless Combobox for VB.NET/C# platform with MySQL/SQL Server database applications
by KristianEkman
An online Angular, .NET 5 Web API, SQL Server on Azure backgammon game
by Sergii Syrovatchenko
Open source index maintenance tool for SQL Server and Azure
by 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.

All Articles

Sort by Score

SQL Server 

Please Sign up or sign in to vote.
18 Jan 2017
Jovan Popovic(MSFT)
Mapping properties in EF model to database columns that contain JSON
Please Sign up or sign in to vote.
24 Aug 2009
Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
Please Sign up or sign in to vote.
22 Oct 2017
thangchung
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.
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.
3 Sep 2008
Ahmed Negm
This article introduces how to create and manage .NET enterprise applications using your favorite technology (Data Access Application Block, LINQ, NHibernate, ASMX, and WCF) with the Model Driven Development approach by Sculpture.
Please Sign up or sign in to vote.
16 May 2013
dale.newman
Google your SQL.
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.
14 Aug 2013
Harmen Brouwer
How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.
Please Sign up or sign in to vote.
27 May 2020
Theo Kand
An original AngularJS implementation of the most famous video game ever
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.
1 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.
Please Sign up or sign in to vote.
11 Oct 2011
Enrique Albert
Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.
Please Sign up or sign in to vote.
30 Apr 2021
KristianEkman
An online Angular, .NET 5 Web API, SQL Server on Azure backgammon game
Please Sign up or sign in to vote.
25 Oct 2008
Abhijit Jana
Overview of Log Shipping in SQL Server 2005
Please Sign up or sign in to vote.
17 Aug 2009
vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
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.
23 Apr 2012
Kuthuparakkal
SSIS and Excel Automation
Please Sign up or sign in to vote.
27 Jun 2012
freedeveloper
A small control to control paging in Windows Presentation Foundation.
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.
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.
Please Sign up or sign in to vote.
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.
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.
21 Dec 2007
Bruno Sonnino
This article will show how to use data binding and styles to show data coming from a Microsoft SQL database using the new object-relational model introduced in Visual Studio 2008, LINQ to SQL, allowing grouping, sorting and filtering of data with almost no code.
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.
17 Apr 2012
Nadege Rouelle
Shows how to configure Entity Framework Code First with Data Annotations and Code Fluent.
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.
25 Nov 2016
kannankeril
This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.
Please Sign up or sign in to vote.
7 Sep 2009
Tamer Oz
PocketPcAgent is an application that can be installed on Windows Mobile devices that are running Windows Mobile 5.0 or higher. The application listens to events such as SMS Received, Call Missed, E-Mail Received, Battery Strength Changed, and much more on the Pocket PC.
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.
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.
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.
17 Jun 2009
Sacha Barber
SQL Server CLR functions
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.
25 Oct 2012
Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
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.
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.
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.
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.
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.
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.
2 Aug 2009
Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
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.
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.
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.
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.
2 Jan 2021
#realJSOP
A tool to generate model and viewmodel classes directly from your selected database
Please Sign up or sign in to vote.
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.
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.
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.
8 Oct 2015
DrABELL
App implements bi-directional semantic phone number-to-text converter, extended with novel Lottery+Quiz engine
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.
31 May 2015
Milan Matějka
Compare likenesses and differences between Temporary Tables and Temporary Variables
Please Sign up or sign in to vote.
8 Jun 2015
Dirk_Strauss
LEADTOOLS Recognition Imaging SDK - I had the pleasure of taking the SDK for a spin, and let me tell you it was well worth it.
Please Sign up or sign in to vote.
27 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
Please Sign up or sign in to vote.
13 Mar 2017
defwebserver
You can create database driven .Net Core applications using JavaScriptServices, and PrimeNG.
Please Sign up or sign in to vote.
19 Sep 2017
Igor Krupitsky
Application lets you copy tables from Paradox to SQL Server
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.
30 Jul 2009
Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
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.
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.
18 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.
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.
20 Nov 2019
Igor Krupitsky
Application lets you copy tables from folder with DBF files to SQL Server
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.
20 Apr 2009
András Slyuch
This class collects data rows in the memory and saves them into a Microsoft SQL database with SqlBulkCopy.
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.
17 Dec 2012
AshishChaudha
There are many scenarios in which the data can be bound in a Gridview, in which various operation other than provided by default by gridview needs to be implemented. In this article we will try to bind such operations with some more features.
Please Sign up or sign in to vote.
5 Feb 2013
Gokulnath007
To get instant control over Outlook and various operations of outlook.
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.
31 Jul 2013
apmyhr
Job Match helps job seekers find employment with the right company
Please Sign up or sign in to vote.
6 Nov 2013
Sichen D
How to build system availability timeline in SSRS
Please Sign up or sign in to vote.
24 Jun 2015
Khaled Abdelhamid
Drawing on a web page on the fly using GDI+ and Flood-Fill Technique
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.
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.
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.
30 Sep 2017
#realJSOP
Create and run jobs kinda like SQL Server Enterprise - Interesting Coding
Please Sign up or sign in to vote.
17 Nov 2018
Terence Wallace
A brief article on how to utilize NBA Stats API in a WinForm application
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.
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.
16 Apr 2009
MiamiCoder
How to create a real-world BlackBerry application.
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.
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.
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.
8 Jan 2013
mparvez
How to execute SQL from a file for various purposes.
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.
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.
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.
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.
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.
4 Jun 2018
Shayne P Boyer
Why should we care about containers for development
Please Sign up or sign in to vote.
14 Jul 2019
Viswanatha Swamy
In this article, we will be looking at how to use SQL Server 2017 Docker image for Local Web API development.
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.
9 Mar 2021
#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.
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.
23 Feb 2009
Walid Abdulrazik
An extension to the Microsoft SqlProfileProvider, to provide a search interface. This article is based on Shawn Wildermuth's - "a.k.a. ADO Guy" - work.
Please Sign up or sign in to vote.
9 Nov 2010
Sergei Dumnov
It explains how to display business intelligence dimension table using Silverlight TreeView
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.
28 Nov 2011
Member 7656529
A review of the book Microsoft Visual Studio LightSwitch Business Application Development.
Please Sign up or sign in to vote.
29 Jul 2012
Anup Ghosh for C# & SQL SERVER
The steps to migrate on-premise database data to SQL Azure.
Please Sign up or sign in to vote.
1 Oct 2012
DaveDbViewSharp
Develops an analogy between database table and file directory information and argues that it could be very useful if it were possible to have a similar application to Windows Explorer for database tables. Demonstrates how to obtain the information from Sql Server system tables and dynamic management
Please Sign up or sign in to vote.
20 Dec 2012
mparvez
Dynamically restore full and all transaction log backup.
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.
17 Jul 2013
Tom Glick Philadelphia, US
Run-Time Stored Procedure Processing (get input values, return GridView/Excel File)
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.
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.
21 Apr 2016
Emmanouil Gimissis MSc ICSD
Calculating progressive sums in
Please Sign up or sign in to vote.
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.
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.
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.
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.
5 Apr 2020
DiponRoy
Select data as DataTable object for a database using Entity Framework
11 Apr 2011
Ben Demes
A demonstration of how you can quickly create a simple help desk application using modern development tools with little to no hand coding required.
Please Sign up or sign in to vote.
15 Dec 2008
Enrique Albert
A log4Net example: how to consolidate SQL scripts using log4Net.
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.
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.
26 Oct 2009
dougturn
An overview of the Microsoft interoperability story for Open Source community and PHP Developers.
Please Sign up or sign in to vote.
6 Apr 2010
Rainer Halanek
A Connection Scope for the Entity Framework that allows to execute commands in a single connection
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.
29 Jun 2012
Venkat Chaitanya Kanumukula
Maintenance of Definition's in multiple Dynamics AX Environments
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 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.
Please Sign up or sign in to vote.
24 Jan 2016
RickZeeland
This is an alternative for "SMO Tutorial 3 of n - Scripting"
Please Sign up or sign in to vote.
6 Jun 2018
Gunnar S
Third article in a series of three regarding NServiceBus, WebAPI and Azure Service Fabric
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.
10 Dec 2020
Leif Simon Goodwin
Simple WPF app that shows how to use PetaPoco library to manage an SQL database
7 Jan 2007
William Brewer
With SQL Server, it is strange how some of the most radical improvements that have been introduced over the years have been slipped in almost unnoticed.
2 Apr 2012
Sanjay_Bhatia
With the advent of abundant memory, the majority of user requirements can be delivered without having to build separate data warehouses or using modeling technologies like MDX. This article shows how to use time compression to deliver rapid analysis of enormous data volumes using simple SQL views.
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.
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.
17 Dec 2007
mfmaneef
Explains how to send bulk records to a database using OPENXML.
Please Sign up or sign in to vote.
29 Apr 2009
Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
Please Sign up or sign in to vote.
27 Apr 2009
Aneesur Rehman Khan
Consume 32 bit COM DLL in x64 bit SQL Server 2005
Please Sign up or sign in to vote.
13 May 2009
Paul S. Chapman
Windows Azure, TDS, WCF, Silverlight and a few problems on the way
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.
26 Jun 2009
David O'Sullivan
See how Catharsis can help you rapidly develop robust enterprise level applications.
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.
25 Dec 2009
db_developer
Establishing of an existent connection to SQL Server with a sample: XML/A script execution tracing.
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.
16 Apr 2010
Rabb Moshe Plotkin
How to make a responsive application by not having to wait for your LINQ to SQL to return from the server
Please Sign up or sign in to vote.
13 Apr 2010
Abdul_Rafay
SQL Server Query Notification with BizTalk Server 2009 WCF SQL Adapter
Please Sign up or sign in to vote.
10 Dec 2010
Beavis Killer
This article demonstrates how to generate plain old class objects (POCO) from the Entity Framework v4 (EF4) and use them through RIA Services in SilverLight version 4.
Please Sign up or sign in to vote.
26 May 2011
Keshav Singh
Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the second part.
Please Sign up or sign in to vote.
13 Jun 2011
Steinar Moen from Norway
This article describes an implementation on BizTalk 2006/R2/BizTalk 2009 where a received message is split and sent to many different destinations.
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.
20 Sep 2011
Soptik Dutta
Explains an alternative way of stsadm restoration of a Site Collection.
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.
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.
22 Dec 2011
Keshav Singh
This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
Please Sign up or sign in to vote.
10 Jun 2012
Manar Ezzadeen
PowerShell script that generates an HTML report displaying different information about the SQL Server databases, their CLR assemblies and owners.
Please Sign up or sign in to vote.
24 Feb 2013
gmaran23
Create an EventHandler in SSIS, add a ScriptTask to it, add code files to the ScriptTask and compile the solution - programmatically in C#
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.
28 Apr 2013
freshbreeze
Cloud Solution to help Patients to get rid of Drug Addiction and take medicines on time. Failing to take drug will trigger notifications to Doctors. Drug reminders will be available in Live Calendar and Proofs for taken medicines will be stored in SkyDrive.
Please Sign up or sign in to vote.
30 Apr 2013
Brian Legg
Danger Dodger will keep track of the amount of danger you're in at any given point in time and help you to avoid it.
Please Sign up or sign in to vote.
29 Apr 2013
rodney128
A windows Azure development to showcase online geocoding and mapping.
Please Sign up or sign in to vote.
2 May 2013
DThrasher
Converting a Windows 7 desktop application to Windows 8 and Azure.
Please Sign up or sign in to vote.
13 May 2013
Randall Smith II
A simple solution trying out the Azure platform for development and deployment.
Please Sign up or sign in to vote.
3 Jun 2013
Mark Kestenbaum
An entry to the Windows Azure Developer Challenge.
Please Sign up or sign in to vote.
5 Mar 2014
bconlon
XSD 1.1 support in Liquid XML 2014
Please Sign up or sign in to vote.
25 Aug 2015
bconlon
XSD 1.1 support in Liquid XML 2014
Please Sign up or sign in to vote.
16 Jun 2016
Jovan Popovic(MSFT)
How to easily compare two rows in SQL Server using new JSON functionalities
Please Sign up or sign in to vote.
13 Mar 2017
yuvalsol
Keep the view state out of the web page and store it in SQL Server
Please Sign up or sign in to vote.
6 Jul 2018
Manjuke Fernando
How to replace sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities
Please Sign up or sign in to vote.
11 Sep 2018
Steven L. Wentworth (12896862)
Using combination arithmetic to improve quality of SQL table design and execution
Please Sign up or sign in to vote.
30 Dec 2018
mohghaderi
Add Debug/Release deployments to SQL Server database projects using build events and powershell
Please Sign up or sign in to vote.
27 Jan 2019
Melick
How to resolve the issue: AppFabric installation failed because installer MSI returned with error code: 1603
Please Sign up or sign in to vote.
3 Feb 2019
Melick
SharePoint 2016 Installation using AutoSPInstaller Online - how to set up the environment and service accounts
Please Sign up or sign in to vote.
12 May 2019
Manjuke Fernando
Observations made for a strange behavior on JSON_VALUE when table contains blank and non-blank values
Please Sign up or sign in to vote.
15 Feb 2021
kusnaditjung
How to create Entity Framework Core 5 data migration in .NET 5
Please Sign up or sign in to vote.
3 May 2013
Mohan Mallampalli
A HTML5 note taking app capable of capturing Video notes.
24 Jun 2004
Redgate Software
A simple solution to scripting when sysdepends are damaged
13 Jun 2005
IronSpeed Inc.
Taking full advantage of the built-in infrastructure services of the Microsoft .NET Framework - without taking months to learn new languages, APIs and protocols - is one of the most pressing challenges faced by enterprise application developers today.
20 Oct 2005
Redgate Software
Using a combination of iScala, SQL Server and Red Gate's software tools to manage data processes.
3 Feb 2006
Redgate Software
Essential tools for easy migration to SQL Server 2005.
2 May 2006
Petr Palas
This article compares various approaches to storing, editing, and displaying structured content on the web. It shows the advantages and disadvantages of using XML and relational SQL databases.
30 Jun 2006
Redgate Software
SQL Dependency Tracker allows you to graphically visualize database object dependencies. This means that users can track down potential "collateral damage" before pushing database changes through. With this ingeniously simple to use tool, you can also document database dependencies.
1 Nov 2006
Redgate Software
This article describes how you can use SQL Refactor to sharpen up your T-SQL.
7 Nov 2006
Daniel Wood
Learn how changing the way you write queries can make them run faster. This article will describe the automated approach to optimizing SQL. DBA's have been doing it for years, now it's available for developers.
7 Dec 2006
James Westgate
Use an agile managed database framework, and feel you've finally reached programming heaven.
21 Dec 2006
Redgate Software
Database professionals have a special role in their workplace because they bear responsibility for customer database integrity. This article argues that the 'online' or 'lock ladder' database development model, which uses live instances is the only way to ensure true database integrity.
7 Jan 2007
Robyn Page
Some seemingly simple requirements such as getting the DATETIME for the "start of the month" can be surprisingly tricky.
10 Apr 2007
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.
15 Jun 2007
Atanu Banerjee
A composite application is a collection of software assets assembled to provide a business capability. These assets can be deployed independently, enable composition, and leverage specific platform capabilities. Microsoft Office's comprehensive platform for this is Office Business Applications (OBA)
7 Jan 2008
Visual Numerics, Inc.
This document focuses on the combination of VSTO 2005 and Visual Studio 2005 Team Edition.
20 Sep 2010
DBI Technologies Inc.
What’s the best method for binding schedule controls to a database? A response is normally focused on the needed implementation; however, business rules can be used to define strategic implementations. This Showcase uses Warehouse Shipments and Dock Scheduling as a metaphor for exploring the topic
14 Mar 2011
Redgate Software
Continuous integration makes development more efficient – allowing bugs to be caught earlier, and providing rapid validation. But for too long, it hasn’t been standard practice for databases. This is an overview of implementing CI so you can bring database code in line with application development.
8 Apr 2014
Jeffrey T. Fritz
In this article, I’m going to show you how to set up dtSearch with an Entity Framework dataset and then use faceted search navigation to add multiple filters to the result set.
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.
4 Jun 2014
rapidagiledevelopment
The Software Development process can be time consuming and stressful. Outlined here are some practical tips on how to ease the strain with kissIT!® applications within the context of Prototyping / Agile methods for SQL, C# & VB.NET.
14 Jul 2014
Redgate Software
If you’re thinking about adopting database source control, or have a system but aren’t using it consistently yet, here are seven tips to avoid deployment disasters.
1 Aug 2014
Chris_Yates
When managing a large amount of servers and databases, having an efficient way to search for objects in a particular database, SQL Server instance or the object metadata is crucial. DBA Chris Yates tells us why SQL Search from Red Gate helps him achieve this with ease, and at no cost.
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.
28 Oct 2014
Grant_Fritchey
Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong.
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.
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#.
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.
30 Jan 2018
Quest Software
If you wanted to ramp up database DevOps, which development tasks would be most important for you?
Please Sign up or sign in to vote.
27 Apr 2021
Sergii Syrovatchenko
Open source index maintenance tool for SQL Server and Azure
Please Sign up or sign in to vote.
24 Jun 2012
Patrick Kalkman
A complete WP7 application with SQL compact database, LINQ to SQL, MVVM Light and Dropbox integration
Please Sign up or sign in to vote.
3 Apr 2019
Mahsa Hassankashi
Best approach for having more secure channel to transfer user information throughout the web
Please Sign up or sign in to vote.
12 Jan 2014
Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
Please Sign up or sign in to vote.
21 Apr 2004
Armen Hakobyan
Using SQL-DMO to shrink SQL Server transaction logs.
Please Sign up or sign in to vote.
8 Dec 2015
Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
12 Sep 2003
Jonathan de Halleux
A helper framework for generation of SQL queries in C++ and Lua
Please Sign up or sign in to vote.
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
Please Sign up or sign in to vote.
12 Mar 2015
TarikHuber
SQL Table Toolkit is a Class Library offering a quite large amount of tools for fast and easy work with SQL Tables
Please Sign up or sign in to vote.
28 Apr 2005
emadns
How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.
Please Sign up or sign in to vote.
20 May 2010
Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
Please Sign up or sign in to vote.
11 Sep 2010
Renil Joy, Bangalore
Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.
Please Sign up or sign in to vote.
8 Apr 2020
Daniel Miller
Describes a fast, lightweight implementation of the CQRS+ES pattern using C#
Please Sign up or sign in to vote.
11 Jun 2011
Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
Please Sign up or sign in to vote.
11 Mar 2020
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).
Please Sign up or sign in to vote.
17 Jul 2016
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
Please Sign up or sign in to vote.
3 Apr 2019
Mahsa Hassankashi
This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.
Please Sign up or sign in to vote.
19 Jun 2012
David Catriel
How to get a list of data rows that caused an exception (or several of them) in a SqlBulkCopy operation
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
19 Apr 2012
Sacha Barber
A look at designing a service layer using good practices, and the MSFT technology stack.
Please Sign up or sign in to vote.
29 Oct 2008
Giovanni Bejarasco
A walkthrough in UDT programming with primary focus on database concepts.
Please Sign up or sign in to vote.
25 Mar 2018
Ryan G Conrad
Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL
Please Sign up or sign in to vote.
28 Dec 2011
Evoluteur
A look at the minimal metadata needed (database mapping and user interface) for generic CRUD applications using the example of a to do list.
Please Sign up or sign in to vote.
26 Apr 2016
Jose Segarra
Support routines for handling JSON in SQL Server
Please Sign up or sign in to vote.
11 Jun 2011
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
Please Sign up or sign in to vote.
6 Aug 2013
Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
Please Sign up or sign in to vote.
25 Sep 2012
_Amy
Dynamic menu generation according to user privileges from database.