FDD 2023 – Session Materials

You can find the slides for my session at Future Data Driven summit at GitHub. It was really nice presenting (virtually). If you have any questions, let me know!
The...

How to Secure SQL Server

Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. At times when applications are run in geographically restricted areas, there...

SQL Homework – September 2023 – Time for temporal tables.

Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading

Common Mistakes in SQL Server – Part 2

The  Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...

Common Mistakes in SQL Server – Part 2

The  Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...

Enable PowerShell Remoting

Enable PowerShell Remoting

I use PowerShell quite a lot to manage servers, especially SQL Servers. So I need to be able to run PowerShell...

Future Data Driven 2023 is This Week

The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register today and save a note in your calendar. The event has  a great schedule (scroll...

Opening the SQL Prompt Command Palette

A few years ago SQL Prompt added a command palette to let you search the commands available. This is similar to the same concept in Visual Studio Code, ADS,...

Quickly Creating a tsqlt Test for a Query

One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...

SQL Saturday Denver 2023–VCS Primer for the Database slides

My slides are here: VCS Primer Denver 2023 This was an overview of what version control is, and the basics of Git. Not too many questions, but if you...