(Greg Larsen) SQL Server 2005 performance can be tracked and monitored by using performance counters. The performance counters can be displayed by either the System Monitor (PERFMON) tool, or by using the “sys.os_exec_performance_counters” Dynamic Management View (DMV). This DMV is new with SQL Se
Other News
Extending Base Type Functionality with Extension Methods
(Scott Mitchell) In November 2007, Microsoft released the .NET Framework version 3.5, Visual Studio 2008, and new versions of the C# and Visual Basic languages (see An Overview of ASP.NET 3.5 and Visual Studio 2008 for more details on the release). The new C# and Visual Basic versions include a myri
New XBRL Taxonomy a ‘Boon to Investors’
(Michael Hickins) The U.S. Securities and Exchange Commission is releasing a new taxonomy for Extensible Business Reporting Language on Dec. 4 in the hopes of improving financial reporting and analysis.
Multiple NULL values in a Unique index in SQL Server/DB2 LUW
Yesterday, when helping out a friend who was working on a project that required porting an application from Oracle v9.2.0.5 to SQL Server 2005, he ran into the same UNIQUE index issue as we had blogged before. Since that was a major requirement by the client, this project needed to support having mu
MySQL: How do I import individual table dump files in to MySQL using shell script?
(CrazyToon) After I wrote the post: How do I dump all tables in a database into separate files? I got emails from couple people asking how to import the individual table files back in to MySQL. First way to import each sql file created by the post is to import each file individually by typing: my
Oracle BI EE 10.1.3.3/2 – Same Page Navigation Drills and Passing Parameters
(Venkatakrishnan J) We had a couple of questions on our internal blogs with regard to navigation drills and passing parameters. I thought i would blog about both of them since this might prove useful for others who are attempting the same. The first question was, how do we enable “Drill in Place” fo
Did you know? Cloning is Legal (and Available in SQL Server 2005)
(Kalen Delaney) I first heard about the possibility of database cloning way back in version 7.0 and thought it sounded like a great idea. Who wouldn’t love to have a bunch of identical little databases running around, of smaller size and easier manageability?
LINQ, Spatial Data, Version 1.00000 in 2008 and More
Register Early for the Virtual Conference… …and help provide feedback on setting up the session schedule, see the tools early, participate in chats and more. All just for getting your name in the hat early. The SSWUG SQL Server Virtual Conference – on your desktop, in your timezone, more than 27 sessions and much more. This is YOUR conference. > […]
DITA: One Size Fits All for Technical Publishing?
(Bob Doyle) Back in June 2006 I wrote an XML Editors review article for EContent Magazine that covered a dozen desktop and web-based authoring tools for XML. That article was a bit too hard on both the writer and editorial staff, so we’re not likely to do it again soon. (I may publish a revised stud
Manipulating ASP.NET 2.0 browser support
(Tony Patton) Even though we are at version 3.5 of the .NET Framework and ASP.NET, I am still having fun exploring some of the cool features that were added in version 2.0.