Connecting SQL Server to SaaS Apps, Stored Procedures Tutorial, 30 Years of SQL Server and Capture Deadlocks

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]( [Connecting SQL Server to SaaS applications with a Linked Server]( Learn about CData Connect Cioud which is a cloud-based data virtualization solution to integrate many types of cloud data sources using SQL Server Linked Servers.... [Read Now]( [mssqltips image]( [30 Years of SQL Server History]( Everything started in 1993, 30 years ago! This first version of SQL Server was created in an agreement between Microsoft and Sybase. Learn about the different versions of SQL Server over time.... [Read Now]( [mssqltips image]( [SQL Server Data Masking Alternative]( Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries. Learn about how Db... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [SQL Server Stored Procedure Tutorial]( This tutorial look at how to create stored procedures in SQL Server to be able to reuse the code for various purposes.... [Read Now]( [mssqltips image]( [The Secret to Doubling DBA Productivity]( Learn how DBAs are doubling productivity and minimizing complexities across numerous database platforms including: prioritization, consistency, automation and more. ... [Read Now]( [mssqltips image]( [Drop All Tables in SQL Server and Generate a List of Objects to Drop]( Learn how to drop multiple SQL Server objects with just one command and how to quickly generate a list of objects to drop.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Capturing SQL Server Deadlocks using Extended Events]( In this tip we look at how to capture deadlocks that occur in SQL Server and the associated information to help troubleshoot. We look at how to do this using the GUI and T-SQL code.... [Read Now]( [mssqltips image]( [Powerful SQL Server Data Quality Tools for Cleansing and Validation]( Learn how Data Stewards can leverage Unison from Melissa Data to solve data quality issues such as duplicate records and enrich contact data for better decision making.... [Read Now]( [mssqltips image]( [How to Encrypt and Decrypt CSV File in SSIS]( In this article we look at how you can use a SQL Server Integration Services (SSIS) package to encrypt and decrypt data to and from a flat file.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]