SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Microsoft Security Bulletin Summary for July 2008 - what is it now?

2008-07-09T08:07:00Z

I believe it has been a while that we have seen the security hotfix from Microsoft Security team on SQL Server (alone). The latest security bulletin has announced important security patches that are related to SQL Server in addition to Windows operating Read More......(read more)

SQLKnowHow - gear up for exclusive training from professionals

2008-07-08T13:27:00Z

SQLKnowHow is the new organisation that is focused on training services based on SQL Server. In this regard they have lined up very interesting list of events in coming months, it will be a great time for the SQL Server Users in United Kingdom to grab Read More......(read more)

Quick and simple way to know the stored procedures parameters using TSQL

2008-07-08T11:13:00Z

As you may be aware that you can pass parameters to the stored procedure when you have the selection of data requirement such as stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Using INFORMATION_SCHEMA Read More......(read more)

SQL Server Technical Rollup July 2008 - Important & Interested links for you

2008-07-07T07:51:00Z

As you may be aware all the Technical information roll-up on MSDN & Technet is sent out in email format, in this regard I wanted to share the important and interested links for you on SQL Server arena. Downloads Source Code Analyzer for SQL Injection Read More......(read more)

SQL Server 2005 - How to compare content of tables without using third party tools?

2008-07-04T08:36:00Z

You may be aware about using Third party tools to compare the data between 2 tables. Using SQL Server 2005 you need not entirely dependant on such requirement, TABLEDIFF utility is the new addition to the SQL Server. This utility enables you to compare Read More......(read more)

FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique clustered index on a SQL Server 2005-based computer: "Msg 2511"

2008-07-03T21:46:00Z

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 after Read More......(read more)

Internet Database based Services find a suitable service provider

2008-07-02T08:31:00Z

When you have your business activities on the Internet then you have a major requirement to provide Business Continuity in finding the suitable/sustainable service provider. So I believe there are few key factors you need to consider such as the location Read More......(read more)

SQL Server Express - get sample kits in express way

2008-06-30T08:30:00Z

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 Read More......(read more)

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

2008-06-27T09:10:00Z

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 Read More......(read more)

Unable to install SQL Server 2008 RC0 Books Online

2008-06-26T09:54:00Z

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 Read More......(read more)

SQL Server 2008 new features highlights - a short video samples

2008-06-25T18:06:00Z

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 Read More......(read more)

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"

2008-06-24T13:33:00Z

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 Read More......(read more)

SQL Server 2008 RC0 and 3.5 Compact edition Books Online - download and update your copy

2008-06-24T13:03:00Z

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 Read More......(read more)

Error: SQL Server not found or Access Denied, General network errors & Timeout expired: Find the root cause with a trace?

2008-06-24T08:02:00Z

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 Read More......(read more)

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"

2008-06-24T01:30:00Z

SQL Server 2008 - Performance Studio

2008-06-20T16:50:00Z

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 Read More......(read more)

SQL Server Data Services - what's new, basics and dig deeper

2008-06-20T07:27:00Z

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 Read More......(read more)

Tech-Ed IT Professional 2008 - Europe in Barcelona, open for registration

2008-06-19T23:32:00Z

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 Read More......(read more)

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.

2008-06-19T08:01:00Z

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 Read More......(read more)

SQL Server: PERFMON counters to identify server utilization data

2008-06-18T12:21:00Z

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 Read More......(read more)