Design A Database Using an Entity-Relationship Diagram
New Author! Ramesh talks a little about database theory, using the ERD, and how you can put it to work.
2003-10-28
22,487 reads
Articles
Cycling Those Error Logs
Have you ever tried to open the current error log in Enterprise Manager only to have it seize up and hang? Has that annoyed you? It certainly annoyed Steve Jones and he decided to do something about it. A little techinque for helping to manage the size of those logs and prevent the "not responding" message from appearing in Task Manager.
2003-10-27
6,345 reads
Code Stored in Files Instead of Stored Procedures
This articles proposes storing the source code for stored procedures on disk rather than in the database itself, the intent to give developers the ability to easily change them or potentially to allow third party encryption of source code. (Note from SSC: If you choose to implement a technique like this, please be sure you understand the implications of exec'ing strings)
2003-10-24
8,313 reads
Bulk Data Load Using OLEDB Template Libraries
New Author! This is a fairly article that looks at how to do bulk data loading at a very (very) low level. You'll need to be able to read code to make use of this.
2003-10-23
5,853 reads
For SQL Server, XML Is One Answer
New author! Nick discusses why 'XML is One Answer', outlining some of what he believes are key points about using XML with SQL Server. This is a follow up (and sort of counter point) to another great article we had here on the site a couple weeks ago by Don Peterson. Good stuff!
2003-10-22
5,738 reads
An Interesting Article on Unicode and Character Sets
This may well be more than you want to know about Unicode (and no, it's not a SQL article), but it's a pretty useful discussion to have.
2003-10-21
70 reads
Documenting Stored Procedures
Regular columnist Robert Marda discusses a few ideas on stored procedure documentation. How much documentation do you need and is "documentation" different than code comments?
2003-10-20
18,688 reads
Mapping Database File Objects and Fragmentation
Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?
2003-10-16
8,864 reads
When Do You Pull Your Hair Out?
Another adventure in the real world. Steve Jones tracks down a problem with locks on a live system. Read along and see how he works through the issues.
2003-10-15
5,181 reads
Terminal Services - A Couple Tips
We agree with Andy that Terminal Services is definitely a tool to have in the DBA toolbox. Like most tools, everyone uses them differently. Andy starts the discussion with some comments on how he uses TS - what about you? Do you use TS at all? Use it differently than Andy does? Prefer a different solution? Read the article and post a comment.
2003-10-14
7,467 reads
Blogs
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...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
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