(Arshad Ali) As your business grows, the number of applications grows as well, as do the SQL Server instances to support these applications. As a SQL DBA, you need to have a multi-server management dashboard that proactively tells you about the resource utilization on each SQL Server instance.
Other News
Visual Studio Watches Windows
Visual Studio’s debugging windows, such as the Locals and Autos windows, allow developers to view the current contents of in-scope variables. The Watches windows are similar, except that the contents of the window are determined by the programmer.
APAR Friday Bonus: Admin stored procedures updated with more DSNZPARM support
(Willie Favero) Yes, this one is small, that’s why it’s a APAR Friday Bonus track. However, even though it is small, it’s one of those fixes that tickle my fancy because it deals with DSNZPARM in some way,
Performance Tuning SQL Server: Tools and Processes
(Buck Woody) Performance Tuning can be a little confusing — there are so many places that you can start the process that it is difficult to know where to begin. You can start with the hardware side of things, the queries, the indexes, or any number of other places. It often becomes a matter of the t
Drawing Circular Shapes
(Darla Ferrara) Drawing circular shapes in SVG is slightly more complex that other forms. A circle adds an additional variable to the mix, radius. The parser needs to understand the diameter of your circle. SVG handles closed circles differently than arches, or arcs.
What’s required to tune MySQL?
(Baron Schwartz) I got a serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It is a question that I hear often, but I never thought about answering it in public. Here’s a consolidated version of what I explained during our conversation.
Drag and Drop Sortable Lists using jQueryUI, jQuery AJAX, ASP.NET Web Methods and a Detachable Entity Framework Data Repository
(Wes Grant) I have had several occasions where I needed an interface to create and order a list on the web. I had searched many times over the years looking for a clean and simple interface for doing this but never found one that I liked, so this is the solution that I created.
Understanding the new JVM exit property in the latest DB2 Universal JDBC driver
(Sujan Ghosh) Using a new global property, you can now trap JVM exit or System.exit() upon completion of SQLJ tools like db2sqljcustomize and db2sqljbind, using the DB2 Universal JDBC Driver.
Getting started with Code Snippets feature of SQL Server Denali
(Arshad Ali) A new feature in SQL Server Denali is code snippets. In this tip I talk about what it is, how to use it and how to customize/add code snippets as needed.
Access has Its Place
Access has Its Place Our reader’s comments are varied. However, one thing that appears common in almost every comment, for or against, is that Access is bad as long as it stays where it belongs. It is a great tool for prototyping, one step up from spreadsheet power users. It helps support needs for ETL, reporting, monitoring and other niche […]