Check our collection of quick technical tips.
Check our Tip of the Week, which this week discusses about the available data service offerings on Azure and provides relevant examples. Tip of the Week #12 On the Azure cloud, there many types of data offering platforms and services. There are RDBMS platforms for dealing with relational data, Document databases for dealing with document-based … Read more…
Check our Tip of the Week, which this week explains the Capital Expenditure (CapEx) vs. Operational Expenditure (OpEx) concepts. Tip of the Week #11 Two of the fundamental concepts you need to learn when getting started with Cloud Computing is Capital Expenditure (CapEx) and Operational Expenditure (OpEx). CapEx has to do with the money an … Read more…
Check our Tip of the Week, about the “Tags” feature in Azure SQL Database. Tip of the Week #10 One of the available Azure SQL Database Server settings are “Tags”. Tags are name/value pairs that enable you to categorize resources and view consolidated billing by applying the same tag to multiple resources and resource groups. … Read more…
Check our Tip of the Week, about the SQL Server offerings in Azure. Tip of the Week #7 The Available 3 SQL Server offerings in Azure are: SQL Server on Virtual Machines (*IaaS) Azure SQL Database (Logical Server – *PaaS) Azure SQL Database Managed Instance (*PaaS) *IaaS: Infrastructure as a Service *PaaS: Platform … Read more…
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…
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…
This is a quick but useful tip, on how to change the font and size of Grid or Text Results in SSMS. For changing the font and/or size of Grid results in SQL Server Management Studio (SSMS): Within SSMS, navigate to the “Tools” menu, then “Options”, “Fonts and Colors” and select to “Show settings … Read more…
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…
Check our Tip of the Week, about JSON support in SQL Server. Tip of the Week #3 Since SQL Server 2016 and later, TempDB system database can be configured via SQL Server 2016 installation wizard. For example, you can set the number of data files and growth settings, as well as set multiple volumes … Read more…
Check our Tip of the Week, about JSON support in SQL Server. Tip of the Week #2 With JSON support in SQL Server 2016 and later, you can format query results as JSON by adding the FOR JSON clause to a SELECT statement in SQL Server. Also, you can convert JSON data to rows … Read more…
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…
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…
When is TempDB Used? That’s a very good question! In this SQL Server Administration quick tip, we will be discussing about, when the TempDB SQL Server system database is used. About the TempDB System Database in SQL Server TempDB is one of the system databases of SQL Server. As its name implies, it is … Read more…
This short post discusses SQL Server Support for TLS 1.2. It is a recommended security best practice, to upgrade to Transport Layer Security (TLS) protocol 1.2 as several known vulnerabilities have been reported against SSL and earlier versions of TLS. Many of us who work with SQL Server, we needed – or will need at a … Read more…
Hey folks all around the world! I hope you are having a great time! I do, and I’m super excited to announce today that I’m launching a new post category on the SQLNetHub Blog. The name of this category is “Quick Tips“. I really enjoy writing long and comprehensive articles which explore all those amazing … Read more…