(Adam Ronthal) Speed is a vital imperative in today’s business climate. For organizations seeking a fast and agile way to analyze very large data sets, IBM DB2 with BLU Acceleration data management represents a tremendous leap forward in intelligent, in-memory database analytics.
Other News
Joining Data from Disparate Sources
Moving away from rational databases as a data storage technique may have its own set of problems to solve. For example, what do you do when you have two collections of data with a common attribute (like a foreign key in a relational database) on which you join the two sets, resulting in a new set of data with attributes […]
Undocumented SQL Server 2012 Database Mail Procedures
Undocumented SQL Server 2012 Database Mail Procedures SQL Server 2012 supports the following useful undocumented database mail stored procedures: sp_RunMailQuery sp_SendMailMessage sp_sysmail_activate sysmail_verify_account_sp sysmail_verify_principal_sp sysmail_verify_profile_sp sp_RunMailQuery The sp_RunMailQuery database mail stored procedure is used to run the mail query. This stored procedure is used in the sp_send_dbmail stored procedure to execute a query if query is specified. Syntax sp_RunMailQuery [...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
SQL Server Analysis Service (SSAS) Changing a Source Table and a Data Source View (DSV)
(Scott Murray) So you did everything correctly with your OLAP project. You had a trained Project Manager leading the team; users were directly involved from the beginning and you had clear definitions of the scope of the project and ultimately all the various reporting needs and objectives. You even
Importing Dynamics GP AR Apply records using SQL
(Steve Endow) I was working with a customer this morning who had recently imported and posted 2,800 AR cash receipts. Only after posting the cash receipts did they realize that the payment applications for those cash receipts did not import.
Creating custom authentication filter in ASP.NET MVC
(Sheo Narayan) In this article, we shall learn how to create custom authentication filter in ASP.NET MVC 5+ using built in Authentication filter.
WPF Menu Controls Class Hierarchy
(Richard Carr) The eighty-first part of the Windows Presentation Foundation Fundamentals tutorial looks at the base classes of the WPF menu controls. This article includes the inheritance hierarchy of all of the WPF controls seen in the tutorial so far.
Node.js Transform Streams vs. Through2 Streams
(Ben Nadel) As I’ve been trying to get my Gulp.js build script to work, I’ve found it necessary to dip down into Node.js and learn about streams. According to the Gulp.js documentation, all Gulps.js plugins are Transform streams, running in “Object Mode,” that accepts and emit vinyl File objects.
Back to Buffer Pool Basics: Part 5B – VPSEQT and VPPSEQT
(Willie Favero) Before we jump into discussing the different variable buffer pool thresholds, the defaults for the fixed buffer pool thresholds are: immediate write threshold (IWTH) – 97.5%, data management threshold (DMTH) – 95%, and prefetch threshold (SPTH) – 90%. Now we’ll discuss sequential s
Integrate the Information Governance Catalog and IBM InfoSphere DataStage using REST
(Deepa Ramamurthy Yarangatta) IBM InfoSphere DataStage is a data integration tool that lets you move and transform data between operational, transactional, and analytical target systems. In this article, learn to use InfoSphere DataStage to integrate with the REST resources of the Information Govern