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
311 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
629 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
385 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
288 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
962 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
467 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers