SQL Exercise During Candidate Interview Process
A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...
2011-06-01
2,710 reads
Blog Posts
SQL Saturday Pensacola
I know it has been almost a month since I posted last and this is not really a “real” post,...
2011-06-01
424 reads
An Unexpected Service Gotcha
Recently I was participating in a round of storage rearranging with a client (aka the storage dance) which consisted of...
2011-05-31
1,554 reads
Free SQL Exam cram sessions from Microsoft.
G’day,
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at...
2011-05-31
2,926 reads
How to protect code written in Stored Procedure or User Defined Function?
Introduction
We have always
been wondering on how to protect/secure our t-sql code written in Stored
Procedures and UDF in shared hosting environment...
2011-05-31
13,207 reads
Identity Reseeding
I love the identity property. I use it in many of my tables, mostly because it gives me a fairly...
2011-05-31
2,430 reads
Speaking at 24 Hours in the Cloud
On June 1st GITCA will run a 24 hour round-the-world virtual event focusing on Cloud Computing. Please visit http://sp.GITCA.org/sites/24Hours for...
2011-05-31
1,580 reads
SQLSaturday #85 in Orlando!
It’s that time of year again, actually a little earlier than in previous years as we’ll be holding our fifth...
2011-05-31
1,498 reads
Start All Your Meetings in Pole Position
Let’s face it, a lot of us don’t enjoy attending meetings and can often find them to be a bit...
2011-05-31
1,825 reads
Taking It to the Extreme: SQLCLR and Parallelism - a NYC event coming soon!
Here’s another awesome SQL event coming to New York City. (Keep reading for your discount below!) It’s already getting hot...
2011-05-31
2,356 reads
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