SQL SERVER – SQL Server Desktop Screen Background

Buck Woody (MSFT) has published a blog post about SQL Server Desktop Screen Background. I really like the SQL Server Desktop background and I have replaced that background on my work laptop. I came across this particular post because I am regular reader of his blog. Few of the other interesting posts written by him are following.

Who do I talk to in Microsoft about…

Test your Restores, or, a Cautionary Tale

If due to any reason, the original image is moved, you can download the image by clicking on following image as well.

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

About these ads

SQLAuthority News – Big Thinkers – Robert Cain

I am exceedingly impressed and inspired by an on-going series of Big Thinkers by Robert Cain – A SQL Server MVP and a genial, whole-souled person.

Robert Cain and Pinal Dave

Robert Cain and Pinal Dave

On meeting Robert Cain earlier this year at SQL Server MVP Summit in Seattle I asked him a question – Where do you get so many innovative ideas to write on blog and create presentations? He replied, “I do not try to get ideas, my experience inspires me.”

Well, it is true that Robert has more than 10 years of experience as one of the TOP experts in SQL Server. Unlike most of the SQL Server MVPs his knowledge is not limited to SQL Server; he is well versed in ASP.NET and Business Intelligence (BI) as well. What is really inspiring and great about him is that he has maintained his position as a top technology expert and has used his position to help out others through his comments/answers in various forums.

Before I answer the question what is big thinkers and why Robert is a big thinker, let me tell you when did I last come across his blog. I was looking forward to learn about BI and I searched for the same in the search engine. I found the following article of Robert. I right away downloaded it and read it through and through. Instead of reading my experience about this easy-to-follow and crisp article, I would suggest you all to experience it yourself. Download the PDF from Introduction To Data Warehousing and Business Intelligence.

Robert takes personal interest when it comes to advising and playing the role of a mentor to the members of community. He has another very useful presentation available online Careers in SQL Server. Even though you are an experienced user I would still recommend you to go through this PDF to see where you stand in your career and what should be your next step.

As I mentioned earlier, Robert is one of the few experts who can fluently talk on both SQL as well as .NET. He has written a marvelous series on FILESTREAM type and storage of varbinary, which is a complete guide on this subject. I strongly suggest that you give it a look, and I promise that it is an easy read.

I may or may not write another part of this series of Big Thinkers but I salute to a real big thinker Robert Cain!

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

SQLAuthority News – Blog Makeover – New Banner – New Color

Just a month back I had  previously changed my personal homepage and had requested for feedback from my readers here SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested. To my astonishment, I received a huge number of emails. But I received only one comment. This time, I would like to request my readers to leave your comments on my blog instead of emailing it to me. This will allow everyone to know about others feedbacks and the actions I take towards incorporating the feedbacks on my blog.

Let us go over the very first and quite perceptible change.

Banner
The banner has been given a brand new look. Two major renovations have been done. First, I have replaced the previous dull image of mine with a new sharper and brighter image. Also, you all can see more of me now. I have placed a larger photo of mine; the earlier one was quite small. Second major changes that you all must have noticed is the color scheme. From the two-year old luscious green I’ve moved on to the cool blue!

In the past two years, I had changed my banner only once.  However, this time I decided to completely change my banner as well as color. It now appears spick and span. Yet another noteworthy change I have made is in the banner background. Beside my photo, there are two different images; there is a cloud like image on the left side of my image and a simple grid on the right side. Any guess what these two signify? Well, the reason behind this change is to suggest that SQL Server is moving toward cloud grid like computing world.

Color
I have been receiving countless requests from my long list of readers to change my color scheme. I was flooded with suggestions – Facebook Blue, Twitter Blue, Google Blue, MSN Blue, MVP Blue, LinkedIn Blue, to name a few- making the task of choosing extremely difficult. I finally selected a color which is closer to Facebook blue but a little darker. Of all the medications, choosing the color was the most crucial as there was no clear definition as to which shade of blue I should settle on.

Clean up HTML and Sidebar
I have made a number of other new changes such as removing unnecessary icons, images as well some of the flairs. I think now it is uncluttered and usable. Let me have your suggestions on enhancing the side bar.

Search
Search @ SQLAuthority.com now has the same look and feel as the main site. In addition, the search has also improved and now there will be no more delay in getting result. If you like the search do spread the words.

Previous Site

New Site

New Site

Again, please send me your comments about the new design.

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

SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested

I’m pleased to inform you all that I’ve recently launched my personal website. It’s been a long time since I’ve been writing on my blog http://blog.sqlauthority.com, but I’ve been keeping my personal notes at my homepage http://www.pinaldave.com.

I’ve completely rehauled the website to give it the much-needed makeover, right from redesigning the layout to writing fresh content. But, I would be extremely happy to have your feedback so that I can enhance my website further.

I’ve always been a people’s person who believes in sharing his knowledge. Also, I want to see myself growing as an individual and as a professional. This is the reason why I pay a lot of attention to feedback. I hope my readers would provide me with some valuable feedback to make my website even better, which would in turn help me reach out to more people to accomplish my objective of serving my community.

I’ve enumerated below the significant improvements that have been made on my website.

Click on Image to see Latest Webpage

1) Clear Design

Previously, I used to receive a lot of feedback regarding the layout, which was a little confusing. Besides, the page was flooded with links that directed the visitors away from my website, which was certainly a serious concern. In contrast, the new layout contains few but relevant links that would actually benefit my website.. I have even changed the background from light brown to white for more clarity and better readability. Best of all, all the pages will now feature the latest three articles from SQLAuthority.com on left navigation panel.

