(Steve Barker) A Wolf, a Dolphin and a Sphinx walk into a bar… nevermind. We’ll skip the jokes. This post is about using SSL to set up a secure connection between MySQL and Sphinx. Serious stuff!
Other News
Mission-Critical Performance Enhancements Coming in SQL Server 2014
(Kevin Kline) Last month I told you about the overall set of features which Microsoft plans to release when SQL Server 2014 (SQL2014) is released to manufacturing. Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performa
Capturing DB Usage stats – sp_spaceused simulation using DMV’s.
(Prashanth Jayaram) sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters.
How Do I combine results from more than one table?
(Kris Wenzel) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.
SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied on the object, database, schema – Part II
(Pinal Dave) A couple of days back I wrote the blog on Msg 230 and thought it was one of the simplest implementations of access control on the system. To continue with the code in this blog, please make sure you read the same first before getting into the examples here.
Interception in .NET
(Vishwas Sutar) This article discusses about what interception (with little insights in AOP) is and how it can be implemented with Unity framework in .NET framework based software system.
Developing a Simple YouTube App with VB and Windows 8.1
(Hannes Du Preez) Question: What would the 21st century be without YouTube? Answer: Quite boring. Apart from all the funny and interesting videos on there, the main reason that 99% of people visit YouTube is because of the music videos. Today, I will show you how to make a very small YouTube applica
Giving Your Database Updates Enough Time
(Peter Vogel) My client was having a problem processing some very large batches of data in their online application: Their SQL updates were timing out. I offered to look at ways of fixing the problem (more on that in a later tip) but, in the meantime, the client asked me to see about “fixing the tim
WPF Shapes – Rectangle
(Richard Carr) The one hundred and twentieth part of the Windows Presentation Foundation Fundamentals tutorial considers the second two-dimensional drawing control of WPF. This is provided by the Rectangle class.
Weeding Through the Masses
And so the world revolves again, the same script is being played over. The new version of the scenario is centered around all the new tools that are going to make software development easier. Last time we had Java, CORBA, Com, Visual Basic, Power Builder, Oracle Tools, Delphi, and many versions of C and 4GL tools all battling it out […]