Sign in
|
Join
|
Help
MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Home
Blogs
WordPress Blogs
Media
June 2011 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Blogs
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Home
About
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
SQL Server 2012 releases RTM and Evaluation edition, don't missing virtual event launch 07th March 2012
How to keep a track of list of SQL Server versions and builds releases?
Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook
SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!
Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook
Tags
2005
2008
best practice
best practices
community
conference
database
databases
dba
dmv
download
error
indexes
kba
memory
microsoft
monitoring
performance
query
security
sql server
ssis
ssms
tsql
T-SQL
View more
News
Archives
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
March 2012 (1)
January 2012 (6)
December 2011 (2)
November 2011 (6)
October 2011 (7)
September 2011 (3)
August 2011 (9)
July 2011 (4)
June 2011 (8)
May 2011 (8)
April 2011 (2)
March 2011 (8)
February 2011 (5)
January 2011 (11)
December 2010 (18)
November 2010 (9)
October 2010 (10)
September 2010 (24)
August 2010 (11)
July 2010 (30)
June 2010 (19)
May 2010 (3)
April 2010 (11)
March 2010 (6)
February 2010 (5)
January 2010 (11)
December 2009 (4)
November 2009 (3)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Sort by:
Most Recent
|
Most Viewed
|
Most Commented
Getting started with SQL Azure
For the last 8 months I have been busy in working out on my first book titled: Microsoft SQL Server 2008 R2 Administration cookbook and by god it is a long time to catch up with the latest trends and technologies in IT world. In specific to SQL Server...
Published
Wed, Jun 22 2011 4:42
by
SqlServer-Qa.net
Filed under:
sql server
,
services
,
download
,
samples
,
sql azure
,
database manager
,
training kit
,
examples
SQL Server Manageability Series: upgrade of client tools and error: The File %CommonDir%\dte80.olb could not be loaded #sql #ssms #sqltools
For all my consulting tasks I prefer to use SQL Server 2008 R2 Management Studio provided the involved instances are on version 2005 or higher. Recently I bought a new laptop and in process get all necessary tools installed so that I can make use of this...
Published
Tue, Jun 21 2011 5:46
by
SqlServer-Qa.net
Filed under:
sql server
,
ssms
,
tools
,
BOL
,
management studio
,
file search
,
installallation
,
code examples
,
system32
How to become a SQL Server DBA?
Its a good question and I get to asked many times by the people who I meet and greet in Usergroup & Conference meetings. There is no clear or consice answer for this question, as it requires lot of patience and dedication to learn the concepts of...
Published
Wed, Jun 15 2011 11:03
by
SqlServer-Qa.net
Filed under:
sql server
,
dba
,
learning
,
conference
,
concepts
,
cookbook
SQL Server Manageability Series: how to change the default path of .cache files of a data collector? #sql #mdw #dba
How to change the default path of .cache files of a data collector after the Management Data Warehouse (MDW has been setup? This was the question asked by one of the DBAs in a client's place, instantly I enquired that were there any folder specified...
Published
Wed, Jun 15 2011 6:24
by
SqlServer-Qa.net
Filed under:
sql server
,
dba
,
access
,
best practices
,
temp
,
data files
,
cache reports
,
management data warehouse
,
mdw
,
data collector
,
cookbook
Data Warehousing 2.0 and SQL Server: Architecture and Vision
As Data warehouses mature over time, the emphasis shifts from making data available to consumers to the production of data. Let’s look more closely at the data warehouse, beginning with an overview of its components. A data warehouse has a long life span...
Published
Mon, Jun 13 2011 10:23
by
SqlServer-Qa.net
Filed under:
sql server
,
performance
,
dba
,
etl
,
data warehouse
,
data center
,
parallel processing
,
pdw
SQL Server BI Performance series: managing CUBE performance issues
What kind of performance issues you will need to face when you are setting/managing a Business Intelligence environment involving SQL Server technologies. I see this more as a practical question than to answer about the technology. When we talk about...
Published
Mon, Jun 13 2011 2:26
by
SqlServer-Qa.net
Filed under:
sql server
,
ssis
,
ssas
,
ssrs
,
dba
,
query
,
best practices
,
business intelligence
,
benchmarking
,
ebook
,
parallel processing
SQL Server 2008 R2 Update for Developers Training Kit (May 2011 Update) #sql #sqltraining #dba #developer
The training kits are highly useful for any user to know more about the product or technology, in this regard the May 2011 update for SQL Server 2008 R2 Developers training kit consist updates to SQL Server 2008 and SQL Server 2008 R2 in addition to Office...
Published
Wed, Jun 8 2011 8:30
by
SqlServer-Qa.net
Filed under:
sql server
,
developer
,
community
,
codeplex
,
conference
,
training
,
demos
SQL Server Performance series: TEMPDB.. monitoring and troubleshooting practices #sql #sqlperf #tempdb
The global resource for a SQL Server system is TEMPDB, because it holds all the information pertaining to temporary user objects, internal objects used by SQL engine, row versioning for data modifications and any ad hoc TSQL execution results. Since SQL...
Published
Wed, Jun 8 2011 2:01
by
SqlServer-Qa.net
Filed under:
sql server
,
perfmon
,
performance
,
dba
,
best practices
,
table
,
troubleshoot
,
tempdb
,
monitoring
,
benchmarking
,
performance monitoring
,
counters
Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.
zines:andrewbelon.com