SQL Server Management tools Author: Basit A. Farooq Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high training costs, and poor DBA productivity. To keep up with these new demands of complex enterprise database management solutions,...
Pro Members
Troubleshooting SQL Server 2012 Analysis Services problems
Troubleshooting SQL Server 2012 Analysis Services problems If you have problems with SQL Server 2012 Analysis Services, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 Analysis Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...
Exploring LinqDataSource Control in ASP.NET – Part 1
Exploring LinqDataSource Control in ASP.NET – Part 1 The LinqDataSource control is a new data source control introduced in ASP.NET 3.5 that allows you to bind LINQ models to data bound controls in your web applications. LinqDataSource control allows you to connect to data sources like SQL Server and in-memory collections with a minimal need custom coding required for building...
Using Non-Equi Joins
Using Non-Equi Joins Non-equi joins are those ones where the join condition uses an inequality comparison. This can be useful when defining self joins – ones defined on the same table. Suppose you have a table whose rows contain information about football teams. You need to make up a schedule for a series of games where each team is to...
Setting Up Oracle Database 12c on Oracle VM VirtualBox
Setting Up Oracle Database 12c on Oracle VM VirtualBox This article explains how to get started quickly with Oracle Database 12c installed in a virtual machine running on Oracle VM VirtualBox. In particular, you will look at how to install a VM, taking advantage of the pre-built Oracle Linux 6 Admin VM. Then, you’ll walk through the process of installing...
Tips for using SQL Server 2012 configuration options
Tips for using SQL Server 2012 configuration options One of the ways to optimize SQL Server 2012 performance is setting the appropriate server configuration options. You can set these options by using the SQL Server Management Studio or the sp_configure system stored procedure. SQL Server 2012 configuration options may be separated to two categories: – Options that take effect immediately...
SQL Server monitoring and optimization–(Part 2)
SQL Server monitoring and optimization – (Part 2) Author: Basit A. Farooq Editor’s Note: In this first of the two part article series, you learned how to use monitoring tools, including System Monitor and SQL Server Profiler. You also learned how capture a trace file or table using SQL Server Profiler. In this second part, you learn how to use...
What is More Valuable: a Jack of All Trades or an Expert of One?
Hello, this is Laura Lee Rose – author of the books TimePeace: Making Peace with Time – and the Book of Answers: 105 Career Critical Situations. I am a business and efficiency coach that specializes in professional development, career management, time management, and work-life balance strategies. Today’s question is : What’s more valuable to job force: Jack of all trade...
Troubleshooting problems with locking in SQL Server 2012
Troubleshooting problems with locking in SQL Server 2012 If you have problems with SQL Server 2012 locking, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 locking bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
DB2 Performance Fundamentals
DB2 Performance Fundamentals By Craig S. Mullins Applications that access DB2 databases are only as good as the performance they achieve. And every user wants their software to run as fast as possible. As such, performance management, monitoring, and tuning comprise the biggest demand on the DBA’s time. When asked what is the single most important or stressful aspect of...