(Ulf Wendel) It is the third day I try to find mysqlnd plugin use cases for the Succeed with Plugins webinar on October, 26th. Not being innovative or creative today, I looked into a classic: client fail over.
Other News
Run Operating System Commands in SQL Agent using PowerShell
(Buck Woody) From time to time you may need to run a command from SQL Server on the operating system. There are various ways to do this, and most all of them are insecure. The cmdexec process allows you to have access to the command line in the operating system, but there are some fairly significant
SQL Server 2012: Microsoft’s Case for Structured Data in the Cloud Era
(Scott M. Fulton, III) Unstructured data, for lack of a more poetic phrase, exists. In fact, there’s more of it now than at any time in history – the growth rate Forrester experts cite is 80% annually, and perhaps rising.
WebSockets for Faster, More Scalable Ajax Applications
(Peter Vogel) The idea behind WebSockets is simple: the client requests a TCP socket to communicate with the service. Once the socket’s created, the client and the server can use it to send messages to each other. WebSockets’ impact should be tremendous, both in improving the performance of Ajax ap
Views In SQL Server
(Keshav Singh) This article discusses one of the basic but greatly misunderstood objects in SQL server – “Views”. Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our needs.
InfoSphere Optim and the complete business object, Part 1: Understanding the complete business object
(John Haldeman) Knowing your data relationships and understanding the complete business object are crucial for successful test data management, data privacy, application retirement, and data growth projects. Part 1 of this article series introduces the key concept of a complete business object.
Displaying Multiple Series on an SSRS Chart using Chart Area
(Siddharth Mehta) A report might contain multiple data series on a chart, which can have considerably varying scales but common category groups. In such cases where this a big difference in scales, the data series with the lower scale can become obscured. In this tip we will take a look at how to so
Code Lookup Options for Enumerations
SSWUG TV With Stephen Wynkoop Don’t miss IMHO with SQL Server MVP Denny Cherry. Watch the Show Code Lookup Options for Enumerations Yesterday I opened the topic of keeping Enumerations and lookup table values in synch. One technique I used in the past was making the lookup values in the tables the standard. I was using NetTiers for my DAL […]
SSWUG TV – Interview with Peter Serzo, Senior SharePoint Architect with High Monkey Consulting
Pro-Center Video Programming for IT Professionals
A Love/Hate Relationship with Enums
Love/Hate Relationship with Enums Enums are used frequently to enforce a data domain and establish human readable names for codes. An Enum only exists in application software. It does not exist in a database. Often we have reference tables in the database in order to translate codes created by application Enum values into human readable text. Now we have the […]