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
312 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
386 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
289 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
963 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
469 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers