Indexing Tutorial, SSIS vs ADF, SQL Server Replication Failure and T-SQL Dev Tips

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]( [Fix SQL Server Replication Failure Caused by Duplicate Values]( In this tip, we cover how to fix an SQL Server replication failure caused by duplicate values in a unique index of a replicated table.... [Read Now]( [mssqltips image]( [What a DBA Needs to Know about SQL Server Administration]( The DBA role encompasses a broad range of skills and focus areas, including SQL Server administration. In this webinar, we'll look at the key areas you should master if you're charged with SQL Server administration.... [Read Now]( [mssqltips image]( [Choosing Between SSIS vs ADF: What You Need to Know]( In this article, we look at how you might go about choosing whether to use SSIS or ADF for your next ETL/ELT project.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [DBI Web Performance Suite for DB2 LUW and SQL Server]( The DBI Web Performance Suite for SQL Server and DB2 is a database performance collection, analysis and recommendation tool to help you troubleshoot and tune your database systems.... [Read Now]( [mssqltips image]( [SQL Server Index Tutorial Overview]( This tutorial will try to go through each type of index available in SQL Server and explain why/when each one could be used to improve your query performance.... [Read Now]( [mssqltips image]( [Secrets to Fast High Availability for SQL Server]( Learn how to quickly build a two-node HA cluster for SQL Server in the AWS cloud.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server CROSS APPLY and OUTER APPLY]( Learn about SQL Server CROSS APPLY and OUTER APPLY and how they differ from regular JOINs and how to use these along with scripts and a video. ... [Read Now]( [mssqltips image]( [Rolling up multiple rows into a single row and column for SQL Server data]( Learn how to roll-up multiple rows into one row and one column with concatenation in SQL Server with FOR XML, STUFF and STRING_AGG. ... [Read Now]( [mssqltips image]( [Format numbers in SQL Server]( In this article we cover different ways to format numbers in SQL Server using various functions like CAST, CONVERT, ROUND, CEILING, FLOOR and FORMAT.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]