|
|
| Articles about SQL Server, .Net, and other development topics. Features the T-SQL UDF of the Week Newsletter. |
RSS Feed URL : http://www.NovickSoftware.com/rss.xml
Category : SQL & databases
Total Views : 20 |
| Latest entries from this feed url |
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.
|
|
|
|
|
Latest Fox News Feed |
How to Create an Enjoyable Web Page Design
Novice and professional designers alike – you may probably be skilled enough of any one or all of the techniques in creating a Web page and designing them. However, not all designs, even those made by authorities in the field, prove to be enjoyable and entertaining enough for the users. This is a fact that we hope does not irk some of our design enthusiasts and discourage them from honing their skills.
In terms of honing your skills in Web design, here are several pointers that will give you a chance to make enjoyable designs on a web site. These elements should be kept in mind to make it easier for your customers to interact with your web page, get satisfied with what they’re looking for and thoroughly have an enjoyable experience.
What’s a Design Dinosaur
Are you fond of applying and scrambling old and new design clichés in one helpless web page? Are you one of the thousands not yet enlightened that ‘too much of a good thing is bad’? Are you too engrossed in improvising other designs and not coming up with your own?
Being a design dinosaur is a common sickness among designers who tend to be exposed and awed in latest design clichés coming out and copying or improvising them to concentrate on making his / her original design. But this practice isn’t entirely wrong, though. There’s always some "monkey see, monkey do" in the design world. Someone comes up with a great logo, Website, package and the next thing you know, they’re everywhere.
What’s bothersome in using most design clichés is that it implies you're not using up your own talents as a designer. In graphic designing, the ultimate creation to make you cry “Eureka!” may come upon us on our thirtieth attempt. This moment will happen once you really challenge and stretch yourself.
Set up Your Online Portfolio
Planning to set up your very own online portfolio? Very well, then you have to know first what’s an online portfolio and its uses. Of course, you also have to know how to take lay out you portfolio online in order to take advantage of it more.
Online portfolios are collections of pictures and information about individuals or companies which are posted in the web. These portfolios are a showcase of your skills, services and talents for prospects. By viewing your online portfolio, the right kind of users may happen upon it and acquire the services you’re offering.
|
|
Popular Fox News Searches |
|
news feed WWF news latest for news feed news feed wwf nesws news web marketing madical news health news fox news News and Opportunities news sabah times digital camera news news right now fox news WWF NEWS Developer News medical news feed Search result for Related feed to KEPUTUSAN PERMOHONAN SMK TEKNIK Free And Clear Real Estate Articles By JOHN BECK related feed to permohonan borang kemasukan teknik vokasional Tips for Opening a Online Forex Trading Account |
|
