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

  • ADO.NET data providers

    ADO.NET-managed data providers are an abstraction layer for data services and are much like ActiveX Data Objects' ADODB class.  Book Excerpt

  • Applying transactions to multi-table updates

    The SqlTransaction object provides clients with the ability to commit or roll back updates to SQL Server base tables. Here are steps to execute ADO.NET transacted updates.  Book Excerpt

  • ADO.NET 2.0: A new approach to data access

    Learn about the role of ADO.NET 2.0 namespaces and managed data providers.  Book Excerpt

  • ADO.NET summarized

    Read the summary of Chapter 1, 'Migrating from ADO to ADO.NET,' from the book "Expert One-on-one Visual Basic 2005 Database Programming."  Book Excerpt

  • ADO.NET Typed DataSet objects

    Learn the differences between DataSets and disconnected Recordsets, then get methods for generating ADO.NET objects with VS 2005 and SQL Server 2000 or 2005.  Book Excerpt

  • Basic ADO.NET data objects

    Basic ADO.NET data objects are runtime data-access types that have ADODB counterparts. Learn more in this chapter.  Book Excerpt

  • 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

  • Writing efficient queries

    Database model tuning comes with one big stipulation. Find out what it is in this book excerpt.  Book Excerpt

Back to top