Worst Day As A DBA
I remember the day pretty vividly, it was in the summer months and I was as green as green can...
2014-06-26
427 reads
Blog Posts
“A good DBA is a lazy DBA”
I’m borrowing from Andy Leonard (blog | twitter) who says all the time, “Good engineers are lazy.”
If you’re thinking, “Why would I want (to...
2014-06-25
1,958 reads
5 Things to Know About Indexes for SQL Server
One of the first questions I got while interviewing for a potential position as a DBA was “If there is...
2014-06-25 (first published: 2014-06-19)
6,669 reads
Clustered Columnstore Indexes – part 32 (“Size Does Matter, but how ?”)
Continuation from the previous 31 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
The Columnstore Row Group Size Question:
What is better for SQL Server performance:...
2014-06-25
260 reads
Dealing with a long string
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,552 reads
Final Summer Precon for Me – Portland Maine
This coming weekend is the SQL Saturday #293 in Portland, Maine with my precon on Friday. I am really looking forward to attending...
2014-06-25
440 reads
I am speaking at the PASS Summit 2014
I am super excited to announce that I have been selected to speak at the 2014 PASS Summit. This is...
2014-06-25
1,227 reads
PASS Summit 2014 – I’m speaking!
On June 25, 2012, I set a goalfor myself. It was this:
In the next 3 years, I want to present...
2014-06-25
687 reads
Speaking at PASS Summit 2014
Achievement unlocked.
I am more than delighted to announce that I was selected to speak at the upcoming PASS Summit 2014...
2014-06-25
143 reads
Speaking at SQLSaturday Oslo, Norway 2014
I am extremely delighted to announce that I was selected to present a Deep Dive session on Clustered Columnstore Indexes...
2014-06-25
161 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