THE WEST 136th STREET [200th] BLOCK ASSOCIATION
Menu
Thank you for completing the form! If you haven't please click the button below for your annual membership dues
.
Please click the button below to pay your annaual dues in the amount of $25.00


Members
{{recruiter.last.lastName}}
MIL Projects:
MIL
NaviGator
PropaGator
SubjuGator
Major:
Graduation:
E-mail:
Linkedin:


- TL;DR
- Introduction to Keycloak
- Ideas behind Keycloak.AuthServices.Authentication
- Demo
- Bonus - Adding Authorization
- Summary
TL;DR
Learn how to use Keycloak in ASP.NET Core 6 by using Keycloak.AuthServices.Authentication.
Introduction to Keycloak
Keycloak - Open Source Identity and Access Management. Add authentication to applications and secure services with minimum effort. No need to deal with storing users or authenticating users. Keycloak provides user federation, strong authentication, user management, fine-grained authorization, and more.
Personally, I’m a big fan of Keycloak because it is a mature and full-fledged identity and access management system. It contains everything you might need for most of the scenarios. Contrary to IdentityServer it is easy to use out-of-the-box with no code required to get things going. If Azure Active Directory is not an option for some reason I definitely consider Keycloak as a viable open-source option that could be installed on-prem.
Features:
- Single-Sign On
- Identity Brokering and Social Login
- User Federation
- Admin Console
- Account Management Console
- Authorization Services
See: https://www.keycloak.org/
Ideas behind Keycloak.AuthServices.Authentication
Keycloak is OAuth2 + OpenID Connect compliant provider so it should be easy to use it. Although, it takes some time to may Keycloak concepts and configuration to ASP.NET Core Authentication configuration model. That is the way I’ve prepared a convenience library to speed up the integration process and make using Keycloak in .NET world more enjoyable.
Basically, we use AddKeycloakAuthentication
to register and configure JwtBearerDefaults.AuthenticationScheme
authentication scheme and provide KeycloakAuthenticationOptions
.
/// <summary>
/// Adds keycloak authentication services.
/// </summary>
public static AuthenticationBuilder AddKeycloakAuthentication(
this IServiceCollection services,
KeycloakAuthenticationOptions keycloakOptions,
Action<JwtBearerOptions>? configureOptions = default) {/*...*/}
The overall project structure looks like this:
var builder = WebApplication.CreateBuilder(args);
var services = builder.Services;
services.AddKeycloakAuthentication(authenticationOptions);
var app = builder.Build();
app.UseAuthentication();
app.UseAuthorization();
app.MapGet("/", (ClaimsPrincipal user) =>
{
app.Logger.LogInformation(user.Identity.Name);
}).RequireAuthorization();
app.Run();
Configure KeycloakAuthenticationOptions
The are various ways to configure Keycloak authentication. Later, I will show you how to use Keycloak OIDC client adapter seamlessly.
1⃣ Construct object
var authenticationOptions = new KeycloakAuthenticationOptions
{
AuthServerUrl = "http://localhost:8088/",
Realm = "Test",
Resource = "test-client",
};
services.AddKeycloakAuthentication(authenticationOptions);
2⃣ Read manually from configuration
var configuration = builder.Configuration;
var authenticationOptions = configuration
.GetSection(KeycloakAuthenticationOptions.Section)
.Get<KeycloakAuthenticationOptions>();
services.AddKeycloakAuthentication(authenticationOptions);
3⃣ From configuration
var configuration = builder.Configuration;
services.AddKeycloakAuthentication(configuration, KeycloakAuthenticationOptions.Section);
// section is optional KeycloakAuthenticationOptions.Section = "Keycloak"
services.AddKeycloakAuthentication(configuration);
4⃣ From the configuration file
keycloak.json file used by the Keycloak OIDC client adapter to configure clients. You may also want to tweak this file after you download it.
var configuration = builder.Configuration;
var host = builder.Host;
host.ConfigureKeycloakConfigurationSource("keycloak.json"); // file name is optional
services.AddKeycloakAuthentication(configuration);
Demo
Before we start integrating we need to run an instance of Keycloak on a dev machine.
docker run -p 8080:8080 \
-e KEYCLOAK_ADMIN=admin -e KEYCLOAK_ADMIN_PASSWORD=admin \
quay.io/keycloak/keycloak:19.0.1 start-dev
Please refer to https://www.keycloak.org/getting-started/getting-started-docker for more details.
Let’s create our first realm.
- Open the Keycloak Admin Console
- Hover the mouse over the dropdown in the top-left corner where it says Master, then click on Add realm
- Fill in the form with the following values:
- Name: Test
- Click
Create
Create a user
Initially, there are no users in a new realm, so let’s create one:
- Open the Keycloak Admin Console
- Click
Users
(left-hand menu) - Click
Add user
(top-right corner of table) - Fill in the form with the following values:
- Username<EMAIL_ADDRESS>- First Name: Your first name
- Last Name: Your last name
- Click
Save
Let’s try to secure our first application. The first step is to register this application with your Keycloak instance:
- Open the Keycloak Admin Console
- Click
Clients
(left-hand menu) - Fill in the form with the following values:
- Client Type: “OpenID Connect”
- Client Id: test-client
- Click
Save
As mentioned above, Keycloak has a concept of adaptor config. It allows us to copy essential configurations. Keycloak.AuthServices.Authentication
is deliberately designed to streamline the installation process, so the KeycloakAuthenticationOptions
mimics the structure of the adapter config.
Navigate the newly created client (top-right) and click “Action>Download adapter config”
Here is what it looks like:
{
"realm": "Test",
"auth-server-url": "http://localhost:8080/",
"ssl-required": "external",
"resource": "test-client",
"public-client": true,
"verify-token-audience": true,
"use-resource-role-mappings": true,
"confidential-port": 0
}
💡 Generally, you want to use protocol mapper to configure the required audience (“resource” in the config above). To simplify the demo, we can just turn off Audience validation. Change “verify-token-audience”: false. See https://dbp-demo.tugraz.at/handbook/relay/keycloak/keycloak_audience/ and https://stackoverflow.com/a/53627747/8168625 for more details.
💡 Tokens should be exchanged based on HTTPS, but for the developer environment, you can use HTTP. Change “ssl-required”: “none”
Now, we can create keycloak.json or extend appsettings.json.
{
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft.AspNetCore": "Warning"
}
},
"Keycloak": {
"realm": "Test",
"auth-server-url": "http://localhost:8080/",
"ssl-required": "none",
"resource": "test-client",
"verify-token-audience": false
"confidential-port": 0
}
}
To use provided configuration, simply register AddKeycloakAuthentication
var builder = WebApplication.CreateBuilder(args);
var services = builder.Services;
var configuration = builder.Configuration;
var host = builder.Host;
host.ConfigureLogger();
services.AddEndpointsApiExplorer().AddSwagger();
services.AddKeycloakAuthentication(configuration);
var app = builder.Build();
appv.UseSwagger().UseSwaggerUI();
app.UseAuthentication();
app.UseAuthorization();
app.MapGet("/", (ClaimsPrincipal user) =>
{
app.Logger.LogInformation(user.Identity.Name);
}).RequireAuthorization();
app.Run();
Now we need to obtain an access token and make a call via swagger-ui. There are various ways you can do it. In my case, I opened “test-client” and made it confidential, and enabled “Direct access grants”. This way we can use a username and password. Please make sure you understand how to configure OAuth 2.0 and OpenId Connect before moving to production. In my case, it is just easy to demonstrate.
curl --data "grant_type=password&client_id=test-client&username=test&password=test&client_secret=Tgx4lvbyhho7oNFmiIupDRVA8ioQY7PW" \
localhost:8080/realms/Test/protocol/openid-connect/token
Now, we can navigate swagger https://localhost:5001/swagger
and make an authentication request by providing an access token.
Bonus - Adding Authorization
Let’s see how we can use Keycloak.AuthServices.Authorization
to build basic Keycloak-aware policies. See: AuthorizationPolicy
💡 Keycloak has a concept of roles. I added realm and resource roles behind the scenes. I suggest you figure it out on your own as an exercise 😛.
In the example below we require a user to have “admin” realm role and “r-admin” resource role by using RequireRealmRoles
and RequireResourceRoles
respectively. Note, that resource roles are automatically mapped to Microsoft.AspNetCore.Authorization
roles so b.RequireResourceRoles("r-admin")
is same as b.RequireRole("r-admin")
.
⚠ The resource
from KeycloakAuthenticationOptions
is used as an Audience and as the key for role mapping.
var builder = WebApplication.CreateBuilder(args);
var services = builder.Services;
var configuration = builder.Configuration;
var host = builder.Host;
host.ConfigureLogger();
services.AddEndpointsApiExplorer().AddSwagger();
services.AddKeycloakAuthentication(configuration);
services.AddAuthorization(o => o.AddPolicy("IsAdmin", b =>
{
b.RequireRealmRoles("admin");
b.RequireResourceRoles("r-admin"); // stands for "resource admin"
// resource roles are mapped to ASP.NET Core Identity roles
b.RequireRole("r-admin");
}));
services.AddKeycloakAuthorization(configuration);
var app = builder.Build();
app.UseSwagger().UseSwaggerUI();
app.UseAuthentication();
app.UseAuthorization();
app.MapGet("/", (ClaimsPrincipal user) =>
{
app.Logger.LogInformation(user.Identity.Name);
}).RequireAuthorization("IsAdmin");
app.Run();
Here is what the logs look like after a successful HTTP GET “/” request.
Summary
You can use Keycloak.AuthServices to integrate with Keycloak. Keycloak has tons of great features and thankfully we can benefit from the Java open-source world as .NET developers.


