(Glenn Berry, Louis Davidson and Tim Ford) Every time a SQL Server session has to wait for some reason before the requested work can continue, SQL Server records the length of time waited. It also records the resource for which the transaction is waiting.
Other News
The importance of synchronous event handlers
(Ishai Sagi) In SharePoint, we can create list item event handlers (or receivers). I have written about this in the past, and even posted some code for setting the security automatically on a list item as it is created.
.NET Workload Indirection with Managed Extensibility Framework and Task Parallel Library
(Jeffrey Juday) Applications like Windows Services and Web Services often have a demanding workload and sophisticated extensibility needs. Managing a workload on the .NET platform often means utilizing the Task Parallel Library (TPL) classes. .NET extensibility capabilities span many components, but
IBM DB2 Express-C Available Free in the Cloud
(Chris Smith) There are many applications today built on top of MySQL, but widespread concerns about Oracle’s intentions to support the free Community Server editions persist. So far, companies that rely on the free editions of MySQL have not had cause for concern, and presumably the worst that coul
APAR Friday: HIPER – Potential optimization problem using frequency, histogram statistics
(Willie Favero) Although gathering frequency and histogram statistics can in some cases be a performance life saver, it seems there are occasions that those same frequency and histogram statistics can also get you into to trouble in the from of a not too good access path being chosen.
Using the service integration bus link in WebSphere Application Server to route messages from a local queue to a remote queue
(Manivannan Manickam) IBM WebSphere Application Server includes a variety of JMS providers that can be used by applications for asynchronous communication. By default, WebSphere Application Server uses a service integration bus (SI bus) for asynchronous communication.
Different ways to monitor Log Shipping for SQL Server databases
(Jugal Shah) Log shipping has been an option for creating a failover server for SQL Server for quite some time. In this tip, we look at different ways that you can monitor the status of your log shipped databases.
Data Privacy – Old News or New Issues?
Data Privacy – Old News or New Issues? I’ve been spending a lot of time working through data issues with a number of clients and friends and their companies. It’s odd (and good) that this is coming to light now, but I’m also beginning to see that this is both just the beginning and a much larger more persistent issue. […]
Encryption Comments & Feedback
SSWUGtv – New Show! With Stephen Wynkoop In this edition… Privacy policies and data warehouses, Oracle and their 70x performance increase, Career tips from Laura Rose. Also, our guest segment is all about security… and so much more. Watch the Show Last Day to Register: T-SQL Querying Fundamentals with Itzik Ben-Gan Online course starts tomorrow – full 30 days of […]
Create Bigfile Tablespace – Oracle Managed Files (OMF)
(Tyler Muth) Working with Exadata a lot (almost exclusively) I create almost all my tablespaces as bigfile using OMF. For some reason I can never find the right syntax for this when I need it. So, that’s the main reason for this post.