Hope!
2020 was a rough year. We’ve had friends and family leave us. Jobs lost. Health scares a plenty and that’s ... Continue reading
2020-12-31
64 reads
Blog Posts
Logging the history of my past SQL Saturday presentations
(2020-Dec-31) PASS (formerly known as the Professional Association for SQL Server) is the global community for data professionals who use the Microsoft data platform. On December 17, 2020 PASS announced...
2020-12-31
139 reads
Using Azure Durable Functions with Azure Data Factory - HTTP Long Polling
(2020-Dec-21) While working with Azure Functions that provide a serverless environment to run my computer program code, I’m still struggling to understand how it actually works. Yes, I admit, there...
2020-12-31 (first published: 2020-12-21)
453 reads
2020 was certainly a year on the calendar
According to my blog post schedule, this is the final post of the year. It’s nothing more than a coincidence, but making it through the worst year in living...
2020-12-30
51 reads
Creating an HTML URL from a PowerShell String–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wrote about getting a quick archive of...
2020-12-30
297 reads
Daily Coping 30 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-30
43 reads
Estimating the storage savings by removing columns with NULL value across the table or marking them as SPARSE
In the previous article Find columns with NULL values across the table we discussed that storage space can be saved by removing columns with NULL value across the table...
2020-12-30 (first published: 2020-12-21)
736 reads
Workout Wednesdays for Power BI in 2021
I’m excited to announce that something new is coming to the Power BI community in 2021: Workout Wednesday! Workout Wednesday started in the Tableau community and is expanding to...
2020-12-30 (first published: 2020-12-18)
369 reads
Daily Coping 29 Dec 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-29
54 reads
How to Easily Grant Permissions to all Databases
This article demonstrates one method to grant READ access to all DBs while still keeping the environment secure & hitting that chord of doing it efficiently.
The post How to...
2020-12-29
930 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
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers