When it comes to programming, I no longer have any idea how quickly or accurately I can type. I also have a reduced memory of the objects I use on a daily basis, either written my myself, or contained in libraries I frequent. Why am I able to get away with this reduced set of skills? We have all come […]
Other News
But what about SQL Tuning?
(Lockwood Lyon) DBAs need to remove themselves from the rut of “what do I tune?” and spend some quality time on metrics, configurations, and costs. Develop these measurements and do a root cause analysis. Know your system!
ROW_NUMBER SQL Server
(Derek E Wilson) SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number() function. You can use this function to return a sequential number in your result set that begins at 1.
Reading performance counter data in .NET
(tilovell09) Nothing you can’t easily write yourself, but while playing around, I wrote this one myself, and learned one or two things.
Dynamic-CSS Styles and Animations – Jquery Plugin
(sameh obada) Jquery plugin to create dynamic css animations and transitions.
SQL Developer 4.1: Easier Excel Imports
(Jeff Smith) The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer‘ – and it has been since I published it almost 3 years ago.
Logging with MySQL: Error-Logging to Syslog & EventLog
(Tatiana) You’ve already read it in What’s new in 5.7 (So Far) — the MySQL server now has new-and-improved supported for syslog (on unix-like systems) and EventLog (on Windows). In the next few paragraphs, we’ll take a look at what they are, what has changed, and how they can make your life easier.
DB2’s Got Talent: The Search Returns
(Carol) It has been almost a year since our partner DBI Software crowned the current DB2’s Got Talent Champion, Mike Krafick. Once again DBI are searching for participants to enter the hugely successful annual contest and we are thrilled to be sponsoring the competition again this year.
Attribute routing in ASP.NET MVC 5+
(Sheo Narayan) In the previous article, we learnt about convention based routing. In this article, we shall learn about Attribute based routing that is directly applied to the action method of the controller. This feature is only supported in ASP.NET MVC 5+ versions.
Create a clustered index and a primary key on existing tables
(Jen McCown) It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes on existing tables is one that newish DBAs tend to trip up on, and so (like I do), I shall blog about it so there’s a nice, clear, explicit reference available.