SQL: 2013

Friday, December 20, 2013

2014 Technology Predictions Series: MapR Technologies on Big Data

As 2013 winds down, it's only natural for people to make personal New Year's resolutions for 2014. It's also a perfect time for technology industry predictions.

This is the fourth installation in our multi-part "Technology Predictions for 2014series in which industry providers--from Big Data to cloud to mobile--share their predictions about the hot tech trends that will take center stage in 2014. We'll be sharing all the predictions we've heard with you over the next several days.

MySQL Development

Dedicated mysql database programmer, mysql database programming are needed to make a good website. In these days when you have created an e-commerce site to a web application development company India there are certain things you need to keep in mind. The main thing that you should look into their services they provide and the experience of the team members. The team has the experience in developing dynamic website development, e - commerce shopping cart, database management, security, project management, and much more. They have the expertise in PHP, VBScript, MySQL, Javascript, and XML.

Few of the software development companies offer specialized internet marketing solutions, CMS , PHP programming and design, e- mail marketing, affiliate marketing, directory portals , web applications maintenance of websites and include much more . There are many companies of PHP India which offer services geared to the actual cost and the result for customers. If necessary, they develop the software open source development that helps you improve your business. If you are looking for an offshore PHP development companies are a better choice. They provide some services, such as

CachMonitor 2.06

CachMonitor is an SQL development tool for InterSystems database Cach . It features an advanced SQL query editor with SQL syntax highlighting, SQL code completion with context sensitive information about database objects (also known as Intellisense), an SQL history buffer for executed SQL commands, SQL code formatting, parallel queries, graphical SQL execution plan with index and selectivity information from every used index in the plan, SQL abbreviations, and much more.

RELEASE NOTES: For ENH, this release adds drag-and-drop for Server and Server-Groups moving within the server navigator, Server Navigator with a toolbar to show important actions, a trial license for evaluation of CachMonitor Professional which can be requested online via the Manage-License Dialog, a new Script Navigator for easy working and navigation with many (SQL) scripts, and Query Analyzer which shows the file path from the current file in the status bar.

CachMonitor 2.0.2

CachMonitor is an SQL development tool for InterSystems database Cach . It features an advanced SQL query editor with SQL syntax highlighting, SQL code completion with context sensitive information about database objects (also known as Intellisense), an SQL history buffer for executed SQL commands, SQL code formatting, parallel queries, graphical SQL execution plan with index and selectivity information from every used index in the plan, SQL abbreviations, and much more.

RELEASE NOTES: You can now write SQL queries across namespaces. This release added "mapped tables" and "federated namespace", an "Auto register CachServer" function that makes it straightforward to create a Server registration from local Cachinstallations, improvedhex view, a "Navigate to last selected object" feature, the ability to rename server groups, a way to change the table name for the "Copy table". The Class Browser no longer shows system classes.

Schoology: Integrations/API Web Developer (PHP)

LOCATION: New York, NY

URL: Schoology is one of the fastest growing education technology companies, with more than 2 million users across the world. We have redefined the learning management system to make online education a community effort between the students, the teachers and the parents.

Working at Schoology offers you a chance to help solve the most important challenges in education in an environment that's fun, collaborative and innovative.We need smart, creative individuals who are passionate about education and aren't afraid to show it.And if you play a mean game of pool or Pac Man, you can show off those talents here, too!

Are We There Yet? Grace Hopper Conference 2012

I recently attended the . What an amazing experience! GHC offers a breadth of technical talks, career development, networking, and role models for technical women. This year over 3500 attendees converged onto the Baltimore Convention Center: about half were undergraduate and graduate students in computer science; the rest were tech women from industry and academia.Are We There Yet? The keynote speaker, Nora Denzel, a tech executive formerly of Intuit, HP, and IBM, delivered an on the conference theme, "Are we there yet?" Her definitive answer was "no": in fact, the fraction of tech jobs held by women has declined to 25%, down from 30% a decade ago. This is a concern because research has shown that more gender diverse teams make better decisions.Not Your Normal Tech Conference. Unlike many tech conferences, GHC included talks and panels on a breadth of technical topics. Within a three-day period, I attended interesting discussions about , , , and enterprise social networking. The goal was to share cutting-edge academic research and the latest best practices from industry.Career Development. Another unique aspect were the panels on career development. Catalyst research firm led a session on "Sponsors or mentors: which will get you there?" The takeaway was that mentoring is essential, but sponsorship is . There were ample opportunities for informal networking; over lunch I learned about , a community of women developers in the Bay Area who get together for hacking sessions.Making a Difference. Can one woman or organization make a difference on diversity? The resounding answer at GHC was "yes!" Take for example Harvey Mudd College, a small 750-student engineering college, which this year ranked #1 among schools in GHC attendance, with 58 attending. After in recruiting and retaining female CS majors, Harvey Mudd's fraction of female CS grads jumped from 10% in 2005, to 40% this year.Don't Just Take my Word. Check out this Storify overview of GHC: (click on "Next Page" to load each day's summary.) - Full Post

