(Scott Guthrie) I’ve blogged in the past about some of the text editor improvements in VS 2008 that have been made for JavaScript intellisense and CSS style intellisense.
Other News
Sending HTML Mail with Embedded Image in .NET
(Soyuj Kumar) After writing a couple of articles on CLR integration (in SQL Server 2005) technology this one is my first article purely based on .NET. I guess we all are habituated with emails. Sometimes we need to transfer more information in emails so we attach files, presentations, images, etc. a
How to connect Excel to SQL Server 2005 Analysis Services
This article describes how to connect Microsoft Office Excel to Microsoft SQL Server 2005 Analysis Services.
Crosstab Pivot-table Workbench
(Robyn Page and Phil Factor) There comes a time with many Database Developers charged with doing management reports when the process of doing it properly gets very tedious. By ‘doing it properly’, I mean the ‘best practice’ of having to do the basic reporting in SQL and relying on a front-end applic
Spicing-up Oracle on Windows
(Steve Callan) This article covers the use of setting some extra string values in the registry, how to display what the values are set to, and how to work around the missing tool known as oerr.
Using the cost-based optimizer to improve Database 10g performance
(V.J. Jain) One of the many advantages of upgrading to Oracle 10g is that the cost-based optimizer (CBO) has been improved to allow for better performance by using a cost model that accounts for I/O and CPU. This cost model allows the optimizer to choose the best execution plans based on statistics
How to: Partial Restore After Media/Drive Failure
(Sarah Henwood) Recently I had a few questions about how to go about partial restores if you have media failure that affects only specific filegroups, and your database is inaccessible because of the missing file(s). The steps while simple, are not readily apparent in example form in books online.
Getting Started with MySQL Proxy
(Giuseppe Maxia) The launch of MySQL Proxy has caused quite a commotion in the community. And with reason. For feature-hungry people, this is undeniably the most exciting addition to MySQL set of tools.
Keep Your Eye on the SQL Server Ball
Featured Article(s) Tips for using SQL Server 2005 Transactional Replication (Part 1) Here are some helpful tips to performance tune and optimize SQL Server 2005 Transactional Replication. Failover Clustering – The Easy Way If you’ve tried to set up clustering, or failover solutions in general with SQL Server’s native tools, you’ve no-doubt seen that it can be, challenging. It doesn’t […]
Day 30 as DBA, Real DBAs and More
Day 30 as DBA This follow-on to the Day 1 as DBA show will go into the things you can do now that you’re semi-established in your routines. Daily maintenance, auditing, security checks, best practices and more. There is a lot to consider and think about when you’re putting a good foundation in place for your systems, we’ll cover check […]