How to Get Started with Version Control for Databases
Today, Kendra talks about why version control for databases is important and how to get started.
2020-02-04
501 reads
Kendra Little
Why I Don’t Like Shared Development Databases
Today, Kendra explains why she doesn't like shared development databases.
2020-01-31
502 reads
Why A Query May be Faster the Second Time it Runs
Today, Kendra Little explains why a query may run faster the second time you run it.
2020-01-29
2,491 reads
Two Important ‘ONLINE’ Column-Level Operations in SQL Server
Today Kendra talks about two of the online options used when working with indexes.
2020-01-14
346 reads
The V1 Team’s Doomed Redesign
A new version of an existing application doesn't always provide an upgrade.
2019-03-18
106 reads
Do you work with data? You’ve always got options.
She's ready for the future. Are you?
In preparing for the SQLPeople event, I thought about the role, motivation, and techniques...
2011-04-15
935 reads
Andy Leonard’s great idea: SQLPeople events
Not too long ago, Andy Leonard (blog|twitter) dreamed up the idea to create the SQLPeople community. The community is forming...
2011-04-13
874 reads
To Do: Win Great SQL Training and a Cruise
Wondering what to do when you get a break from work email today?
Make your opening move in a fun contest.
What’s...
2011-03-31
1,904 reads
I laughed, I cried, it was better than CATS: The Fast Track Data Warehouse 3.0 Reference Guide
Careful what you say about cats, lady.
You know what’s crazy?
A comprehensive, technical, well thought-out, and ENJOYABLE document. One written with...
2011-03-30
1,786 reads
Dynamic Management Quickie: Exploring SQL Server’s system views and functions as you work
There’s a lot of dynamic management and system objects to keep track of in SQL Server.
We all sometimes have the...
2011-03-22
1,343 reads
Blogs
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...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers