Feeds:
Posts
Comments

Archive for the ‘SQLAuthority Website Review’ Category

SQLAuthority News – Hyderabad Techies February Fever Feb 11, 2010 – Indexing for Performance

Posted in SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority News, SQLAuthority Website Review, T SQL, Technology on February 28, 2010 | 4 Comments »

I recently presented in Hyderabad User Group on the subject of The Other Side of SQL Server Index: Advanced Solutions to Ancient Problem , you can read more about this event here SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review. I really had great time talking about Index and Index Tuning. Index is very important part of database performance tuning and understanding it is a big thing. I have learned a lot of performance tuning tricks from Itzik Ben-Gan and Greg Low.

After successful session at Hyderabad User Group, I have presented follow up technical session at online Hyderabad User Group Hyderabad Techies. The title of the session was SQL Server Index Maintenance: Detect, Create, Detect & Rebuild. It was really fun as session was attended by 50+ enthusiasts and had lots of interaction in online community which is a bit unusual.

Hyderabad Techies is a community which is launched exclusively for developers working on Microsoft technologies in Hyderabad which has 1000+ members.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

Read Full Post »

SQLAuthority News – Links to Book On Line – Data Mining Algorithms (Analysis Services – Data Mining)

Posted in Business Intelligence, Data Warehousing, SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, T SQL, Technology, tagged on February 23, 2010 | 1 Comment »

I have quite often received request for the Data Mining Algorithms details. Book Online has wonderful resources for the same. I suggest to read them here.

Data Mining Algorithms (Analysis Services – Data Mining)

The data mining algorithm is the mechanism that creates a data mining model. To create a model, an algorithm first analyzes a set of data and looks for specific patterns and trends. The algorithm uses the results of this analysis to define the parameters of the mining model. These parameters are then applied across the entire data set to extract actionable patterns and detailed statistics.

Read more here.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

SQLAuthority News – Blog Subscription and Comments RSS

Posted in About Me, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, T SQL, Technology on February 22, 2010 | 11 Comments »

Quite often I get email where many readers ask me how to get email from SQLAuthority.com blog. Today very quickly I will go over few standard practices of this blog using you can stay connected with SQLAuthority.com

First the most important is search: I received hundreds of emails and hundreds of comments every day. I try to answer each of them but if you have any urgent question I strongly suggest to search in my custom SQLAuthority.com Search. It searches in all the blogs as well in the comments.

Search @ SQLAuthority.com

If you want to stay connected with SQLAuthority.com using your RSS reader here are RSS feed for the same.

RSS of all the Posts: http://blog.sqlauthority.com/feed/

RSS of all the Comments posted on blog: http://blog.sqlauthority.com/comments/feed/

There are ways you can also subscribe to emails of the blog.

Subscribe to email from Feedburner: http://www.feedburner.com/fb/a/emailverifySubmit?feedId=872428

Subscribe to email from WordPress: (Look for following box in Right Side Nav)

Subscribe to SQLAuthority.com

Subscribe to SQLAuthority.com

Additionally, each post on this blog has subscription available for comments of that post only. At the bottom of each post there is following features which can help you to subscribe to only that post related details.

Post Detail Subscription on SQLAuthority.com

Post Detail Subscription on SQLAuthority.com

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

SQLAuthority News – Converting a Delimited String of Values into Columns

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Server, SQL String, SQL Tips and Tricks, SQLAuthority Website Review, T SQL, Technology, tagged on February 10, 2010 | 2 Comments »

This blog post is about two great bloggers and their excellent series of blog posts. It was quite unusual to see two bloggers posting articles that are supporting each other and constantly improving the articles to the next level.

Two blogs which I am going to mention here are as follows: SELECT Blog FROM Brad.Schulz CROSS APPLY SQL.Server() – Brad Schulz and Demystifying SQL Server – Adam Haines. Before continuing this blog post, I suggest you all to bookmark these blogs for future reference.

The whole thing started when Adam tried to answer the question “How to transform a delimited values into columns?” on MSDN SQL Forum. Adam made the first blog post here http://jahaines.blogspot.com/2009/06/converting-delimited-string-of-values.html and then Brad and Adam bounced a few ideas off the wall. Then, Adam started his series on concatenating column values http://jahaines.blogspot.com/2009/06/concatenating-column-values-part-1.html, and http://jahaines.blogspot.com/2009/07/concatenating-column-values-part-2.html.  In part two of the series, Brad wanted to get a deeper understanding of why the results came out the way they did. Adam then started another series on unpacking or parsing out delimited characters, http://jahaines.blogspot.com/2009/11/splitting-delimited-string-part-1.html and here http://jahaines.blogspot.com/2009/12/splitting-delimited-string-part-2.html.  From here, Brad started digging even deeper into the internals of the XML method. Brad has a comprehensive list of the back and forth on this post, http://bradsruminations.blogspot.com/2009/12/delimited-string-tennis-anyone.html and a final post here http://bradsruminations.blogspot.com/2010/01/delimited-string-tennis-again-final.html.

The final outcome is that both the XML method and number table can perform equally, but the XML method has to be coded in a very particular way; otherwise performance will be horrendous. Also, the permanent number table shows consistently more performance than the inline number table; however, on smaller string sizes, the difference here is that most of the inline number tables require more CPU and RAM, whereas the permanent number table requires more IO. For an average developer, the number table solution is probably the easiest of the solutions to implement.

Overall, I strongly suggest to go through the abovementioned posts; you will love it and become their fan. Please note these posts are very easy to understand and if you know a bit of XML only, you will still be able to understand them very well. The above description has been taken with proper consent of the Adam and Brad.

Hats Off to you Guys! You guys inspire me and many SQL enthusiasts!

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

SQLAuthority News – Microsoft in India – Leadership Profiles

Posted in SQL, SQL Authority, SQL Documentation, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLAuthority Website Review, T SQL, Technology on January 29, 2010 | 1 Comment »

Recently when I have attended SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 I got the chance to attend the keynote by Srini Koppolu Corporate Vice President & Managing Director (Microsoft India Development Center). It was great keynote and very interesting. We all were listening it carefully to the master who developed IDC. While listening him I realize that I do not know other pillars of Microsoft India. Just searching a bit online on MS site I came across following site which has list of all the leaders of the Microsoft India.

I am sure just like me there are many others who wonder about the top leadership of Microsoft India.

I have found following link on MS site where they have listed all the top leaders along with their bio.

MS Leadership

MS Leadership

Microsoft in India » Leadership Profiles

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

« Newer Posts - Older Posts »