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
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers