Date Fun with SQL Server
I saw a people discussing date formats on Twitter after PASS put out an advertisement for a webinar with a...
2018-04-03
395 reads
Blog Posts
Power BI Custom Visuals Class (Module 96 – Enlighten Waffle Chart)
In this module you will learn how to use the Enlighten Waffle Chart. The Enlighten Waffle Chart is a simple...
2018-04-03 (first published: 2018-03-27)
2,550 reads
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...
2018-04-03
11 reads
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Watch this week's video on YouTube
In this week's video with Power BI expert Eugene Meidinger, we're in the kitchen learning about Power BI.
Power BI has two languages available for...
2018-04-03
4 reads
Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
288 reads
Procedure to Create New Filegroups and Files
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
53 reads
Remembering Robert Davis, aka @SQLSoldier
I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread,...
2018-04-03
25 reads
2018-04-03
257 reads
TDE – Regenerating the Database Encryption Key
As discussed in the last post, with TDE (Transparent Data Encryption), you generally do not need to change the Database...
2018-04-03
1,136 reads
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...
2018-04-03
564 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