(Pinal Dave) Performance tuning is such a subject that everyone wants to master it. In beginning everybody is at a novice level and spend lots of time learning how to master the art of performance tuning.
Author: SSWUG Research
SQL Server Data Tools in SQL Server 2012 – Part 2
(Arshad Ali) As developers, we have always wanted to have a single Integrated Development Environment (IDE) for not only writing application code but to also to write database code in a single place without switching the environments.
Floating Editors in Oracle SQL Developer v4
(Jeff Smith) Working on a table? Maybe you need to investigate the stats while you also browse some data.
Practical P_S: Finding the KILLer
(Todd Farmer) In a previous post, I described how to leverage PERFORMANCE_SCHEMA in MySQL 5.6 to identify connections which had not been properly closed by the client. One possible cause of connections being closed without explicit request from the client is when another process issues a KILL CONNE
Everything you wanted to know about SQL injection (but were afraid to ask)
(Troy Hunt) Put on your black hats folks, it’s time to learn some genuinely interesting things about SQL injection. Now remember – y’all play nice with the bits and pieces you’re about to read, ok?
TechTip: DB2 Web Query and Excel Spreadsheets: Easy as Pie! Part III – See more at: http://www.mcpressonline.com/database/techtip-db2-web-query-and-excel-spreadsheets-easy-as-pie-part-iii.html
(Gene Cobb) In my previous article in this series, TechTip: DB2 Web Query and Excel Spreadsheets: Easy as Pie! Part II, I showed you some DB2 Web Query techniques that generated multiple worksheets within an Excel spreadsheet. In this article, we continue the discussion on combining these two techno
DB2 BLU: A look at the catalog tables and the synopsis table
(Henrik Loeser) DB2 10.5 with BLU Acceleration allows to create column-organized tables. They are the foundation for “actionable compression” and smart in-memory processing. I plan to cover some details in upcoming posts and already have written some articles about DB2 BLU earlier.
JsonSerializer.cfc – A Data Serialization Utility For ColdFusion
(Ben Nadel) ColdFusion, as you probably know, is a case-insensitive language. Sure, there are methods for executing case-sensitive string comparisons or searches; but, when it comes to variable names and other identifiers, ColdFusion is case-insensitive.
Displaying Model State Errors Inside GridView Columns
(Bipin Joshi) ASP.NET 4.5 web forms support model binding features. Additionally they can make use of model validation using data annotation validators. The validation errors thrown by data annotation validators can be easily displayed in a web form using ValiationSummary control. While this arrange
Regular Expressions: (5) Alphanumeric characters
(Ged Mead) In the posts on this topic so far, we’ve looked at some basic but useful ways of using regular expressions to search for patterns in strings. In this post, I want to home in on alphabetic characters. In regular expression parlance, these are usually described as ‘word characters’.