| Home
>> Feeds
Directory >> Computers
>> Software >>
Novick Software |
Novick Software
Novick Software
The Novick Software web site brings you frequent articles about software development using SQL Server, .Net and related technologies.
- dba_spaceused
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.
- User Defined Functions in SQL Server 2005
This presentation brings you up-to-date on UDFs. Examples of both T-SQL and SQLCLR functions are supplied along with the sample database.
- CSLA: What and Why
Presentation on CSLA, the business object architecture that I use.
- SQL Server 2005 Service Broker Presentation
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
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
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
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
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#
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
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.
- Coding-in-SQL Issue: Performance of .Net Code in SQL Server 2005
.Net code is great, but how does it perform. This article shows a UDF that takes 1/3 the time of the T-SQL equivalent. However, the overhead of UDFs can still be substantial.
- Creating SQL Server User-Defined Types (UDT) with .Net
This presentation discusses the details of User Defined types in SQL Server 2005. This was originally given at the Microsoft Code Camp IV on Sept 24th.
- Programming SQL Server 2005 (Yukon) with .Net Updated
This presentation describes CLR/.Net programming in SQL Server 2005. The examples include a sample UDF, stored procedure, and user-defined aggregate. This presentation was updated for Microsoft's Code Camp IV on Sept 24th and 25th.
- Coding-in-SQL Issue: Programming SQL Server 2005 with the .Net CLR
This issue introduces .Net programming in SQL Server 2005 and shows a simple User-Defined function written in VB.Net
- Visual Basic.Net Resources
Page to like to some Visual Basic Resources. In particular resources for Visual Studio 2005 and converting from VB6 to .Net.
- Personal Blog: Andy's Guy Stuff
I've launched a personal blog that has nothing to do with computer programming, just guy stuff: kids, games, TV, sports, food, family, houses, lawns, little league, and stuff like that. The first post is about a problem with a frozen drain pipe.
The site is http://andysguystuff.blogspot.com/ There's an RSS feed using the Atom format at: http://andysguystuff.blogspot.com/atom.xml I chose the format with the blog content in the feed. Let me know if you like feeds that way.
- Create a User Defined Aggregate with SQL Server 2005
In response to a challenge I've created a SQL Server Product aggregate. SQL Server 2005 allows the creation of User Defined Aggregates in VB.Net or C#. This article shows how simple it is to create and use a user defined aggregate.
Newsfeed display by CaRP
|
