Subtitle button on a remote control

Accessibility after the fact: closed captions for videos

My user group, the Calgary Data User Group, has been recording videos since April of this year, so at the time of this writing we have just two videos on our YouTube channel. As one of the Azure Data Tech Groups we have access to Microsoft Teams, and in there we can display live captions during
-> Continue reading Accessibility after the fact: closed captions for videos

Azure Data

On accessibility in our community

Today I want to write about the community that brought us all together. The community that got this very website on your radar. The community that got many of us spending lunch breaks, evenings and weekends learning about the Microsoft Data Platform at free local events. This community has had various organizations steering its direction
-> Continue reading On accessibility in our community

T-SQL Tuesday Retrospective #015: Aggregations

In early 2011 Jes Borland invited us to write about aggregations: I want to hear how you solved business problems with aggregate functions. I want to see your cool T-SQL tricks. How are aggregates used in SSRS, SSAS, or SSIS? What have you learned about aggregate functions? Ten years of hindsight (and being able to
-> Continue reading T-SQL Tuesday Retrospective #015: Aggregations

Azure SQL logo

A summary of new features in Azure SQL Database

It has been some time since I last wrote about Azure SQL Database. Although it has been more than three years since SQL Server 2017 was released, Microsoft have not been resting on their laurels. Here is a list of features in public preview that you can start testing and including in your future plans
-> Continue reading A summary of new features in Azure SQL Database

analogue clock with a blur effect on the minutes

How SQL Server stores data types: DATETIMEOFFSET

If you’d like to check out the previous instalment in this series on storing dates and times, click here. I avoided mentioning this data type because I didn’t think a lot of people used it, and then my co-author William Assaf (blog | Twitter) told me on Twitter that he uses it, so here we
-> Continue reading How SQL Server stores data types: DATETIMEOFFSET

yes

Things to check when restoring a database

Whenever I restore a database — especially one I obtained outside of my regular environment (for example a customer database, a development database, or even a sample database like WideWorldImporters) — there are a few things I like to check to make sure it’s configured for peak performance. Note that some of this advice may
-> Continue reading Things to check when restoring a database

Close-up of a microscope

How I tackle disaster recovery

One of my special interests as an autistic person is understanding mechanical components of a computer, both analog and digital. In the olden days, we had devices known as hard drives which used one or more spinning disks and a read/write head that would move over the surface with a buffer of air so thin
-> Continue reading How I tackle disaster recovery

T-SQL Tuesday Retrospective #015: Automation

In February 2011, Pat Wright invited us to talk about Automation: So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or with Powershell or a mix of both. Give us your best tips/tricks and ideas for making our lives easier through Automation. I’ve spoken about this topic
-> Continue reading T-SQL Tuesday Retrospective #015: Automation