(Ben Nadel) Over the last week, I’ve been diving deeply into the concept of global times and Daylight Saving Time (DST), exploring the Java Timezone and Calendar classes and seeing how date/time values can be translated around the globe.
Other News
Blowing up in memory
(Domas Mituzas) MySQL isn’t too concerned about table handler memory usage – it will allocate row size buffer thrice per each table invocation. There’s a few year old bug discussing UNION memory usage – for each mention in an union one can allocate nearly 200k of unaccounted memory – so a megabyte s
Delete Duplicates using CTE in SQL Server
(Kumar Shah) This is a blog post for future reference and this has proved useful to me over the past year ever (ever since I found it online). And it’s time to transfer the method from email to blog.
Sound system architecture helps avoid SharePoint 2010 project pitfalls
(Brien M. Posey) Anyone who has ever deployed SharePoint 2010 understands that a lot of planning needs to go into the process. Even so, unforeseen issues can arise during deployment. More often, such issues do not become apparent until long after the deployment process has been completed and the Sha
Script table as – ALTER TO is greyed out – SQL SERVER
(Vadivel) One of my office colleague recently asked me why we are not able to generate ALTER Table script from SSMS. If we right click on the table and choose “Script Table As” ALTER To option would be disabled or Greyed out. Is it a bug?
Bringing Business Analytics to Big Iron
(Julian) Traditionally DB2 for z/OS was considered to be primarily an OLTP data server, with the DB2 for Linux, Unix and Windows variant being a more common choice for analytics and data warehousing duties.
SQL SERVER – Denali – Date and Time Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS() – TIMEFROMPARTS() – SMALLDATETIMEFROMPARTS() – DATETIMEOFFSETFROMPARTS() – A Quick Introduction
(Pinal Dave) In SQL Server Denali, there are seven new datetime functions being introduced, namely:
IBM Cognos Proven Practices: Fit PDF Report Output to Page in IBM Cognos BI Report Studio
(Marc Reed) This short guide demonstrates an easy method of making a report PDF output fit to page, both vertically and horizontally, without impacting the HTML view.
Map Reduce Explained
SSWUG TV With Stephen Wynkoop What, Mango on the Windows Phone? Check it out on SSWUG TV. Map Reduce Explained David shares more insight into the history of the Map Reduce pattern. His practical explanation should provide some ideas for how you can utilize this pattern in your own systems. David Writes: The description of Map and Reduce is not […]
SSWUG TV – Interview with Mark Tabladillo, SQL Server MVP and acclaimed data mining instructor
Pro-Center Video Programming for IT Professionals