Tags » SQL Query

SQLAuthority News - Presented on Database Worst Practices at SQLPASS 2014 in Seattle - November 5, 2014

Earlier last month, I had the opportunity to present at SQLPASS 2014. The event was held in Seattle in November 2014. I had a great time attending this event and I presented on the topic Database Worst Practices on November 5, 2014. 260 more words

SQL Authority

SQL SERVER - Reverse String Word By Word - Part 4

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara and Yuri Petrov contributed to the blog post with their excellent script which I have blogged earlier. 162 more words

SQL Authority

Datawarehouse Database Cleanup SQL query

IMPORTANT: Always perform a FULL Backup of the database before doing anything to it !!!

This article applies to SCOM 2007 and SCOM 2012

Somtimes you may have event storms where you end up having old entries in the Data Warehouse database i.e data that is older than the grooming threshold. 364 more words

SQL Queries

SQL SERVER - Creating the SSIS Catalog - Notes from the Field #058

: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Creating the SSIS catalog. 649 more words

SQL Authority

SQL SERVER - Reverse String Word By Word - Part 3

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. 214 more words

SQL Authority

SQL SERVER - Proving that the Source of the Problems aren’t Tied to the Database

I have always wondered how Sherlock Holmes cracked the toughest of mysteries every single time. This fascination always lead me to learn new techniques every single time. 1,150 more words

SQL Authority

SQL SERVER - Reverse String Word By Word - Part 2

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. 226 more words

SQL Authority