(Seth Delconte) In the event that a transaction log grows to an out-of-control size, shrinking it can be the only solution – but don’t rush to do this until you are aware of the consequences. Shrinking the log could ‘break the log chain’ – rendering the existing transaction log backups useless.
Other News
Analytic Enhancements in SQL Server 2012 – Part II
(Yan Pan) When I wrote the first installment of this series, I used Denali CTP3. Since then, SQL Server 2012 has been released. In this second installment, I am going to show you more new analytic functions and their usage in the RTM version of SQL Server 2012.
RDF Support in IBM’s DB2
(Eric Franzon) We caught up with Bernie Spang, IBM’s Director, Strategy and Marketing, Database Software and Systems, to discuss the latest release of its enterprise data products DB2 and InfoSphere.
Flipping the Light(Switch) Fantastic in Visual Studio 11
(David Ramel) I’ve heard a lot about the new LightSwitch in Visual Studio 11 Beta and how it simplifies data-centric application development, so I thought I’d give it a try.
DB2 10 For LUW: What’s In It for Me?
(Philip Nelson) Whenever a new DB2 version is announced I get asked “Should I be thinking about upgrading?” My answer is always “Yes.” That doesn’t mean that I think you should upgrade your production systems the minute DB2 10 becomes generally available. The key thing is that you take account of t
ColdFusion 10 – Using The Group Attribute With CFLoop To Group Query Rows
(Ben Nadel) Before ColdFusion 10, the “group” attribute was only available on the CFOutput tag. This attribute could be used to create pseudo “GROUP BY” behavior when outputting ColdFusion query data. With ColdFusion 10, the “group” attribute can now be used with the CFLoop tag when looping over a q
How to prevent swapping on a MySQL server?
(Maciej Dobrzanski) Swapping occurs when system moves some data between memory and a special area on disk called swap space. The process is called swapping in or swapping out depending on the direction in which it happens. System swaps out when it makes a decision to free up some physical memory (RA
SharePoint Governance Part – 2
(Pramod Attarde) It is a good practice for organizations to include branding in their governance policy. Using branding policies will ensure the consistent use of enterprise imagery, fonts, themes, and other design elements.
System Administration Certification exam 919 for Informix 11.70 prep, Part 5: Informix backup and restore
(Sanjit Chakraborty and Elisabeth Bach) In this tutorial, you’ll learn about IBM Informix database backup and restore concepts and strategies, and you’ll learn about utilities and commands for managing your database backup and restore processes.
Checking SQL Services Status – An Evolution Part 1
(Robert Pearl) As a production DBA, one of the key things that must proactively be checked on a daily basis is the status of the SQL Server instances, and all of its related SQL Server Services. In editions of SQL Server 2000 and earlier, there were only two main services for concern, MSSQLSERVER a