June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Who needs ETL Version Control?

August 10, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
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…
Read More

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

August 10, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
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…
Read More

SQL SERVER – Use INSERT INTO … SELECT instead of Cursor

August 10, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
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…
Read More

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

August 9, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
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…
Read More

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

August 8, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
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. Many to Many relationships If anyone has done some shopping on…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Dirty Records and Table Hints – Day 7 of 35

August 7, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1. Dirty Records Recap Most SQL people know what a “Dirty Record”…
Read More

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding un-matching Records – Day 5 of 35

August 5, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1. Finding un-matching Records Often time we want to find records in…
Read More
Previous 1 … 296 297 298 299 300 301 302 … 519 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version