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

CLR Stored Procedures - handling security on SQL Server side

SSQA.net — Thu, 24 Jul 2008 08:52:00 GMT

Ok this is not new to say you can write stored procedures in any language to manage them in SQL Server, as 2005 version has started this CLR integration functionality that is exposed in an assembly called system.data.dll, which is part of the .NET Framework...(read more)

Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy - Tech-ed Online Panel video available to view

SSQA.net — Tue, 22 Jul 2008 11:37:00 GMT

In continuation to Tech-ed North America - what I'm doing there? & Say goodbye to Tech-ed 2008 Developers and say hello to IT-PRO! posts here and to wrap up the earlier posts about Tech-ed Online Panel: Leveraging SQL Server Technologies to Build...(read more)

SQL Server Business Intelligence - handling data mining and mission critical applications

SSQA.net — Tue, 22 Jul 2008 09:31:00 GMT

Data, data and data everywhere: a typical scenario for an Enterprise DBA to handle the mission critical applications and comprehensive information across the organization using SQL Server technologies. Since the inception of SQL Server 2005 version Business...(read more)

Ordering Interger values stored in Varchar column

SSQA.net — Mon, 21 Jul 2008 14:21:00 GMT

I have seen many newbies asking "How do I sort the numbers stored in varchar columns?" Here are some methods declare @t table ( data varchar ( 15 )) insert into @t select '6134' union all select '144' union all select '7345'...(read more)

Cumulative Update 8 package for SQL Server 2005 Service Pack2

SSQA.net — Wed, 16 Jul 2008 09:50:00 GMT

I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA...(read more)

DTS Packages migration webinar - get tips and tricks from a MVP

SSQA.net — Tue, 15 Jul 2008 15:44:00 GMT

Brian Kinight is well known SQL Server Professional in the community, every user will know about SQL Server Central website which was founded by him. Join Brian to discuss the strategies of upgrading DTS packages to SQL Server Integration Services (SSIS...(read more)

Varchar(max) datatype and Replicate function

SSQA.net — Tue, 15 Jul 2008 13:54:00 GMT

As you know, Replicate function is used to repeat a character expression for a specified number of times. But by default the result is converted to varchar of maximum size 8000 when you dont convert the expression to specific type Consider the following...(read more)

Get ready for SQL Server 2008 RTM release!

SSQA.net — Mon, 14 Jul 2008 14:56:00 GMT

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 is set to RTM'd during the month of August 2008, as per Bob...(read more)

TSQL to get TOP 10 queries that are using I/O generation, SQL Server 2005

SSQA.net — Mon, 14 Jul 2008 10:26:00 GMT

DMVs are most helpful to find instant information on SQL instance without causing further delays, in any performance degradation time you can execute following TSQL to get top 10 queries that are generating lots of I/O on the server: SELECT TOP 10 total_logical_reads...(read more)

Reporting Services 2008 additional features, other than SQL Server Reporting Services 2005

SSQA.net — Fri, 11 Jul 2008 09:38:00 GMT

SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know...(read more)

Analysis Service error: Either the user, Domain\User, does not have access to the Database Name database, or the database does not exist.

SSQA.net — Thu, 10 Jul 2008 08:02:00 GMT

As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the...(read more)

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

SSQA.net — Wed, 09 Jul 2008 08:07:00 GMT

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)

SQLKnowHow - gear up for exclusive training from professionals

SSQA.net — Tue, 08 Jul 2008 13:27:00 GMT

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)

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

SSQA.net — Tue, 08 Jul 2008 11:13:00 GMT

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)

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

SSQA.net — Mon, 07 Jul 2008 07:51:00 GMT

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)

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

SSQA.net — Fri, 04 Jul 2008 08:36:00 GMT

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)

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"

SSQA.net — Thu, 03 Jul 2008 21:46:00 GMT

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)

Internet Database based Services find a suitable service provider

SSQA.net — Wed, 02 Jul 2008 08:31:00 GMT

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)

SQL Server Express - get sample kits in express way

SSQA.net — Mon, 30 Jun 2008 08:30:00 GMT

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)

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

SSQA.net — Fri, 27 Jun 2008 09:10:00 GMT

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)