SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
February 2008 - Posts
New versions new website - I am specific to SQL Server
Published 29 February 8 7:14 AM |
SSQA.net
You all might know this SQL-HomePage would take you to the SQL Server webpages on Microsoft and now with recent launch 2008 wave another new site created specific to SQL Server 2008, which is SQL-Server-2008 . Nothing major difference here as the first...
SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?
Published 29 February 8 4:4 AM |
SSQA.net
Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the...
Microsoft Empower Program - good deal for ISVs
Published 28 February 8 4:11 AM |
SSQA.net
Microsoft has rolled out new program called - Empower Program that will enable the ISVs to receive software, support and additional resources designed to help you lower your development costs, test your software and speed your solution's time-to-market...
Different ways to know structure of a table
Published 28 February 8 2:51 AM |
SSQA.net
You can use one of the following to know the structure of a table 1 Generate SQL Script option from Enterprise Manager/Management Studio 2 select * from information_schema.columns where table_name='table_name' 3 EXEC sp_help 'table_name'...
Dyanmic IT - Launch 2008 its live now - Windows Server , Visual Studio and SQL Server(later in this year) products
Published 28 February 8 12:59 AM |
SSQA.net
Ok its live now, the Launch 2008 with a theme of Dynamic IT and with that link you can experience the Heroes Happen {Here} wave. Steve Ballmer's press room interview View-it-here But I had one doubt, you can see a 'logo' for Windows Server...
Best Practices for Measuring and Managing Today's Complex Messaging Environment
Published 27 February 8 8:26 PM |
SSQA.net
Like SQL Server Data, email is also an important aspect of day-to-day business life, more or less it is a business-critical communication tool, and downtime can be disastrous for your company. As like to the Disaster Recovery for your data, is your email...
SQL Server 2008: Administer multiple servers by designating configuration servers
Published 27 February 8 3:0 AM |
SSQA.net
Ok, they give you new tool and in next release it has been taken away! This is similar to Surface Area Configuration tool from SQL Server 2005 and after 3 years you don't see from next release which is SQL Server 2008. How do you manage or can administer...
Few hours to go for Windows Server, Visual Studio and SQL Server 2008 launch, here is big deal on SQL release date!
Published 27 February 8 2:1 AM |
SSQA.net
I have been following Dan Jones's blog on " Launch_T-1 , Launch_T-3 & Launch_T-5 " series about SQL Server Launch in US (PST), as a Development Program Manager they have huge task ahead to complete and its not that easy to manage as...
BI Virtual labs on MSDN - specific to data mining and top 10 classed in Tech-ed.
Published 26 February 8 4:45 AM |
SSQA.net
As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual...
SQL Server 2005 error while importing images using ASP page: “ASP Error ‘ASP 0104: 80004005′”
Published 26 February 8 2:33 AM |
SSQA.net
One of the web application user complained about the above error during the upload process of images to SQL Server database! Most of the web applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the...
Developer Day Scotland - how does voting process work for sessions!
Published 25 February 8 4:16 PM |
SSQA.net
In continuation with DeveloperDay scotland on Colin has blogged about How does the voting work for Developer Day Scotland , its interesting and fair!...( read more ) Read More...
SQL Server 2008 BI enahncements - what you want is what you get!
Published 25 February 8 2:49 PM |
SSQA.net
So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped...
SQL Server 2008 February CTP - report a bug and get a chance to win XBOX!
Published 25 February 8 2:20 AM |
SSQA.net
I feel this type of contest by Microsoft will make this (2008) SQL Server release as a best release as more and more users will be interested to j oin the SQL Server 2008 February CTP Bug Bash Contest that will gain chance to win XBOX. These are the OfficialRules...
SQL Server 2008 Resource Governor FAQ
Published 25 February 8 1:36 AM |
SSQA.net
Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and...
SQL Server 2005 - specific roles for replication agents
Published 22 February 8 2:10 PM |
SSQA.net
Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each...
SQLBits conference on01st March 2008 - 1 week to go
Published 22 February 8 2:0 AM |
SSQA.net
In continuing from the post of SQLBits II now the sessions are available on SQLBITS site for your voting. Don't forget to register and cast your vote to be in touch with SQL Server knowledge. Here is the incentive from SQLBITS as the next Free community...
Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
Published 21 February 8 6:22 AM |
SSQA.net
The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...
What's new, rather removed features from SQL Server 2008 (CTP6)
Published 21 February 8 2:11 AM |
SSQA.net
It has been a 'very busy' month sofar, in particular to Microsoft world and sub-domains of Windows Server, Virtual Server & SQL Server and you know why from here. Not a 'real' launch for SQL Server folks out there, but a concession...
SQL Server 2008 February CTP, is availble to download now!
Published 20 February 8 5:37 AM |
SSQA.net
Continuing from this SQL2008CTP blog post it seems there is a confusion on the SQL 2008 CTP downloads page The technet link 851664 refers that Evaluate Microsoft SQL Server 2008 today page was p ublished: November 12, 2007 and further after registering...
SQL Server license with multi-core CPU technology, confusing concepts?
Published 20 February 8 2:47 AM |
SSQA.net
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology...
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
September 2008 (9)
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)
News
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go