(Michael Agroskin) Before diving into concrete use cases and implementation details, let’s see what is missing in the current WPF implementation.
Other News
DSNZPARM: What will not be there when you arrive at DB2 10
(Willie Favero) A few days ago we discussed which DSNZPARMs are being deprecated in DB2 10 for z/OS. Today, we’ll look at which system parameters have been flat removed from the product; gone, nonextant, departed, vamoose.
Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters
(Tim Ford) I’d seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance?
Distributed Database Feedback
SSWUG.Org Virtual Workshop: Query Plans and Processing – TODAY This morning, January 21, from 9AM – 12PM PST Do you have slow running queries? Do you have times when your database just slogs along, and find it difficult to determine the cause? Do you need to improve your query writing and database tuning skills. This is the virtual conference for […]
SQL Q & A: Bottlenecks and Transaction Logs
(Paul S. Randal) Sometimes it’s easy to determine the nature of a performance bottleneck—other times, not so much. The same goes with configuring transaction logs.
SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance
(Pinalkumar Dave) Earlier, I had written two articles related to Shrinking Database. I wrote about why Shrinking Database is not good.
String Formatting in XSLT 2.0
(Eric van der Vlist) To migrate my photo albums from Gallery to WordPress, I ended up having to transform XML fragments such as:
SharePoint Performance Tuning – Resource Throttling
First introduced with SharePoint 2010, Resource Throttling allows the farm administrator to control the overall performance of a SharePoint farm. The biggest performance bottleneck in SharePoint sites is usually large lists, which either have numerous items in a list or have very large items in a li
What’s in an XML Name(space)?
(Michael Marr) Name conflict is a common day occurrence. When you’re blessed with a popular name like Mohamed, Jack, or Michael, name conflict is even more familiar.
Counting Values in a Database Table with the SQL COUNT Function
(Mike Chapple) The COUNT() function in SQL allows you to count database records based upon a variety of criteria. You can use it to count all records in a table, count unique values in a column or count the number of times records occur that meet certain criteria. This tutorial takes a brief look at
