• 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

  • 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

  • Check SQL Server database and log file size with this stored procedure

    Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine "SQL Database Space," but it can also be used to monitor database growt...  Tip

  • Designing SQL Server non-clustered indexes for query optimization

    Non-clustered indexes improve SQL Server query performance by focusing queries on a subset of data. In this tip, you'll find guidelines for designing non-clustered indexes, including choosing index fields, when a clustered index should be used instea...  Tip

  • SAN considerations for your SQL Server environment

    SANs surpass the performance of locally attached storage for its high availability and high performance access to data. In this tip, Contributor Hilary Cotter highlights what you need to consider when using SANs and how to test your SQL Server enviro...  Tip

  • Top 10 SQL Server development tips of 2007

    Here are the top 10 most viewed SQL Server development tips of 2007. From best practices for writing stored procedures and creating SQL Server tables and columns, to T-SQL enhancements and error handling with Try…Catch blocks in SQL Server 200...  The Year in Review

  • ApexSQL Audit 2005.07

    Apex SQL Audit automatically generates triggers to create a Microsoft SQL Server data audit log and provides a reporting utility that extracts the data into meaningful reports.  New Product Showcase

  • How secure is your SQL Server network design?

    Too often, SQL Server systems are located on unsafe networks, and databases are easily accessible -- even by way of the Internet. Here are some descriptions of alarming network design practices and the tools that will secure your SQL Server systems.  Tip

  • ApexSQL Diff/2005.12

    Discover how ApexSQL Diff saves SQL Server developers time comparing databases. This tool analyzes changes in tables, stored procedures, views and more.  New Product Showcase

  • Determining SQL Server database storage requirements

    The first time you calculate storage requirements for a SQL Server database application is significantly important and should be done during the development phase. Here are two methods for pinpointing future storage needs.  Tip

  • Setting up SQL Server clusters on a SAN

    Storage area networks (SANs) allow you to connect expandable storage to your SQL Server installations, but care must be taken when working with SQL Server clusters.  Tip

Back to top