One of your five a day
SQL Server 2022 brings some exciting new language features such as DATE_BUCKET https://learn.microsoft.com/en-us/sql/t-sql/functions/date-bucket-transact-sql?view=sql-server-ver16 As per the information, this function returns the date-time value corresponding to the start of each date-time bucket. This means it much easier and more readable now
The most important part of presentation preparation is design, repetition and preparing for the failure of anything, and I mean anything! Design The overall design, flow and pace of your presentation is vital. If you’ve targeted a level 100 presentation
As some of you may be aware I’ve been heavily involved in using Azure Data Factory Mapping Data Flows and have been impressed by it since day one. Its grown and grown since then and is now in General Availability!
With the release of SQL Server 2019 RC1 we have a host of new features such as; Installation on Windows, Linux and containers Big Data Clusters Compatibility certification There is also a couple of notable changes to the installation process,
I gave a session on Azure Data Factory v2; The Data Flows at Data: Scotland on the 13th September. Azure Data Factory is a cloud-based data integration service that allows you to create data-driven workflows in the cloud for orchestrating
Preparation is everything and part of this preparation is also training to fail. The journey to your certification It is important to remember that learning and studying for a certification is part of a bigger journey. A journey of building
Microsoft it now retiring the Microsoft Professional Program and the new place to go is Microsoft Learn https://docs.microsoft.com/en-us/learn/ The general trend seems to be more and more consolidation at Microsoft Learn. This has a tremendous amount of free learning material! which anyone can use
I recently had the chance to attend and speak at SQLGLA, the premier Scottish data platform conference. Organised by Craig Porteous and a dedicated team it was run smoothly, friendly and professionally. The day started with an introduction and welcome. This
On occasion we just want to use “Edit Top 200 Rows” to UPDATE or INSERT data quickly, perhaps in a development enviroment to quickly test a particluar case. When using the WorldWideImporters database and table PurchaseOrderLines we’ll see the below;
Azure SQL Database has been available for a long time now in its own unique DTU licenced model. As of 4th April it is now also available in a vCore-based Database purchase model, in preview, which will align much more