Tip of the Week No.6 – About SQL Server Temporary Tables

Check our Tip of the Week, about SQL Server Temporary Tables.   Tip of the Week #6 Local temporary tables in SQL Server, are defined by using the # (single hash) sign and they are only available for the session in which they were created in. After the session ends, local temporary tables are automatically … Read more…

Tip of the Week No.5 – CosmosDB Main Technical Characteristics

Check our Tip of the Week, about the main technical characteristics of CosmosDB.   Tip of the Week #5 The main technical characteristics of Azure Cosmos DB are: Ability to globally distribute your data Multiple data models and APIs for working with your data You can elastically and independently scale throughput and storage on demand … Read more…

Tip of the Week No.4 – SQL Server Stretch Database

Check our Tip of the Week, about JSON support in SQL Server.   Tip of the Week #4 Stretch Database in SQL Server 2016 and later, allows storing historical data in the Microsoft Azure cloud. It runs in the background and provides seamless access to both local and remote data. Among other, it can be … Read more…

Tip of the Week No.1 – SQL Server Always Encrypted

Check our Tip of the Week, about the SQL Server Always Encrypted feature!   Tip of the Week #1 With Always Encrypted in SQL Server 2016 and later, you can protect sensitive data, by encrypting sensitive data on the application side, without revealing the encryption keys to the Database Engine. To this end, through a … Read more…

New Blog Post Series: Tip of the Week!

Hi friends around the globe! We are pleased to announce a brand new blog post series titled “Tip of the Week“. Via this series, every Monday, we will be sharing with you, useful short tips on a variety of topics such as: SQL Server Administration and Development, Azure SQL Database, Programming, Data Access and more! … Read more…