Those who read my blog are for sure know my very good friend Jacob Sebastian. He is SQL Server MVP and founder of wonderful site T-SQL Challenges. No matter how expert we are, challenges are made to make us think and try to go to next level. There are certain people who writes always challenging code, however there are many who are yet not expert but the passion of T-SQL is on them. Jacob has many wonderful ideas and T-SQL challenge is his contribution to community, where he helps community to think, help them to mentor and help them to become one better coder.
SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example
In one of the recent consultancy, I was asked if I can give working example of BINARY_CHECKSUM. This is usually used to detect changes in a row. If any row has any value changed, this function can be used to figure out if the values are changed in the rows.…
Read MoreSQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts
This month was very interesting month for me. I visited 2 different countries – Malaysia and Sri Lanka. I had great time attending 3 community sessions – Chennai, Kuala Lumpur and Ahmedabad. Though, I was at home only 5 nights, I was fortunate enough to spend good amount of the…
Read MoreSQL Tips – 5 SQL Server Best Practices
In this blog post we will see 5 SQL Server Best Practices.
Backup Master. I am going to have a backup of the database using script; however, the backup script has not been updated for a long time now.
SQL SERVER – Check Advanced Server Configuration
I was recently asked following question about how to Check Advanced Server Configuration.
SQLAuthority News – 2 Sessions at TechInsight 2010 – June 29 – July 1, 2010
Earlier this month, I got the opportunity to visit Malaysia for community sessions on June 29 – July 1, 2010 at Kuala Lumpur, Malaysia, which I would consider as valuable experience. I presented two different sessions at the event. The event was extremely popular in local community, and I had…
Read MoreSQL SERVER – Computed Column – PERSISTED and Storage
This is the list of the all the articles in the series of computed column.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.