(Alvin Law, Enda McCallig and Garrett Fitzsimons) This paper explores some of the frequently asked questions about database administration on an IBM Smart Analytics System data warehouse database.
Other News
How to Get Elevated Process Path in .NET
(Giorgi Dalakishvili) As you know, retrieving process path in .NET is quite straightforward. For example, if you have process instance someProcess you can get the process path by accessing someProcess.MainModule.FileName. However, for elevated processes, the previous code snippet throws Win32Excepti
AlwaysOn: Minimizing blocking of REDO thread when running reporting workload on Secondary Replica
(Sunil Agarwal) In earlier blog http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-impact-on-the-primary-workload-when-you-run-reporting-workload-on-the-secondary-replica.aspx, I discussed the impact on RTO in case the REDO thread gets blocked.
Integrating Regular Expressions with SQL
Integrating Regular Expressions with SQL A number of people have responded with their take on the use of Regular Expressions in SQL. Many point out how valuable Regular Expressions have been to them using engines already supporting regular expressions. Others extend on this with links to CLR user defined Regular Expression extensions for SQL Server 2005 and later. Based on […]
SSWUG TV – Interviews with SQL Azure MVP Scott Klein and IT career coach Laura Rose.
Video Programming for IT Professionals
Is Entity Framework the Next ODBC?
Is Entity Framework the Next ODBC? What made ODBC a viable technology? It created a single interface for which drivers could be written allowing access to a data store. ODBC drivers were written for text files, Excel Documents, Microsoft Exchange, ISAM Files, Relational Databases, and much more. The key was, there was a common interface used by an ODBC consumer; […]
New Manual Covers DB2 10 for z/OS Security
(Troy Coleman) Every few months, I visit IBM’s DB2 product library and refresh all of my PDF manuals.
TFG 2012 Training Schedule
(Kim May) Instructor-led classroom training is the most effective and reliable way to develop new data management skills. The Fillmore Group delivers a select group of public IBM authorized training courses in our state of the art classroom in Towson, Maryland. Invest in yourself and join us for a
3-Tier Architecture Examples…
(Brian Mains) Previously, I wrote about multiple tiered architectures and the fundamentals associated with various approaches that can be taken when developing with a layered approach. In this article, I plan to illustrate each of these layers in great detail, to help further explain the concept. I
What is the Meaning of the %CPU Column in an Explain Plan? 2
(Charles Hooper) Nearly two years ago I posted the following execution plan in a blog article and asked whether or not there was anything strange about the %CPU column: