September 2, 2010 by pinaldave
In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically man of the performance tuning. I love to tune servers and I love to speed up queries. I often get queries what do I do when I go to performance tuning. Here I am listing my complete service descriptions.
This whole exercise can be done remotely as well on site. The advantage of on site is that I am more involved with local DBAs and the training part is much more enjoyable. I have often got very good relations with the local DBA and we still talk when they have issues with server. There is no replacement of the human connections. The advantage of the remote is there is no travel involved and can be economic when the location is very remote or there is urgent need of performance.
SQL Server Health Check Service
SQL Server Health Check is a very challenging subject that requires expertise in Database Administration and Database Development. Solid Quality Mentors provides specialized health check service where we dive deep into your SQL Server configurations and potential issues and propose solutions to resolve your issues. We also provide maintenance scripts and train your team on few of the key areas in order to empower them to understand and tune the systems in the future. We also provide Hands-On sessions for tuning your queries and propose solutions for your deadlock situations.
If you need this service drop me an email at pinal “at” SQLAuthority.com and IndiaInfo “at” SolidQ.com. If you specify SQLAuthority.com in Title, you will avail special discount in overall rates.
Reference: Pinal Dave (http://blog.sqlauthority.com)
Posted in About Me, Best Practices, Database, Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Training, SQLAuthority News, T SQL, Technology | 2 Comments »
September 1, 2010 by pinaldave
Today I am very happy as my daughter is one year old. I have no words to explain how lucky I am to be father of daughter. She is everything to me and my wife have (sweet) complain that I stopped paying attention to her since our daughter has arrived. Check out here one year old photographs.
There is special bond between fathers and daughters. An year ago here is the comment I have received from Solid Quality Mentors Global CEO Fernando G. Guerrero wrote to me in email.
“What a wonderful gift. Someone told me once that if I had a daughter, I would have a palace waiting for me in Paradise. Congratulations to you and your wife.”
I totally believe in it. Are you father of daughter? What do you feel?
Reference: Pinal Dave (http://blog.sqlauthority.com)
Posted in About Me, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology | 25 Comments »
August 31, 2010 by pinaldave
Monthly round ups are very refreshing as it gives me chance to go back and see what did I do in last month. The highlight of the last month is the my computed column series and its final installment. If you have not followed up on it I suggest you read SQL SERVER – Computed Columns – Index and Performance. I have great fun to investigate the computed column. Second fun thing was to write about views. I am still going to write more article on this subject but atleast the series has started in this month. Following are the first two articles in the series.
Community events are in my blood and I always enjoyed being part of it. I had few reports as listed below where I did community event. Salute to community which is so vibrant.
Career Development or professional development is always burning questions for all. I had great fun to write about when one can take vacation SQL SERVER – Best Practices for DBA Before Taking Vacation. There were lots of curious looks at my article on Shrinking Database SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server. Many people online either refused to see it just based on title. Many online tried to even call big gurus to start controversy, however, all went well once people start reading the article. I had really good discussion also on the article SQLAuthority News – Why SQL Server is better than any other RDBMS Applications?. Obviously SQL Server is the best.
Performance tuning has been my favorite subject always so I have two new announcements this month as well.
There were few more articles but the one which is really make you think was SQL SERVER – Does Order of Column in WHERE clause Matter?. Additionally, there were many other articles I have written during the month, you can check all the articles written by me over here. Tell me which one was your favorite article this month.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology | 1 Comment »
August 30, 2010 by pinaldave
I am very glad that I will be presenting my very first seminar training series worldwide. This event is called the Solid Quality DIRECTIONS Seminar Series. I am very fortunate that I am given this opportunity to work under prestigious organizations. I have been with Solid Quality Mentors for more than a year now. I have learned a lot and I have grown a lot through this group. While working for Solid Quality, I have conducted many training events and various consultations projects. I can say that I have collected and kept with me all the wisdom and knowledge related to my passion, SQL. In one of my recent conversations with Rushabh Mehta (Solid Quality India CEO), I realized that I have a chance to share with everybody this wisdom I have learned. For the very same reason, I will present all the things I learned throughout these many years and compress them into this one major seminar.
The quick schedule for registering here is listed below:
- Chennai, India: Sep 24-25, 2010
- Colombo, Sri Lanka: Oct 4-5, 2010
- TBD, USA: Nov 15-16, 2010
- TBD, USA: Nov 17-18, 2010
- Hyderabad, India: Nov 27-28, 2010
- Pune, India: Dec 4-5, 2010
The very first seminar will occur in Chennai. The detailed agenda of this event you can find over here.
The venue for the first training is as follows:
SAVERA HOTEL
146, Dr. Radhakrishnan Road,
Chennai – 600004, India
Phone: +91-44-2811-4700
This 2-day seminar will cover the best of the best concepts and practices from popular courses offered by Solid Quality Mentors. Instead of learning theory only, the seminar focuses on providing real world experience by using demos and scenarios derived from customer engagements. The seminar is uniquely structured and well-thought-out. Sessions are discussion- based and are designed to be an interactive gateway between the instructor and the participants for an optimal learning experience. The seminar is intended to be immersion-based where participants will have plenty of opportunities to get deeply involved in the concepts presented by the instructor. The best participants will receive special educational materials from the instructor, as well as further follow ups.
3 Free Registrations
Solid Quality India has announced three free give-away registrations for the first event. To win the free registrations, you have to write a blog post or comment on social media (facebook, twitter etc) as to why you should win the free registrations. If your entry is chosen to be the best one, you will win the free registrations. Once you write your blog post or spread the word in social networking, please leave a comment with the name of the city where you want to win free registrations.
To join the seminars, please drop me an email. My email address is pinal “at” SQLAuthority.com and IndiaInfo “at” SolidQ.com. If you specify SQLAuthority.com in the Title of your email, you will avail a special discount in overall rates on specified price. Yes, a more than 20%, I promise.
Reference: Pinal Dave (http://blog.sqlauthority.com)
Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology | Leave a Comment »
August 29, 2010 by pinaldave
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues.
Note: The description has been taken from original Microsoft page.
Download SQL Server Monitoring Management Pack
Reference: Pinal Dave (http://blog.sqlauthority.com)
Posted in Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology | Leave a Comment »
pinaldave
