Data Ownership
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Data Ownership
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Data Ownership
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Get SQL Server Training in the UK
Kalen Delaney has a series on internals and performance taking place in Hertfordshire soon. If you register today, you can still save 20%
SQL errors and other failures fixed from the trenches
Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.
SQL Server Sanity: Maintain Healthy Transaction Logs for Easy Data Recovery
Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
SQL Server 2000 Useful Undocumented Stored Procedures
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
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