SQL Server Table Design Guidelines, Query Tuning Tricks, Daily Operations Checklist and New Power BI Visuals

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL Server Table Design Guidelines]( In this article, we look at three table design guidelines when building an SQL table including data types, designing for deletes, and primary keys.... [Read Now]( [mssqltips image]( [Shaping Your Career: Adapting to the Future of Microsoft Data Management Roles]( Wondering how to stay ahead in a rapidly changing industry? Join industry experts Bob Ward, Kevin Kline, and Blythe Morrow as they delve into the exciting prospects that lie ahead for DBAs and data pros in our field.... [Read Now]( [mssqltips image]( [Checklists to Manage SQL Server Daily Operations]( In this article, we look at how to use checklists for managing SQL Server deployments and other changes along with a sample checklist document you can use in your environment.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [How to tell what SQL Server versions you are running]( Check out this tip to easily find out what version of SQL Server you are running.... [Read Now]( [mssqltips image]( [SQL Server Query Tuning Tips and Tricks]( In this session, we'll walk through SQL Execution Plans, how to generate, how to interpret, how to find the best opportunities for performance gains, and how to optimize queries.... [Read Now]( [mssqltips image]( [Resolving could not open a connection to SQL Server errors]( Solving - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [New Data Presentation in Power BI]( Learn about the new Card visual for Power BI and how this can be used and formatted for better presentation of data.... [Read Now]( [mssqltips image]( [Simplify SQL Server Cloud Migrations]( In today's fast-paced IT landscape, streamlining testing, reducing downtime, and mitigating risks are paramount for successful Windows upgrade and cloud migration projects. Delays and support costs can be a thing of the past when you harness the powe... [Read Now]( [mssqltips image]( [Change the Default SQL Server File Locations]( In this article, we look at how to change the default SQL Server locations for database data and log files and also for backup files.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]