(Matt Goebel) If you are a developer, and have been for longer than six months, there is a good chance you have written an application or two before Microsoft’s latest creation, Vista, came onto the scene. If you are a perfect developer, one who has never strayed from all the coding guidelines, has
Other News
Migrating From MS Access To MySQL
(Christopher Keene) According to recent survey, over 20% of MySQL users plan to migrate a Microsoft Access applications to MySQL over the next 12 months. However there are few documents available that describe best practices for performing such a migration.
SQL Server filegroups for backup and restore
(Eric Johnson) SQL Server has long given database administrators the option of splitting up databases into different files and filegroups. When Microsoft released SQL Server 2005, it greatly expanded the options for using filegroups by introducing partitioning. Additionally, we now have the ability
What is the position of a row?
(Simon Sabin) The simple answer is there isn’t one.
Close those Loopholes – Testing Stored Procedures
(Alex Kuznetsov and Alex Styler) In the previous article, Close those Loopholes in your Database Testing, I was discussing database testing in general. In this article Alex Styler and I will concentrate on database unit testing. Unit testing is becoming more and more common among C#, C++, and Java p
ASP.NET’s Menu control offers another site map navigation option
(Tony Patton) My examination of ASP.NET site map navigation controls — Site Map, SiteMapPath, and TreeView — wraps up this week with coverage of the Menu control.
Computer Security and Statistical Databases
(Bill Stallings) A statistical database (SDB) is one that provides data of a statistical nature, such as counts and averages.
Business Intelligence: Bringing Analytics into Operations
(Michael L. Gonzales) Organizations face threats from new competitors everywhere. New companies sprout up in established industries daily, while traditional competitive walls fall. Phone companies are suddenly doing battle with cable companies, and even with power companies. Banks may soon find them
SQL Server Show Live Now, Your 15 Minutes
Watch the Latest Weekly SQL Server Show, Released Today Watch SelectViews – Facing the Real World Users, a Tool for Optimizing Queries. Query Plans, Your 15 Minutes of Fame, Current Release Versions, Upcoming Events, Tips and More. > Click Here to Watch The Show. Consolidation is More Than Moving Around Instances Frankly, when I first started learning about consolidation, I […]
(78) SelectViews: Facing the Real World Users, a Tool for Optimizing Queries.
Video Programming for IT Professionals