Browse by Tags

IDERA: Download the free public beta new SQL admin toolset, with a feedback you could gain a chance to win a Wii
13 May 08 09:10 AM | SSQA.net

We have 6 winners and 4 more to go! Download the free public beta of our new SQL admin toolset, let us know what you think and you could win a Wii™! Two ways to win: 1) Download SQL admin toolset to enter 2) Refer your friends for extra entries to win...

Filed under: sql server, download, feedback, idera, toolset, multi-script, winner

SQL Server Reporting Services: Resources and information - all in one place
13 May 08 03:30 AM | SSQA.net

During a conference few users asked about resources and information to go through the Reporting Services, as it is a general assumption from the end-user community that referring to Books Online aka BOL doesn't get them anywhere. I always recommend...

Filed under: sql server, performance, reporting services, resources, information, books online, business intelligence, troubleshooting

SSWUG.ORG - SQL Server Virtual Conference II
13 May 08 02:31 AM | SSQA.net

What are the Top 16 things to know about SQL Server? Here are a couple MORE from our series of 16 specific tips ( you can even still watch the previous release of tips too! )... Do you keep getting advanced level SQL Server information when you could...

Filed under: sql server, ssms, chat, conference, experts, virtual event, problems

Most popular blog posts since we started blogs here: sqlserver-qa.net
12 May 08 04:30 PM | SSQA.net

Post Subject Post Views Msg 18456, Level 14, State 1, Server <ServerName>, Line 1 Login failed for user '<Name>' 4,845 SQL Server 2005 & 2000 - Index optimization best practices 4,425 SQL Server 2005 - Ad hoc updates to system...

Filed under: sql server, blogs, popular

A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000
12 May 08 01:43 PM | 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 and Major Modifications A query that references a nondeterministic...

Filed under: sql server, performance, query, kba, 2000, 2005, slow

SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?
12 May 08 04:25 AM | SSQA.net

Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...

Filed under: sql server, databases, best practices, database mirroring, 2005, principal, witness, mirror, timeout

SQL Server 2005 detect DAC session with TSQL
09 May 08 01:11 PM | SSQA.net

SQL Server 2005 has introduce a secret-door for Admins to identify and resolve any connect lockout issues within your database instance, as on http://sqlserver-qa.net/blogs/tools/archive/2007/08/04/dedicated-administrator-console-dac-saved-an-important...

Filed under: sql server, security, dmv, tsql, dac, session

SQL Server 2008 and simplified scripting through PowerShell
09 May 08 04:45 AM | SSQA.net

Have you ever seen or used the PowerShell? If so have you worked on PowerShell within SQL Server 2008, it has 2 kinds of snap-ins that are called as Powershell Provider and set of Cmdlets. The provider will enables the simple navigation mechanism similar...

Filed under: sql server, download, documentation, ctp, new features, windows server, scripting, powershell

New and Modified Knowledge Base article for SQL Server 2005 Reporting Services
08 May 08 03:31 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server...

Filed under: sql server, report builder, kba, object, .NET, reporting services, sap, business intelligence, character, data provider, null, parentNode

SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?
08 May 08 03:42 AM | SSQA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

FIX: Error message when you use the BULK INSERT statement to import data of the timestamp data type in SQL Server 2005: "An invalid datetime value was encountered"
07 May 08 03:28 PM | 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 and Major Modifications FIX: Error message when you use the BULK...

Filed under: sql server, error, kba, bulk insert, data type, timestamp

SQL Server Release Services - Cumulative Update or frequent Service pack releases, which one you favour?
07 May 08 03:26 AM | SSQA.net

Here is the hot news, SQL Server Global Release Services (GRS) has revised their schedule of releasing Service Packs for SQL Server product by stating ' changed approach to Service Packs '. Now the big question how far you can stretch in deploying...

Filed under: sql server, microsoft, high availability, best practices, service pack, cumulative update, releases

More Posts Next page »