(Evan Lenz) Some of you may have noticed that as of release 5, MarkLogic has a new entry page on port 8000:
Other News
Creating and using Report Parts in Report Builder 3.0
(Arshad Ali) Report Builder 3.0, which comes with SQL Server 2008 R2, is a new enhanced report development and report authoring tool intended to be used by business users for ad-hoc reporting.
Solving Performance Issues in Data Migration to SQL Server
(Phani Krishna Kollapur Gandla) A Performance engineering engagement has been conducted for one of the leading automobile insurance companies in Canada. As per the customer decision to reduce the operational and maintenance expenditure, the data residing in different data stores such as DB2 and Orac
Invoking Server Side code using ASP.NET AJAX Client Callback on Web browser close
(Roopesh Reddy) If your ASP.NET web application creates temporary data for the each session, it needs to be deleted while user logs out. If you use InProc session mode, then you can handle Session_End event in the Global Application file(Global.asax) to clear the temporary files.
Granting Access and Binding Defaults when recreating SQL Tables
(David Musgrave) This is a follow on post from my previous article: Backing up and Restoring data when recreating SQL Tables which explains how to recreate tables (usually to fix table structure issues) while making sure that the data is preserved.
Never say ‘there is no way’
(Giuseppe Maxia) Reading a recent MySQL book, I saw an example of SHOW CREATE TABLE that comes with backticks (`) around the table and column names, and a comment:
SQL SERVER – DVM sys.dm_os_sys_info Column Name Changed in SQL Server 2012
(Pinal Dave) Have you ever faced situation where something does not work? When you try to fix it ‑ you enjoy fixing it and started to appreciate the breaking changes. Well, this is exactly I felt yesterday.
Effectively use DB2 data movement utilities in a data warehouse environment
(Mohankumar Saraswatipura) Choosing proper data movement utilities and methodologies is key to efficiently moving data between different systems in a large data warehouse environment. To help you with your data movement tasks, this article provides insight on the pros and cons of each method with IB
Leadership vs. Career Building
What’s Going On Out There? Only you know for sure. There are so many things happening in the software world today, it is an utterly futile task to report on it all effectively. In order to increase the value of SSWUG to all of our readers, we are enabling you to increase our awareness by becoming a "Field Reporter." Intrigued? […]
SSWUG TV – Interview with Itzik Ben-Gan, SQL Server MVP and co-founder of SolidQ.
Pro-Center Video Programming for IT Professionals