SQL Server Archives - Page 183 of 393 - SQL Authority with Pinal Dave

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 2. Every day one winner from United States will get Joes 2 Pros Volume 2. Partitioning with the Over Clause (Part 2) Yesterday we learned how…

SQL SERVER – Who needs ETL Version Control?

August 10, 2011

ETL, SQL Scripts, SQL Utility

While making some changes (read: mistakes) to my ETL business logic the other day, it occurred to me much too late that those unfortunate changes had replaced the once properly working logic with now very flawed logic. The good news was that I remembered what the working logic was supposed…

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Aggregates with the Over Clause – Day 10 of 35

August 10, 2011

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 2. Every day one winner from United States will get Joes 2 Pros Volume 2. Aggregates with the Over Clause You have likely heard the business…

SQL SERVER – Use INSERT INTO … SELECT instead of Cursor

August 10, 2011

Best Practices, SQL Scripts

This blog post is written in response to the post showing some of the worst practices of past. Well, just like last month’s theme, everybody learns by doing it one step at a time. In my case, I started my career as a network engineer and had no database knowledge…

SQL SERVER – The SQL Hands-On Guide for Beginners – Book Available for SQL Server Certification

August 9, 2011

We recently give away 7 physical books of Joes 2 Pros eBook Volume 1. The response to following questions was overwhelming and was excellent. The book is available to purchase now in India and USA. This is great news as I often get request that where one can learn SQL…

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35

August 8, 2011