What's New at Hadoop Summit 2013?

YARNYARN, the new cluster resource manager in Hadoop 2.0, was a major theme at last week's . Although the project itself is not new (in fact, it has been in for several years), what's new is its growing adoption by the Hadoop community. YARN (Yet Another Resource Negotiator) plays a in Hadoop 2.0: it is the cluster resource manager that allows you to run multiple computing frameworks, such as Storm or Spark, in addition to MapReduce, all on the same Hadoop cluster.There was evidence of community adoption of YARN throughout Hadoop Summit: (1) a keynote by Yahoo! describing their production analytics stack built on YARN (), (2) talks about the to speed up Hive by 100x, which relies on YARN (through the new ), and (3) the announcement of YARN's release in , Hortonworks' latest distribution of Hadoop.YARN at Yahoo!According to the , YARN has been undergoing some serious load testing in production Yahoo! systems for personalization and ad targeting. Their YARN clusters run Storm, Spark, and HBase, in addition to MapReduce. This includes a 320-node Storm/YARN cluster that does stream processing, and an overall total of 400k YARN jobs per day. This Strata contains more details about the talk.Tez is a new compute framework that runs on YARN. Tez improves upon MapReduce by supporting the execution of a complex DAG of tasks, beyond the simple map-reduce pattern of MapReduce. Tez is thus more suitable for expressing SQL queries, and will be leveraged to speed up Hive jobs.Hadoop on Rasberry PiHadoop Summit has traditionally been the place to brag about who has the biggest clusters; however, this goes to the opposite extreme :) - Full Post

Saturday, July 6, 2013

Oracle PL/SQL Best Practices, 2nd Edition

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11g, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other. This book offers practical answers to some of the hardest questions faced by PL/SQL developers, including:What is the best way to write the SQL logic in my application code?How should I write my packages so they can be leveraged by my entire team of developers?How can I make sure that all my team's programs handle and record errors consistently?Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance. This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications. "This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals." - Dwayne King, President, KRIDAN Consulting.Download Link: - Full Post

SQL Server Deadlock Graph from SQL Profiler

The first place to start troubleshooting deadlocks similar to the one above is to look at the execution plans for both of the contributing processes. In this case, the plan of interest is for the Selecter process as shown below:

However, before attempting to implement some sort of fix, try running each of the queries involved in the deadlock through SQL Server’s Database Engine Tuning Advisor, as the Tuning Advisor might recommend some new indexes for the queries. A lot of deadlocks can be prevented by adding indexes, as the indexes will make queries faster and reduce the amount of time a resource is locked.
To tune a query:
1.Open SQL Server Management Studio and paste one of the deadlocked queries into a new query window.
2.Analyze the query in Database Engine Tuning Advisor by right-clicking and selecting ‘Analyze Query in Database Engine Tuning Advisor’.
3.For the ‘Database for workload analysis’ field, select the database that you want to tune with, and select the same database in the ‘Select databases and tables to tune’ section.
4.Press the Start Analysis button in the top toolbar.
5.If the Tuning Advisor suggests any indexes, they will appear in the ‘Recommendations’ tab in the ‘Index Recommendations’ section. To create the indexes, you can either select Actions->Apply Recommendations… to create the indexes immediately, or you can select Actions->Save Recommendations (or hit Ctrl+S) to script the indexes to a file that you can run later.
- Full Post

Hybrid SharePoint

A hybrid environment that uses SharePoint Server 2013 and SharePoint Online enables solutions that integrate functionality between services and features such as Search, Microsoft Business Connectivity Services, and Duet Enterprise Online for Microsoft SharePoint and SAP in both environments. This article describes the phases, solutions, and functionality that SharePoint Server 2013 and SharePoint Online hybrid environments support.

- Full Post

Azure Primer

These Windows Azure and SQL Database (formerly SQL Azure) tutorials are designed for beginners who have some .NET development experience. Using a common scenario, each tutorial introduces one or two Windows Azure features or components. Even though each tutorial builds upon the previous ones, the tutorials are self-contained and can be used without completing the previous tutorials.
The first four tutorials demonstrate how to use roles, Windows Azure Storage services, and SQL Database, which are the basics for learning Windows Azure.
- Full Post

Jython Podcast Site Ready

I finished the preliminary Jython Podcast website last week and I thought that it would be a good idea to release it to the world for your thoughts and opinions. I wanted to create and deploy the website as a Django site running on Jython. However, as it turns out I am unable to deploy a Django on Jython site to a server running on JDK 1.5 (at least I haven't figured out how to do it as yet). Therefore, I have had to postpone the deployment of the Django site until I can upgrade to JDK 1.6.It is my plan to begin the podcast with an episode near the end of December. Hopefully once I get the first episode released, iTunes will not have any problems updating to include it.Check out the Jython Podcast site . I also would like to thank for providing the domain name and sponsoring the podcast. - Full Post

Django-Jython: Working With Experimental Database Backends

This is the first of several blogs that I plan to publish regarding the use of experimental database backends with the Django-Jython project. In this series of blogs, I will cover the basics of how to begin using the experimental backends, as well as some details on how to create your own. At the time of this posting, only one "fully supported" backend exists for the Django-Jython project and that is for the PostgreSQL database. However, another experimental backend exists for SQLLite and there are more on the way.In order to build and begin using the experimental backend for SQLLite (or others), you must first obtain a copy of the code, which is available on the , or via your command-line using the following line:svn checkout http://django-jython.googlecode.com/svn/trunk/ django-jython-read-onlyOnce you've obtained the code, it is easy to build. Simply traverse into the root directory of the downloaded code which should be named "django-jython", and perform the build using the setup.py build script as such:jython setup.py buildNow, this works nicely for a build to use the PostgreSQL backend, but it will not include the experimental backend implementations. In order to do so, you must open up the setup.py script and add the experimental backend that you wish to use within the "packages" listing as follows:from distutils.core import setupsetup( name = "django-jython", version = "0.9", packages = ['doj', 'doj.backends', 'doj.backends..zxjdbc', 'doj.backends..zxjdbc.postgresql', 'doj.backends..zxjdbc.sqllite', # Experimental backend 'doj.management', 'doj.management.commands'], ... - Full Post

EMD Upload Error: Oracle Enterprise Management Agent

I came into work on Monday and saw that all of the databases which are running on our development database server were no longer reporting to our Oracle Grid Control. After looking at the Grid Control server, I realized that the management agent was not functioning correctly. Time to investigate... - Full Post

Java EE 7 by JSR

The following is a listing of JSRs that are contained in the Java EE 7 Specification.Java EE Platform Specification - JSR 107 - JCache JSR 236 - Community Utilities for EE JSR 338 - JPA 2.1 JSR 339 - JAX-RS 2.0 JSR 340 - Servlet 3.1 JSR 341 - EL JSR 342 - EE 7 JSR 343 - JMS JSR 344 - JSF 2.2 JSR 345 - EJB 3.2 JSR 346 - CDI 1.1 JSR 349 - Bean Validation JSR 352 - Batch Applications for the Java Platform JSR 353 - Java API for JSON Processing JSR 365 - WebSockets - Full Post

Controversies in Software Testing

My article "Controversies in Software Testing" was published in the .The issue is available now to anyone with a print subscription; the PDF will be available as a free download later in July.It's a ground-breaking issue -- the first three articles are written by , , and me, all members of the Miagi-Do School of Software Testing.I'll be sure to post the free link here when it's up. In the mean time, if you don't subscribe, take a look at the Planet. It's a bit of a lone voice in the UK/European test community, a group that could use some support right now.

- Full Post

Scale List Cleanup Utility for AutoCAD 2013/2014

Scale List Cleanup Utility has been updated so it now works for both and . When a file contains excess scales, performance may be negatively affected. Eventually, the file may become unusable. To use the file, some scales must be removed. This utility repairs affected files by removing excess scales. Nested external references (xrefs) may produce excess scales. To correct this problem, install AutoCAD 2008 Service Pack 1 or corresponding service packs for AutoCAD-based products. The Scale List Cleanup Utility repairs files affected before the necessary service pack was installed. You can also clean affected files unattended from the Command prompt. This utility works even without full . DWG TrueView 2013 can also be used. Notes: 1. The Scale List Cleanup Utility repairs files affected before AutoCAD 2008 Service Pack 1 or corresponding service packs for AutoCAD-based products. 2. Drawings created by AutoCAD based vertical applications may have one scale that will not be removed by this utility. The free utility is available among Autodesk’s Updates & Service Packs.

- Full Post

SSMPropEditor 5.0 as AutoCAD app

5.0 is now available as an app. SSMPropEditor is the Sheet Set Manager Properties Editor for AutoCAD based products. SSMPropEditor 5.0 can now be downloaded and installed as an app from the site. Purchase is also available through as well as from JTB World’s site. Right now I noticed that it was featured on ’s welcome page. In AutoCAD 2014 there is also a Featured Apps tab where I found it showing up. When installed, SSMPropEditor will show up on the Plug-ins tab. For details about the release of SSMPropEditor 5.0 see . Visit the page for all about the product and give the free trial a try.

- Full Post

HTools Menu for AutoCAD

is a plugin for that adds several useful functions. Drawing... - Full Post

Autodesk Infographics

If you are a fan of Infographics there are a few from Autodesk. Some a bit old and some newer but still interesting to review. Click on the images for a larger version. The first one is about Autodesk Brand & Business Transformation. Not long ago was launched. Via . And about 30 years of from 1982 to 2012. The next about Building Information Modeling for Infrastructure. And Improving Healthcare Buildings with BIM. And finally about Lost Opportunities Without 3D Product Design Software.

- Full Post

AutoCAD 2014 learning resources

Have you or will you start using ? If so you may find these learning resources useful. AutoCAD 2014 New Features & Enhancements Revealed is an interactive and free eBook with video, text, and images throughout 33 lessons. Tip via Autodesk’s Shaan Hurley’s . Take a look at and read the eBook , it’s free. Ralph Grabowski has put together “What's Inside? AutoCAD 2014”. Order your copy for $8 from is a Training Video consisting of 9 hours of learning by Shaun Bryant. See also: More .

- Full Post

JTB FlexReport 7.4 released

Software usage and monitoring product has been updated to version 7.4. . See also the . Customers with maintenance have access to this release at no extra cost. Main news are: Added feature description download button to JTB FlexReport Config>Features. Descriptions are taken from this that has been updated with Autodesk’s 2014 products. Edit functionality for auto report settings. But there are much more, see the for more details on this release. to get a time limited license file for free. You can try it in your environment with your real data for a few weeks with full functionality. Full support is provided during trial period. About JTB FlexReport: JTB FlexReport from JTB World is a report and monitoring tool for applications using the FlexNet / FLEXlm (flexlm license manager), IBM LUM (IBM License Use Management), SPLM (Intergraph SmartPlant License Manager), SLM/Sentinel LM/Sentinel RMS, LM-X, Solidworks SNL License Manager, T-Systems license manager product LICMAN, Vertex Systems, MathLM (Mathematica), Primavera from Oracle or 12D software licensing. With any Windows application like Acrobat, Visio, Bentley MicroStation, single licensed AutoCAD or AutoCAD LT can be reported usage of. See also: and as well as the guide to the for FlexNet/FLEXlm in general and Autodesk licensing in particular as well as our freeware .

- Full Post

Autodesk Robot Structural Analysis Professional 2014 network license

RSA 2013 to RSA 2014 Pro network license issue Autodesk customers already owning Autodesk® Robot™ Structural Analysis 2013 will be automatically upgraded to Autodesk® Robot™ Structural Analysis Professional 2014. For the network installations under subscription, as usual once upgraded, you will need to get a new license file. The new license file will be valid for the current and prior 3 version of the product but, this concerns the Professional versions only. In fact, if you previously had an Autodesk® Robot™ Structural Analysis 2013 network license, you will not be able to get a license from the new file. You have to request a combined file that integrates both the 2014 Professional and the 2013 (). Note: combining the files that you own won’t work as they have different issue dates. If you upgraded from Autodesk® Robot™ Structural Analysis 2013 Professional version everything is fine with the new license file. Via Up and Ready’s . For more about and usage reporting using .

- Full Post

JTB FlexReport 7.4.2

This new version of license report solution solves the following issues: Fixed an issue with the Get Feature Descriptions in JTB FlexReport Config where it just did not work to get the descriptions. Fixed a bug in the Access database table tblAppName that causes feature and description to be padded with up to 255 spaces causing among other things issues with some of the reports. Running JTB FlexReport as normal after upgrading to 7.4.2 on a problematic database will automatically fix the issue. Note that it is only JTB FlexReport Core that is updated to 7.4.2. Uninstall existing JTB FlexReport Core and install the new one. Here are the and . If you use SQL Server there is no need to upgrade between 7.4.1 and 7.4.2. Previous release: to get a time limited license file for free. You can try it in your environment with your real data for a few weeks with full functionality. Full support is provided during trial period.

- Full Post

Autodesk Fusion 360 and GrabCAD

Inventor Fusion import and editing functionality was removed from and in the meantime there has been a beta program of Autodesk Fusion 360. A couple of days ago was released. It is free for the next 90 days, and upon expiration of the 90-day initial offer will be available for purchase from the for $25 per month, per user, based on annual contract commitment. Special pricing is available for students and entrepreneurs. “Autodesk Fusion 360 brings together capabilities typically found in separate mechanical, industrial and conceptual design tools into one, easy to use cloud-based service. Fusion 360 offers a radically intuitive user experience, secure access to design information and integrated social collaboration features. Customers can design faster, work anywhere and share with anyone.” Today it was that Autodesk Fusion 360 and AutoCAD 360 will be available on GrabCAD Workbench. “Autodesk and GrabCAD have teamed together to bring you the power of Autodesk Fusion 360 and AutoCAD 360 with the convenience of GrabCAD Community and Workbench.” AutoCAD 360 is already there and Autodesk Fusion 360 is coming soon.

- Full Post

How to purge DGN linetypes in DWGs

Have you problem with DWG files that have become bloated while copying and pasting from DWGs containing DGN linetypes of MicroStation origin or after using DGNIMPORT? AutoCAD DGN Clean-up Tool can be downloaded here and help you out. UPDATE: The download is not available as Autodesk is working on a bug fix. This Hotfix applies to AutoCAD 2013, Autodesk AutoCAD 2014, and related vertical products. Here’s the most important parts from the readme: Installation and Execution Instructions 1. Close all software applications. 2. Download the Hotfix (AutoCAD_2013_2014_DGN_CleanUp_Tool.exe) to a location on your local computer. 3. To install the fix, double-click the ZIP executable and save the file to the product installation folder (for example C:\Program Files\Autodesk\AutoCAD 2013). (My comment: As far as I can see the DLL don’t have to be in the product installation folder, I tried to put it in c:\temp and it worked just fine) To Execute This Hotfix 1. Start up AutoCAD. 2. Netload DgnLsPurge.dll. 3. Open the affected drawing file. 4. Run the DGNPURGE command to make the elements purge-able. 5. PURGE. 6. Repeat steps 4-5 if needed. 7. Save the DWG. 8. Repeat steps 3-7 for other affected files. Here is what it can look like when running DGNPURGE: Command: DGNPURGE Purged 18 unreferenced complex linetype records (of 20). Purged 155 unreferenced strokes (of 157). But the current version of DGNPURGE seems to be affecting lines that are using DGN linetypes too in some cases. Compare with the image above. Autodesk is now aware of that compound linetypes are not handled properly and is working on an update of the tool. If you want to purge many drawings our can be used to automate the work. Here is an example of what the AutoLISP code would look like. Note that even though SmartPurger runs a purge the LSP is loaded after so we need to run purge through the LSP instead. If you like you can change the number of times this is repeated. Right now it is 3 times. Edit the path as needed and remember to use \\ instead of \. (command "._NETLOAD" "C:\\Temp\\DgnLsPurge.dll") (repeat 3 (command "._DGNPURGE") (command "._PURGE" "_A" "*" "_N") ) For technical details around purging traces from DGN linestyles see this post on . Complex DGN linestyles – that presumably cannot be mapped directly to standard AutoCAD linetypes – have entries in their Extension Dictionaries named “DGNLSDEF”. These objects contain references to objects in the “ACAD_DGNLINESTYLECOMP” dictionary (which is inside the root Named Objects Dictionary). The objects in this dictionary represent the “strokes” in the linetype. They might be simple (in the case of STROKE1, above) or more complex. Complex strokes can refer to each other and also to anonymous blocks in the Block Table. UPDATE: about the issues found in the first release and source code for the fix.

- Full Post

Give Away of Autodesk AutoCAD 2013 Practical 3D Drafting and Design

Autodesk AutoCAD 2013 Practical 3D Drafting and Design by João Santos. is together with Packt Publishing having a give away of this new book for 3 lucky winners that have the chance to win eBook copies of the book. Who is this book for? Anyone who wants to create accurate 3D models in AutoCAD, like architecture, engineering, or design professionals, and students. Only basic understanding of 2D AutoCAD is needed. If you’re next step is to learn about how to create 3D shapes and models, view and navigate a 3D model, understand 3D coordinate systems and even lighting and materials so you can create photorealistic images this book could be a good help. My Review I think João has done a good job to cover the subjects in an digestive manner. It is easy to follow along and there are good pictures throughout the book that helps to understand how each task is done. You will also find the exercises easy to follow so you can put theory into practice. Example files are available for download. With the help of this book you will learn most everything that is worth knowing about 3D modeling, drafting and design in . It covers versions of AutoCAD up to . and functionality is not covered though. The 374 pages book is available both in print and in electronic formats like PDF and you can get it from Packt Publishing as well as from some other online stores. Visit for all details, table of contents, sample chapters and to purchase. How to Enter this give away? Head on over to the book page () and look through the product description of the book and drop a line via the comments below this post to let us know what interests you the most about this book and why you would find it useful. Deadline: The contest will close on 7th July 2013 and 3 winners will be selected randomly. Winners will be contacted by email, so be sure to include your email address when you comment or in addition to the comment you can your email address in case you don’t want it to be seen in the comment!

- Full Post

Creating packages in code

This is just a quick one prompted by a question on the , how to programmatically add a precedence constraint (aka workflow) between two tasks. To keep the code simple I’ve actually used two Sequence containers which are often used as anchor points for a constraint. Very often this is when you have task that you wish to conditionally execute based on an expression. If it the first or only task in the package you need somewhere to anchor the constraint too, so you can then set the expression on it and control the flow of execution. Anyway, back to my code sample, here’s a quick screenshot of the finished article: Now for the code, which is actually pretty simple and hopefully the comments should explain exactly what is going on. Package package = new Package();
package.Name = "SequenceWorkflow";

// Add the two sequence containers to provide anchor points for the constraint
// If you use tasks, it follows exactly the same pattern, they all derive from Executable
Sequence sequence1 = package.Executables.Add("STOCK:Sequence") as Sequence;
sequence1.Name = "SEQ Start";
Sequence sequence2 = package.Executables.Add("STOCK:Sequence") as Sequence;
sequence2.Name = "SEQ End";

// Add the precedence constraint, here we use the package's constraint collection
// as it hosts the two objects we want to constrain (link)
// The default constraint is a basic On Success constraint just like in the designer
PrecedenceConstraint constraint = package.PrecedenceConstraints.Add(sequence1, sequence2);

// Change the settings to use a (dummy) expression only
constraint.EvalOp = DTSPrecedenceEvalOp.Expression;
constraint.Expression = "1 == 1";

The complete code file is available to download below.

- Full Post

SQL Profiler Through StreamInsight Sample Solution

In this I show how you can use StreamInsight to take events coming from SQL Server Profiler in real-time and do some analytics whilst the data is in flight. Here is the solution for that post. The download contains Project that reads events from a previously recorded trace file Project that starts a trace and captures events in real-time from a custom trace definition file (Included) It is a very simple solution and could be extended. Whilst this example traces against SQL Server it would be trivial to change this so it profiles events in Analysis Services. Enjoy. - Full Post

StreamInsight and Reactive Framework Challenge

In his Roman from the StreamInsight team asked if we could create a Reactive Framework version of what he had done in the post using StreamInsight. For those who don’t know, the Reactive Framework or Rx to its friends is a library for composing asynchronous and event-based programs using observable collections in the .Net framework. Yes, there is some overlap between StreamInsight and the Reactive Extensions but StreamInsight has more flexibility and power in its temporal algebra (Windowing, Alteration of event headers) Well here are two alternate ways of doing what Roman did. The first example is a mix of StreamInsight and Rx var rnd = new Random();
var RandomValue = 0;
var interval = Observable.Interval(TimeSpan.FromMilliseconds((Int32)rnd.Next(500,3000)))
.Select(i =>
{
RandomValue = rnd.Next(300);
return RandomValue;
});

Server s = Server.Create("Default");
Microsoft.ComplexEventProcessing.Application a = s.CreateApplication("Rx SI Mischung");

var inputStream = interval.ToPointStream(a, evt =>
PointEvent.CreateInsert(
System.DateTime.Now.ToLocalTime(),
new { RandomValue = evt}), AdvanceTimeSettings.IncreasingStartTime, "Rx Sample");

var r = from evt in inputStream
select new { runningVal = evt.RandomValue };

foreach (var x in r.ToPointEnumerable().Where(e => e.EventKind != EventKind.Cti))
{
Console.WriteLine(x.Payload.ToString());
}

This next version though uses the Reactive Extensions Only

var rnd = new Random();
var RandomValue = 0;
Observable.Interval(TimeSpan.FromMilliseconds((Int32)rnd.Next(500, 3000)))
.Select(i =>
{
RandomValue = rnd.Next(300);
return RandomValue;
}).Subscribe(Console.WriteLine, () => Console.WriteLine("Completed"));

Console.ReadKey();

These are very simple examples but both technologies allow us to do a lot more. The ICEPObservable() design pattern was reintroduced in StreamInsight 1.1 and the more I use it the more I like it. It is a very useful pattern when wanting to show StreamInsight samples as is the IEnumerable() pattern. - Full Post

Paging the query result

If you have 5000 products in database, you may like to show them in pages on the screen. It’s a common request to only retrieve the records on a certain page. This query must be quick and efficient if we are talking about millions of records in a table for an AJAX control.
In Oracle, we can do this:
SELECT * from
(
SELECT *, ROWNUM as rownumber from Product order by name
)
where rownumber between (PageNbr - 1)*PageSize + 1 and PageNbr*PageSize
As you can see, this query needs to fetch all rows first then narrows down the result. A more efficient query is:
select *
from ( select a.*, rownum rnum
from ( select * from product order by name) a
where rownum <= PageNbr*PageSize)
where rnum >= (PageNbr - 1)*PageSize + 1
Oracle will optimize this query, so it is not as resource intensive as the first one.
In SQL Server 2005, we can do similar query:
WITH Temp AS
(
SELECT row_number() OVER (ORDER BY [name]) AS rowNum, * from Product
)
SELECT * FROM Temp
WHERE rowNum between (@PageNbr - 1) * @PageSize + 1 and @PageNbr * @PageSize
ORDER BY [name]
The query had been optimized in SQL Server as well. - Full Post

Microsoft Releases SQL Server 2014 Preview

ADT MagazineThe announcement comes one day before the Build 2013 developer's conference in San Francisco. The Windows Azure cloud was first and foremost in Microsoft's messaging about the new software, touting the company's "Cloud OS." "Microsoft has made a ... - Full Post

Friday, July 5, 2013

Job vacancy : Python/Django Web Programmer (Dupont Circle)

2+ years experience with Python and Django • Strong web application development experience • JQuery, & Javascript experience • Strong SQL and DB knowledge • Strong Linux/Unix experience • Ability to work effectively ...

Friday, December 20, 2013

Saturday, October 19, 2013

Tuesday, October 8, 2013

Thursday, July 25, 2013

Friday, July 19, 2013

Sunday, July 7, 2013

Saturday, July 6, 2013

Friday, July 5, 2013