(Ember Crooks) Usually, there’s an admin (well, lots of them for different clients) I ask when I have basic questions about system configurations, but like all DBAs, sometimes I need to figure it out myself. Enter db2pd -osinfo.
Author: SSWUG Research
Creating Typed Java Arrays In ColdFusion Using JavaCast()
(Ben Nadel) A few years ago, I created a user defined ColdFusion function – toJava() – that tried to me “smart” about the way it cast ColdFusion values into Java values. Unfortunately, it turns out that I was basically re-creating a feature that ColdFusion already had; only, I didn’t really understa
WPF Base Classes – Control – Visual Properties
(Richard Carr) The thirtieth part of the Windows Presentation Foundation Fundamentals tutorial continues to examine properties of the Control class. This article describes several miscellaneous properties that modify the appearance of controls.
Extended Events in SQL Server 2012
(Dinesh Asanka) Extended Events were introduced in SQL Server 2008 as a light-weight monitoring mechanism. Most DBAs typically use SQL Profiler to monitor and analyse SQL Server events. However, SQL Profiler is not a lightweight tool and consumes too many resources for use in a production environmen
Planning Your SharePoint 2013 Solution Strategy
(Scott Jamison, Chris Bortlik and Susan Hanley) According to Microsoft market research, nearly 80% of Fortune 500 companies are using SharePoint.1 Adding educational institutions, government agencies, small businesses, and nonprofits means that a significant number of people who go to work have acce
Is Oracle 12c Instance Level CPU Consumption Reporting Fixed?
(Craig Shallahamer) I was curious if Oracle had fixed instance level v$sysstat CPU consumption statistic reporting in 12c. Why was a curious? Because in the past, the Oracle Database 6, 7, 8i, 9i, 10g, 11g have all incorrectly reported instance wide CPU consumption when sourced from the v$sysstat vi
The DEFAULT value for a column
(Hemant K Chitale) Here’s a simple demo of how a column’s DEFAULT definiton behaves.
What Queries are Causing My Waits?
(johnsterrett) In my last blog post, I showed you how I go about baselining wait statistics. Typically my next step once I have found my top wait types is to use extended events to figure out the SQL statements causing the majority of the waits for those wait types.
Store Perfom Data Collector data to SQL Server
(Vinoth NM) As a DBA we frequently run perfmon on our servers to monitor performance of the SQL Servers, In this section I am going to write how to schedule a perfmon data collector to collect the perfmon data to a SQL server destination.
Custom Installer And XML Serialization There was an error generating the XML Document – FileNotFoundException
(David Homer) I’ve recently had an issue that’s wasted an entire day of my life that I’d like to share.