SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
January 2008 - Posts
Disruption to the internet due to damage in undersea
Published 31 January 8 5:34 AM |
SSQA.net
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...
SYSMON (PERFMON) counters that will help you to resolve SQL Server Integration Services issue
Published 31 January 8 3:45 AM |
SSQA.net
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...
Real-time replication with SQL Server reporting, strategies and resolution to the problems?
Published 30 January 8 12:23 PM |
SSQA.net
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...
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
Published 30 January 8 9:31 AM |
SSQA.net
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...
You can pre-order the Kalen Delaney SQL Server Internals Course on DVD
Published 30 January 8 8:52 AM |
SSQA.net
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...
Great loss to SQL Server community specially!!
Published 30 January 8 5:43 AM |
SSQA.net
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...
How SQL Server manages when a database is created in terms of I/O and disk usage?
Published 29 January 8 5:46 AM |
SSQA.net
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...
SQL Server Analysis Services MDX Query performance monitoring - highlights
Published 29 January 8 3:27 AM |
SSQA.net
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...
Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?
Published 29 January 8 1:36 AM |
SSQA.net
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...
The frustration of sweeping generalizations - follow on from Search Engine Q&A #12
Published 28 January 8 11:35 PM |
SSQA.net
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...
Search Engine Q&A #12: Should you create multiple files for a user DB on a multi-core box?
Published 28 January 8 8:10 PM |
SSQA.net
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...
Best way to deploy SQL Server 2005 with SAN
Published 28 January 8 2:1 AM |
SSQA.net
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...
SQL Server Analysis Services slicing and dicing
Published 27 January 8 6:8 AM |
SSQA.net
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...
Security best practices - personally & technically
Published 26 January 8 8:12 AM |
SSQA.net
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...
SQL Server 2005 Best Practices Analyzer January 2008 update
Published 25 January 8 4:8 AM |
SSQA.net
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...
SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
Published 25 January 8 3:41 AM |
SSQA.net
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...
How to use TSQL to find the size of total and free physical memory within the SQL Server?
Published 24 January 8 4:28 PM |
SSQA.net
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...
MVP Global Summit 2008
Published 24 January 8 1:49 PM |
SSQA.net
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...
SQL Server 2005 schema integration changes and use of best practices - use of Schema Qualified Tables/Views
Published 24 January 8 7:19 AM |
SSQA.net
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...
Learning resources for SQL Server 2008
Published 23 January 8 8:28 AM |
SSQA.net
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...
More Posts
Next page »
Search
Go
This Blog
Home
Contact
About
Tags
2005
2008
best practice
best practices
blogs
database
databases
dmv
download
error
high availability
indexes
kba
microsoft
performance
query
replication
reporting services
security
server
sql server
ssis
ssms
tsql
webcast
Community
Home
Blogs
Media
Groups
Archives
August 2008 (30)
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)
News
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go