Contents Azure SQL Database - Security Features Introduction Transparent Data Encryption Deny All by Default Azure Active Directory (AD) Authentication Advanced Data Security (ADS) Introduction Security is the foundation for building successful solutions in Microsoft Azure. Not only has Microsoft…
Microsoft announced the general release of SQL Server 2019 at Microsoft Ignite. This is the answer to the demands exerted by massive data and expectations of real-time query performance across a variety of data sources. A data platform for modern enterprises and modern expectations.
Microsoft has taken its data-warehouse solution to the next level in both performance and capabilities. And has now launched Azure SQL Data Warehouse as Azure Synapse Analytics. With Azure Synapse, you can build, manage, collaborate and analyse your data all within the same service.
Support has already ended for Windows Server 2008 and end of support for SQL Server 2008 is fast approaching. Discover the challenges, opportunities and advantages of modernization with migration to the Azure cloud.
We wanted to share with the Database Administrators (DBAs) of our clients, this great free Azure SQL Administration eBook being offered by Microsoft. Many DBAs are unsure what skills need to be added to their existing skill set or how best to get up to speed. This course/eBook is a great answer.
We are pleased to tell you that Microsoft has awarded Ballard Chalmers Gold Partnership in Data Analytics. We add this to our Gold competencies in the Data Platform and Application Integration.
The Query Store was introduced back in SQL Server 2016 and with the incoming release of SQL Server 2019, it remains a very important feature to know and understand to utilise in performance tuning exercises. Not only is this feature available with on-premises SQL Server but it is a key tool to use when troubleshooting performance issues in Azure SQL Database.
As the storage of data increases and the quantity of queries rises, Azure SQL Data Warehouse continues to enhance its price-performance, flexibility, and security. Igor Stanko announced the newest upgrades last week, where we see new capabilities both in preview and general release.
With the announcement in September of SQL Server 2019 in public preview, we have been keeping an eye out for further information on what to expect. With the release looming, change is certainly ahead. Here we take a look at some key trends and changes set to hit SQL Server in 2019:
Extended support for SQL Server 2008 ends in less than 6 months, on 9 July 2019. End of extended support means Microsoft will no longer release security updates for any version of SQL Server 2008 or 2008 R2. Any organisation…