2) Content
SQLAuthority.com is my key writing platform and I write on it almost every day. Till now, I have written over 900 articles.. Like any normal guy I too have my favorites and frequently used links. Some of my articles are script based and some are theory based. I have categorized them as per my preference and also based on the feedback I have received. The links are listed here.

3) Photos
I have often received comments that my photos are pretty old and I must update it. Probably, my readers got tired looking at my same old pose! So, I have updated the photos page of my website with my latest photographs. In future I will make sure to keep the photos page updated. Visit my photos page.

4) Resume
In my resume, I have added several important information related to my career. I have simplified my resume, and now it only includes relevant details on my current objective. Currently, I am working as an independent consultant and specialist in SQL Server Query Optimization and Database Architecture. You can hire me or my entire crew. I have a team of over 65 talented and qualified developers who can complete your project irrespective of size, complexity or programming language.

5) Social Media
Social Media and Social Networking are hard to separate when we are a part of society. You can follow me on Twitter or join my professional network at LinkedIn.

I am very eager to know your opinion about my new website. Please do send me your feedback.

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

SQL SERVER – Automated Index Defragmentation Script

Index Defragmentation is one of the key processes to significantly improve performance of any database. Index fragments occur when any transaction takes place in database table.  Fragmentation typically happens owing to insert, update and delete transactions. Having said that, fragmented data can produce unnecessary reads thereby reducing performance of heavy fragmented tables.

I have often been asked to share my personal Index Defragmentation Script. Well, I use Automated Index Defragmentation Script created by my friend – a SQL Expert – Michelle Ufford (a.k.a SQLFool). Michelle is a SQL Server Developer, DBA, a humble blogger, and an absolute geek! She is also the President of Eastern Iowa PASS Chapter, known as the I380 Corridor Professional Association of SQL Server. Currently, she is working with large, high volume, high performance SQL Server databases at GoDaddy.com. Her nickname might be SQLFool but honestly speaking, she is one of the best Gurus of SQL.  You can read her  blog here.

Michelle has written an excellent article about Automated Index Defragmentation Script. I recommend this wonderful write-up to all those database developers who are searching for a good solution to improve database performance. Read her article Automated Index Defragmentation Script to equip yourself with better understanding on how to improve database performance.

Here, I would to mention an interesting question taken from the above-mentioned article, which will clearly show how powerful this Automated Index Defragmentation Script is.

How long will this Automated Index Defragmentation Script  take to run?
Well, it depends. I don’t necessarily recommend running it without specifying a database; at least, not unmonitored. You *can* do that, but it could take a while. For example, to run sys.dm_db_index_physical_stats for all databases and tables, totaling 2TB, took me 4.5 hours; that doesn’t even count the actual defrags.

You can download the script from here.

Please feel free to contact Michelle or me if you have any questions and doubts regarding this script.

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

SQLAuthority News – Top 10 Strategic Technologies for 2009

Gartner, Inc. analysts highlighted the top 10 technologies and trends that will be strategic for most organizations. Factors that denote significant impact include a high potential for disruption to IT or the business, the need for a major dollar investment, or the risk of being late to adopt.

The top 10 strategic technologies for 2009 include:

Virtualization. Much of the current buzz is focused on server virtualization, but virtualization in storage and client devices is also moving rapidly.

Cloud Computing. Cloud computing is a style of computing that characterizes a model in which providers deliver a variety of IT-enabled capabilities to consumers

ServersBeyond Blades. Servers are evolving beyond the blade server stage that exists today. This evolution will simplify the provisioning of capacity to meet growing needs.

Web-Oriented Architectures. The Internet is arguably the best example of an agile, interoperable and scalable service-oriented environment in existence.

EnterpriseMashups. Enterprises are now investigating taking mashups from cool Web hobby to enterprise-class systems to augment their models for delivering and managing applications.

Specialized Systems. Appliances have been used to accomplish IT purposes, but only with a few classes of function have appliances prevailed.

Social Software and Social Networking. Social software includes a broad range of technologies, such as social networking, social collaboration, social media and social validation.

Unified Communications. During the next five years, the number of different communications vendors with which a typical organization works with will be reduced by at least 50 percent.

Business Intelligence. Business Intelligence (BI) have a direct positive impact on a company’s business performance, dramatically improving its ability to accomplish its mission by making smarter decisions at every level of the business from corporate strategy to operational processes.

Green IT. Shifting to more efficient products and approaches can allow for more equipment to fit within an energy footprint, or to fit into a previously filled center.

Reference : Pinal Dave (http://blog.sqlauthority.com), Gartner Inc.(Published after receiving permission)

SQLAuthority News – Download SQL Server 2008 System Views Poster – PDF – A Wall Poster

Microsoft has published SQL Server 2008 System Views Poster. This poster should be must have poster for any SQL Server Developer. I have this poster on my wall. If you have extra copy of this postered in print. Do send it to me and I will forward it to developer who are very good but can not afford to get this poster printed in glossy pages.

The Microsoft SQL Server 2008 System Views Map shows the key system views included in SQL Server 2008, and the relationships between them. The map is similar to the Microsoft SQL Server 2005 version and includes updates for the new and updated the Microsoft SQL Server 2008 features such as resource governor, extended events, full-text search, and others.

This is must have poster for every Database Developer and Database Administrator.

[Download is removed as new version of SQL Server is released]

You can find additional popular SQLAuthority Downloads Best SQL Server Downloads List.

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