|
Code Formatting Standards and Naming Conventions |
|
|
|
|
|
Leszynski Naming Conventions for Microsoft Solution Developers |
[not at all specific to T-SQL] |
|
[not at all specific to T-SQL] |
|
|
T-SQL
Coding Standards
T-SQL Formatting |
|
|
An online code "beautifier"
But also take a look at DevArt's "SQL Complete" product...don't miss the free Express Edition (they integrate into SSMS)... ...and Red-Gate's "Refactor" product.
And here's another, "Code Prettifier" found at Simple-Talk |
From the developers at wangz.net.
From the developers at Red-Gate.
The Code Prettifier formats SQL, C#, and VB code. |
|
Structured Query Language, Coding, Programming, and Coding Standards |
Don't forget to see my
library & reference book list.
|
|
See my Text Editor Shortcuts document |
|
|
|
|
|
|
|
|
|
|
|
A DatabaseJournal.com article by Gregory Larsen. |
|
|
Twiki, an "Open Source Wiki for the Enterprise" |
Useful for documentation efforts. |
|
From Itzik Ben-Gan's outstanding book <see page for more detail>. |
|
|
By Greg Larsen for Simple Talk. |
|
|
Regular Expression Library (RegExLib.com) |
Useful for a number of programming languages including SQL. |
|
By Gregory A. Larsen, at DatabaseJournal.com. |
|
|
Sample code for an e-commerce site for a ficticious sportings goods manufacturer. |
|
|
Using a Parent Child Hierarchy in SQL Server to Implement a Custom Security Scheme |
By Ray Barley from MSSQLTips.com |
|
13 Things You Should Know About Statistics and the Query Optimizer |
by Fabiano Amorim at Simple-Talk. |
|
by Donnie Garvich, primarily an article on web application programming. |
|
|
Twiki, an "Open Source Wiki for the Enterprise" |
Useful for documentation efforts. |
|
From Jeff Smith, a Boston Dev. |
|
|
From Itzik Ben-Gan's outstanding book <see page for more detail>. |
|
|
By Greg Larsen for Simple Talk. |
|
|
Tibor Karaszi's (MVP) "Ultimate Guide to the DATETIME Datatypes" |
Found on his website, www.karaszi.com. |
|
Integrating SharePoint Data with SQL Server (This web-services approach offers minimal coding) |
SQL Server Magazine, InstantDoc #101656, by Anup Kafle. |
|
From DevX.com. |
|
|
A SQLServerCentral.com resource by Jacob Sebastian, which also describes usage of sp_ExecuteSQL versus the EXEC command. |
|
|
Microsoft Access & SQL Server
|
A multi-part series by Tim Ford at MSSQLTips.com, tips 1470, 1471, 1480, 1482, 1490, and 2023. |
|
More links on Microsoft Access Integration w/ SQL Server
|
|
|
|
|
|
Have you ever had a compiled DLL and wondered what was inside it? From TechRepublic, posted March 4, 2008. |
|
Links to the APPLY Operator:
|
|
|
Free eBook from Simple Talk,
|
by Alex Kuznetsov. |
|
fabFORCE.net (DBDesigner4 visual database design tool for MySQL) |
Very cool database design tool (open source) if you develop with MySQL. |
|
Send Email from SQL Server Express Using a CLR Stored Procedure |
By Greg Robidoux at MSSQLTips.com. |
|
An blog post on Scalar Subqueries |
An MSDN blog post by Craig Freedman. |
|
ASP and ASP.Net resources from the "15 Seconds" website, such as Using ASP with SQL-DMO for "anywhere" management. Also Visual Studio (2005) Tutorials! |
|
|
Send Email from SQL Server Express Using a CLR Stored Procedure |
By Greg Robidoux at MSSQLTips.com. |
|
An blog post on Scalar Subqueries |
An MSDN blog post by Craig Freedman. |
|
Free eBook on software pricing suggestions, |
By Neil Davidson of Simple-Talk (Red Gate). |
Querying Active Directory in SQL Server
|
|
| An excellent article on Defensive Error Handling | From Simple-Talk, by Alex Kuznetsov, with code samples and good examples using Try...Catch. |
|
Create a SQL Server Data Dictionary in Seconds using Extended Properties |
From MSSQLTips.com by Ken Simmons. |
|
From SQLServerCentral.com by Jeff Moden. |
|
|
From Simple-Talk.com by Michael Sorens; a November 4, 2010 post. |
|
|
From SQLServerCentral.com by Wagner Crivelini. |
|
|
From CodingHorror.com, by Jeff Atwood. Nice diagrams. |
|
|
From CodeProject.com. |
|
|
A Simple-Talk free eBook by Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdić. |
|
From Jeff Smith, a Boston Dev. |
|
|
When do use sprocs v. functions? Excellent article and broader than the title. |
|
|
#2537 Should I use a view, a stored procedure, or a user-defined function? |
From aspfaq.com. |
|
Interesting article on Stored-Procedure basics...a number of valuable points made |
An Addison-Wesley site reference by Ken Henderson, who also wrote "The Guru's Guide to T-SQL"...an excellent resource! |
|
A SQLMag article (Instant Doc#47010) by Itzik Ben-Gan on Nulls in SQL Server. |
|
|
Recommended by student Julie Vanbuskirk. Good examples of several NULL issues. |
|
|
A SQLMag article (Instant Doc#48165) by Itzik Ben-Gan. |
|
| "Gaps in SQL Server Identity Columns" |
From MSSQLTips.com by Chad Boyd. |
|
SQL Server Service Broker Example on How to Configure, Send and Receive Messages |
From MSSQLTips.com by Jayakumar Krishnan. |
|
How to Call a SharePoint Web Service from a SQL Server CLR Function |
From MSSQLTips.com by Ray Barley. |
|
SQL Server Magazine, InstantDoc #97590 |
|
|
by Susan Perschke in SQL Mag, InstantDoc 94954. |
|
|
SQL Server Magazine, InstantDoc #97590 |
|
|
Tibor Karaszi's (MVP) "Ultimate Guide to the DATETIME Datatypes" |
Found on his website, www.karaszi.com. |
|
Microsoft SQL Server Spatial Data homepage |
|
|
A reference website, BeginningSpatial.com, from author Alastair Aitchison.
Check out /spatial_results_tab |
|
|
Integrating SQL Server 2008 Spatial Capabilities with Microsoft Virtual Earth (now Bing) |
From SQLMag.com by Tyler Chessman, InstantDoc #100528. |
|
David Lean's ("Dave Does Data") Microsoft blog |
|
|
Tons of great posts. |
|
|
He is a Bing Maps Technology Specialist for Microsoft. |
|
|
Again, tons of great posts. |
|
|
Powerful Geographic Visualisations Made Easy with SQL Server 2008 |
From
SQl-Server-Performance.com by John O'Brien (MVP). |
|
From MSDN. |
|
|
Web and Windows resources and more. |
|
|
From Microsoft.com. Geocoding. |
|
|
From Codeplex.com |
|
|
From Codeplex.com |
|
|
Reference website for creating GeoRSS feeds. |
|
|
How to Implement a Custom HTTP Handler in .NET
(For example, if I wanted to create a custom GeoRSS handler) |
From MSDN. |
|
SQL Server Spatial Tools project on Codeplex |
Provides useful functions. |
|
Official website. |
|
|
From CodeHaus.org. Useful resource, nice diagrams and examples. |
|
|
From WorldAtlas.com. |
|
|
(Shape2SQL, and SQLSpatial Query Tool) |
Free tools at www.SharpGIS.net, SQL Server 2008 Spatial Tools", by Morten Nielsen. |
|
SharpMap, Geospatial Application Framework for the CLR |
Free tools at Codeplex.com. |
|
Reference website. |
|
|
From GISPython.org |
|
|
"Your home for Community Mapping and Participatory GIS Software, Tools, Maps, Shapefiles, and Tutorials". |
|
|
Free cartographic boundary files. |
|
|
Source Code Control Solutions |
|
|
Microsoft's VisualStudio TeamEdition |
There are about six different TeamEdition editions! |
|
Tools for Small and Midsize Teams. |
|
|
Seapine ALM (Application Lifecycle Manager) |
|
|
|
|
|
List of Free Source Control Version Control Software apps |
|
|
Subversion, an Open Source Source-Code Control Application |
Often abbreviated as "SVN". |
|
Excellent article on (non-Microsoft) Source-Code Control solutions for Visual Studio |
Found at "The Code Project". |
|
Found at "stresscrack", the blog of Chris Coughlin. |
|
|
By William Brewer, of Simple-Talk. The article talks about what it takes to bring database development under source code control. Oh, don't forget that Red Gate now has a source code control product. :) |
|
|
|
|
XML Tutorial |
An excellent tutorial from W3Schools.com |
|
XPath Tutorial |
A tutorial from W3Schools |
|
XQuery Tutorial |
A tutorial from W3Schools |
|
Another XML Tutorial found at: XML-Training-Guide.com |
And a ton of other resources. |
|
Stylus Studio provides XML tools. |
|
|
Free eBook, "The
Art of XSD - eBook", |
From Simple-Talk. Ouch...it's 467 pages. |
|
Free WYSIWYG XML Editor from Altova, Authentic 2010 |
There is a "Community Edition", which is free, and an Enterprise version which is not free. |
Commercial examples of Custom XML Markup Languages:
|
|
| Scripts to Use XML to Insert and Update Rows in a SQL Server Table | From MSSQLTips.com by Wayne Ackman. It has nested FOR XML Path statements and is just generally an interesting XML dev script. |
| SQL Server XML Bulk Loading Example | From MSSQLTips.com by Tim Cullen. It discusses the recurring need to load XML. Interesting content. |
|
|
|
|
ASP and ASP.Net resources from the "15 Seconds" website, such as Using ASP with SQL-DMO for "anywhere" management. Also Visual Studio (2005) Tutorials! |
|
|
"The Place ASP Developers Go". |
|
|
Resources, such as a list of ADO Connection Strings by Carols Antollini. |
|
|
Examples of many connection strings across many RDBMS and other data sources such as Active Directory. |
|
|
|
|
|
fabFORCE.net (DBDesigner4 visual database design tool for MySQL) |
Very cool database design tool (open source) if you develop with MySQL. |
|
|
|
|
|
|
|
Resources, such as an Intro to SQL-DMO. |
|
|
Reference website. |
|
| Getting Started with Silverlight | A Microsoft reference. References videos and tutorials and includes Expression Blend info as well. |
|
Free eBook on Visual Studio 2010 exam preparation (exams 70-515, 70-511) |
From Accelerated-Ideas.com. |
