Expand a Range of SQL Dates, NoSQL Databases, SQL Server vs Oracle TDE and Cloud Transformation (MSSQLTips 9/2/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Integration Services Tutorial - Start Learning]( [Guide to Build Graph Node and Edge Tables with Azure Data Studio]( [Guide to Build Graph Node and Edge Tables with Azure Data Studio]( Learn how to build graph node and edge tables using Azure Data Studio in this step-by-step guide.... [Expand a Range of Dates with GENERATE_SERIES Function]( [Expand a Range of Dates with GENERATE_SERIES Function]( In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows.... [Unlock Reliable and Predictable System Performance]( [Unlock Reliable and Predictable System Performance]( Having reliable, predictable system performance is the goal of every IT professional. This is even more true for a SQL Server database professional given that the data is the backbone of almost every organization. While you could build your own set o... [SQL Server and Oracle Transparent Data Encryption Differences and Similarities]( [SQL Server and Oracle Transparent Data Encryption Differences and Similarities]( In this article, we look at how to set up Transparent Data Encryption for SQL Server and Oracle along with the differences and similarities.... [Universal Data Integration Across the Enterprise]( [Universal Data Integration Across the Enterprise]( Universal real-time data integration is a serious technical and organizational challenge that supersedes the native SQL Server capabilities. CData has recognized these challenges and has delivered a universal data access solution via drivers for on-p... [NoSQL Data Models for Large Document Data Stores]( [NoSQL Data Models for Large Document Data Stores]( In this article, we learn about different data models to use for large document data stores such as Embedded, Composite Key, Inverted Index, and Single Table.... [Migrate to AWS Cloud to Gain Business Agility and Cost Benefits]( [Migrate to AWS Cloud to Gain Business Agility and Cost Benefits]( The migration to AWS was a major undertaking for SkyTouch. Not only did SkyTouch need to minimize the impact of downtime for their customers, they also had to plan for numerous integrations between systems, customers, and third parties. The AWS Migra... [Cloud Transformation: Collaboration, Communication and Governance]( [Cloud Transformation: Collaboration, Communication and Governance]( This article covers tips on establishing, enhancing, and empowering collaboration, communication, and governance on Cloud Transformation projects.... [By Greg Robidoux - ]( [How to rename a SQL Server database]( In this article we look at different ways to rename a SQL Server database and also how to get exclusive access in order to rename the database. ... [By Arshad Ali - ]( [Using MERGE in SQL Server to insert, update and delete at the same time]( In this tip we look at an example to help you better understand how the SQL Server MERGE statement works.... [By Manvendra Singh - ]( [SQL Server AlwaysOn Interview Questions and Answers - Part 1]( Learn about SQL Server AlwaysOn through interview questions and answers related to configurations, daily operations and more.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}