Taking Care of Things Today
Steve Jones talks about procrastination today and how you might not want to do that with your SQL Servers.
Untrusted Foreign Keys with NOT FOR REPLICATION Option on the Key
My Foreign Keys are STILL untrusted after the double CHECK. Here's how you can fix this issue.
Questions About Pivoting Data in SQL Server You Were Too Shy to Ask
Of all the basic SQL operations, the pivot seems to cause the most problems. It turns out that there are several questions that come to mind while learning about pivoting, but which are seldom asked on forums.
Returning Sorted Record Sets Using the ORDER BY Clause
Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order. To make sure a result set is ordered you need to use the ORDER BY clause. In this article I will be exploring how to return an order result set by using the ORDER BY clause.
A Little Empathy
Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.
Prevent sp_ Procedures with SQLCop
Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.
Data Cleaning in SQL 2012 with Data Quality Services
Feodor Georgiev provides a thorough walkthrough on setting up SQL Server's Data Quality Services (DQS) and creating the rules it uses to function as a first step towards data cleansing.
Hadoop and SQL Server
Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.
Options to Improve SQL Server Bulk Load Performance
In this tip Ben Snaidero looks at how to improve SQL Server Bulk Load performance. He focuses his performance tests on options using the BULK INSERT T-SQL command to judge how the various options affect speed.
Dynamically Create Tables Based on an Access Table
Create and Load Sql Server Tables based on Dynamic Access Database
Blogs
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...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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