Upon your arrival at Kilimanjaro airport, our representative will meet you and drive you to your hotel for a first evening in Tanzania. Arusha is a major international diplomatic hub. The city hosts and is regarded as the de facto capital of the East African Community. Arusha is surrounded by some of Africa's most famous landscapes and national parks. Situated below Mount Meru on the eastern edge of the eastern branch of the Great Rift Valley, it has a mild climate
The road transfer from the Kilimanjaro International Airport to your lodge will take about 1 hour, so sit back and enjoy the ride through the city's sub-urban arriving at your lodge for a well deserved overnight.
Night at Lake Duluti Lodge on a Half Board basis
Duluti is a small volcanic lake of stunning beauty, and its forested crater walls are a sanctuary to over 130 different bird species. Canoeing across its smooth surface is a soothing and special way of taking in the wildlife in the overarching trees and the breath-taking scenes of Mt Meru. This trip is especially striking in the late afternoon when hundreds of Cattle Egrets come down to the lake to roost for the night.
Night at Lake Duluti Lodge on a Half Board basis
Early morning you will be picked up from your hotel and drive to Tarangire National Park for a full day of game viewing and photographing. Named after the river that flows through the park, Tarangire National Park is one of the lesser known Tanzanian National Parks, giving it a real air of undiscovered Africa.
Famous for its tree climbing pythons, massive baobabs and large herds of elephant, Tarangire National Park is small but still home to a significant wildlife population, with a density of wildlife matched only by Ngorongoro. Birding is particularly good here; the swamps, tinged green year round, are the focus for 550 bird varieties; the most breeding species in one habitat
Today is committed to a full day game drive Tours in Tarangire National Park. Imagine hundreds of zebra stripes reflecting in still waters. Imagine the looming silhouette of elephants burnt into the crimson sunset. Imagine the sight of ghostly baobab trees scattered across shimmering grasslands. These features are not figments of imagination – these features are just a taste of what Tarangire is all about!
The most spectacular feature of Tarangire is that it serves as a place of refuge for the largest elephant population in northern Tanzania.Elephant viewing in Tarangire is outstanding and it is likely that you will see hundreds of elephants in a single day. Set against stunning scenery, elephant viewing will undoubtedly prove to be one of the biggest highlights for a Tours in Tarangire. Tarangire is an incredible park that will reserve a special place in your heart and memories. Rest assured - no matter what time of year you choose to visit Tarangire, you’ll certainly be glad you did!
Night at Acacia Farm Lodge on a Full Board basis
Early morning you will be picked up from your hotel and drive to Lake Manyara National Park for a full day of game viewing and photographing. Stretching for 50km along the base of the rusty-gold 600-metre high Rift Valley escarpment, Lake Manyara is a scenic gem, with a setting extolled by Ernest Hemingway as “the loveliest I had seen in Africa”.
From the entrance gate, the road winds through an expanse of lush jungle-like groundwater forest where hundred-strong baboon troops lounge nonchalantly along the roadside, blue monkeys scamper nimbly between the ancient mahogany trees, dainty bushbuck tread warily through the shadows, and outsized forest hornbills honk cacophonously in the high canopy. Manyara provides the perfect introduction to Tanzania’s birdlife. More than 400 species have been recorded, and even a first-time visitor to Africa might reasonably expect to observe 100 of these in one day. Highlights include thousands of pink-hued flamingos on their perpetual migration, as well as other large waterbirds such as pelicans, cormorants and storks.
Manyara provides the perfect introduction to Tanzania’s birdlife. More than 400 species have been recorded, and even a first-time visitor to Africa might reasonably expect to observe 100 of these in one day. Highlights include thousands of pink-hued flamingos on their perpetual migration, as well as other large waterbirds such as pelicans, cormorants and storks.
Night at Acacia Farm Lodge on a Full Board basis
Today, you will visit the Ngorongoro crater, the main feature is a large, unbroken, unfolded volcanic caldera. The crater, which formed when a giant volcano exploded and collapsed on itself some two to three million years ago, is 610m (2,000 ft.) deep and its floor covers 260 km² (100 sq. mi). The crater floor is mostly open grassland with two small wooded areas dominated by Acacia xanthophloea.
Game drives through the Ngorongoro Crater begin early in the morning in closed Tours vehicles with pop – up roofs. Accompanied by an expert driver guide, a magnificent experience is sure to be had! The descent into the crater is one of scenic beauty, as you make your way through lush forests, home to numerous elephants and buffalo. As you reach the inside of the Ngorongoro Crater, marvelling at the incredible landscape around you, your guide will take you through the grassy crater floor, the unbelievable fever tree forest, the banks of Lake Magadi and the surrounding marshes. Lunch is served picnic style, surrounded by the natural wonders around you as well as the exceptional wildlife, roaming freely, with which you share this extraordinary paradise.
Night at Ngorongoro Sopa Lodge on a Full Board Basis
Night at Ngorongoro Sopa Lodge on a Full Board Basis
Today we will leave Ngorongoro and head to the vast plains of the Serengeti! We will see wildlife along the way, and of course when we reach Serengeti National Park you will have the chance to see the many animals that make the park so famous. The best vantage points and worthwhile areas are chosen to give you the best possible chance to observe animals and to capture your perfect photo. Depending upon the time of year, you have the chance to see the great migration with a hundred thousand wildebeests and zebras. During the small rainy season in October and November, you will typically see these herds moving from the Kenyan Masai Mara through the northwest Serengeti to the plains in the south. After the long rainy season in April through June, the herds travel slowly back through the west and northwest Serengeti. With fluctuations in rainfall, this timetable can change the animals’ migration times and routes. Your guide will know where and when to find the animals and makes sure that you can see the animals from the best spots in the national park.
Night at Kubu Kubu tented camp with All-Inclusive
Spend a full day exploring the vast Serengeti plains. Serengeti National Park quite simply offers the finest game viewing in all of Africa. Unrivaled concentrations of wildlife, stunningly beautiful landscapes and vast pristine areas make this region our number one pick.
You will rise early to enjoy an early morning game drive. At sunrise you may encounter animals grazing in the beautiful light of sunrise and predators may still be busy hunting before retiring to rest for the day. Sunrise on the Serengeti is not to be missed and extraordinary photographic opportunities will abound at this magical time of day. You have the option to return to your accommodation for a hot lunch or to opt for a packed lunch which can be enjoyed at one of the various picnic sites found in the Serengeti. After lunch you will continue on a game drive. Around the time of dusk be on the lookout for lion. Cheetah can also be spotted on the plains in the early morning and late afternoon when temperatures are not too high. They rely on daylight and speed to catch their prey. Hippo pods can be seen in the bigger pools and rivers while crocodiles can be seen sunning themselves on the riverbanks. You will return to Camp in time to enjoy a sundowner before your evening meal.
Night at Kubu Kubu tented camp with All-Inclusive
After breakfast you will leave your camp/lodge for the transfer to the Serengeti airstrip. You will enjoy an early morning game drive enroute stopping for last minute game viewing and photographing. You will be required to arrive at the airstrip at least one hour before departure time. The flight usually takes about four hours so sit back and enjoy the scenic flight over the Serengeti plains and onto Zanzibar. The flight might touch down in Arusha to board other people.
Upon arriving at Zanzibar airport, you will be met by an East African Voyage representative who will pick you up and transfer you to your next destination.
Today, you will arrive in Pemba and head to The Manta Resort, where you will spend your Pemba beach holiday. After your arrival, feel free to spend the day relaxing on the beach.
Upon your arrival, you will be transferred to your hotel in Pemba.
Night at The Manta Resort in a garden room with All-Inclusive
Spend the day relaxing on the pristine white beach and enjoying the turquoise Indian Ocean. Enjoy the Manta Resort's ocean-view pool, its spa, or go snorkeling to view the amazing sea life that surrounds the island.
NNight at The Manta Resort in a garden room with All-Inclusive
Swim amongst some of the most stunning sea life in the world with PADI-certified dive instructors! Pemba offers quintessential Indian Ocean diving, with coral-choked walls, colorful reefs, big bommies and enormous sea fans orbited by an amazing cast of reef fish. The diving here tends to be more advanced, with depths in the 30-40 metre/100-130 foot range. This remote Coral Sea atoll is made up of several individual sites. But, North Horn is perhaps its most famous for its shark feed. Most of the diners are whitetips, grey whalers, silvertips and the occasional hammerhead, but you'll also see potato cod, bigeye trevally and bumphead parrotfish.
You'll still have time to relax at the resort in the afternoon.
Night at The Manta Resort in a garden room with All-Inclusive
There is no doubt that Pemba is a spice island once you have visited the spice farm. A fascinating experience as the owner shows you around his farm and informs you of all the secrets that these spices hold. 70 % of the world’s clove harvest comes out of Pemba Island. This excursion takes approximately 2 hours.
Then, spend the afternoon relaxing on the beach or at the pool, and enjoy a massage at Manta's spa.
Night at The Manta Resort in a garden room with All-Inclusive
You will be transfered from The Manta Resort to the airport.
Today, you will fly to Dar es Salaam for your flight home.


