I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my dreams ever come true. Still, it’s fun every once in a while, to be whimsical about the way I wished SQL Server worked. Especially in January because, you know, new beginnings.
Choice is good, but too much choice can cause problems in both coffee shops and software teams, as Steve notes today.
Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.
Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days […]
There have been a number of changes to the T-SQL language that are very specialized. Steve asks if you use any in your code?
Recently, my skills were put to the test when I needed to compare hundreds of Active Directory and SharePoint Groups to find similarities in their memberships.
Are you doing the things at work that your boss cares about or the things you care about? Steve has a few thoughts on this.
In this next level, learn how you can load data from Amazon S3 in Fabric.
Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.
There is still a huge demand for data centers, both from cloud vendors and private enterprises.
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
I’m giving two online sessions soon on virtual events that are free to attend....
Comments posted to this topic are about the item The Security of Old Tech
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Comments posted to this topic are about the item Tables with a SPARSE Column...
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers