Who needs data access? Not You!
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:
When Too Much is Not a Good Thing December 13,...
2019-12-12
5 reads
Blog Posts
A guide to acronyms, abbreviations, and other technical terms
Here’s a list of some technical terms, acronyms, and abbreviations you may have heard, and what they mean. Some of the definitions are taken from Wikipedia. This list is...
2019-12-11
37 reads
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone ... Continue reading
2019-12-11 (first published: 2019-12-05)
661 reads
Information Measurement with SQL Server Part 4.7: The Bhattacharyya and Hellinger Distances
By Steve Bolton …………Over the course of this segment of the series, we’ve slowly assembled a classification system for some distances measures that can be used for DIY data...
2019-12-11 (first published: 2019-11-30)
411 reads
Reflection on Talking at SQLSaturday Charlotte About Mental Health
On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...
2019-12-11
3 reads
Reflection on Talking at SQLSaturday Charlotte About Mental Health
On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...
2019-12-11
5 reads
T-SQL Tuesday #121: Gifts Received This Year
Closing out 2019’s T-SQL Tuesday, Mala (blog | twitter) is asking us to reflect on the past twelve months:
This is a time for material gift giving, for many of...
2019-12-11
4 reads
How Serverless is Working in Azure SQL Database
When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...
2019-12-10 (first published: 2019-11-27)
1,051 reads
Install ALL Things SQL Server… What?
Does your server look like this? Many of us have inherited a SQL Server instance that has all SQL Services installed. Someone, maybe even you, went through the SQL...
2019-12-10 (first published: 2019-11-26)
907 reads
Online, Resumable, and WAIT_AT_LOW_PRIORITY operations in SQL Server
ONLINE operations in SQL Server were simple to understand for years — we got ONLINE index rebuilds in SQL Server 2005. That was it for a while. Then, things...
2019-12-10
466 reads
Blogs
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...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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