Data Manipulation Language
In this blog post we describe what is Data Manipulation Language (DML) and include this article in our exam guide...
2012-07-07
315 reads
SQL Server Get Identity after Insert using SP
I thought I will share my experience how you can get identity value after insert using SQL Server. I have...
2012-07-03
630 reads
RSS pubDate format in SQL Server
Today I had to write T-SQL code to convert date into very specific date format (Mon, 02 Jul 2012 19:24:05...
2012-07-02
390 reads
Three reasons for normalization
In this article we cover three reasons for normalization (from our point of view). We created the article and included...
2012-07-02
290 reads
Database Interview questions
I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.
2012-07-01
966 reads
SQL Server Performance Tuning Overview
In this blog article I will give an overview of performance tuning based on common situation that occur on small...
2012-07-01
472 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers