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.

Blogs

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

pivot multiple columns and transpose to same row sql server

By sugaz007

I have a table like below: CREATE TABLE #Test (Category_ID INT, [Type] VARCHAR(2),Student_ID INT,...

GRANT CREATE SEQUENCE syntax error

By webrunner

Hello experts, I am getting this error Msg 102, Level 15, State 1, Line...

Missing Integration Services Catalogs folder in SSMS

By giles.clapham

I've developed an SSIS Package that I need to deploy to a remote server,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers