WHEN: AVAILABLE NOW ON DEMAND SPEAKERS: Stan Gibson, Principal, Stan Gibson Communications Todd Behrbaum, Senior Product Manager for HP PolyServe Software SPONSOR: Hewlett-Packard Company DOWNLOAD PODCAST! ABOUT THE PODCAST: This is the third in a three-part podcast series on the topic of SQL Server...
Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day! The recent release of Windows Server 2008 from Microsoft...
Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the only difference between Active-Passive configuration...
Are you aware whether your Enterprise has legal compliance on Sarbanes-Oxley or HIPAA ? First off what you should know about legal compliance is when it comes to the compliance matter on almost every business person's mind, Sarbanes-Oxley, there's good news and not so good news. The good news...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-15-2008
Filed under: SOX, business continuity, sql server, microsoft, audit, environment, database management, laws, legal, compliance, hippa, data protection
I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall IT costs which is the priority for any Enterprise...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-12-2008
Filed under: sql server, microsoft, security, environment, sa, 2000, 2005, virtual server, vmware, operating system, windows server, benefit, costing
In continuing from the series of Change-Data-Capture tags on this site I have been testing through this CDC feature on my test environment, which has proved fruitful results (to some extent). But the in the real world scenario do you really need to log all such activites? As you may be aware that logging...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-01-2008
Filed under: sql server, users, ctp, environment, cdc, best practice, testing, triggers, new features, audit trial, change data capture, stored procedures
How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes' for all the questions above, in general getting...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-19-2007
Filed under: dashboard, sql server, performance, databases, microsoft, security, blog, environment, best practice, backups, monitoring, baseline, benchmarking, downloads, performance monitoring
Do you have any criteria for your Development Environment within the SQL Server platform? Do you perform end-to-end testing whenever a new hotfix or service pack needs to be applied on the SQL Server? So think about having seperate Database Development environment where it is like to like with Production...
The CTP4 for SQL Server 2008 has been released as a Virtual Image to install directly on your Virtual server installation. This download comes as a pre-configured VHD. This allows you to trial SQL Server 2008 CTP 4 in a virtual environment. You need to download the 4 files for this CTP4, earlier it used...
I was able to install SQL 2008 July CTP as a Virtual Image, tried to test few replication tasks to know what has been changed since last versions. At this time I would like to use the replication scripts from SQL 2000 version to see what it takes, nothing much I believe compared from 2005 to 2008. While...