(Arshad Ali) As the infrastructure grows to sustain the growth of an enterprise so does the number of DBAs to support this infrastructure. Different groups of DBAs perform separate sets of roles and responsibilities; for example there can be one group of DBAs responsible for the overall management o
Other News
Creating the Perfect ASP.NET UI with Web Parts and User Controls
(Peter Vogel) In reporting dashboards and SharePoint, it’s taken for granted that users should be able to customize the UI to create one that best supports their needs. In fact, only by letting your users create their own UI can you deliver the perfect UI to a diverse group of users (and you always
Blob Size Never Reduces When Using RBS with SharePoint 2010
(BrianGre) So last week I had a customer let me know that after configuring RBS (remote blob storage) with their SharePoint Server 2010 environment they noticed that the blob size was not reducing after they would delete a document from the SharePoint library. So we begin investigation into what it
Quick demo of accessing XML data with jQuery
(Raymond Camden) This blog post is mainly for my own memory – but a user asked about access CDATA values stored in an XML field via JavaScript. I’m using jQuery to work with XML and wrote up a very quick demo. For the most part, it seems like it “just works”, but I assume there are going to be some
Summary Tables with MySQL
(Keith Larson) I was recently talking with a few people and the concept of summary tables came up as solutions for them. The issue is, they never thought of it. Hopefully this post will help them as well as others.
Slow querying of DBA_EXTENTS, DBA_FREE_SPACE and dropping tables
(Martin Widlake) Are you finding queries to identify free space, the size of segments or details of extents in your database are very slow? You could have a database with a very, very large number of extents. If you are on version 9 or up, I would suggest you check the extent management settings for
How do I force a query to use bind-aware cursor sharing?
(Allison) Way back in our original post on adaptive cursor sharing, a commenter asked if there was a way to skip the monitoring for a query and go straight to bind-aware cursor sharing. We mentioned then that we would add a hint for this purpose, but we never addressed the new hint here on the blog
Will Enabling a 10046 Trace Make My Query Slower (or Faster)?
(Charles Hooper) It seems that I often wonder about the things that I read… is it really true? Several years ago, one of the items that I wondered about is whether or not an execution plan for a SQL statement could change magically simply because the Oracle RDBMS knows that it is being watched (a b
Clustering every SQL Server instance
(Linchi Shea) You may disagree, but I believe it is a good practice to cluster all the SQL Server instances. That is, even when you plan to run a SQL Server instance on a single machine, you should install it in a single node cluster.
Object whitespace-naming madness
(Szymon Wojcik) Have you ever tried creating objects and giving them strange names? I made some experiment at one of lab servers, main focus was space (you know, the long key at the bottom of the keyboard :D). So, without further ado – the first object to be tested is a database.