SQL Server Archives - Ballard Chalmers

Azure SQL Database – Security Features

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…

SQL Server 2019 – General Release

14th November 2019
BC Comms Team
Blog, Feature Announcements, Infographic, SQL Server

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.

Azure Synapse Analytics, the Next Evolution of Azure SQL Data Warehouse

13th November 2019
BC Comms Team
Azure, Data, Feature Announcements, Infographic, News, SQL Server

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.

End of Support for Windows Server 2008 and SQL Server 2008 – The Challenges, Opportunities and Advantages of Modernization

25th October 2019
BC Comms Team
Application Modernisation, Azure, Blog, Infographic, SQL Server

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.

Free Azure SQL Administration eBook for DBAs

10th September 2019
BC Comms Team
Azure, Data, News, SQL Server

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.

Ballard Chalmers Achieves Microsoft Gold Partner in Data Analytics

20th August 2019
BC Comms Team
Ballard Chalmers, Business Intelligence, Data, News, SQL Server

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 – SQL Server

23rd July 2019
Arun Sirpal
Blog, Data, How-To, SQL Server

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.

Azure SQL Data Warehouse New Features

17th May 2019
BC Comms Team
Azure, Feature Announcements, News, SQL Server

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.

Key Changes Set to Hit SQL Server in 2019

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:

6 months to SQL Server 2008 end of extended support

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…