Working with “special” names
What do you do when you need to use a special character in a name? Well, I guess I should...
2015-10-22 (first published: 2015-10-19)
1,500 reads
Kenneth Fisher
“That little green arrow.” or “My code used to work but now I’m getting a debug error.”
If you’ve worked with SSMS for any length of time this will look awfully familiar:
SSMS 2008R2
SSMS 2012 +
This little green...
2015-10-15
514 reads
Finding the error from a failed job.
This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you...
2015-10-15 (first published: 2015-10-07)
2,324 reads
Keep an eye on those Audit files!
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server...
2015-10-13
497 reads
Updating a view
I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So...
2015-10-12 (first published: 2015-09-30)
3,091 reads
SSMS Connection Information
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...
2015-10-05 (first published: 2015-09-28)
2,083 reads
The powerpoint for my SQL Server Security Basics session
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned...
2015-10-05
536 reads
“sql_handle” is not a recognized table hints option.
I’ve you’ve run a query similar to the following:
SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle);And gotten an error similar to:
Msg 321, Level...
2015-09-23
1,022 reads
Finding the worst running query in a stored procedure
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...
2015-09-22 (first published: 2015-09-10)
4,663 reads
Zombie AD Groups
I spent something like 2 hours today trying to figure out how a particular user had access to one of...
2015-09-21
629 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
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