Jun 2026 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
  • Hire Me
  • Health Check

SQL SERVER – expressor Studio 3.4 Rules Editor – ETL Graphical Coding Tool

October 11, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, DBA
New in the expressor Studio 3.4 release is the rules editor.  This graphical coding tool replaces the transform editor of earlier versions.  The rules editor works in concert with the newly introduced attribute propagation functionality to minimize the amount of data mapping and coding you need to provide.  The expressor…
Read More

SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2011 – Seattle

October 11, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL PASS
For the third year in a row, I am attending the SQLPASS Summit, October 11-14. Every year I have explained my reasons for attending this conference in Seattle, and this year I will state those reasons again. WHY? I have written two articles on this subject, which you can read…
Read More

SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You!

October 10, 2011
Pinal Dave
SQLAuthority News
SQL Milestone, SQL Server

I really never thought that I would be writing this post – honestly! After 1900th post and almost 5 years, this has been a journey and lots of learning. I get to write a 100 “mile stone” post 3-4 times a year, so I am happy to be writing this one. I am eagerly looking forward to my 2000th blog post as well.

Read More
System Center Monitoring

SQLAuthority News – System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance

October 9, 2011
Pinal Dave
SQL
Database, SQL Documentation, SQL Download

Microsoft is continuously releasing System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance

Read More

SQLAuthority News – SQL Server Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions

October 8, 2011
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
I earlier wrote about DBA Quiz at All was well few moments before all went wrong – Reasons and Resolutions. I have even announced that I will give away one print book of SQL Wait Stats book. SQL Programming Joes 2 Pros (vol 4) [Amazon] | [Flipkart]- Chapter 13 has…
Read More

SQL SERVER – Server Side Paging in SQL Server CE (Compact Edition)

October 7, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Paging, SQL Scripts
SQL Server Denali is coming up with new T-SQL of Paging. I have written about the same earlier. SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative SQL SERVER – Server Side Paging in SQL Server Denali Performance Comparison SQL SERVER – Server Side Paging…
Read More

SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()

October 6, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Collation, SQL DMV, SQL Function, SQL Scripts, SQL Server

In my recent Office Hours, I received a question on how to determine the case sensitivity of the database. Let us learn about how we can Detecting Database Case Sensitive Property using fn_helpcollations().

Read More
Previous 1 2 3 4 5 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version