SQL Server Topics:
SQL Server Database Modeling and Design
A database model is exactly what is sounds like - the structural format of the database. An accurate and up-to-date data model can help SQL Server administrators to create high-performance applications from the get-go and better meet the needs of end users. Common database models include hierarchical, network and relational models. This topic page features the design tips and modeling tools that administrators need to create a successful data model and design an effective database for Microsoft SQL Server.
Must read
- Microsoft Visual Studio 2010 spotlight IT SPOTLIGHT - Visual Studio 2010 is the latest version of Microsoft’s application development platform, equipped with a slew of add-ons and new features. Learn more about what’s new here.
- Microsoft brings PHP integration to SQL Server Reporting Services Tip - PHP isn’t just a Linux language anymore. With the help of a new SDK, developers can incorporate the scripting language with SQL Server reports.
- Open source tool simplifies database synchronization for SQL Server Tip - A free tool for Microsoft SQL Server could help take the time out of syncing up public and development databases.
News:
1 - 3 of 29-
New tool puts Oracle in the hands of SQL Server developers
08 Apr 2010
News - Microsoft and Quest have banded together to help put development for SQL Server and Oracle databases under the same umbrella.
-
New tool puts Oracle in the hands of SQL Server developers
08 Apr 2010
Article - Microsoft and Quest have banded together to help put development for SQL Server and Oracle databases under the same umbrella.
-
Top products named for SQL Server
15 Jan 2007
Article - Quest Software's LiteSpeed for SQL Server 4.6 took the Gold for backup and recovery along with SQL Sentry Event Manager Enterprise Edition v2.7 for performance. Tableau v2.0 earned the top spot for general database product of the year.
Reference & Learning:
1 - 3 of 100-
Microsoft Visual Studio 2010 spotlight
08 Jul 2010
IT SPOTLIGHT - Visual Studio 2010 is the latest version of Microsoft’s application development platform, equipped with a slew of add-ons and new features. Learn more about what’s new here.
-
DBConvert for MS SQL & MySQL
06 Mar 2009
New Product Showcase - DBConvert for MS SQL & MySQL allows for the conversion from MySQL databases to SQL Server and from SQL Server databases to MySQL servers.
-
DBSync for MS SQL & MySQL
06 Mar 2009
New Product Showcase - DBSync for MS SQL & MySQL performs SQL-to-MySQL and MySQL-to-SQL database conversion and synchronization.
VIEW ALL Reference & Learning ON SQL Server Database Modeling and Design
Expert Technical Advice:
1 - 3 of 121-
Microsoft brings PHP integration to SQL Server Reporting Services
07 May 2010
Tip - PHP isn’t just a Linux language anymore. With the help of a new SDK, developers can incorporate the scripting language with SQL Server reports.
-
Open source tool simplifies database synchronization for SQL Server
23 Mar 2010
Tip - A free tool for Microsoft SQL Server could help take the time out of syncing up public and development databases.
-
Optimizing SQL Server indexes –- even when they're not your indexes
12 Aug 2009
Tip - When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed.
VIEW ALL Expert Technical Advice ON SQL Server Database Modeling and Design
Definitions:
1 - 3 of 30-
record standardization
22 Sep 2004
Word -
-
Versioned Object Base
12 Apr 2004
Word -
-
Database: Glossary
27 Oct 2003
Word - This is a glossary of database-related terms.
VIEW ALL Definitions ON SQL Server Database Modeling and Design
SQL Administration: SQL Security, SQL Backup, SQL Server Performance