| Novick Software |
| Put this feed on your website |
| Description: |
The Novick Software web site brings you frequent articles
about software development using SQL Server, .Net and
related technologies. |
| Format: |
RSS 2.0 |
| Url: |
http://www.NovickSoftware.com/rss.xml |
| |
| Latest headlines |
Novick Software
|
dba_spaceused
Tue, 5 Jun 2007 20:28:11 -0400
This article presents a stored procedure for convenient reporting of the space consumed by each table. It's uses SQL Server's sp_spaceused to compatibility but includes the schema so that like named tables can be distinguished.
|
CSLA: What and Why
Tue, 5 Jun 2007 20:27:26 -0400
Presentation on CSLA, the business object architecture that I use.
|
User Defined Functions in SQL Server 2005
Tue, 5 Jun 2007 20:27:00 -0400
This presentation brings you up-to-date on UDFs. Examples of both T-SQL and SQLCLR functions are supplied along with the sample database.
|
SQL Server 2005 Service Broker Presentation
Sun, 14 May 2006 10:46:46 -0400
Service Broker is a component introduced in SQL Server 2005. This presentation with an accompanying example script describes Service Broker and discusses how it might be used.
|
Book Review: Murach's ASP.Net 2.0 Upgrader's Guide: VB Edition
Mon, 2 Jan 2006 10:28:48 -0400
This is a targeted book for the experienced ASP.Net developer who's ready to move up to ASP.Net 2.0. I recommend it.
|
Presentation: An Application for Executing Ad Hoc SQL in a Regulated Environment
Fri, 11 Nov 2005 13:04:58 -0400
What do you do when the data in an application is incorrect and the application isn't able to correct the situation? You fix it, right? That approach doesn't sit well with the policies required by the regulatory compliance requirements of HIPPA and SOX, nor do auditors look on it favorably. This presentation demonstrates an application built to allow ad hoc changes to data and create an audit trail of changes. Along the way we'll see some interesting T-SQL and use of SQLXML.
|
Coding-in-SQL issue: A SQLCLR Stored Procedure to Write to a Trace File
Fri, 4 Nov 2005 12:14:32 -0400
This issue shows a stored procedure written in Visual Basic.Net that writes a line of trace information to a file. It's an example of an assembly that uses requires the External_Access permission set. Included is a discussion of permission sets and some of the error messages encountered while creating the procedure. The download includes the source code and an example output file.
|
SQL Server Programming: From 2000 to 2005
Mon, 24 Oct 2005 20:56:41 -0400
This full day presentation was a Microsoft Mini-Code Camp given October 22nd in the Microsoft Waltham, MA office. I joined Adam Machanic to write and and present. The presentation covered SQLCLR, Service Broker, User-Defined Functions in both T-SQL and .Net. Slides and examples are available on the link page.
|
Utilities for .Net Development in VB.Net & C#
Fri, 21 Oct 2005 08:08:39 -0400
List of development utilities with links to where you can get them. The list includes both free/open and commercial utilities. This page was produced in connection with the Developer Utility Roundup presentation.
|
.Net Developer Utility Roundup
Fri, 21 Oct 2005 08:06:18 -0400
There are hundreds of development utilities available to .Net developers. This presentation was given at the New England Visual Basic Professionals User Group's Developer Utility Roundup.
|