• Database index design and optimization: Some guidelines

    What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.

  • Download SQL Server Insider

    SQL Server Insider e-zine is a quarterly online publication focusing on Microsoft’s enterprise database, SQL Server. Join the editors of SearchSQLServer.com for an in-depth look into the database t...

  • 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)

  • SQL Server 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.

SQL Server Database Modeling and Design

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • 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

  • Alerting capabilities in SQL Server 2005

    Alerts in SQL Server 2005 have surpassed the functionality of those in SQL Server 2000. It seems the latter version is meeting industry needs for an SMTP based email system with the introduction of Database Mail. In this tip Edgewood Solutions' Jerem...  Tip

  • 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

  • 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

  • Developing with SQL Server 2005 Express

    With SQL Server 2005 Express Edition, Microsoft offers a feature-rich tool set with a familiar interface free of charge. Edgewood Solutions' Jeremy Kadlec provides an overview of this SQL Server version that includes Management Studio Express.  Tip

  • Database: Glossary

    This is a glossary of database-related terms.  Definition

  • 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

  • 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

Back to top