Virtual Log Files: 200 or 1000?
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...
2018-05-23
477 reads
Blog Posts
Azure PowerShell – List Data Center Locations
Occasionally I will come across the need to use PowerShell for my day to day activities. One such need came up this week when I was preparing to do...
2018-05-22
55 reads
Bring Your Own Key to Azure SQL Database TDE
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store and manage encryption keys for SQL Server. With Azure...
2018-05-22
15 reads
Converting JSON to SQL Server CREATE TABLE Statements
Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...
2018-05-22
5 reads
Converting JSON to SQL Server CREATE TABLE Statements
Watch this week's video on YouTube
Tedious, repetitive tasks are the bane of any lazy programmer. I know, because I am one.
One such repetitive task that I find comparable to...
2018-05-22
9 reads
Power BI Custom Visuals Class (Module 102 – Slim Data Bar KPI Visual)
In this module you will learn how to use the Slim Data Bar KPI Visual. The Slim Data Bar KPI...
2018-05-22 (first published: 2018-05-09)
2,354 reads
SQL Saturday – Dallas – May 2018
I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to...
2018-05-22
205 reads
SQL Saturday Iowa City Precon June 22
I’m extremely proud to announce that I have been selected to present an all-new preconference training session on Friday, June...
2018-05-22
283 reads
Update Oddness for SQL Server
I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I...
2018-05-22
328 reads
Day 20 Innodb Storage engine
InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID...
2018-05-21
201 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers