Newsroom

Where Technology, Implementation & Analysis Intersect

10
Nov

Rodney Landrum on SSRS 2008

I recently attended a free event hosted by Vaco Orlando. Special guest speaker, Rodney Landrum, SQL DBA with UAFC, spoke on the value of integrating SQL Server Reporting Services (SSRS) into your organization from both a development and administrative point of view. Rodney gave a great overview of SSRS 2008, including the new control for map and spatial data visualization. This has to be one of the coolest new features of 2008 for me. I can certainly see how membership based companies as well as any prospect lead analysis could be greatly aided with this type of spatial presentation of data. Other topics discussed included understanding Business Objects (BO) reporting vs SSRS reporting and knowing when SSRS would be a better solution, as well as using Stored Procedures to improving reporting performance. I highly recommend Rodney's book Pro SQL Server 2008 Reporting Services. You can order a copy by clicking on the Amazon link on this page. According to Simple-Talk.com, Rodney Landrum has been architecting solutions for SQL Server for over 10 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has authored three books on Reporting Services including his most recent 2008 edition for Apress. You can view Rodney's complete profile at Simple-Talk.com

01
Nov

Often I'm asked, what's my next career move? In today's economy, it takes a flexible, well-rounded professional to be able to not only survive, but succeed. I consider myself to be of that mindset. As a sales, marketing, and operations strategist with over 20 years of IT experience, I've been successful as a consultant and as an internal employee. While I am comfortable continuing with consulting, for the right opportunity, I definitely would consider a full-time position. My first 10-12 years were spent in infrastructure. The last 10 have been spent in data management, analysis and assisting developers in the SDLC on many projects. My strongest IT skills are in the realm of RDMS and SQL. Overall, companies benefit from my exceptional understanding of business and my ability to communicate effectively with various levels of a team. I take pride in being able to make a difference in a company and moving the needle. Understanding a companies business goals and objectives I can analyze the current data and procedures, identify broken processes, and missed opportunities. From there I can effectively design and implement a strategic plan working with the necessary departments and resources to bring about positive improvement and growth. I would be happy to meet with you to discuss any opportunities you may have. Craig Glenn

18
Oct

It has been my experience that most data anomalies can be traced back to an unmanaged, undocumented, or forgotten business process. Oftentimes, business rules are established, programs and processes are implemented and then left to survive on their own. The mindset is, set it and forget it. If only it was that easy. As Director of Operational Analysis with a multi-million dollar company, one of my specialties was to look for and identify lost opportunities for revenue. Surprisingly, this did not always take the form of new business development. Many times my task was to simply identify "leaks" in business processes. In numerous instances, I was able to identify data anomalies which lead to the recovery of tens of thousands of dollars. Data anomalies can take many forms but are often found in large data groups. By trending revenues, analyzing declines and working backwards through processes, these anomalies can help businesses identify broken or mismanaged processes. Often business rules are broken because of lack of communication between departments, programmers, management, or all of the above. Having a business analyst watch for anomalies is key to managing processes and keeping your business on an upward trending track. Managing Data Anomalies A membership-based company in which I worked has an annual renewal for their membership product. At the time of this example, there were two payment plan options for the membership renewal, Full Payment

07
Jul

Trojan msiexec.exe

I thought I would share my notes on how I removed some malware from one of our PC’s.  This is not meant to be complete documentation of the trojan associated with msiexec.exe, but rather my experience and how I got it to go away.  So tread lightly and I hope this information is helpful to someone else. OS: Windows Vista Date: 7/6/2011 ATTENTION: See disclaimer at the bottom of this post before you do anything! Received a pop up asking for permission to run application msiexec.exe from unknown publisher Said NO Pop up was persistent and would not go away, even after reboot Googled (on different machine) mostly finding that this was a necessary windows file and to not kill the process I tried to kill it anyway because it was from an unknown publisher.  I was unsuccessful. Found that this was in fact a Trojan masking as a legitimate Windows file.  You can tell the difference by the file location.  The legit Windows file is located in the windows/system32 directory but the trojan is typically found in the users/name/appdata/local/temp/ directory. I found the offending file there and deleted it. Reboot File came back just like magic! Ran AVG but found nothing.  I think this is because I never really allow the trojan to load. I did read somewhere that if you say yes to continue and allow the app to run that AVG will catch it.  I didn’t want to take that chance. Reboot Windows Vista in safe mode. Deleted all temp files in the users/YOURUSERNAME/appdata/local/temp directory. As well and windows temp just for

30
Jun

Certified WordPress Developer

Craig Glenn is now a Certified Wordpress Developer!