Total
Used
Cached
10 TB
63.6 GB
3.2 GB
| User | Milestone | Branch | Date |
|---|---|---|---|
| Benji HarperDesigner |
22 / 30
|
develop4cc1bc2 | April 22, 201614:45 |
| Alex ChanDeveloper |
8 / 15
|
develop63e8ec3 | April 22, 201614:45 |
| Justine CliffordDesigner |
1/ 12
|
master8cb98ec | April 22, 201613:02 |
The Shiba Inu is the smallest of the six original and distinct spitz breeds of dog from Japan. A small, agile dog that copes very well with mountainous terrain, the Shiba Inu was originally bred for hunting.
54
POST4235
FOLLOWERS892
WATCH| User | Milestone | Branch | Date |
|---|---|---|---|
| Benji HarperDesigner |
22 / 30
|
develop4cc1bc2 | April 22, 201614:45 |
| Alex ChanDeveloper |
8 / 15
|
develop63e8ec3 | April 22, 201614:45 |
| Justine CliffordDesigner |
1/ 12
|
master8cb98ec | April 22, 201613:02 |
Make some fun tonight?
Hello!
I'm finish my job!
60%
70%
Waiting
Thursday 12:00 PM
Partly Cloudy
22 °C
Precipitation 0% Humidity 90% Wind 5 km/hThu
13°C11°C
Fri
11°C9°C
Sat
13°C10°C
Sun
12°C11°C
Mon
9°C7°C
Tue
8°C5°C
Wed
7°C6°C
Thu
8°C7°C


This iteration adds a class library which our behaviors act against. Things like size and position tracking for moveable entities, and some basic movements are controlled by the class library with some of the game rules remaining in the behaviors for the time being.
I haven't implemented any more features yet, but with the beginnings of a library to work against I can just about start doing that. The next iteration will complete the library structure, and move most of our core game logic (i.e. business logic) into the library where it belongs. This ought to leave our behaviors as fairly straight-forward shells which do very little on their own except make calls to the library.


Event Location:
Seminole State College of Florida
100 Weldon Blvd Building UP
Sanford, Florida
Abstract:
Working in large Enterprise environments as an employee is a challenge on the best of days. Getting the company to purchase the proper software is I believe a difficult task for even the most seasoned DBAs. Having started at my 3rd large Enterprise I have come to learn that each one manages the purse strings in their own manner. I have always been graced with corporate licenses that allowed me to install Enterprise Editions of SQL Server across the board. I am happy to say that the pendulum has swung and I am now tasked with justifying my SQL Server licenses. This has been a positive event for me that I would like to share with you. This session will share with you some of my current experiences with Standard and Enterprise Editions of SQL Server. You will be armed with some facts that can help you decide Standard or Enterprise edition so that you can meet the projects objectives, your SLAs and most importantly justify the cost of your SQL Server license.
Speaker(s): Daniel Taylor,
Abstract:
There is runaway growth in the data volumes many organizations are facing today. The bad news is that much of this data is unstructured which means your traditional RDBMS just isn't capability of helping you deal with it. As a result significant emphasis has been put on technologies like Hadoop, No SQL and other distributed databases which are better suited to handling unstructured data. With the latest release SQL Server 2012 however, Microsoft has provided new features which will help tame some of this unstructured data. This session will dive into the new FileTable and Statistical Semantic Search features. We will show you how they work and highlight real world examples for integrating these exciting new features into your organization.
Speaker(s): Christopher Price,
Abstract:
Support of the large databases is not a trivial task. Large amount of data negatively impacts system performance and make administration and SLA compliance much more complicated. Data partitioning can help to solve those problems and reduce support and hardware cost. This session demonstrates various approaches of data partitioning available in SQL Server. It compares pros and cons of different partitioning techniques from performance, scalability and administration standpoints. The session also discusses how to reduce hardware cost by implementing tiered storage and demonstrates how to move data between filegroups and/or disk arrays keeping the system online in the different versions and editions of SQL Server.
Speaker(s): Dmitri Korotkevitch,
Abstract:
You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker(s): Aaron Nelson,
Abstract:
Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is... database change management. This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker(s): James McAuliffe,
Abstract:
Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that? You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're on a coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check. Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office
Speaker(s): Kendal Van Dyke,
Abstract:
Do you have applications in your environment that don't use SQL written by a person but by the application itself? No, the system isn't self-aware. Chances are the system is utilizing Microsoft's Entity Framework. Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we'll review what Entity Framework is and how it's changed over time. We'll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we'll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you're a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.
Speaker(s): Richie Rump,
Abstract:
Powered by Fusion-io, Protected by SIOS: Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of high-speed Fusion ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection – at a price you can afford. Join us and you could win a $100 American Express gift card.
Speaker(s): Tony Tomarchio and Sandy Sandifer,
Abstract:
With a lot of companies looking to the cloud for cost savings, it helps to know what the differences are between on premises and cloud installations of your IT services. In this session, we'll take a look at SQL Server Reporting Services and the feature differences between deploying in the cloud, and deploying on premises. We'll look at different options for where you can deploy your reports as well. Also, Shannon Lowder will help with the associated costs of each solution, as well as preparing you for some of the gotchas you'll face as you move to the cloud today.
Speaker(s): Josh Luedeman,
Abstract:
XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents. We will look at why you should start working with Extended Events, when you should start, and how to start. What you will learn: 1. How to investigate XEvents objects using the DMV's 2. How to create an XEvents Session 3. How to transition an existing Trace to an XEvents Session. What you should know coming in: 1. Basic use of SSMS 2. Familiarity with Trace/Profiler
Speaker(s): Jack Corbett,
Abstract:
This session introduces Data Quality Services, a feature introduced in SQL Server 2012. One of the challenges in developing Business Intelligence solutions is ensuring that the data does not have inconsistencies, incomplete records, invalid or inaccurate values, and data duplication. Sometimes when consolidating data from more than one source you have to transform data to create one standard set of domain values in a standard format. SQL 2012 answers this need with Data Quality Services (DQS). In this session, you will learn the basics of what DQS is and how it can be used to clean your data. You will see how to build a domain both manually and from an existing data table. You will then see how to use these domains to validate tables in SQL Server and Excel preparing them for use in SSAS and PowerPivot. After this session, you will understand how by putting quality back into your data, you can be your organization's BI hero.
Speaker(s): Michael Antonovich,
Abstract:
Data Quality Services brings a new way to clean bad data as it's entering your data warehouse environment. In this session, we'll discuss what benefits using data quality services provides and how it can make development simpler in the long run. We'll show how to create a knowledge base, data quality projects, and administration of your data quality server. Finally, we'll use SSIS to consume this project and load into a data mart for cleaner data.
Speaker(s): Chris Schmidt,
Abstract:
PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge.
Speaker(s): Mike Davis,
Abstract:
Spatial data has been around since 2008 but it should fire it's PR person. It's too bad that spatial data gets no love, it's actually something that pretty much all SQL Server shops could use. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data. I will use some real world examples to help get the wheels turning on how you can use it within your organization and show how powerful it can be to see your data visually on a map.
Speaker(s): Hope Foley,
Abstract:
See how to build your first Windows 8 app. We will use what I learned when creating the app: .NET Gurus Can Cook, which contains recipes from famous folks in the software industry such as Scott Hanselman and Mary Jo Foley. Join ComponentOne Developer Evangelist and former Microsoft Developer Evangelist, Russ Fustino in this session and learn the new programming paradigm for creating Windows 8 style apps. You will see how to build an application that incorporates many of the key characteristics of a great Windows 8 style app, including: * A modern UI user experience that leverages the signature Windows 8 controls such as GridView, ListView, FlipView, AppBar, Semantic Zoom and other Windows 8 controls. * A user experience that scale * Getting data locally or thru Azure
Speaker(s): Russell Fustino,
Abstract:
Power View provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on Power Pivot workbooks or tabular models deployed to SSAS instances. In this session will dive in to what is needed to create Power View reports and an overview of the reporting enhancements in the new version of SQL Server.
Speaker(s): Guillermo Caicedo Santiago,
Abstract:
Learn how to use the Separation of Duties Framework and a Privileged Identity Management suite to minimize the permissions needed by DBAs to do routine work. I'll review the Separation of Duties Framework and an easy to implement, low hassle solution that provides DBAs the minimum necessary access required to maintain the server but not be able to view user data. I will prove that sysadmin is not always required more often than most DBAs think. Also, attendees will learn how to define a permission set with a single script that allows your company’s DBAs to do routine work and how to elevate DBA permissions quickly to respond to production emergencies.
  Or perhaps you've got packages that run reasonably well, but you're convinced they could run faster. Where do you start troubleshooting? How do you eliminate those performance pain points? In this demo-packed session, we'll work through some of the most common causes of performance bottlenecks in SSIS packages, along with recommended practices for maximizing performance. Among the topics we'll cover: troubleshooting methods to detect performance hotspots; optimizing sources and destinations for maximum throughput; choosing the most efficient data flow transformations; and using parallelism to improve performance.
Speaker(s): Tim Mitchell,
Abstract:
He's been telecommuting in some capacity or another since before he was a DBA. For 13 years he's been able to be a productive, responsive, integral and valuable asset to my company without maintaining a physical presence within the confines of a corporate office. She's been telecommuting for less than a year and is directing a fleet of SQL BI Professionals for a Major Microsoft partner. Together, let's have a conversation and discuss what has (and has not) worked for us over the years. Let's discuss the traits of a good telecommuter as well as those attributes that may not make this the right arrangement for everyone. We will even discuss what our companies have done over the years to not only accommodate telecommuting, but to embrace and succeed from having staff that work remotely! Taken from the approach of a husband and wife team with different experiences in telecommuting, this session is aimed at staff, spouses and management alike.
Speaker(s): Tim Ford,
Abstract:
On this session you will learn how to create an SSIS Framework in support of your enterprise organization. Learn to create,modified and configured SSIS packages at run time. Automate ETL process, Audit your SSIS packages across your network.
Speaker(s): Jorge Novo,
Abstract:
In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
Speaker(s): Timothy McAliley,
Abstract:
This fun and informative session covers best practices for data visualization and even infographics using Microsoft BI: Excel, Power View, the Office 2013 Web Apps Framework, Reporting Services, Visio and other open source and third-party data visualizations.
Speaker(s): Jen Underwood,
Abstract:
Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections.
Speaker(s): Jeffrey Garbus,
Abstract:
As DBAs, we constantly have to stretch our time and budget resources, and the best way to keep up with demands is through process automation. Workflow and PassThru parameters are just two of the features that will allow you to turn complex tasks into simple, repeatable, automated processes easier than you would have ever dreamed possible. And if you’ve had trouble with PowerShell in the past, the auto-completion and eager loading of modules will make your transition to PowerShell hero even simpler. Come see how mid-tone blue can help take your skills to the next level.
Speaker(s): Michael Wells,
Abstract:
When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
Speaker(s): Don Stevic,
Abstract:
Wondering about Hadoop, and how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.
Speaker(s): John Welch,
Abstract:
During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete.
Speaker(s): Shannon Lowder,
Abstract:
New to SQL Server 2008, Extended Events provide a refreshingly new method of looking at what occurs inside of SQL Server. This session will show you how to leverage Extended Events to solve complex problems by identifying the root cause faster than other methods of data collection provide.
Speaker(s): Jonathan Kehayias,
Abstract:
Have you ever thought about speaking at a user group or SQLSaturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session
Speaker(s): Eddie Wuerch,
Abstract:
Is your day full of repetitive tasks that you would like to hand off? Maybe you can push them back to the source. SSRS can empower you to empower your users. By pass the UI team and do it yourself. We will discuss options and considerations you should know about to create a report process to populate data your users are asking you to populate with validation and defaults.
Speaker(s): Pam Shaw,
Abstract:
The Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel.
Speaker(s): Jose L. Rivera,
Abstract:
Are you just starting out in the DB world? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to either of those questions, then this is the session for you! John will be talk about things from both an administration side a well as developmental that he's seen in the wild that every DBA should know and understand. We'll look at things like Auto Shrink, SELECT *, Index Basics and 7 others!
Speaker(s): John Morehouse,
Abstract:
In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!
Speaker(s): Rob Volk,
Abstract:
In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning.
Speaker(s): Eric Wisdahl,
Abstract:
Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.
Speaker(s): Andy Warren,
Abstract:
In this session we will cover what is a SSIS Framework, why you need a SSIS Framework, and how to implement it.
Speaker(s): James Phillips,
Abstract:
Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs. Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance? In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many.
Speaker(s): Mike Hillwig,
Abstract:
Every company has a backup strategy.  In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy!
Speaker(s): Ed Watson,
Abstract:
Microsoft has announced that our next version of SQL Server will be SQL Server 2014. SQL Server 2012 had some major upgrades in AlwaysOn Availability Groups, ColumnStore Indexes, and Resource Governor. SQL 2014 takes those features to the next level and introduces a whole lot more! Rebuild Indexes and Statistics by Partition? Yes! A new Optimizer/Cardinality Estimator that you can choose for your Queries? Yes! Hekaton in memory data tables that exist separate to the buffer pool and use HASH indexes instead of B-TREE? YES! Plus SSD Buffer Pool Extensions, Read-Write ColumnStore Indexes and much more!
Speaker(s): Bradley Ball,
Abstract:
A bane to almost every DBA, data deployments are one of the least enjoyed part of database development. In this session we'll look at the causes of this pain and the best ways to avoid the pain.
 Digging further, you find that your indexes are not being maintained. In this session we'll look at some different systems that can be used for index maintenance. Additionally we'll explore some of the basic DMV's that provide us information about indexes.
Speaker(s): Robert Biddle,
Abstract:
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
Speaker(s): Allen White,
Abstract:
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
Speaker(s): Chris Bell,
Abstract:
You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this demo rich session you will be able to - Explain the differences between SQL Servers 9 "index" types - Identify the layout of SQL Server data on disk - Decide which index types are the right ones to use for a given query - Assess the impact of the Key on access speed
Speaker(s): Sebastian Meine,
Abstract:
Determine what's in play and what's not. This presentation will focus on steps you can take to determine the performance of your SQL Server and where you may need to spend some time optimizing. We will review tools and scripts that are available from Windows Server and the SQL community so you won't have to go and ask your boss to buy something.
Speaker(s): Carlos L Chacon,
Abstract:
Are you currently using Master Data Services? if the answer is no, you can't afford to miss this presentation. In this session Luis will provide an overview of MDS 2012. Whether you are looking for a better solution for your business users than the common spread-marts or you are implementing a Master Data Management strategy to go along with your EDW, this session is for you.
Speaker(s): Luis Figueroa,
Abstract:
Are you new to SQL Server? Did your first tasks involve problem solving someone else's work? Diagnosing SQL Server problems does not have to be a time sink, or a struggle. Learn about the most common errors in SQL Server and Brandie's top 20 tips for finding the problem fast.
Speaker(s): Brandie Tarvin,
Abstract:
This session covers the new features and functions introduced to T-SQL in SQL Server 2012. Our time will be spent reviewing enhancements to T-SQL specifically for SQL Server 2012 with attention to demonstrations and code samples. This is a basic session, but ttendees should have a general knowledge of T-SQL.
Speaker(s): David Dye,
Abstract:
Matching is the identification of rows which are likely duplicates and is the less well known feature of Data Quality Services. In this session we'll go over the creation of matching rules, how to use the rules with matching activity projects and the brand new Codeplex DQS SSIS Matching component!
Speaker(s): Julie Smith,
Abstract:
Being a full-stack .NET developer, I have written my fair share of T-SQL, but not until I became an accidental DBA did I find a new world of T-SQL options available to me. In this session, I will go over a five T-SQL commands available since SQL Server 2005 and up that I have been completely missing. We will evaluate the usefulness of CTE, OUTPUT, MERGE, APPLY, and RANKING FUNCTIONS and how each of these can replace common cases you see everyday.
Speaker(s): Jason Carter,
Abstract:
This session will demostrate how you can reuse a PowerShell script in SSIS "Script Task" component as part on a ETL flow. I'll be showing some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Everyone is welcome to attend.
Speaker(s): Maximo Trinidad,
Abstract:
If you've only seen the 'canned' MS demo's of PowerPivot and are looking a little to sink you teeth into, this is your session. We will walk through real-life demonstrations utilizing SharePoint and PowerPivot technologies. Describe approaches to common problems and pitfalls that have been learned overtime from real implementations.
Speaker(s): Kevin Grohoske,
Abstract:
A lot of report development today is done through T-SQL using a lot of temp tables and aggregate functions. The reason for this is because a lot of database developers were scared of Analysis Services MDX and its complexity. Until SQL Server 2012 there was no other option in the Microsoft stack for a corporate BI solution until SQL Server 2012 and the BISM Tabular Model. BISM Tabular's query language is an Excel like language called Data Analysis Expressions (DAX). This session will cover some basic concepts of the DAX language and how powerful it is and why the T-SQL developer should consider it.
Speaker(s): Anthony Sammartino,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/pub/timothy-mcaliley/10/530/787/
I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.
LinkedIn: https://www.linkedin.com/in/jenunderwood
Contact: http://www.impactanalytix.com/
Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment. Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: https://www.linkedin.com/in/timothyford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
LinkedIn: http://www.linkedin.com/in/sebastianmeine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
LinkedIn: http://linkedin.com/in/slowder
Contact: http://shannonlowder.com
For over 15 years Shannon Lowder has been spotting patterns and learning ways to work smarter instead of harder. He started with development and moved into database administration. Using TSQL, Database Jobs and PowerShell, he automated himself out of contracts quickly. As Business Intelligence became a greater demand, he moved into SSIS, SSRS, and SSAS development. Early on, he tried using PowerShell and .Net to automate BI Development. Later those efforts turned to Biml. After founding a startup six years ago, he finds himself a data platform consultant, designing and guiding other professionals to build highly automated enterprise solutions. Today, he is a Biml Hero candidate and is awaiting the final approval for the award.
LinkedIn: http://www.linkedin.com/pub/allen-white-sql-server-mvp/5/784/b08/
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
LinkedIn: http://www.linkedin.com/pub/daniel-taylor/
Contact: http://dbabulldog.wordpress.com/
Daniel Taylor started his DBA life at Nielsen Media Research Company working with Sybase ASE 11 thru 12.5, Sybase IQ, eventually moving to SQL server. Daniel has worked with SQL Server versions from 7.0 to 20012. Daniel also worked for Publix as Senior DBA, Technical Specialist and was the SQL Server team lead that supported over 2000 instances of SQL Server. Currently Daniel is a Sr. SQL Database Specialist at New York Life Tampa Division. You can find him on Twitter as @DBABullDog.
LinkedIn: https://www.linkedin.com/in/donald-stevic-03a5ab1/
I have spent the last 16 years of my life living, learning and teaching SQL Server. I am currently a Principal DBA at SAIC, and I teach online DBA courses at BYU-Idaho. My life before all this was as a high school Drama teacher here in Florida. It might seem an odd transition, but it really isn't. To me, part of being a great DBA is embracing the artistry of the process. How the design of a database ebbs and flows into its final form. So, I guess you could say I am a SQL artist.
Contact: http://jason-carter.net
Jason#39;s past has included being a developer, a development manager, accidental DBA, and now a full-time DBA. Having worked with VLDBs as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator
LinkedIn: https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
Pam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQLSaturday Tampa.
Contact: http://blog.extremebi.net
Luis Figueroa is an IT professional focused on delivering business solutions that leverage the Microsoft SQL Server platform. His area of expertise is Data Warehousing and Business Intelligence but he is passionate about all things SQL Server. With 10+ years of experience in the IT field, Luis has delivered data management solutions for companies in the Security, Online Marketing and Healthcare Industries. He is also the chapter leader of the MS BI user group of South Florida.
LinkedIn: http://www.linkedin.com/pub/robert-biddle/8/266/630
Contact: http://robert-biddle.com
Robert Biddle is a Data Architect for Hilton Grand Vacations in Orlando, Florida. He has over a decade of experience working with SQL Server in a variety of roles. He has a Bachelor’s degree in Computer Science from the University of Delaware and also has MCITP certifications for Database Administration and Database Development. In recent years, Robert has specialized himself working with data integration, ETL, and data warehousing. He is a frequent speaker at SQLSaturday and Code Camp events.
Contact: http://www.sqlbn.com
Jose L is a SQL Server MCITP and MCT with over 10 years of experience developing Business Intelligence solutions using SQL Server technologies, among others. He currently works as Consultant at Nagnoi, Inc. as well as College professor at University of Phoenix. In addition, he shares his knowledge and perspectives as PRPASS Vice President and Community Leader, Co-Leader for the Azure and Global Spanish virtual chapters and frequent speaker at user groups and SQLSaturday events, among others.
Contact: http://sqlrus.com
John Morehouse is currently a Database Architect/Engineer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and and a frequent speaker at SQLSaturday's as well as other conferences. In his spare time, you can find John running after one of his two sons or working on his 113 year old house.
LinkedIn: http://www.linkedin.com/in/mikewells
Contact: http://sqltechmike.com
Michael Wells is a Microsoft Specialist at Dell EMC covering enterprise customers. He has worked in IT since 2000 and has supported all versions of SQL Server from SQL Server 2000 to SQL Server 2014. Michael has been presenting since 2007 for local user groups, CodeCamps, SQLSaturday events, IT Pro Camps, and large conferences like PASS Summit and Oracle OpenWorld.
LinkedIn: http://www.linkedin.com/in/eddiewuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
Contact: http://www.sharepointmetro.net/
Kevin first started programming on a Timex Sinclair 1000 when he was 11 years old. As a professional, Kevin has been designing and developing custom applications using Microsoft development tools since 1995. He has designed and developed large enterprise class applications and intranet applications for companies such as International Paper, LexisNexis and many others. He now resides on the Destin Florida with his family and enjoys the coastal living.
LinkedIn: https://www.linkedin.com/in/jonathonmoorman
Jon has developed using Sql Server since version 6.0! Easily distracted by shiny objects, he has always been on the bleeding edge of sql development. When not presenting, Jon might be found backpacking, hiking, camping, canoeing, or simply resting at home with a good scifi book.
Tony Tomarchio is the Director of Field Engineering at SIOS Technology Corp. Tony specializes in high availability and data recovery best practices and has over a decade of experience in enterprise systems management. Sandy Sandifer is a Sales Engineer at Fusion-io focusing on their Florida based prospects and clientele. Sandy is a MCSE and has over a decade of experience in IT Design and Planning. He specializes in high performance storage solutions leveraging solid state technologies.
Contact: http://hopefoley.com/
Hope has over 12 years experience in the IT world, she has worked across many industries from small business enterprises to Fortune 500 companies. She has a vast knowledge of database design, administration and support, data warehousing and data mining, and custom database solutions. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst, and took over as Principal Microsoft Consultant, where she now leads a team of expert DBAs and developers. She is also a SQL Server MVP.
LinkedIn: https://www.linkedin.com/in/ericwisdahl
Eric Wisdahl is a computer engineer working in the database field. He has held multiple roles and positions in e-commerce, marketing and insurance industries. Currently, he is working as a database administrator in a development role for an e-commerce company. Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.
LinkedIn: http://linkedin.com/in/richierump
Contact: http://jorriss.net
Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.
LinkedIn: https://www.linkedin.com/in/sqlvariant
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award. Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Database Administrator by day and Author by night Brandie Tarvin sails pirate-populated waters, fights evil robots in disguise and turns kingdoms into chaotic rebellious city-states all while coding ETL processes and protecting real-world data from corruption. If it weren't for her, someone else would have the job and where would be the fun in that? Brandie's first computer experience was with a State-of-the-Art Commodore 64 brought home by her father, who informed her that "computers are NOT toys" and would not let her use it until she learned how to program. In late 2003, she turned her hobbies of programming, MUSHing and assisting friends with generic tech support into a full time career as a database administrator. She's been stuck in the fabulous and bizarre world of professional IT work ever since. Currently, Brandie is a Database Administrator Developer for Allstate Dealer Services in Jacksonville. She has published several articles on SQLServerCentral.com, trains her co-workers in SQL Server, and has previously presented at several SQLSaturday events and JSSUG meetings. She also writes fiction and freelances for Catalyst Game Labs in her spare time.
LinkedIn: http://www.linkedin.com/in/joshluedeman
Contact: http://www.joshluedeman.com
Josh is a Sr FastTrack Engineer with the FastTrack team in the Azure Engineering Group at Microsoft. Josh focuses on Microsoft's Cloud Scale Analytics Solutions in Azure using products like HDInsight, Data Lake, Data Factory, and DataBricks. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.
LinkedIn: https://www.linkedin.com/in/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
LinkedIn: http://www.linkedin.com/profile/view?id=11710667amp;trk=tab_pro
James McAuliffe is a Cloud Solution Architect with CCG Analytics, a Microsoft Gold Partner. He is also a Microsoft Preferred Partner Solutions expert and has been worked with clients of all sizes, from local businesses to Fortune 500 companies. Today’s mix of Big Data and cloud offerings make yesterday’s dream today’s possibility. Let’s talk about it!
LinkedIn: https://www.linkedin.com/in/michaelpantonovich?
Contact: http://sharepointmike.wordpress.com
Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User's Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
LinkedIn: http://www.linkedin.com/in/mikehillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
Contact: http://bluewatersql.wordpress.com/
Chris Price is a Sr. BI Consultant with Pragmatic Works based in Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQLSaturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor.
LinkedIn: https://www.linkedin.com/in/carloslchacon
Contact: http://sqldatapartners.com/blog
Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.
LinkedIn: Linkedin: http://www.linkedin.com/pub/max-trinidad/12/47/775/
Contact: http://www.maxtblog.com
Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.
LinkedIn: https://www.linkedin.com/in/sqlballs
Contact: http://www.sqlballs.com
Bradley Ball is a Sr. Azure Engineer for Microsoft, and former Data Platform MVP. During his IT career Bradley has spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, and the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at SQLSaturdays, SSUG's, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com
LinkedIn: http://www.linkedin.com/in/watsoned
Contact: http://sqlgator.com
Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.
LinkedIn: http://www.linkedin.com/in/gcaicedo/
Contact: http://www.sqltitan.com
Guillermo Caicedo es un profesional de bases de datos y tecnolog#237;a trabajando como Consultor en Nagnoi, LLC. Ha ayudado a numerosas empresas a obtener conocimiento sobre sus datos por desarrollar e implementar soluciones de inteligencia empresarial en sus organizaciones. El Sr. Caicedo tambi#233;n tiene una amplia experiencia desarrollando aplicaciones web y m#243;viles. Guillermo es un Data Platform MVP y l#237;der del Cap#237;tulo PASS para Puerto Rico (PRPASS).
LinkedIn: https://www.linkedin.com/in/christophermschmidt
Contact: http://intelligentsql.wordpress.com/
Chris Schmidt is a data architect with Centric Consulting and has experience designing business intelligence solutions for a wide variety of companies in multiple industries. He is very passionate about the entire Microsoft BI stack, with a special emphasis on SSIS and SSAS.
Contact: http://www.clubfarpoint.com/Forums/blogs/russells_blog/
Russ Fustino heads up Developer Evangelism at ComponentOne as a Senior Developer Evangelist. He is also a highly experienced Windows Phone 7 software developer with a passion for conveying relevant, current, and future software development technologies and tools through live seminars, teaching, and internet video productions. Russ has a new innovative blog and interview video series with influentials, about current technology, ComponentOne products and developer community called ‘Russ Cam’!
LinkedIn: http://www.linkedin.com/pub/christopher-bell/19/a08/93/
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do 'Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris' thoughts and technical community activities at WaterOxConsulting.com.
LinkedIn: http://www.linkedin.com/in/mikedavissql
Contact: http://MikeDavisSQL.com
Mike Davis, MCITP, is a Consulting Team Lead at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQLSaturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
Contact: http://etldevelopernotes.blogspot.com/
Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes using automation, and dynamic programming for SSIS. Currently Jorge is working in the programming and development of Data Master Service for the organization.
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
James Phillips is the VP Technology for Mizuho Americas and has over 20 years of experience with SQL technologies with the last 10 years focused on Business Intelligence. He is a past Leader of the Northern NJ SQL Server User group and current Leader for SQLSaturday NYC. He has worked in a wide array of industries including finance and insurance. Regularly speaks about Database Performance Tuning, SSIS and Power BI topics. Also an avid softball player and father to 5 beautiful children.
LinkedIn: http://www.linkedin.com/in/apsammartino
Contact: http://www.sqlant.me
Anthony Sammartino is the Vice President of the BI Solutions division for TekPartners. Anthony has been building Business Intelligence solutions as a consultant for many fortune 500 companies for over 13 years. For the last 11 years he has almost exclusively used the Microsoft SQL Server BI stack and focused on the following technologies: DB Engine, SSIS, SSAS, SSRS, PowerPivot, Power View, and SharePoint. Anthony currently holds certifications as an: MCP, MCTS(BI), MCITP (BI), and PMP#174;
LinkedIn: http://www.linkedin.com/in/jackcorbett
Contact: http://www.wisemanorwiseguy.com
JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016. Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control. Jack has presented at many user groups and SQLSaturday even
LinkedIn: http://www.linkedin.com/in/juliesmith0503/
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer--but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
LinkedIn: http://www.linkedin.com/in/johncwelch/
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
LinkedIn: http://www.linkedin.com/in/rdameron
Contact: http://RonaldDameron.com
Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software. He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux. He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International. He is most active on Twitter as @RonDBA.
The following is a list of sponsors that helped fund the event.


|
SuanShu, a Java numerical and statistical library | |||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object com.numericalmethod.suanshu.optimization.constrained.linearprogramming.simplex.Tableau
public class Tableau
This class implements a "tableau" and its operations used in the Simplex method when solving an LP problem.
| Nested Class Summary | |
|---|---|
static class |
Tableau.Label
|
static class |
Tableau.LabelType
|
| Field Summary | |
|---|---|
double |
epsilon
a precision parameter: when a number |x| ≤ ε, it is considered 0 |
static Tableau.Label |
UNDEFINED
|
| Constructor Summary | |
|---|---|
Tableau(Matrix T,
double epsilon)
Construct a simplex tableau, assuming the standard form. |
|
Tableau(StandardLpProblem2 problem)
Construct a simplex tableau from a standard problem. |
|
Tableau(Tableau.Label[] rowLabel,
Tableau.Label[] colLabel,
Matrix T,
double epsilon)
Construct a simplex tableau. |
|
Tableau(Tableau table)
Copy ctor. |
| Method Summary | |
|---|---|
static DenseMatrix |
buildTable(StandardLpProblem2 problem)
phase 1: (feasible) tableau initialization |
double |
get(int row,
int col)
Get the table entry at [row, col] . |
double |
getBCol(int row)
|
Tableau.Label |
getColLabel(int i)
|
double |
getCostRow(int col)
|
Tableau.Label |
getRowLabel(int i)
|
boolean |
isFeasible()
Check if this table is feasible. |
double |
min()
Get the minimum inferred by this table. |
ImmutableVector |
minimizer()
Get the minimizer inferred by this table. |
int |
nCols()
Get the number of non-basic variables. |
int |
nRows()
Get the number of basic variables. |
int |
problemSize()
Get the number of variables in the problem, the cost/objective function. |
void |
swap(int r,
int s)
Perform a Jordan Exchange to swap row r with column s . |
java.lang.String |
toString()
|
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Field Detail |
|---|
public static final Tableau.Label UNDEFINED
public final double epsilon
| Constructor Detail |
|---|
public Tableau(Tableau.Label[] rowLabel, Tableau.Label[] colLabel, Matrix T, double epsilon)
rowLabel
- the labeling of the basic variablescolLabel
- the labeling of the non-basic variablesT
- the table represented in matrix formepsilon
- a precision parameter: when a number |x| ≤ ε, it is considered 0public Tableau(Matrix T, double epsilon)
T
- the table represented in matrix formepsilon
- a precision parameter: when a number |x| ≤ ε, it is considered 0public Tableau(StandardLpProblem2 problem)
problem
- a standard linear programming problempublic Tableau(Tableau table)
table
- another Tableau| Method Detail |
|---|
public int nRows()
public int nCols()
public double get(int row, int col)
[row, col]
.
row
- the row indexcol
- the column index
T[row, col]
public double getCostRow(int col)
public double getBCol(int row)
public Tableau.Label getColLabel(int i)
public Tableau.Label getRowLabel(int i)
public boolean isFeasible()
true
iff the table is feasiblepublic int problemSize()
public double min()
public ImmutableVector minimizer()
public void swap(int r, int s)
r
with column s
.
r
- the index to the entering variable (row)s
- the index to the leaving variable (column)public static DenseMatrix buildTable(StandardLpProblem2 problem)
problem
- a linear programming problem
public java.lang.String toString()
toString
in class java.lang.Object
|
SuanShu, a Java numerical and statistical library | |||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |


Reverse-Flash
Reverse-Flash is a name which has been used by several fictional supervillains in American comic books published by DC Comics. Each iteration is an enemy of the hero known as The Flash. As each version of the Flash has the power to travel at super-speeds, each version of Reverse-Flash can also travel at super-speeds, allowing them to travel back and forth in time. The fact both of them have the same power is much of the reason they are enemies.


2. Software Setup¶
Before you can start using your OpenMV Cam you’ll need to download and install OpenMV IDE.
2.1. Windows¶
OpenMV IDE comes inside of an installer that will automatically install the IDE along with drivers for the OpenMV Cam and the MicroPython pyboard. Just follow the default installer prompts.
To launch OpenMV IDE afterwards just click on its shortcut in the Start Menu.
2.2. Mac¶
OpenMV IDE comes in a .dmg
file. Simply open the .dmg
file and then
drag the OpenMV IDE .app
onto the Applications folder shortcut to install
OpenMV IDE.
In addition to installing OpenMV IDE you’ll also want to install device firmware update (DFU) support so that you can recover your OpenMV Cam if you encounter a problem with our boot-loader.
First you’ll need to install a package manager. Either MacPorts or HomeBrew. If you don’t have a preference choose HomeBrew.
For MacPorts you’ll need to execute the following commands:
sudo port install libusb py-pip
sudo pip install pyusb
For HomeBrew you’ll need to execute the following commands:
sudo brew install libusb python
sudo pip install pyusb
In general, you have to install libusb
, python
, and pyusb
.
To launch OpenMV IDE just click on its .app
file in your Applications
folder.
2.3. Linux-Desktop¶
OpenMV IDE comes inside of an installer .run
file. Just do:
chmod +x openmv-ide-linux-*.run
./openmv-ide-linux-*.run
And then follow the installer prompts to install OpenMV IDE on linux.
Afterwards, see the README.txt
file and the setup.sh
file in the
installer output directory for installing device firmware update (DFU) support
so that you can recover your OpenMV Cam if you encounter a problem with our
boot-loader.
Finally, to launch OpenMV IDE just click on the bin/openmvide
file. If
OpenMV IDE fails to launch you may need to add execution permissions first.
Do:
chmod +x openmvide
./openmvide
If this doesn’t work then use the openmvide.sh
script instead. Do:
chmod +x openmvide.sh
./openmvide.sh
In general, you’ll need to run OpenMV IDE using the openmvide.sh
script if
you’ve installed Qt on linux. The openmvide.sh
script fixes linker path
issues before launching OpenMV IDE to make sure that it runs on any system.
2.4. Linux-RaspberryPi¶
OpenMV IDE comes inside of an installer .tar.gz
file. Just extract the
contents where you like (like ~/openmvide
). Afterwards, see the
README.txt
file and the setup.sh
file in the output directory for
installing device firmware update (DFU) support so that you can recover your
OpenMV Cam if you encounter a problem with our boot-loader.
Finally, to launch OpenMV IDE just click on the bin/openmvide
file. If
OpenMV IDE fails to launch you may need to add execution permissions first.
Do:
chmod +x openmvide
./openmvide
If this doesn’t work then use the openmvide.sh
script instead. Do:
chmod +x openmvide.sh
./openmvide.sh
In general, you’ll need to run OpenMV IDE using the openmvide.sh
script if
you’ve installed Qt on linux. The openmvide.sh
script fixes linker path
issues before launching OpenMV IDE to make sure that it runs on any system.


Remoting and WebServices.Net
THIS PAGE IS .NET 1 ONLY. See WCF
WebServices
- Sessions- must be explicitly added on both client and service
Server:[WebMethod(EnableSession=true)] public void NewGame()
Client:service1.CookieContainer = new System.Net.CookieContainer();
- Other WebMethod attributes: CacheDuration (cache it), TransactionOption (NB: if call other webmethods, transaction aren't passed over Soap, so multiple calls aren't Acid)
- Exceptions: any exceptions in a webmethod are passed as a SoapException
- Authentication: pass your windows auth by
server.Credentials = System.Net.CredentialCache.DefaultCredentials;
otherwiseserviceobj.Credentials = new NetworkCredential(username, password);
- Custom authentication: use SoapHeaders- create a custom class derived from SoapHeader, and make it a member of your WebService assembly; then decorate the WebMethod with the attribute specifying the member name
[WebMethod, SoapHeader("MyHeader",Direction=SoapHeaderDirection.InOut)]
- SOAP Extensions. You extend SoapExtension with overrides GetInitializer, Initialize, ChainStream, ProcessMessage (switch/case SoapMessageStage). Generally you're doing things (like encryption or value translations) in .AfterSerialize (sender- just before sent) and/or .BeforeDeserialize (receiver- as soon as received). You may also need a SoapExtensionAttribute class so it can be used.
- The serializer may not work out all derived types in a hierarchy, so add a [XmlInclude(typeof(MySpecificObj))] attribute
- You can customise the Soap format- SoapDocumentService(Use=SoapBindingUse.Encoded) or SoapRpcService (for class) or SoapDocumentMethod (for method). Literal is default, encoded and rpc have namespaces for each datatype. The literal and encoded (document style) also allow SoapParameterStyle.Bare and XmlElement attributes.
- To show an aspx if you browse to a webservice: wsdlHelpGenerator href="form.aspx" (NB: only works for subfolders- .Net 1.1 has error in root directory)
Remoting
- Marshal-by-value objects implement ISerializable
- Marshal-by-reference objects extend System.Marshal-ByRefObject and become proxies on the client
Have LifetimeLeases (clients can renew by getting the ILease from GetLifetimeService) - Server Activation - created by first method call (not on "new obj")
- WellKnownObjectMode.Singleton (shared):
ChannelServices.RegisterChannel(new TcpChannel(8020)); WellKnownServiceTypeEntry myservice = new WellKnownServiceTypeEntry(typeof(MyService),"TcpService", WellKnownObjectMode.Singleton); RemotingConfiguration.ApplicationName = " TcpService"; RemotingConfiguration.RegisterWellKnownServiceType(myservice);
- WellKnownObjectMode.SingleCall (created each call, stateless)
In xml: configuration/system.runtime.remoting/application/service/wellknown/@mode="SingleCall" @type=MyRemoteClass,RemoteAssembly
NB: most scalable, suitable for load-balancing - Can host in IIS (for SSL etc). Just put system.runtime.remoting into web.config (no channel- it's 80, no tcp obviously), and register objectUri with ".rem" extension.
- WellKnownObjectMode.Singleton (shared):
- Client Activation (created by "new")
- Versioning: The client specifies the version- server can't specify the version (as opposed to SOAs)
- Can't use IIS as a host - only SAOs
- XML config:
RemotingConfiguration.Configure("my.config"); //remember to do this!
- Channels:
HttpServerChannel channel=new HttpServerChannel(0); //0= available port (if already used-exception) ChannelServices.RegisterChannel(channel);
NB: clients don't specify port.
NB: http channels can be more secure than tcp if hosted in IIS - You can do remoting asynchronously:
// Create delegate to a method that is executed when async method done. AsyncCallback callBackDelegate = new AsyncCallback(CallBackMethod); // Create a delegate to the method that will be executed asynchronously MyAsyncDelegate startLongCallDelegate = new MyAsyncDelegate(obj.LongCall); // Begin the invocation of the asynchronous method. startLongCallDelegate.BeginInvoke(remoteMethod,nothing);
- Avoiding client copies
- Interface assembly. As interfaces don't have constructors, use Activator.GetObject (for server activated) or Activator.CreateInstance (for client-activated)
- Or use soapsuds.exe (for http channels) to generate a proxy (dll or source)
Serviced components (.Net COM+ apps)
- Derive from System.EnterpriseServices.ServicedComponent
- Decorate with attributes eg ObjectPoolingAttribute (default is false), ApplicationActivation (Library or Server- latter must be in GAC), TransactionsAttribute on class, AutoCompleteAttribute on a method (calls SetComplete/ SetAbort)
- Register manually with RegSvcs.exe (shows errors), or in code using RegistrationHelper class
- AccessControl integrates with COM+ security via attributes such as Application/ComponentAccessControl and SecurityRole
- Queued:
- Assembly- support queues: [assembly:ApplicationQueuing(Enabled=true,QueueListenerEnabled=true)]
- Class- show interface: [InterfaceQueuing(Enabled=true,Interface="IMyInterface")]
- No callbacks or app-specific errors, or return values
- Client uses Marshal.BindToMoniker:
IInterface i =(IInterface) Marshal.BindToMoniker(@"queue:/new:MyNameSpace.IMyInterface"); i.DoMyMethod(); Marshal.ReleaseComObject(i);
- DEBUGGING: attach to DllHost.exe
Windows Services
- System.ServiceProcess namespace has
- ServiceBase class (services, either Win32OwnProcess (single process) services or Win32ShareProcess (shared process) services).
VS: change Name and ServiceName properties and the Main sub
Override OnStart, OnStop etc + OnCustomCommand, OnPowerEvent (if Can* properties =true)
AutoLog=true + EventLog.WriteLog(mess) (false to send to custom event log) - ServiceInstaller and ServiceProcessInstaller classes to install
VS Designer: rightclick- Add Installer - ProjectInstaller class contains instances of both with [RunInstaller(true)] attribute (for Installutil.exe)
ServiceProcessInstaller.Account= LocalService, LocalSystem, NetworkService, or User - ServiceController class to start/stop/pause (rather than via Service Control Manager (SCM))
Should be a separate exe! Create a winform and drop ServiceController from toolbox (or Server Explorer- rightclick the service + "Add To Designer").
Check .Status = .Running before ops
.ExecuteCommand(int) /*between 128 and 256*/, GetServices()
- ServiceBase class (services, either Win32OwnProcess (single process) services or Win32ShareProcess (shared process) services).
- You can drag a performance counter from the Server Explorer - NB remove MachineName
WCF
- X509 Certificates
- How To Use Certificate Authentication and Message Security in WCF [CodePlex]
- MSDN: Working with certificates
- Certicates mmc: Start - Run - MMC - File - Add/Remove Snap-In - [Add] - Certificates - Computer Account - Local Computer.
- For test certificates: makecert. Eg
makecert -r -pe -n "CN=XYZ Company" -sky exchange -sr LocalMachine -ss my
(an exportable self signed certificate with a subject for the Trusted People store for LocalMachine - ASP access to certificates: Download WinHttpCertCfg and run it
winhttpcertcfg -g -c LOCAL_MACHINE\My -s "My Server Machine" -a "ASPNET"
(for XP; -a "NETWORK SERVICE" for Windows Server 2003) - Using Windows CERTSRV to request/issue client and server X.509 certificates [CodeProject, nicely illustrated]
- WCF binding for Ws-Security (message mode): system.serviceModel/bindings/wsHttpBinding/binding/security mode="Message"/message clientCredentialType="Certificate"
- behaviors/endpointBehaviors/behavior/clientCredentials/serviceCertificate/authentication certificateValidationMode="PeerOrChainTrust" allows a self signed certificate if it is in the Trusted People store.


Pixel Art Maker
Web App to Make Pixel Arts
Canvas Size
Box Count in Row:
Box Count in Column:
Select Color
Choose a color to start designing.
Set Cell Size
Your preferred grid cell size.
Circle or Ractangle
Set how you want the grid cells to be displayed.
Start drawing your next masterpiece
ROWS and COLUMNS count should be LESS then or EQUAL to 100 and GREATER then or EQUAL to 0.


Contact Us!
We are always looking for motivated students and postdocs to work with us!
Read more about our research and our recent achievements.
Mayuri Rege, Ph.D.
DST-INSPIRE Faculty
Department of Microbiology
Ramnarain Ruia Autonomous College
Matunga, Mumbai- 400019
mayurirege [at] ruiacollege [dot] edu


Hello There! My name is Devon Mickels and I'm the creator, developer, and programmer of Surviving Exile. It's an original indie colony management game that I'm making as one of my first PC release for my company Dwarven Realms Studios!
In this colony management strategy game, you control a group of exiled travelers who were sent on an intergalactic prisoner mining ship. However, in its journey the ship began experiencing unexpected maintenance issues and was forced to evacuate, shooting your crew to the closest planet. You have landed with nothing but your crew and will need to begin gathering resources to ensure your survival.
You will need to set up camp and set up a research station to collectively pull together your knowledge in order to transform your gathered resources in the tools and weapons needed to survive. The members of your crew will serve as your primary resource, and under your management, will gain the essential skills needed in order to survive.
But be careful, as you are not the only prisoner crew that was evacuated from that ship and there are sure to be other groups just like yours. Some good, some bad, but that is up for you to decide.
The success or failure of your crew depends on the appropriate management of the risks ahead of you in getting deciding whether to settle on this planet, or return home.
This game is currently in a closed alpha period. We are continuously developing new features and fixing bugs to ensure the best possible experience when finally released to the public. Please be sure to follow our development on our Instagram.


NamPower calls for calm
NamPower says the nation needs not to panic, as the company has the capacity to deal with power outage situations around the clock.
This follows last night's power outage experienced throughout many central and coastal areas, as well as most parts of the northern regions,
The power utility says the outage was caused by a technical fault on the transformer at Kokerboom-Aries's 400 kV lines in the south.