WynApse Home Page
Home    Blog    About    Contact       

XAML
Silverlight Articles
Silverlight Tutorials
Silverlight Tooltips
Windows Phone
Metro Articles
C#
General
Legacy Code
Tagged Posts
Silverlight Cream
Windows Dev News
Latest Article:


My Tags:
My Sponsors:

Lifetime Member:

Articles for tag: SQL


A Little Linq to Sql

A More Efficient Method for Paging Through Large Result Sets

A reliable dependency viewer / tracker / checker for SQL 2005

Academic Tutorials

Accessing and Updating Data in ASP.NET 2.0: Handling Database NULL Values

Accessing and Updating Data in ASP.NET 2.0: Inserting Data

Accessing and Updating Data in ASP.NET 2.0: Updating Basics

An Easy Way to Detect Duplicates in a Given Data Set

ASP.NET Security [Part I]

ASP.NET Tips and Tricks and LINQ Slides/Demos from CodeMash

Attaching multiple sqlite databases in WP7

Build a Script-Only ASP.NET 2.0 Data Editing Page

Building a Shopping List

Copying Data From SQL Server Management Studio

Create a Custom Profile Provider in ASP.NET 2.0 Using LINQ To SQL For Kicks

Creating a Quick and Dirty Online Blackjack Game

Creating an Event Calendar

DataBase Design & Creation

Debugging Linq To Sql

Debugging SQL Server 2005 Stored Procedures in Visual Studio

Deploying a Local Database to a Remote Web Host

Displaying Detail Records for User-Selected Master Records

Displaying Detail Records for User-Selected Master Records :: Using a Dynamic IN Clause

Efficiently Paging Through Large Result Sets in SQL Server 2000

ExecuteSql()

Extracting a SQL CE DB from Isolated Storage in WP7 Mango.

Filtering and Sorting in ADO.NET

Filtering Custom Paged Results

Free SQL Server Training Videos (and other good data tutorial pointers)

Frequently Asked Questions in SQL Server 2005 - Programmer Perspective

Getting Changed Entities from a LINQ to SQL DataContext

Great New ASP.NET 2.0 Data Tutorials Published

How to Protect Your Application Against Parameter Injection

How to Read/Write an Image to Database in Binary Format

HOW TO: Use SQLite in C# Metro style app

Implementing Dynamic WHERE-Clause in Static SQL

Implementing the Repository Pattern with LINQ-to-SQL

Improving the image upload sample

LINQ to SQL (Part 2 - Defining our Data Model Classes)

LINQ to SQL – Poormans DAO / CRUD.

Linq2Sql: How to join tables on more than one column

LinqToSQL A Detailed Review

Logging in to another SQL Server from a PowerShell session

Maintaining a Log of Database Changes - Part 1

Maintaining a Log of Database Changes - Part 2

Making simple search solution

More In-Depth About Nulls And DBNull

MS Access SQL

My favorite SQL2005 feature

NET DateTime, SQL dateTime, SQL date, a small Cheatsheet

New Embedded Database Support with ASP.NET

NotSupportedException w/ Sql CE on WP7 Mango

Passing Multiple Records to a Stored Procedure in SQL Server

Programmatically Accessing Data using the Data Source Controls

Read the SQL Server Error Log with PowerShell

Reading and Writing Excel Spreadsheets Using ADO.NET C#

Relational Database Management Systems - Concepts and Terminologies

Retrieve data from a web page

Retrieving and saving images from SQL Server using RIA Services and Silverlight

Retrieving Data from a SQL Server 2005 Database Using the SQL DataSource Control in ASP.NET 2.0

Retrieving the Just-Inserted ID of an IDENTITY Column Using a SqlDataSource Control

Richard's Way: Four Easy Steps To Create Complex SQL That Runs Fast

Rolling Your Own Website Administration Tool - Part 2

Run a SQL Server Command from PowerShell without the SQL Server Provider

Saving and Retrieving Web Page Control with SQL Server and C#

Search Stored Procedures

Serialization in Database

SQL Azure Database Manager – Part 1 : How to connect to your SQL Azure DB

SQL Azure Database Manager – Part 2 : Now you’re in, take a tour

SQL Quick Reference

SQL Server 2008 - Transparent Data Encryption

SQL Server 2008- Backup Compression

SqlCeException–The specified table does not exist. [ TABLENAMEHERE ]–WP7 Mango

Storing Binary Files Directly in the Database Using ASP.NET 2.0

Storing Files in SQL Server using WCF RIA Services and Silverlight – Part 1

Storing Files in SQL Server using WCF RIA Services and Silverlight – Part 2

Storing Files in SQL Server using WCF RIA Services and Silverlight – Part 3

Storing Images as Serialized Strings in Code Instead of in Resource Files

Think you know how to write UPDATE statement? Think again.

Transferring Data Using SqlBulkCopy Class

Tuning Up ADO.NET Connection Pooling in ASP.NET Applications

Understanding Connection Pooling in .NET

Understanding Date and Time Functions and Operations in SQL Server

Understanding Full Text Search in SQL Server 2005

Understanding INNER JOINS in detail

Understanding Transaction in ADO.NET

Using LINQ to SQL (Part 1)

Using ObjectDataSource to do the dirty work for your custom data source

Using SQL CE on WP7 Mango–Getting Started

Using SQL CE On WP7 Mango–Working with Associations

Using SQL CE On WP7 Mango–Working with Indexes

Using SQLite in a Metro style app

Using SqlMetal to generate Windows Phone Mango Local Database classes

Video - SQL2008 and Table Valued Parameters

Virtual Earth: Drawing on the map and storing the result in SQL Server 2008

Visual Studio and SQL Server 2008

Working with Binary Large Objects (BLOBs) Using SQL Server and ADO.NET

Working with Data in ASP.NET 2.0

Working with SQL Server LocalDB in LightSwitch Projects in Visual Studio 11


Microsoft MVP

Member of WPF and Silverlight Insiders
Silverlight Control
Creative Commons License
Copyright © 2006-2013, WynApse