Welcome to Jacksonville Developers User Group Sign in | Join | Help

Database Design and Administration (RSS)

SQL Database Design and Administration
Friday, June 30, 2006 8:39 AM

Great Typed DataSet Tutorial

www.ASP.NET is quite a resource for learning the .NET 2.0 Framework in general and of course all things ASP.NET.  The team has added a well done tutorial on Data Access.  My two favorite tutorials are http://www.asp.net/learn/dataaccess/tutorial01cs.aspx?tabid=63 which
posted by dbottjer | 0 Comments
Filed Under: , ,
Friday, December 09, 2005 11:14 AM

SQL Date Queries

Most of us have used database’s containing SQL Server’s DateTime data type.  Let’s say you want to query a table with such a field returning all the records from a certain year.  An easy way to do this is to use SQL’s Year Function as follows
posted by dbottjer | 0 Comments
Filed Under: ,
Monday, November 14, 2005 10:28 PM

Free SQL Server 2005 Training from MS Press

Free MS Press e-Learning courses:   The courses, which retail at $99 each, will remain free untilNovember 1, 2006.Here's the significant link: https://www.microsoftelearning.com/sqlserver2005/
posted by dbottjer | 0 Comments
Filed Under: , ,
Thursday, September 22, 2005 12:55 PM

SQL Table Naming Conventions

How do you name your SQL Tables?  Are the names singular or plural?  I’ve been reading a book on Database Design and it suggests that tables should be singular because they represent a single record instance of data stored in the table. 
posted by dbottjer | 0 Comments
Filed Under:
Monday, August 01, 2005 11:22 PM

Stored Procs Vs Dynamic SQL

There are many great topics of debate in software development.  DataSets Vs. Objects, Smart Clients Vs. Web Apps, and Stored Procs Vs. Dynamic SQL.  Many have argued that writing stored procedures is rigid and doesn't allow for an easy way to
posted by dbottjer | 0 Comments
Filed Under:
Monday, June 13, 2005 8:52 PM

T-SQL VS CLR In SQL 2005

There is going to be an MSDN Webcast: T-SQL vs. the CLR in SQL Server 2005- How Should You Choose? (Level 200) http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275333&EventCategory=4&culture=en-US&CountryCode=US  
posted by dbottjer | 0 Comments
Filed Under: ,