ScriptDomVisualizer - Now Displays TSqlParserToken's
New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part...
2015-11-25
963 reads
Blog Posts
SSC Editorial: Early Adopters
I wrote Early Adopters for SQLServerCentral after seeing a comment elsewhere that basically lumped all MVP’s into one category as...
2015-11-25
536 reads
Test if a File Exists with Powershell
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
Awhile...
2015-11-25
1,360 reads
Women in technology
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
630 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
48 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes...
2015-11-24
55 reads
Changing case of T-SQL Keywords
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person...
2015-11-24
6 reads
Database Mirroring Error 1418
Database Mirroring Error 1418
Hello Everyone.
This post will be helpful in resolving the error 1418 that we may come across when...
2015-11-24
2,796 reads
Identity Column Increment Value (EVEN/ODD)
As always I’m sitting at my desk, minding my own business, when an email comes in from a developer.
“Hey DBA’s,...
2015-11-24 (first published: 2015-11-18)
4,856 reads
In-Memory OLTP in SQL 2016
With SQL server 2016 around the corner, I would like to share some of my thought on the usage for...
2015-11-24
735 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Question of the Day
Fun with JSON I
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers