(anhphan) In ScottGu’s Blog “Announcing the release of Windows Azure SDK 2.0 for .NET”, among all other new features, you learn how to stream your Windows Azure Web Site’s application logs into Visual Studio. It might be also useful if you persist those same logs in Azure Table Storage and view them
Author: SSWUG Research
Why Windows Azure SQL Database May Be Right For You
(Thomas LaRock) Grande. Bold. No room. It’s my standard order when at Starbucks. Despite there being thousands of ways to have my coffee prepared I prefer the simplest.
How to Allow a User to Refresh Another User’s Materialized View
(Andrew Reid) I needed to find out how to allow a user to refresh another user’s materialized view. Once I had done this I decided to document it for future reference with a worked example, which I ran on an Oracle 11.2.0.2.7 database.
Enhanced Control of Your Scripts via Checkpoints in Data Studio
(Vince Petrillo) In my last blog I focused on tooling support for the new DB2 BLU Acceleration and rightfully so. BLU Acceleration is a game changer and tooling support makes it even easier to use. I also want to point out there were many enhancements to Data Studio beyond support for BLU Accelera
PHP: PECL/mysqlnd_ms 1.6 – automatic retry loop for transient errors
(Ulf Wendel) PECL/mysqlnd_ms is client-side load balancing driver plugin for PHP MySQL that aims to increase distribution transparency when using any MySQL based cluster: failover, read-write splitting, abstraction on consistency (e.g. read-your-writes), partitioning/sharding support, … it’s all the
SQL Server Analysis Services Partition Maintenance and Processing
(Scott Murray) Now that I created several SSAS partitions, what do I need to do to process and maintain them? What options are available to improve my processing time?
Passing Value Between Pages in ASP.NET
(Bikash Prakash Dash) This tip discusses different methods of passing values between ASP.NET pages.
Querying Your Oracle SQL Developer Data Modeler Designs
(Jeff Smith) Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the databa
Explain Part 2 – Command Line Explain Plans Using db2exfmt
(Ember Crooks) This series started with Explain Part 1 – Explain and the DB2 Optimizer. This is the second post in the series. I want to cover my favorite method for generating Explain Plans, and in the process, discuss some of the elements. I am a fully admitted command line junkie.
Replication Renaming Schemas, Tables and Columns
(Linas Virbalas) Schema definitions on replication slaves sometimes differ. Ability to rename schemas, tables and columns and still setup replication with comfort is useful for MySQL to MySQL replication, while for heterogeneous topologies like these, it’s a must.