June 2008 - Posts

SQL Server Express - get sample kits in express way
Published 30 June 8 3:30 AM | SSQA.net
For every new user in SQL Server world and experienced users to get used to newer version of SQL Server, having sample kit will definetly help out. In this scenario I often get emails asking about any samples or documentation (procedures) to get more...
Filed under: , , , , ,
You receive a "Creating the partitioned snapshot" message when you create a pull subscription that is configured to receive the precomputed partition of a merge publication in SQL Server 2005
Published 27 June 8 4:10 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New You receive a "Creating the partitioned snapshot" message...
Filed under: , , , ,
Unable to install SQL Server 2008 RC0 Books Online
Published 26 June 8 4:54 AM | SSQA.net
In continuation with the BOL update topic on SQL2008-RC0_BOL post here I have had troubles in installing the RC0 Books Online on to my laptop. As per the error below I thought it may be problem with the Windows Installer service on my laptop (Vista Ultimate...
Filed under: , , , , ,
SQL Server 2008 new features highlights - a short video samples
Published 25 June 8 1:6 PM | SSQA.net
I'm sure that by now you are aware about the list of new features within SQL Server 2008 and recently I have had couple of emails from newbie DBA/users in SQL Server asking about any reference they can get on these new features, with a video. In this...
Filed under: , , , , ,
FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: "A stack overflow occurred in the server while compiling the query"
Published 24 June 8 8:33 AM | SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New FIX: Error message when you run a long stored procedure that is encrypted...
Filed under: , , , , , ,
SQL Server 2008 RC0 and 3.5 Compact edition Books Online - download and update your copy
Published 24 June 8 8:3 AM | SSQA.net
As in continuation with the latest release of SQL Server 2008 that is Release Candidate , I strongly recommend you update your local copies of SQL Server Books ONline aka BOL. Here is the link to download the latest copy of SQL Server 2008 RC0 BOL - Link_to...
Filed under: , , ,
Error: SQL Server not found or Access Denied, General network errors & Timeout expired: Find the root cause with a trace?
Published 24 June 8 3:2 AM | SSQA.net
The following error is a frequent-faced issue by any SQL Server user : SQL Server is unavailable or does not exist or SQL Server does not exist or access denied In this regard we have already relevant post PotentialCauses_Resolution here, but still I...
Filed under: , , , , , ,
FIX: Error message when you run a DELETE statement from a table that contains a nonclustered primary key in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"
Published 23 June 8 8:30 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New FIX: Error message when...
Filed under: , , , , , , ,
SQL Server 2008 - Performance Studio
Published 20 June 8 11:50 AM | SSQA.net
I've been looking at this new feature of SQL Server 2008 in order to demo it to customers, and I have to say it's pretty cool ! Along with Resource Governor and compression, it's one of my favourite new features and a good reason to consider...
Filed under: , , ,
SQL Server Data Services - what's new, basics and dig deeper
Published 20 June 8 2:27 AM | SSQA.net
In continuation to my post about best learnings in Tech-Ed conference on SQL Server Data Services (SSDS), I'm kind of more interested to know about this new 'cloud based' data management solution for the Data Platform. So the first question...
Filed under: , , , , ,
Tech-Ed IT Professional 2008 - Europe in Barcelona, open for registration
Published 19 June 8 6:32 PM | SSQA.net
TechEd IT Professionals 2008, 3-7 November, Barcelona is now open for registration. It's the Microsoft premier technical education conference with five days of deep dive technical training, information and community resources. As a reminder, the Super...
Filed under: , , ,
SQL Server 2005 xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
Published 19 June 8 3:1 AM | SSQA.net
Usage of SQL Mail is quite common within SQL Server environment, recently I have involved at one of the client's site with the error: Msg 17930, Level 16, State 1, Line 0 xp_sendmail: Either there is no default mail client or the current mail client...
Filed under: , , , , , ,
SQL Server: PERFMON counters to identify server utilization data
Published 18 June 8 7:21 AM | SSQA.net
Recently I have been involved to carry over an assesment of server utilization on the SQL estate farm (nearly 150+) instances, as it stands it is not an easy job to obtain the results when you have no influence on accessing required information on a shared...
Filed under: , , , , ,
Webcast: The Key to Enforcing Compliance and Standardization: Policies
Published 17 June 8 4:53 AM | SSQA.net
Free webcast is convened by IDERA Wednesday, June 25, 2008 .. | .. 11:00 AM CST | .. 12:00 PM EST "The Key to Enforcing Compliance and Standardization: Policies" While managing complex database environments, one of the most challenging objectives...
Filed under: , , , , , , ,
SQL Server Data Services - get to know more about it!
Published 17 June 8 3:2 AM | SSQA.net
One of the best learning during Tech-Ed week was to know about SQL Server Data Services which might be suitable for the web-based platforms, type of what we have and 2 interesting features for me were 'Business ready SLA & Application Agility'...
Filed under: , , , , , ,
Indexing Strategies
Published 17 June 8 2:2 AM | SSQA.net
I attended a SQL Server User Group meeting earlier this year and heard a presentation about favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have been involved in performance...
Filed under: , ,
List of Technology User Groups within United Kingdom
Published 16 June 8 5:39 PM | SSQA.net
During a recent discussion within a local User Group I have been asked with the above question that where can I get list of User Group information for Microsoft Technologies. Please find the following list of Usergroups that are convened within geographical...
Filed under: , , , , , ,
SQL Server 2005 or 2008: SQL Native Client or MDAC - which is best one to use?
Published 16 June 8 3:53 AM | SSQA.net
SQL Native client or MDAC - which is best one to use? This was the question I was asked during my presence at DAT booth at the Tech-Ed ITPRO conference in Orlando. The sensible answer will be 'it depends'. Practically I have seen that there are...
Filed under: , , , , , ,
KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues
Published 12 June 8 10:2 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New SQL Server 2005 installers...
Filed under: , , , , , ,
SQL Server 2005 Performance Dashboard
Published 12 June 8 6:25 AM | SSQA.net
I've had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I've created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers...
Filed under: , , ,
More Posts Next page »