Welcome to SqlServer-QA.net Sign in | Join | Help

Business Continuity (SSQA.net)

Business continuity & Contingency planning - essential and unavoidable tasks.

March 2007 - Posts

Disaster Recovery & Business Continuity for SQL Servers Through a Standby Approach
Sonasoft automates the disk-to-disk backup and recovery process for the Microsoft applications such as Exchange, SQL server & Windows servers. A centralized management of multiple servers and provide the cost effective turnkey Disaster Recovery strategy Read More...
My SQL Server security best practices whitepaper is available
For folks that have been asking...my latest whitepaper " SQL Server 2005 Security Best Practices - Operational and Administrative Tasks " was posted on the Technet website this week. It also covers the nuances of security when using SQL Server SP2 and Read More...
A bonus talk for Belgian SQL Server user group next week
Next week (28-29 Mar) I'll be doing some talks on SQL Server 2005 and ADO.NET vNext at DevDays Belgium in Ghent. On 28 Mar, I'll also be doing a special additional talk on SQL Server 2005 Event Notifications (including a cross-database notification demo) Read More...
Why Service Level Agreement (SLA) important to Business Continuity?
Why Service Level Agreement (SLA) important to Business Continuity? Do you know why SLAs are important? Do you know your SLAs? Do you think you can meet your SLAs? The answer is here and you will learn more from there. Read More...
NeverFail for Disaster Recovery & High Availability
High Availability & Business Continuity has been my favourite subject since last 5 years, I don't know why but the time is changing as other environments are changing too in IT world. Being a DBA too by profession backup is main arch to keepup the Read More...
Client Side Attacks: Your Weakest Security Link
Attend this Webcast and discover how to: Effectively assess how vulnerable your information assets are to spear phishing attacks targeted at end users Ensure that Outlook, Internet Explorer and other applications do not can provide an attacker an easy Read More...
SQL Server 2005 Best Practices Analyzer CTP
SQL Server 2005 Best Practices Analyzer CTP Its a great news for every DBA on SQL Server 2005 ranch that Microsoft SQL Dev.(Performance) team has released the a preview of Best Practices Analyzer for SQL Server 2005 version, which is in CTP mode at present Read More...
A White Paper on "Cannot Delete File: Cannot Read from the Source File or Disk"
A White Paper on "Cannot Delete File: Cannot Read from the Source File or Disk" Recently I have been looking for information on few issues when deleting (backup) files and had issues with errors stating "Cannot Delete File: Cannot Read from the Source Read More...
What is your way (easy) to upgrade from previous versions?
SQL Server 2005 is more than year old now and most of the organizations are preparing to upgrade from the previous version as the Service Pack 2 is out now. When you talk about upgrade practices then it is not that easy to perform without any problems. Read More...
Two things you can't do in SQLCLR
Since SQL Server 2005 was introduced with .NET programming support, folks have been trying to push the boundaries of what can be used in SQLCLR or at least trying to determine where those boundaries are. Here's two things that, as far as I know, can't Read More...
SQL Server or MSDE support on Vista/Longhorn?
As expected recently Microsoft announced that Windows Vista and Lonhorn are supported by SQL Server 2005 Express Edition Service Pack 1 (SP1), and for all other editions will be supported by SQL Server 2005 Service Pack 2 (SP2) or later when it becomes Read More...
Need a backup strategy, Enterprise and Home user!
This is a question for all Database Administrators & System Administrators in any Enterprise that, so you’ve decided to backup your data but what is the next step? The answer will be yest 'we have a backup schedule in place' and in addition to that Read More...
RAID Server Failures And Data Loss Issues!
Recently we had this discussion about what will be situation when there will be a RAID server failure and chances of data loss issue. The common cause for this issue might be a RAID controller failure or configuration changed, Two or more hard drives Read More...
Effective Usage of SQL Server 2005 Database Mirroring by SSQA in SQL Server Open World
WOW, I was on high-five mood this morning after getting a good feedback for my presentation in SQL Server Open World conference (March 08th to 10th 2007) in Copenhagen. High Availability and Business Continuity is my ranch and will be concentrating more Read More...
How Simple Steps Ensure Database Security?
Listen to this Podcast and discover: Simple steps to follow to ensure your database is completely secure What you need to consider when protecting information stored on your company's database How to defend your database against sophisticated security Read More...
Using stored procedures with EDM ObjectServices in the March CTP (with code)
One thing that I thought was particularly interesting in the Orcas Mar CTP was support for stored procedures. This support exists in LINQ to SQL and EDM ObjectServices; I thought I'd start with ObjectServices. There almost no documentation on this topic Read More...