Microsoft Indexing Service HOW-TO
This article describes how to provide full text search using Microsoft Indexing Service in .NET applications.
2007-07-20
2,379 reads
.Net
SQL Agent - A Job Scheduler Framework
In this article, I'll show you how to create a generic scheduler that runs on a Windows Service. The scheduler will be able to accept pluggable actions that we can develop later implementing a custom interface.
Background
2007-07-17
3,240 reads
CLR: Digging into IDisposable
One of the major productivity benefits that the common language runtime (CLR) offers developers of managed code is that the garbage collector (GC) makes sure any memory allocated on the managed heap is cleaned up after it is no longer needed.
2007-07-13
1,942 reads
Debugging Stored Procedures in Visual Studio 2005
This article walks through the basics of debugging stored procedures using Visual Studio 2005. It covers breakpoints, watches and stepping through code.
2007-07-05
4,532 reads
Gathering RSS Feeds using Visual Studio and RSS.NET
If you would like to learn how to build and customize your very own Windows service to retrieve posts from multiple RSS feeds, and then store those posts in a SQL Server database, let John Papa guide you through his tutorial.
2007-05-25
2,081 reads
Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server
The .NET Framework 2.0 introduces a very handy new class in the System.Data.SqlClient namespace called SqlBulkCopy that makes it very easy and efficient to copy large amounts of data from your .NET applications to a SQL Server database. You can even use this class to write a short .NET application that can serve as a "middleman" to move data between database servers.
2007-05-09
3,525 reads
Dynamic Images and Databases
Should you store dynamically generated web-site graphics in a database or is the file system the better option? Dino illustrates how to make this decision in ASP.NET
2007-04-17
3,883 reads
Regular Expression Based Token Replacement in ASP.NET
Damon Armstrong presents an extremely powerful and flexible token replacement mechanism for your ASP.NET applications. It is based on regular expressions so allows you to search for dynamic text, instead of just a static token, in a given string.
2007-01-26
2,182 reads
Part 1: Developing an object oriented database in less than 140 lines
One of the best benefits of the .NET Framework over lower level programming is that it enables developers to create very complex, custom solutions, without writing low-level code. Zach Smith explores how you could take advantage of the built-in .NET Framework functionality to develop a simple object oriented database in less than 140 lines of code.
2007-01-19
4,211 reads
The Enterprise Library for .NET Framework 2.0
What does a SQL Server developer care about the Enterprise Library? SQL Server guru David Poole is starting to work with .NET and brings us his perspective on what this library is and how it benefits those who develop against SQL Server.
2006-08-21
15,250 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Community at PASS Summit
Comments posted to this topic are about the item Community at PASS Summit
ASCII value of certain column is null
When ASCII(Column) is null, what does it represent? Is this some kind of special/control...
Ask SSC