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

  • Microsoft reaches 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.

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

  • SQL Server encryption vs. hashing for data security

    Choose carefully between encryption and hashing algorithms in SQL Server 2005 because not all methods fit all data security purposes.  Tip

  • Configure aliases for SQL Server databases and servers

    Aliased names can save you from changing your code and configuration files when you need to point your application to another server or move the location of database objects. In this tip, you'll find options and strategies for aliasing database serve...  Tip

  • Creating SQL Server columns: A best practices guide

    When creating SQL Server columns, improve database performance by following these best practices for defining data types, keys and NULL configurations.  Tip

  • Creating SQL Server tables: A best practices guide

    When creating SQL Server tables, follow these quick tips for defining filegroups, indexes, key constraints and partitions to improve SQL Server performance.  Tip

  • Best SQL Server indexing strategies

    SQL Server supports only two index types for most data types: clustered and non-clustered. Learn how and why building the appropriate index type during your database design will significantly impact SQL Server performance.  Tip

  • Build code portability between SQL Server environments

    Code portability between SQL Server environments can eliminate a major point of failure. Learn how to structure code portability in DTS, SQL Server Integration Services and file paths.  Tip

  • Clustered and non-clustered indexes in SQL Server

    Rules for using a clustered index vs. a non-clustered index are tough to decipher. In this tip, you'll see the fundamentals to consider when making your choice, along with some best practice techniques. Get an overview of tradeoffs and proper index i...  Tip

  • 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

  • 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

  • Working with schemas in SQL Server 2005

    If you're managing too many databases with too many objects, it may be time to take advantage of SQL Server 2005's ANSI SQL feature: schemas.  Tip

Back to top