The easiest way to generate random rows in MySQL is to use the ORDER BY RAND() clause.
Other News
Subterranean IL: Compiling C# exception handlers
(Simon Cooper) An exception handler in C# combines the IL catch and finally exception handling clauses into a single try statement:
Create Your Next Application and Database in the Cloud
(Vince Varallo) This article will demonstrate how to create a database in the Cloud and then create an ASP.NET web site which uses this database as the back end.
SSIS Script Task and Microsoft Office Automation
(Marcin Policht) While using Microsoft Office Excel to store a variety of semi-structured data tends to be more economical and convenient than SQL Server, it lacks data mining and data warehousing capabilities. This article explores importing spreadsheets onto SQL Server and taking advantage of Offi
Creating ASP.NET MVC ‘Web Site’
(Bipin Joshi) If you used ASP.NET MVC before, you are probably aware that Visual Studio provides ASP.NET MVC Web Application project template to create MVC based applications. There is no option to create MVC Web Sites. In this article I am going to explain how I solved this issue in one of my appli
ChartResult: Testable ASP.NET MVC 3 controller actions that return Chart
(Gunnar Peipman) Lately I blogged about charts support in ASP.NET MVC 3 beta. This posting showed how to get chart initialized and sent to client quickly. In this posting I will show you how to use Chart with ChartResult to make our chart operations testable.
A few more DB2 10 for z/OS ‘little gems’
(Willie Favero) Yes, another DB2 “What’s New” blog post.. sort of… I’ve been trying to find stuff being delivered in DB2 10, or that changed in DB2 10, that everyone else isn’t talking about yet I feel should be at least mentioned someplace. So, here’s the “Place” to mention them.
DB2 Tools corner: The DB2 for z/OS REORG utility and noncontiguous partitions
(Mary Petras) By keeping up to date with the IBM DB2 Utilities Suite for z/OS service stream maintenance and enhancements, you can learn about the latest improvements that might solve some of your current problems.
Considerations for Implementing SnapManager for SQL Server
(Scott Shaw) Our company virtualized a large number of SQL Servers to NetApp appliances. The infrastructure team purchased NetApp’s application Snap Manager for SQL Server (SMSQL) for snapshot backup and recovery. I’m a DBA, not a storage administrator! What are some best practices prior to implemen
Remote DBA
SSWUG Free Expo Event: Real-World SharePoint Administration Friday, February 11, 2011, 9 a.m. – 1 p.m. PST Build you skills for deploying and supporting SharePoint by attending this virtual conference. Experts will teach you techniques for managing access control, implementation strategies and tips you can use immediately. With registration you also receive a free complimentary membership to SSWUG for one […]