Tech Lunch News

Červencové novinky ze světa dat byly trochu prázdninové a odpočinkové, ale i tak jsme se podívali na pár zajímavých a šikovných demíček, které by se vám mohli hodit.
Co nového...

Efficient calculation of an ISBN-13 check digit

I thought I might pass along, what I have found to be, the most efficient way to validate the check digit within Azure SQL Server. I was looking to...

SQL Server on VMware Accelerator now free!

My SQL Server on VMware Accelerator boot camp video series is now live on Youtube! There’s no strings attached and no price of entry, so now there’s no reason...

A New Word: Exulansis

exulansis – n. the tendency to give up trying to talk about an experience because people are unable to relate to it – whether through envy or pity or...

Demonstrating How I Use Voice Access

As part of my effort to inform people on how to use tools with their disabilities and continue working, I created a series of videos that demonstrate how I...

Exciting New Adventures Ahead

Some of you may know that I went to work for BlueGranite a little over four years ago. It was humbling to be part of such a talented team...

Three more chapters of my data architecture book are available!

As I have mentioned in a prior blog post, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering...

Azure Data Studio Schema Compare Extension

A coworker recently introduced me to the SQL Server Schema Compare extension in Azure Data Studio. It has come in handy since we don’t have any paid-for tools, so...

A Barebone Script To Generate SQL Script to Create Synonyms

A Barebone Script To Generate SQL Script to Create Synonyms

This stored procedure can be used to generate a SQL script to create synonyms for all tables in...

Generate SQL Script to Allow or Disallow Access To All Data

I had a requirement to temporarily prevent access, read or write, to a particular database for all users except 2 users. There were hundreds of SQL Logins with access...