(Pinal Dave) I am a big time advocate of some common best practices that I see in the industry. These have been ingrained into every session that I do be it SQL Server, MySQL or any other databases.
Author: SSWUG Research
The DB2Night Show #156: Using and Optimizing DataStage and DB2
(Scott) 100% of our audience learned something! DataStage is a very popular ETL tool that is used with IBM DB2 LUW. Michael offered some very valuable advice on how to maximize performance in DPF and non-DPF environments.
The Read Uncommitted Isolation Level
(Paul White) Read uncommitted is the weakest of the four transaction isolation levels defined in the SQL Standard (and of the six implemented in SQL Server). It allows all three so-called “concurrency phenomena”, dirty reads, non-repeatable reads, and phantoms:
CONCAT and STUFF Functions in SQL Server 2012
(Arshad Ali) We often need to combine two or more string values to use this combined string value in reporting. Although there was a way to do that in earlier versions of SQL Server, starting with SQL Server 2012 we have CONCAT function for this specific situation. This T-SQL function also takes car
Temp Tables, Filesorts, UTF8, VARCHAR, and Schema Design in MySQL
(Baron Schwartz) The other day we were doing some peer review on a schema change at VividCortex and the topic of character set, column length, and the potential downsides of using utf8 came up.
The Database Protection Series – Database Activity Monitoring
(Chris Foot) In this installment, we’ll talk about the benefits that real time database activity monitoring products provide. We’ll also learn how these types of products work. You will notice that I often refer to the McAfee database security protection product set when I describe some of the acti
SQL Developer 3 and Timestamp Conversion
(Dominic Brooks) I shouldn’t be using an old version of SQL Developer like v3 (3.2.10.09) anyway but… cut a long story short … I am.
Tuning Database XQuery Statements (1)
(Marco Gralike) I had a question of a colleague to have a look at a statement that didn’t really perform. So I had a look and tried to explain afterwards how my mindset worked during solving the problem at hand. I post it now here as well hoping it might help others.
ESJ: Extremely Simple JSON for C++
(Jerry Evans) ESJ is a JSON mapper for C++ with modest compiler requirements (No C++11) and zero reliance on 3rd party libraries. It is a very light-weight, easy to use system for inter-operating with web and database services.
Career Critical Situations
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.