Browse by Tags

Webcast: 24 Hours of SQL Server 2008: Ensuring Your Data Is Secure with a Trusted Platform

Published 28 March 8 6:45 PM | SSQA.net

Another part of Technet webcast series on SQL Server 2008. In this part a focus on IT professionals and the SQL Server 2008 the Trusted Platform. In the first part of the series we spent time looking at how Contoso was using SQL Server 2008 as a productivity...

Filed under: business continuity, sql server, high availability, technet, security, 2008, trusted platform, data loss, data platform

Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

Published 16 November 7 4:53 AM | SSQA.net

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...

Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins

What you can do to prevent data leakage and get tips on encryption and other forms of protection against data leakage.

Published 20 September 7 12:14 PM | SSQA.net

Today, security professionals need to be aware that data can escape their organizations via many endpoints, including USB devices and laptops. But what some need to be aware of is that critical data is leaking out via less obvious places such as smartphones...

Filed under: webcast, high availability, security, download, podcast, community, events

Database Mirroring: Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

Published 12 September 7 4:56 AM | SSQA.net

The above error is quite common within the database mirroring setup, you could get to see. The intial workaround for this error will be to check whether any network issues are causing this error when the failover is intiated from a Primary server to the...

Filed under: sql server, high availability, security, error, database mirroring, service account, 1418, ports

Whats the best way to setup memory on a four-node cluster?

Published 6 September 7 4:42 AM | SSQA.net

Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...

Filed under: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

Published 21 August 7 9:6 AM | SSQA.net

--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState...

Filed under: sql server, high availability, integration, security, ssms, error, surface, not found