Sign in
|
Help
MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Home
Blogs
Media
January 2008 - 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
Windows Azure platform and SQL Server 2008 R2 feature complete CTP is available for download
SQL Server 2008 features that work only in Enterprise Edition
SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!
I am a forum spammer! Delete my account immediately!!
SQL Server upgrade practices - choose optimal upgrade options
Tags
2005
2008
best practice
best practices
community
conference
database
databases
dba
dmv
download
error
indexes
kba
microsoft
performance
query
replication
security
sql server
ssis
ssms
tsql
T-SQL
webcast
View more
News
Archives
November 2009 (2)
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
November 2009 (2)
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
November 2009 (2)
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
November 2009 (2)
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
November 2009 (2)
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
November 2009 (2)
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
November 2009 (2)
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
November 2009 (2)
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
November 2009 (2)
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
November 2009 (2)
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
Disruption to the internet due to damage in undersea
Can you sustain a disruption to your Internet service? I cannot, when I have tried to call one of the mobile service provider got this message that "Severed cables disrupt internet"?? Eventually I found that Internet services have been disrupted...
Published
Thu, Jan 31 2008 5:34
by
SSQA.net
Filed under:
business continuity
,
sql server
,
integration
,
best practices
,
disaster recovery
,
internet
,
high avialability
,
indian
SYSMON (PERFMON) counters that will help you to resolve SQL Server Integration Services issue
As you are aware that SYSMON (PERFMON) provides very useful counters to analyze the system performance or to schedule a historical growth of your system usage. From the changes (upgrade) to the Operating System and SQL Server we now have new set of SQL...
Published
Thu, Jan 31 2008 3:45
by
SSQA.net
Filed under:
sql server
,
performance
,
ssis
,
users
,
best practices
,
sysmon
,
perflib
,
data flow
,
integration services
Real-time replication with SQL Server reporting, strategies and resolution to the problems?
Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that...
Published
Wed, Jan 30 2008 12:23
by
SSQA.net
Filed under:
sql server
,
microsoft
,
data
,
integration
,
security
,
download
,
replication
,
reporting services
,
magazine
,
windows it pro
You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services or in SQL Server 2008 Reporting Services after you upgrade Windows Server 2003 to Windows Server 2008
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete You encounter a problem with a subscription that uses the file share delivery...
Published
Wed, Jan 30 2008 9:31
by
SSQA.net
Filed under:
sql server
,
upgrade
,
report builder
,
kba
,
2008
,
reporting services
,
windows 2003
You can pre-order the Kalen Delaney SQL Server Internals Course on DVD
Great news to all SQL Server users! The DVD - Kalen Delaney SQL Server Internals course (part1) is almost ready and you can pre-order a copy right now! This is our first in what we hope to be will be an entire series of outstanding SQL Server training...
Published
Wed, Jan 30 2008 8:52
by
SSQA.net
Filed under:
sql server
,
integration
,
tuning
,
kalen delaney
,
tutorial
,
training
,
dvd
,
friends
,
lessons
Great loss to SQL Server community specially!!
Its a sad news to hear about Ken Henderson all of the SQL Server users will remember his invaluable contributions & knowledge and our condolences to his family... If god grants me one wish ............then I ask to rollback that transaction...( read...
Published
Wed, Jan 30 2008 5:43
by
SSQA.net
Filed under:
sql server
,
microsoft
,
expert
,
bad news
How SQL Server manages when a database is created in terms of I/O and disk usage?
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that...
Published
Tue, Jan 29 2008 5:46
by
SSQA.net
Filed under:
sql server
,
performance
,
management
,
indexes
,
windows
,
i/o
,
sysmon
,
disk space
,
usage
,
resource
,
perflib
,
worker threads
,
task manager
SQL Server Analysis Services MDX Query performance monitoring - highlights
When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve...
Published
Tue, Jan 29 2008 3:27
by
SSQA.net
Filed under:
sql server
,
performance
,
mdx
,
query
,
best practices
,
tsql
,
monitoring
,
Analysis Services
,
baseline
,
benchmarking
Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?
The newest ranch of Security - trust worthy features in SQL Server 2005 usage of symmetric keys has an important role. Always the document suggests to use Windows Authentication of security purpose and better control of user/security management, but when...
Published
Tue, Jan 29 2008 1:36
by
SSQA.net
Filed under:
application
,
sql server
,
security
,
best practice
,
sql authentication
,
sa password
,
symmettric keys
,
store
,
windows authentication
The frustration of sweeping generalizations - follow on from Search Engine Q&A #12
A bit more traffic on the thread (see previous post here ) prompted me to give my thoughts on the many sweeping generalizations that plague the computer industry and make it difficult sometimes to give advice in forums and blogs. I'd like to repost...
Published
Mon, Jan 28 2008 23:35
by
SSQA.net
Filed under:
performance
,
Search Engine Q and A
,
General
Search Engine Q&A #12: Should you create multiple files for a user DB on a multi-core box?
There's been a very interesting discussion going on over at SQLServerCentral.com about whether to create multiple files for a user database because the server has multiple CPUs - see the thread here . I wrote a couple of long responses during the...
Published
Mon, Jan 28 2008 20:10
by
SSQA.net
Filed under:
performance
,
IO Subsystems
,
Search Engine Q and A
Best way to deploy SQL Server 2005 with SAN
If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct...
Published
Mon, Jan 28 2008 2:01
by
SSQA.net
Filed under:
sql server
,
performance
,
tools
,
2005
,
san
,
best practice
,
raid
,
hardware
,
configuration
,
benchmarking
,
downloads
,
iometer
,
deployment
,
sqlio
SQL Server Analysis Services slicing and dicing
I was going through Books Online in learning the concepts of slicing of data within Analysis Services for the new project that is upcoming, all these years I have basic knowledge of SSAS and with latest available features in SQL Server 2005 Analysis Services...
Published
Sun, Jan 27 2008 6:08
by
SSQA.net
Filed under:
sql server
,
performance
,
data mining
,
2005
,
Analysis Services
,
slicing
Security best practices - personally & technically
See this awesome post about how best you can adopt security and beaware about which is right and which is wrong Avoiding the bad guys - detecting potentially malicious advertising campaigns that is applicable on both personal security & techinical...
Published
Sat, Jan 26 2008 8:12
by
SSQA.net
Filed under:
business continuity
,
sql server
,
microsoft
,
blogs
,
integration
,
security
SQL Server 2005 Best Practices Analyzer January 2008 update
Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings...
Published
Fri, Jan 25 2008 4:08
by
SSQA.net
Filed under:
sql server
,
microsoft
,
download
,
best practices
,
2008
,
ctp
,
analyzer
,
2005
,
Analysis Services
,
extent
,
rtm
SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...
Published
Fri, Jan 25 2008 3:41
by
SSQA.net
Filed under:
sql server
,
performance
,
indexes
,
cache
,
users
,
tsql
,
best practice
,
backups
,
create
,
online
,
monitoring
,
operating system
,
busy
,
creation
How to use TSQL to find the size of total and free physical memory within the SQL Server?
Recently I have to search for the information on the total size of free physical memory on the SQL Server which is causing lots of performance issues, when reported to CSS they have supplied the following TSQL to get more information in this regard: With...
Published
Thu, Jan 24 2008 16:28
by
SSQA.net
Filed under:
sql server
,
performance
,
memory
,
microsoft
,
dump
,
physical
,
tsql
,
select
,
css
,
size
MVP Global Summit 2008
As per the plans MVP global summit 2008 registration is open for the MVPs and Regional Directors, this is a good event to meet fellow professionals in Microsoft's backyard in Seattle. Looking forward to meet and discuss more about SQL Server 2008...
Published
Thu, Jan 24 2008 13:49
by
SSQA.net
Filed under:
sql server
,
microsoft
,
mvp
,
seattle
,
global summit
SQL Server 2005 schema integration changes and use of best practices - use of Schema Qualified Tables/Views
You all know that it is a best practice to use the schema qualified tables or views for the better management and performance (sometimes). As the Best Practices Analyzer tool which will be a part of SQL engine from 2008 version onwards confirms that this...
Published
Thu, Jan 24 2008 7:19
by
SSQA.net
Filed under:
sql server
,
download
,
version
,
best practices
,
2005
,
bpa
,
schemas
,
tablels
,
referential integrity
,
query plans
Learning resources for SQL Server 2008
As January 2008 almost getting finished that means 1 month in 2008 is reduced that brings the date to get RTM for SQL Server 2008. Before that the users (DBAs, Developers & Analysts) must get knowledge in making best use of SQL Server 2008 features...
Published
Wed, Jan 23 2008 8:28
by
SSQA.net
Filed under:
sql server
,
microsoft
,
community
,
2008
,
virtual
,
labs
,
2005
,
best practice
,
free
,
learning
1
2
3
4
Next >
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