This month’s tech tip is about Azure Database for SQL and its available deployment options. Tech Tip: There are 3 available deployment options, when it comes to Azure SQL Database. These are: Azure SQL Database (Platform as a Service – PaaS) Azure SQL Managed Instance (Platform as a Service – PaaS) SQL Server on … Read more
This month’s tech tip is about SQL Server and Azure SQL Database. Tech Tip: Among other, SQL Server (version 2016 and later) and Azure SQL Database support “Dynamic Data Masking”. This feature, allows the user to set SQL Server to dynamically mask sensitive data from unauthorized access, based on certain rules. Enroll to … Read more
This month’s tech tip is about Search Engine Optimization (SEO). Tech Tip: Some of the major guidelines for efficient Search Engine Optimization (SEO) in your blog articles are: Write unique and clear content. Use the proper titles for your articles. Use the proper headings and subheadings for your articles and keep them relevant to … Read more
This month’s tech tip is about SQL Server and Azure SQL Database. Tech Tip: Among other, SQL Server and Azure SQL Database support Transparent Data Encryption also known as TDE. TDE encrypts SQL Server data files, log files and backup files and it is transparent to the users that are authorized to access SQL … Read more
TechHowTos.com is your ultimate source of high-quality tech how to’s and knowledge. Just visit https://www.techhowtos.com and get access to tens of straight-to-the point, how-to articles on different technology areas such as: databases, programming, Windows, and more. Visit https://www.techhowtos.com today! Reference: TechHowTos.com (https://www.techhowtos.com) © TechHowTos.com
One of the most significant features in SQL Server 2017 is the enhanced support for Machine Learning. As defined in Wikipedia, Machine Learning is a field of computer science that gives computers the ability to learn without being explicitly programmed. Technology has matured enough, in order to finally take a deep dive into Artificial Intelligence (AI) and Machine Learning and SQL … Read more
This article discusses whether it is possible to restore a database backup from SQL Server 2005 SP4 to SQL Server 2005 SP3 or not. If the database was in place when you patched SQL Server 2005 to SP4 then yes, you can backup the database and restore it on SQL Server 2005 SP3. If the … Read more