Email Alerts
-
Microsoft Master Data Services boosts SQL master data management
With all the excitement around new gadgets in the upcoming release of SQL Server, code-named Denali, it’s easy to forget how much Microsoft played up features in its current version. SQL Server Insider did some digging around in SQL Server 2008 R2 an... E-Zine
-
SQL Server's Data Quality Services makes cleanup a cinch
SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes. Feature
-
SQL Server Denali, R2, XP: What sizzles, what doesn’t this summer
With the latest SQL Server Denali CTP out, Microsoft exec Mark Kromer discusses updates and addresses blogosphere buzz about what Denali’s not running on. Feature
-
Top reasons to get started with SQL Server Denali
The upcoming SQL Server Denali is chock-full of new features, such as super-fast column-store indexes and a new Web-based reporting tool. But what does it mean for businesses? Feature
-
Finally, development across platforms in Microsoft Visual Studio 2010
Microsoft says Project Juneau, its toolset for Microsoft Visual Studio 2010 expected to be rolled out with the upcoming SQL Server Denali, will break new ground in development. Feature
-
Microsoft Visual Studio 2010 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. IT SPOTLIGHT
-
DBConvert for Access & MS SQL
DBConvert for Access & MS SQL allows for the conversion from Microsoft Access databases to SQL Server and from SQL Server databases to Microsoft Access. New Product Showcase
-
DBConvert for MS FoxPro and MS SQL
DBConvert for MS FoxPro and MS SQL converting data from MS FoxPro databases to MS SQL server and from SQL servers to FoxPro databases. New Product Showcase
-
DBForms from MS Access to ASP.NET+MS SQL
DBForms from MS Access to ASP.NET + MS SQL converts Microsoft Access databases and tables to MS SQL databases. New Product Showcase
-
DBSync for MS SQL & MySQL
DBSync for MS SQL & MySQL performs SQL-to-MySQL and MySQL-to-SQL database conversion and synchronization. New Product Showcase
-
DBConvert for MS SQL & MySQL
DBConvert for MS SQL & MySQL allows for the conversion from MySQL databases to SQL Server and from SQL Server databases to MySQL servers. New Product Showcase
- See more Essential Knowledge on SQL Server Database Modeling and Design
-
Microsoft SQL Server, PDW reach out to Hadoop for big data processing
In this Q&A;, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access. Q&A; | 13 Sep 2011
-
SQL Server Denali overshadows the Azure cloud for attendees at Microsoft TechEd
Cloud was the word at Microsoft TechEd, but attendees’ interest was rooted in SQL Server Denali, the upcoming version of the database that will be released in a CTP this summer. News | 20 May 2011
-
In 2011, SQL Server market trending toward cloud, virtualization
Higher SQL Server cloud adoption with more competition and SQL Server virtualization will get top billing in the SQL Server market in 2011, experts predict. Plus, self-service BI is on the up and up, along with solid-state devices. News | 13 Jan 2011
-
Microsoft releases new parallel data warehouse, previews Denali
Microsoft detailed its new parallel data warehouse capabilities and a cloud-based support offering, and also provided a glimpse of what's to come in the next SQL Server release. News | 09 Nov 2010
-
New tool puts Oracle in the hands of SQL Server developers
Microsoft and Quest have banded together to help put development for SQL Server and Oracle databases under the same umbrella. Article | 08 Apr 2010
-
New tool puts Oracle in the hands of SQL Server developers
Microsoft and Quest have banded together to help put development for SQL Server and Oracle databases under the same umbrella. News | 08 Apr 2010
-
Top products named for SQL Server
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. Article | 15 Jan 2007
-
Q&A;: Making the jump to 64-bit SQL Server 2005
Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the... News | 20 May 2006
-
Getting BI from the contact center
Forward-thinking contact centers are using quality monitoring applications for business analysis. Article | 16 Feb 2006
-
Q&A;: Making the jump to 64-bit SQL Server 2005
Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the... Interview | 24 Jan 2006
- See more News on SQL Server Database Modeling and Design
-
Top five features in SQL Server Developer Tools
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features. Tip
-
Warned about table changes in SSMS? Here’s a workaround
Editing tables in SQL Server Management Studio and getting this warning, “Saving changes is not permitted”? It happens when the table needs to be re-created. But don’t fret. This change in SQL Server 2008 R2 can be undone with a simple tweak. Tip
-
SQL Server merge replication using IIS
In older versions of SQL Server, securely replicating data between sites or companies was not easy to do. Microsoft SQL Server merge replication simplifies the process using Internet Information Services (IIS). Tip
-
Where to look next for BI applications? Try the cloud
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you? Tip
-
Microsoft brings PHP integration to SQL Server Reporting Services
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. Tip
-
Open source tool simplifies database synchronization for SQL Server
A free tool for Microsoft SQL Server could help take the time out of syncing up public and development databases. Tip
-
Optimizing SQL Server indexes -- even when they're not your indexes
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. Tip
-
Top tips and tricks for SQL Server database development
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more. Tip
-
Managing the development lifecycle with Visual Studio Team System 2008
Learn how Visual Studio Team System 2008 Database Edition can add and modify objects, generate deployment scripts and manage the development lifecycle of your SQL Server databases. Tip
-
A first look at Visual Studio Team System 2008 Database Edition
Visual Studio 2008 Database Edition is designed to simplify database development and better manage development lifecycles. Check out the new features in Microsoft's 2008 version of VSDB. Tip
- See more Tips on SQL Server Database Modeling and Design
-
Using MDX and UDM in a SQL Server Analysis Services environment
Learn the specifics of Multidimensional Expressions (MDX) and the Unified Dimensional Model (UDM) in a SQL Server Analysis Services environment. Ask the Expert
-
Query to find SQL Server database names created by users
Find how to query in SQL Server to get all database names created by users. Ask the Expert
-
Viewing database tables in Query Analyzer
Greg Low explains how to view all database tables in Query Analyzer. Ask the Expert
-
Displaying a SQL Server database report in Excel
We are working with SQL Server 2000 Enterprise Edition. We have been tasked with developing a report from the SQL Server database, which we then have to display in Excel. This data will be calculated using a query and then placed into specific cells ... Ask the Expert
-
Modifying a query to show navigation path
SQL Server 2005 expert Adam Machanic offers code to modify a query showing a navigation path down a tree to each node returned in the original result, but this time in a different format. Ask the Expert
-
Preventing SQL Server DTS package failures
SQL Server DTS package failures when updating a table can be avoided by using FileSystemObject and ActiveX Script Tasks. Ask the Expert
-
Using SQLMail to send query results
Sending query result by email requires SQLMail, which is essentially the integration of SQL Server & Exchange. Ask the Expert
-
Listing database tables without records
SQL Server Integration/Development Expert Joe Toscano shares method to get a more flexible solution from your query. Ask the Expert
-
Preventing users from having more than one login session open at once
Prevent simultaneous logins to your SQL Server database with this advice from SQL Server Security Expert Steven Andres. Ask the Expert
-
Adding columns and determining row size
Development expert Greg Low explains how to insert new columns and assess table row sizes. Ask the Expert
- See more Expert Advice on SQL Server Database Modeling and Design
-
database replication
Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued) Definition
-
multidimensional expressions (MDX)
multidimensional expressions (MDX) Definition
-
tablespace
In a database management system (DBMS), a tablespace is a logical group of data files in a database. A typical database contains at least one tablespace, and usually two or more. In a database, a tablespace plays a role similar to that of a folder ... Definition
-
flat file
A flat file is a file containing records that have no structured interrelationship. Definition
-
C++
C++ is an object-oriented programming (OOP) language that is viewed by many as the best language for creating large-scale applications. Definition
-
ActiveX Data Objects (ADO)
ActiveX Data Objects (ADO) is an application program interface from Microsoft that lets a programmer writing Windows applications get access to a relational or non-relational database from both Microsoft and other database providers. Definition
-
Database: Glossary
This is a glossary of database-related terms. Definition
-
database
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. (Continued...... Definition
-
data structure
A data structure is a specialized format for organizing and storing data. Definition
-
data mart (datamart)
A data mart is a repository of data gathered from operational data and other sources that is designed to serve a particular community of knowledge workers. Definition
- See more Definitions on SQL Server Database Modeling and Design
-
database replication
Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued) Definition
-
SQL Server's Data Quality Services makes cleanup a cinch
SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes. Feature
-
Microsoft Master Data Services boosts SQL master data management
With all the excitement around new gadgets in the upcoming release of SQL Server, code-named Denali, it’s easy to forget how much Microsoft played up features in its current version. SQL Server Insider did some digging around in SQL Server 2008 R2 an... E-Zine
-
Microsoft SQL Server, PDW reach out to Hadoop for big data processing
In this Q&A;, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access. Q&A;
-
Top five features in SQL Server Developer Tools
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features. Tip
-
SQL Server Denali, R2, XP: What sizzles, what doesn’t this summer
With the latest SQL Server Denali CTP out, Microsoft exec Mark Kromer discusses updates and addresses blogosphere buzz about what Denali’s not running on. Feature
-
SQL Server Denali overshadows the Azure cloud for attendees at Microsoft TechEd
Cloud was the word at Microsoft TechEd, but attendees’ interest was rooted in SQL Server Denali, the upcoming version of the database that will be released in a CTP this summer. News
-
Top reasons to get started with SQL Server Denali
The upcoming SQL Server Denali is chock-full of new features, such as super-fast column-store indexes and a new Web-based reporting tool. But what does it mean for businesses? Feature
-
Finally, development across platforms in Microsoft Visual Studio 2010
Microsoft says Project Juneau, its toolset for Microsoft Visual Studio 2010 expected to be rolled out with the upcoming SQL Server Denali, will break new ground in development. Feature
-
multidimensional expressions (MDX)
multidimensional expressions (MDX) Definition
- See more All on SQL Server Database Modeling and Design
About 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.