:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...
2014-03-13
1,438 reads
SQLStudies
T-SQL Tuesday #52: Keep your head down!
It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has...
2014-03-11
1,291 reads
Characters you should never ever use in an object or schema name!
You can put pretty much any character you want into an object or schema name by enclosing the name in...
2014-03-05
727 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
3,049 reads
Impersonating a server level permission
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...
2014-03-07 (first published: 2014-02-26)
2,548 reads
What’s the difference between a temp table and a table variable?
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...
2014-02-24
1,099 reads
Finally added a (t) to my (b)
I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....
2014-02-20
506 reads
Getting a query plan
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware...
2014-02-19
1,484 reads
DBA Myths: An index on a bit column will never be used.
Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...
2014-02-19 (first published: 2014-02-17)
2,618 reads
T-SQL Tuesday #51: Doubledown disaster
Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.
It’s always a gamble when buying a...
2014-02-14 (first published: 2014-02-11)
1,579 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