(Tibor Karaszi) This post is inspired from a discussion about bulk logged recovery model and log backup. Some basics: In bulk logged recovery model, some operations can be minimally logged, like: SELECT INTO Index create, rebuild and drop Bulk loading of data
Other News
ASP to ASP.NET Migration
(Manoj Srivastava and Amit Kataria) Migration from ASP to ASP.NET can drastically improve the performance of your applications. A software created using ASP.NET is more robust, scalable, reliable, and secure as compared to the software created using ASP. ASP.NET, which is a new version of ASP, remov
Scaling Secret #2: Denormalizing Your Way to Speed and Profit
(Todd Hoff) Alan Watts once observed how after we accepted Descartes’ separation of the mind and body we’ve been trying to smash them back together again ever since when really they were never separate to begin with.
Seven Steps to Improving Your VB Code
(John Tränkenschuh) I teach Visual Basic. I love it. It’s been good to me, all the way back to VB3. VB usefulness is growing wildly, but why do actual VB coding practices seem to lag a bit?
Sample database migration tutorial using IBM DB2 Migration Toolkit
(Alex Jarzebowicz) The free-of-charge IBM DB2 Migration Toolkit can simplify and improve your migration to DB2 for Linux, UNIX, and Windows. This tutorial demonstrates the use of the toolkit to convert a database model from a Microsoft SQL Server DDL script to a DB2 database. The converted objects w
Monitor Your Applications With Vista’s Performance Logs and Alerts
(Seth Livingston) The Windows Reliability and Performance Monitor (RPM) (see Figure 1) is a new application in Windows Vista that unifies the approach to monitoring real-time and historical reliability and performance data. The Performance Logs and Alerts (PLA) API gives you programmatic access to f
Merge Replication, SQL Server Reporting Services Help
Watch The Latest Weekly SQL Server Show > Watch SelectViews – now with the segment selector in Beta, allowing you to jump around the show. Featured Article(s) Tips for using SQL Server 2005 Merge Replication (Part 1) Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication. It’s Like A SQL Server Private Investigator… When […]
Webcast Today: SQL Server Consolidation
Featured Article(s) Understanding the SDLC Phases of a Software Project [Part I] Software Development follows various structured models and methodologies similar to any other engineering discipline. Each of these models provides its own set of methodologies to design and develop a software application. The choice of any such models entirely depends on the nature of the software project in hand […]
DB2 Locking – Success or Failure in Managing DB2
(Bill Arledge and Judy Quenet) DB2 for z/OS incorporates unique relational characteristics with traditional database capabilities, including robust locking mechanisms that ensure data integrity while maximizing concurrency for the world’s most sophisticated DB2 applications. DB2 locking is a broad
nxslt3.exe/NxsltTask v3.0 – now running compiled XSLT stylesheets
(Oleg Tkachenko) Here goes nxslt3.exe/NxsltTask v3.0. It’s nxslt tool for .Net 3.5. It can do everything nxslt2/NxsltTask v2.3 can plus the ability to run compiled XSLT stylesheets.