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
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
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
470 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers