Displaying results for:

Get Started with SQL on Azure

SQL Azure Logo Piraeus Consulting

If you are a developer interested in leveraging the power of the cloud for your project, Microsoft’s Azure is one of the leading platforms to consider. Microsoft has gone “all-in” on the cloud and that includes the venerable SQL Server. If…

Read More »

SQL Error

Dealing with failures is an all-too-common feature of our complex, interconnected digital world. Here are some tips I’ve found for understanding and resolving errors with SQL Server and a couple of my “favorite” errors. Step 1: Review the logs When…

Read More »

FeatureImage_5SlowSQL2

As analysts, one of the most powerful ways to boost our capabilities is to learn SQL, so it’s no surprise that basic SQL knowledge is becoming ubiquitous. However, analysts looking to sharpen their skills commonly overlook the necessity for a…

Read More »

FeatureImage_6EasyETL_2

Processing Data Flow tasks in parallel allows multiple items to be completed simultaneously thus reducing overall execution length. Place multiple non-dependent data flow tasks within the same sequence container without data flow connectors enforcing a sequential flow. 2. Specify column…

Read More »

FeatureImage_QuickandDirty

It’s the call every database engineer dreads: a critical (and usually well-behaved) query has been running for hours with no end in sight. SLAs are at stake. The pressure is rising. The DB-A Team isn’t taking your call. It’s time…

Read More »

FeatureImage_FakingWebForm

It’s a common situation: you need some simple data entry forms and reports, but you’re facing one of the following blockers, and you have insufficient budget to work around them: You have complex business rules to implement, but no database…

Read More »

Contact Us Terms & Conditions Sitemap Privacy © 2016 Piraeus Consulting LLC a Beyondsoft Company All Rights Reserved