The author of the NYCdotNet blog is a VB.NET and SQL server developer living and working in New York City. The author seeks to promote clean, readable, efficient code in both VB and SQL from design to development, deployment, and application maintenance.

Creating a deep hierarchy with FOR XML

by nycdotnet

New York City .NET

I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].

--SAMPLE...

2011-01-27

17,234 reads

Using the MERGE statement

by nycdotnet

New York City .NET

I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...

2011-01-17

4,054 reads

Wiring up a common click event handler in an ASP.NET page

by nycdotnet

New York City .NET

I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...

2010-12-30

3,098 reads

How to tell if a property exists by name

by nycdotnet

New York City .NET

I recently was working on a library to manage reports in an application (probably a good candidate for an open source project)...

2010-12-29

663 reads

Blogs

Enabling an Index: #SQLNewBlogger

I don’t do a lot of work with disabled index, but I learned how...

Back to Boston for SQL Saturday

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By Tim Mitchell

Most of us who work with data have, at least a few times, been...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers