(Susan Visser) IDUG EMEA took place in Prague a few weeks ago and like all European conferences, it was fun and educational. In some ways it feels like a DB2 reunion as well since it is much smaller than other conferences that I attend. This makes it easy to connect with people and to catch up sin
Other News
BIN$ Index Found in the Execution Plan – Digging through the Recycle Bin
(Charles Hooper) There are a few articles that can be found on the Internet that describe the cause of indexes with names similar to BIN$ld5VAtb88PngQAB/AQF8hg==$0 and BIN$PESygWW5R0WhbOaDugxqwQ==$0 appearing in execution plans.
Adventures in TSQL: SQL Server Query Performance Analysis using DMVs
(Carl Nolan) From the development perspective I often have to perform an analysis of a database application. More often than not this entails looking at a running system and ensuring that the application queries are behaving as expected. As such, I thought it would be worthwhile sharing some TSQL sc
Simplified MySQL SSL connections
(Mark Grennan) In last weeks OurSQL postcast (episode 65) Sheeri, Sarah and Jerry talked about making MySQL safe with SSL. Encryption always seems to be such a confusing subject. I think every database should be using SSL by default. So, I was wondering just how easily SSL could be setup.
Visual Studio Code Definition Window
When working with large projects with numerous classes and references, it can be difficult to remember how every method works. The Code Definition Window helps by automatically looking up definitions and displaying their signatures or source code.
SQL SERVER – Introduction to PERCENTILE_DISC() – Analytic Functions Introduced in SQL Server 2012
(Pinal Dave) SQL Server 2012 introduces new analytical function PERCENTILE_DISC().
WPF DropDownButton Control
(Mahesh Chand) If you have written any Windows Forms or WPF applications, I am sure you are familiar with a Button, ComboBox and DropDown controls. How about a Button acts as a DropDown control when you click on t? That is what the WPF team has added in the WPF Toolkit, a new control called DropDown
How to use Google Chart Tools with IBM Mashup Center
(Louis Mau and Rajesh Kartha) Google Chart Tools provide a rich set of visualization capabilities, such as scatter chart and gauge, that complement the chart types available with the IBM Mashup Center charting widget. You will see how Google Chart Images can be used with IBM Mashup Center to generat
Identify location of the SQL Server Error Log file
(Ashish Kumar Mehta) How do I find out where the SQL Server Error Log file is located for a specific SQL Server instance? In this tip we look at different ways a DBA can identify the location of the SQL Server Error Log file used by an instance of SQL Server.
String Comparison Tips From Readers
SSWUG TV SQL Server Injection prevention and help, interview with Philip Japikse, Patterns and Practices Evangelist for Telerik. We also have the latest news on Oracle’s purchase of RightNow Technologies, IBMs push into unstructured data analysis and more. Watch the Show Featured Article(s) Optimistic Locking in DB2 for z/OS As of DB2 Version 9, a new technique called "optimistic locking" […]