Finding overlapping ranges of data

0
1
This week, I had a problem where I needed to find and eliminate from the results of my query, data with overlapping ranges. I have written about this topic before, in my database design book book, in regards to building a trigger to avoid overlapping ranges. But even though I have written on the topic … Read more

Microsoft Dynamics 365 Storage Pitfalls – Here is the Cost Effective Solution

0
3
In Microsoft Dynamics 365, by default, database is optimized for database record storage and not for files or attachment storage. Hence, cost effective storage management of huge sized data files becomes one of the most critical aspects for the organizational users. This blog narrating the process of optimizing storage capabilities of Microsoft Dynamics 365 CRM … Read more

My First Experience Migrating a .NET App to Core

6
18
I recently migrated an old .NET Framework 4.5.2 app to .NET Core 2.0. This isn’t a guide to that process and certainly isn’t an exhaustive list of all the things that can go wrong, but rather provides an account of what worked for me, where the pitfalls were, and whether it was worth it. The … Read more

What Counts for a DBA – Deadlines

0
0
Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline, they work like fury. If we didn’t have deadlines, we’d stagnate. ― Walt Disney I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild … Read more

Matters of Timing in Concurrency

0
4
There are a few topics in SQL Server that I love academically, but are truly a pain to get right. The other is security, and it pales in comparison to how much trouble it is to program for truly safe concurrent access to a resource. The biggest issue: time. What makes it more difficult is … Read more

What Counts For A DBA – Adequacy

2
3
“Aim High!” “You could be president some day!” “You’re just as smart as that Einstein kid down the street” … …And other crazy things parents tell their kids. Of course, very few kids grow up to be President, or a groundbreaking scientist. Most of us are merely adequate. Adequate parents, and adequate at our jobs, … Read more

Inline Index Definition

0
3
There are a lot of features of SQL Server that I (and I know some of you), never really get around to using, usually because you have your ways, you have done things the same way for 100 years, and it all works fine enough. You may have heard of a feature, but said I … Read more

Ready Player Tattoo

2
3
I am sitting in my hotel room in Nashville getting ready for #SQLSatNash as I write this. I know there are a lot of #SQLFamily here at this and I look forward to seeing them again.  It is snowing outside. This is perfect weather for a Florida boy to contemplate his life and pen a … Read more

New Beginnings for an Old Blogger

1
3
The pain of parting is nothing to the joy of meeting again. – Charles Dickens Happy New Year! I am stoked to be blogging here on SimpleTalk! I am a major fan of Redgate’s tools for a long time, and have been a Friend of Redgate for almost as long. My new year’s resolution is … Read more

Troubleshooting Failed PolyBase Installation in SQL Server 2017

This article shows you how to troubleshoot a failed installation of SQL Server and how to implement a workaround to allow SQL Server 2017’s PolyBase feature to be installed when version 9 of the Java Runtime Environment (JRE) is present. An installation of all features in SQL Server 2017 has three external dependencies. Python, R, … Read more