SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Katie and Emil

We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.

Basic SQL Interview Questions

We decided to add blog post that covers only basic SQL Interview questions and answers. The blog currently provides only questions that are split into theory and practical questions.

Read more

0 comments, 911 reads

Posted in Katie and Emil on 7 July 2012

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 also written stored procedure that shows how to use one of the methods and return the value using sp argument so it can be used for other purposes.

Read more

0 comments, 560 reads

Posted in Katie and Emil on 3 July 2012

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 GMT) so I could generate in my stored procedure pubDate element for my RSS feed.

Read more

0 comments, 316 reads

Posted in Katie and Emil on 2 July 2012

Three reasons for normalization

In this article we cover three reasons for normalization (from our point of view). We created the article and included it in our exam guide to 98-364 Database Fundamentals.

Read more

0 comments, 242 reads

Posted in Katie and Emil on 2 July 2012

Database Interview questions

I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.

Read more

0 comments, 827 reads

Posted in Katie and Emil on 1 July 2012

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 and medium size BI projects. Later on I hope to add more links that describe the subject in more details.

Read more

0 comments, 418 reads

Posted in Katie and Emil on 1 July 2012

Newer posts