--- layout: default ---
An Open Source Project Bringing accessible technology to the touch screen domain.
To create a product that will allow a visually impaired person to interact with any touch screen.
Touch screens are becoming more and more common in everyday life. Airplanes, movie theatres, grocery stores, mall directories and more all use touch screens to provide services. Unfortunately these touch screens often do not have any accessible features for someone who is unable to clearly see all of its elements. In general touch screens aren't accessible to someone who is visually impaired, and we aim to change that.
Recently WatVision has become open source. The entirety of the source code is now available on Github under the MIT license. The goal for this change was to ensure that the technology would be available to any other developers who would want to pursue this project further, or add accessibility to their own projects.
View the Source Code Here:
The James Dyson Award is an annual competition which has the goal: 'design something that solves a problem'. This open ended Engineering Design award was made to encourage engineering, and innovation.
The WatVision team is incredibly proud to have won the James Dyson 2018 award at the national level. The WatVision design competed with different engineering solutions from all over Canada.
Here are a small selection of the articles written about this achievement:
- Engineering students’ project captures national Dyson award - University of Waterloo
- Waterloo developed app that helps visually impaired wins award - Kitchener Today
- Please search for: 'WatVision James Dyson Award' if you want to learn more!
The WatVision team presented at the University of Waterloo Mechatronics Symposium and won two awards: The General Motors Innovation award, and also 2nd place in the People's Choice award.
The team aims to ensure that this technology becomes available to as many people as possible in the future, and any further news will be posted on this site, or you can subscribe to be notified by email below. Stay tuned!
The WatVision team is made up of 6 fourth year Mechatronics Engineering students from
the university of Waterloo. The team has a diverse background in different areas of technology
such as software, electrical and mechanical engineering concepts.
If you want to get in contact with the team you can email us at:
<EMAIL_ADDRESS>We are happy to answer any questions about our project.


First day as an intern is related with the newness of the situation; new people, new names, new faces, new place. One single ting was familiar my Internship coordinator Lars Niels Henriksen and ……….. the minions. :)
At the very begging my desk was waiting with the cutest message from the team and the minions. In every corner of the room the minions were watching. It may appear that they have changed their strategy and their ultimate purpose is more peaceful as making at ease the interns first day and even the intern stay and forgot all about finding the most despicable master.
As I mentioned before the first day was paved with a lot of new. The surrounding is amazing, happy smiling colleagues, inspirational businesses. The building is decorate in such a manner that wherever you look you get to learn from all the facts on the wall or on the floor. On the walls you can find display of the Business Canvas, on the floor you may read the Stage- Gate model and so on.
I met the colleagues that make Spinderihallerne “spinning”, from the financial department to the top leader. People with beautiful minds that create unbelievable projects; how does it sound a use of the philosophy paradigms in solving social problems or business issues, or a haunted house right on the back of Spinderihallerne all provided by Dystopia team.
 The entire environment is the best place for being creative, innovate and learn from the best.
comments powered by Disqus


SDWebService Class Reference
| Inherits from | NSObject |
| Declared in | SDWebService.h |
Overview
SDWebService is designed to be used to manage a set of web services that exists at a particular endpoint.
It is meant to be subclassed to create methods that work with a particular service.
This class supports only HTTP GET and POST methods.
The web service endpoint and the type of requests and query formats are defined in a plist file which should be specified as documented below.
A sample plist is available as a private gist at: https://gist.github.com/619b18f55c3ff61a908e
SDWebService Property List Format Specification ###
baseURL
(string): This required key describes the base URL endpoint which forms the prefix to all requests.requests
(dictionary): A dictionary comprising of a key for each type of method in the web service.
The name of the key is used in the SDWebservice subclass to access its format from the plist.
Each key itself points to a method dictionary.
Each method dictionary comprises of the following keys:-
method
(string): The HTTP method of the request. SDWebService supports GET and POST. -
routeFormat
(string): The method specific string that follows the baseURL. It may contain replacement markers of the form{replaceMe}
.
Each of those can be replaced by the replacements defined in the routeReplacement sibling dictionary defined below.
They can also be replaced by a routeReplacement dictionary passed into the request creation code via the performRequestWithMethod: calls.
All replacement markers must be substituted with appropriate values using one or both or the above mechanisms when a request is being created. -
routeReplacement
(dictionary): This dictionaly comprises of keys that match the replacement markers in therouteFormat
string.
The value for each key is put in place of the replacement marker when the request is being created. -
postFormat
(string): The method specific string that is sent in the post body in case of a POST request. It may contain replacement markers of the form{replaceMe}
.
Each of those can be replaced by the replacements defined in the routeReplacement sibling dictionary defined below.
They can also be replaced by a routeReplacement dictionary passed into the request creation code via the performRequestWithMethod: calls.
All replacement markers must be substituted with appropriate values using one or both or the above mechanisms when a request is being created.
-
Blocks in use are defined as: ###
// Defined for old-style block callbacks. Data and UI processing occur in this block and it is run on the main thread.
typedef void (^SDWebServiceCompletionBlock)(int responseCode, NSString *response, NSError **error);
// Handles data processing for a given connection. `response` will be an NSHTTPURLResponse 99% of the time.
// The return/result is the dataObject that will eventually be passed to SDWebServiceUICompletionBlock.
// This block is run on a separate GCD thread.
typedef id (^SDWebServiceDataCompletionBlock)(NSURLResponse *response, NSInteger statusCode, NSData *responseData, NSError *error);
// The dataObject parameter is the result of SDWebServiceDataCompletionBlock. UI updates of the contained data should
// happen here. This block is always run on the main thread.
typedef void (^SDWebServiceUICompletionBlock)(id dataObject, NSError *error);
Tasks
-
timeout
The timeout, in seconds, for calls made to this service. Default is
property60.0
. -
+ sharedInstance
Returns the singleton for the web service class.
-
– initWithSpecification:
Initializes the instance with a plist specification included in the bundle and named using the string in
specificationName
and of type .plist. -
– initWithSpecification:host:path:
Initializes the instance with a plist specification included in the bundle and named using the string in
specificationName
and of type .plist.
Overrides thebaseHost
andbasePath
with the parametersdefaultHost
anddefaultPath
. -
– baseSchemeInServiceSpecification
Returns the base scheme in the service specification.
-
– baseHostInServiceSpecification
Returns the base host in the service specification.
-
– basePathInServiceSpecification
Returns the base path in the service specification.
-
– baseURLInServiceSpecification
Returns the baseURL in the service specification.
If the baseURL contains a replacement marker of the type{replaceMe}
, then it is replaced with the value of the keyreplaceMe
if it exists in the Settings bundle.
There can only be one such replacement marker in the baseURL. -
– isReachable:
Returns
YES
if there is reachability to the Internet.NO
otherwise. -
– isReachableToHost:showError:
Returns
YES
if there is reachability tohostName
.NO
otherwise. -
– clearCache
Removes all cached responses.
-
– performRequestWithMethod:routeReplacements:completion:
Calls performRequestWithMethod:routeReplacements:completion:shouldRetry: with
shouldRetry
set toYES
. -
– performRequestWithMethod:routeReplacements:completion:shouldRetry:
Creates and initiates a request to the web service.
-
– performRequestWithMethod:routeReplacements:dataProcessingBlock:uiUpdateBlock:
Calls performRequestWithMethod:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry: with
shouldRetry
set toYES
. -
– performRequestWithMethod:headers:routeReplacements:dataProcessingBlock:uiUpdateBlock:
Calls performRequestWithMethod:headers:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry: with
shouldRetry
set toYES
. -
– performRequestWithMethod:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry:
Calls performRequestWithMethod:headers:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry: with
headers
set tonil
. -
– performRequestWithMethod:headers:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry:
Creates and initiates a request to the web service.
-
– cancelRequestForIdentifier:
Cancles the request that matches the
identifier
. -
– handledError:dataObject:
Override in subclass as so:
SDWebServiceUICompletionBlock uiBlock = ^(id dataObject, NSError error)
{
if ([self handledError:error dataObject:dataObject])
{
// do your ERROR UI
}
else
{
// do your SUCCESS UI*
// You may still need to do some error checking here.
// Think of handledError: as kind of a global error handling for your app.
// If this service call has possible error conditions that no other
// service call would have, you’ll want to look for those here as well.
}
} -
– will302RedirectToUrl:
Implement in subclass for specific behavior in case a request is undergoing a 302 redirect.
-
– serviceCallDidTimeoutForUrl:
Implement in subclass for specific behavior in case a request times out.
-
– showNetworkActivity
Implement in subclass to do what’s needed when network activity starts.
-
– hideNetworkActivity
Implement in subclass to do what’s needed when network activity ends.
Instance Methods
baseHostInServiceSpecification
Returns the base host in the service specification.
- (NSString *)baseHostInServiceSpecification
Declared In
SDWebService.h
basePathInServiceSpecification
Returns the base path in the service specification.
- (NSString *)basePathInServiceSpecification
Declared In
SDWebService.h
baseSchemeInServiceSpecification
Returns the base scheme in the service specification.
- (NSString *)baseSchemeInServiceSpecification
Declared In
SDWebService.h
baseURLInServiceSpecification
Returns the baseURL in the service specification.
If the baseURL contains a replacement marker of the type {replaceMe}
, then it is replaced with the value of the key replaceMe
if it exists in the Settings bundle.
There can only be one such replacement marker in the baseURL.
- (NSString *)baseURLInServiceSpecification
Declared In
SDWebService.h
cancelRequestForIdentifier:
Cancles the request that matches the identifier
.
- (void)cancelRequestForIdentifier:(NSString *)identifier
Declared In
SDWebService.h
handledError:dataObject:
Override in subclass as so:
SDWebServiceUICompletionBlock uiBlock = ^(id dataObject, NSError error)
{
if ([self handledError:error dataObject:dataObject])
{
// do your ERROR UI
}
else
{
// do your SUCCESS UI*
// You may still need to do some error checking here.
// Think of handledError: as kind of a global error handling for your app.
// If this service call has possible error conditions that no other
// service call would have, you’ll want to look for those here as well.
}
}
- (BOOL)handledError:(NSError *)error dataObject:(id)dataObject
Declared In
SDWebService.h
hideNetworkActivity
Implement in subclass to do what’s needed when network activity ends.
- (void)hideNetworkActivity
Declared In
SDWebService.h
initWithSpecification:
Initializes the instance with a plist specification included in the bundle and named using the string in specificationName
and of type .plist.
- (id)initWithSpecification:(NSString *)specificationName
Declared In
SDWebService.h
initWithSpecification:host:path:
Initializes the instance with a plist specification included in the bundle and named using the string in specificationName
and of type .plist.
Overrides the baseHost
and basePath
with the parameters defaultHost
and defaultPath
.
- (id)initWithSpecification:(NSString *)specificationName host:(NSString *)defaultHost path:(NSString *)defaultPath
Declared In
SDWebService.h
isReachable:
Returns YES
if there is reachability to the Internet. NO
otherwise.
- (BOOL)isReachable:(BOOL)showError
Discussion
%warning%
Warning:showError
is currently ignored.
Declared In
SDWebService.h
isReachableToHost:showError:
Returns YES
if there is reachability to hostName
. NO
otherwise.
- (BOOL)isReachableToHost:(NSString *)hostName showError:(BOOL)showError
Discussion
%warning%
Warning:showError
is currently ignored.
Declared In
SDWebService.h
performRequestWithMethod:headers:routeReplacements:dataProcessingBlock:uiUpdateBlock:
Calls performRequestWithMethod:headers:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry: with shouldRetry
set to YES
.
- (SDRequestResult *)performRequestWithMethod:(NSString *)requestName headers:(NSDictionary *)headers routeReplacements:(NSDictionary *)replacements dataProcessingBlock:(SDWebServiceDataCompletionBlock)dataProcessingBlock uiUpdateBlock:(SDWebServiceUICompletionBlock)uiUpdateBlock
Declared In
SDWebService.h
performRequestWithMethod:headers:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry:
Creates and initiates a request to the web service.
- (SDRequestResult *)performRequestWithMethod:(NSString *)requestName headers:(NSDictionary *)headers routeReplacements:(NSDictionary *)replacements dataProcessingBlock:(SDWebServiceDataCompletionBlock)dataProcessingBlock uiUpdateBlock:(SDWebServiceUICompletionBlock)uiUpdateBlock shouldRetry:(BOOL)shouldRetry
Parameters
- requestName
The name of the request as specified in the plist.
- replacements
Route replacements if any for the routeFormat as well as the postFormat in the request spec.
- dataProcessingBlock
The block to execute after the request completes to process the response in a background thread.
- uiUpdateBlock
The block to execute after the dataProcessingBlock completes to update the UI on the main thread.
- shouldRetry
Set to
YES
to retry the request once after a time out.
Return Value
An SDRequestResult object to indicate the success of the method (not the call) and to provide a unique identifier for cancelRequestForIdentifier:.
Declared In
SDWebService.h
performRequestWithMethod:routeReplacements:completion:
Calls performRequestWithMethod:routeReplacements:completion:shouldRetry: with shouldRetry
set to YES
.
- (SDWebServiceResult)performRequestWithMethod:(NSString *)requestName routeReplacements:(NSDictionary *)replacements completion:(SDWebServiceCompletionBlock)completionBlock
Discussion
%warning%
Warning: DEPRECATED. Use performRequestWithMethod:routeReplacements:dataProcessingBlock:uiUpdateBlock: instead
Declared In
SDWebService.h
performRequestWithMethod:routeReplacements:completion:shouldRetry:
Creates and initiates a request to the web service.
- (SDWebServiceResult)performRequestWithMethod:(NSString *)requestName routeReplacements:(NSDictionary *)replacements completion:(SDWebServiceCompletionBlock)completionBlock shouldRetry:(BOOL)shouldRetry
Parameters
- requestName
The name of the request as specified in the plist.
- replacements
Route replacements if any for the routeFormat as well as the postFormat in the request spec.
- completionBlock
The block to execute after the request completes.
- shouldRetry
Set to
YES
to retry the request once after a time out.
Return Value
An enum to indicate the success, or failure of the method (not the call) and also to indicate if the response is cached.
Discussion
%warning%
Warning: DEPRECATED. Use performRequestWithMethod:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry: instead
Declared In
SDWebService.h
performRequestWithMethod:routeReplacements:dataProcessingBlock:uiUpdateBlock:
Calls performRequestWithMethod:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry: with shouldRetry
set to YES
.
- (SDRequestResult *)performRequestWithMethod:(NSString *)requestName routeReplacements:(NSDictionary *)replacements dataProcessingBlock:(SDWebServiceDataCompletionBlock)dataProcessingBlock uiUpdateBlock:(SDWebServiceUICompletionBlock)uiUpdateBlock
Declared In
SDWebService.h
performRequestWithMethod:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry:
Calls performRequestWithMethod:headers:routeReplacements:dataProcessingBlock:uiUpdateBlock:shouldRetry: with headers
set to nil
.
- (SDRequestResult *)performRequestWithMethod:(NSString *)requestName routeReplacements:(NSDictionary *)replacements dataProcessingBlock:(SDWebServiceDataCompletionBlock)dataProcessingBlock uiUpdateBlock:(SDWebServiceUICompletionBlock)uiUpdateBlock shouldRetry:(BOOL)shouldRetry
Declared In
SDWebService.h
serviceCallDidTimeoutForUrl:
Implement in subclass for specific behavior in case a request times out.
- (void)serviceCallDidTimeoutForUrl:(NSURL *)url
Declared In
SDWebService.h


| 2686 - Stargates Europe - Southeastern - 2006/2007 | |||||
| Submit | Ranking |
``A Long Time Ago, in a Galaxy Far, Far Away..." one advanced civilization discovered a manner of instant traveling between solar systems. Since that moment, they have devoted all their efforts to constructing pairs of stargates that connect distant planets. Soon enough communication network became so complex that they require help to maintain information about the connected worlds.
Write a program that will help them maintain information about the connected systems and we will make sure that the best of your solutions will be forwarded to their space-time continuum.
Planets A and B are connected if there is a direct stargate connection between them, or there is a planet sequence P1, P2,...Pn where P1 = A, Pn = B and there is a direct stargate connection between Pk and Pk-1, k {2...n} . Connections are bidirectional. There can be multiple connection paths between two planets.
Input file consist of multiple data sets. Each data set occupies one or more lines. There are no empty lines in the input file. Each line starts with a single letter `D', `C' or `Q' (upper or lower case) followed by 1 to 5 integers with following meaning:
`D' (define) has only one argument which defines number of planets N considered in following data set ( N6000000, planets are numerated from 1..N).
`C' (connect) creates a connection between a given pair(s) of planets.
`Q' (query) examines if a given pair(s) of planets are connected.
Both `C' and `Q' command (`X' in following text) share the same syntax:
X src dst - Creates a connection (or query) between given pair of planets (src, dst).
X src dst nnn - Creates a connection (or query) between src planet and nnn consecutive planets numerated from dst.
Example: X 1 100 3 creates following links (1,100), (1,101), (1,102).
X src dst nnn step - Creates a connection (or query) between src planet and nnn planets numerated from dst with given step.
Example: X 1 100 3 5 creates following links (1,100), (1,105), (1,110).
X src dst nnn dststep srcstep - Creates a connection (or query) between nnn pairs of planets numerated from src with srcstep and dst with dststep respectively.
Example: X 1 100 3 5 15 creates following links (1,100), (16,105), (31,110).
Output file contains one line pre each query (`Q') line in the input file. Each line contains two numbers separated by space dash space sequence. First value represents number of connected planet pairs from appropriate query while second represents number of disconnected planet pairs.
d 5 C 1 3 D 20 q 1 3 c 1 10 10 Q 1 2 18 1 1
0 - 1 9 - 9


pthread_mutexattr_init, pthread_mutexattr_destroy, pthread_mutexattr_settype, pthread_mutexattr_gettype - mutex creation attributes
#include <pthread.h>
int pthread_mutexattr_init(pthread_mutexattr_t *attr);
int pthread_mutexattr_destroy(pthread_mutexattr_t *attr);
int pthread_mutexattr_settype(pthread_mutexattr_t *attr, int type);
int pthread_mutexattr_gettype(const pthread_mutexattr_t *attr, int *type);
int pthread_mutexattr_setkind_np(pthread_mutexattr_t *attr, int type);
int pthread_mutexattr_getkind_np(const pthread_mutexattr_t *attr, int *type);
int pthread_mutexattr_setrobust(pthread_mutexattr_t *attr, int robust);
int pthread_mutexattr_getrobust(pthread_mutexattr_t *attr, int *robust);
Mutex attributes can be specified at mutex creation time, by passing a mutex attribute object as second argument to pthread_mutex_init(3) . Passing NULL is equivalent to passing a mutex attribute object with all attributes set to their default values.
pthread_mutexattr_init initializes the mutex attribute object attr and fills it with default values for the attributes.
pthread_mutexattr_destroy destroys a mutex attribute object, which must not be reused until it is reinitialized.
pthread_mutexattr_settype sets the mutex type attribute in attr to the value specified by type.
pthread_mutexattr_gettype retrieves the current value of the mutex kind attribute in attr and stores it in the location pointed to by type.
PThreads4W also recognises the following equivalent functions that are used in Linux:
pthread_mutexattr_setkind_np is an alias for pthread_mutexattr_settype.
pthread_mutexattr_getkind_np is an alias for pthread_mutexattr_gettype.
The following mutex types are supported:
PTHREAD_MUTEX_NORMAL - for â€˜â€˜fastâ€™â€™ mutexes.
PTHREAD_MUTEX_RECURSIVE - for â€˜â€˜recursiveâ€™â€™ mutexes.
PTHREAD_MUTEX_ERRORCHECK - for â€˜â€˜error checkingâ€™â€™ mutexes.
The mutex type determines what happens if a thread attempts to lock a mutex it already owns with pthread_mutex_lock(3) . If the mutex is of the â€œnormalâ€� or â€œfastâ€� type, pthread_mutex_lock(3) simply suspends the calling thread forever. If the mutex is of the â€˜â€˜error checkingâ€™â€™ type, pthread_mutex_lock(3) returns immediately with the error code EDEADLK. If the mutex is of the â€˜â€˜recursiveâ€™â€™ type, the call to pthread_mutex_lock(3) returns immediately with a success return code. The number of times the thread owning the mutex has locked it is recorded in the mutex. The owning thread must call pthread_mutex_unlock(3) the same number of times before the mutex returns to the unlocked state.
The default mutex type is PTHREAD_MUTEX_NORMAL
PThreads4W also recognises the following equivalent types that are used by Linux:
PTHREAD_MUTEX_FAST_NP â€“ equivalent to PTHREAD_MUTEX_NORMAL
PTHREAD_MUTEX_RECURSIVE_NP
PTHREAD_MUTEX_ERRORCHECK_NP
pthread_mutexattr_setrobust sets the robustness attribute to the value given by robust.
pthread_mutexattr_getrobust returns the current robustness value to the location given by *robust.
The possible values for robust are:
PTHREAD_MUTEX_STALLED - when the owner of the mutex terminates without unlocking the mutex, all subsequent calls to pthread_mutex_*lock() are blocked from progress in an unspecified manner.
PTHREAD_MUTEX_ROBUST - when the owner of the mutex terminates without unlocking the mutex, the mutex is unlocked. The next owner of this mutex acquires the mutex with an error return of EOWNERDEAD.
On success all functions return 0, otherwise they return an error code as follows:
pthread_mutexattr_init
ENOMEM - insufficient memory for attr.
pthread_mutexattr_destroy
EINVAL - attr is invalid.
pthread_mutexattr_gettype
EINVAL - attr is invalid.
pthread_mutexattr_settype
pthread_mutexattr_getrobust
EINVAL â€“ attr or robust is invalid.
pthread_mutexattr_setrobust
EINVAL â€“ attr or robust is invalid.
Xavier Leroy<EMAIL_ADDRESS>Modified by Ross Johnson for use with Pthreads4W.
pthread_mutex_init(3) , pthread_mutex_lock(3) , pthread_mutex_unlock(3) .
For speed, PThreads4W never checks the thread ownership of non-robust mutexes of type PTHREAD_MUTEX_NORMAL (or PTHREAD_MUTEX_FAST_NP) when performing operations on the mutex. It is therefore possible for one thread to lock such a mutex and another to unlock it.
When developing code, it is a common precaution to substitute the error checking type, then drop in the normal type for release if the extra performance is required.


This is some math. With new line characters in between.
inline math, $5.00 $$no math$$
$$5+5$$ inline math
$$5+5$$


{% extends "courses/base_course.html" %} {% load i18n %} {% block content %}
{% blocktrans with course_name=course.name %}The course "{{ course_name }}" has no content.{% endblocktrans %} {% url contact as contact_url %} {% if ask_admin %} {% blocktrans %}Consider getting in touch with an administrator.{% endblocktrans %} {% else %} {% blocktrans with date=course.start_date %}It starts in {{ date }}.{% endblocktrans %}
{% blocktrans %}Please, use this contact form if you have any questions.{% endblocktrans %} {% endif %}


A derecho (pronounced similar to "deh-REY-cho") is a widespread, long-lived wind storm that is associated with a band of rapidly moving showers or thunderstorms. -https://www.weather.gov/lmk/derecho
Although a derecho can produce destruction similar to the strength of tornadoes, the damage typically is directed in one direction along a relatively straight swath.
70% of all derechos occur between the months of May-August (the warm season). The other 30% occur during the cool season.
Derechos in the United States most commonly occur along two axes. One extends along the "Corn Belt" from the upper Mississippi Valley southeast into the Ohio Valley, and the other from the southern Plains northeast into the mid Mississippi Valley (figure below).


| < Day Day Up > |
Other DB2 ComponentsYou are near the end of your excursion behind the scenes of DB2. Before you finish, however, you should know about two other DB2 components that operate behind the scenes: the Boot Strap Data Set (BSDS) and DB2 logging. The BSDS is a VSAM KSDS data set utilized by DB2 to control and administer the DB2 log data sets. It is an integral component of DB2, controlling the log data sets and managing an inventory of those logs. The BSDS is also used to record the image copy backups taken for the SYSIBM.SYSCOPY DB2 Catalog table. Because SYSIBM.SYSCOPY records all other DB2 image copies, another location must be used to record image copies of the SYSIBM.SYSCOPY table. DB2 logs every modification made to every piece of DB2 data. Log records are written for every INSERT, UPDATE, and DELETE SQL statement that is successfully executed and committed. DB2 logs each updated row from the first byte updated to the end of the row. These log records are written to the active logs. DB2 usually has two active log data sets to safeguard against physical DASD errors. The active logs must reside on DASD. (They cannot reside on tape.) The active log data sets are managed by DB2 using the BSDS. NOTE For tables defined using the DATA CAPTURE CHANGES option, an UPDATE causes DB2 to log the entire updated row, even if only one column is changed. As the active logs are filled, DB2 invokes a process called log offloading to move the log information offline to archive log data sets (see Figure 23.6). This process reduces the chances of the active logs filling up during DB2 processing, which would stifle the DB2 environment. DB2 can access archive logs to evoke table space recovery. The BSDS manages and administers the archive logs. Figure 23.6. DB2 log offloading. |
| < Day Day Up > |


 Display 2 | Regular 40px |
| h2. Display 1 | Semibold 25px |
| h3. Headline | Semibold 20px |
| h4. Title | Semibold 18px |
| h5. Subhead | Semibold 16px |
| h6. | Semibold 14px |
| Body | Regular 13px/14px |
| Caption |
Inventors are encouraged to search the USPTO's patent database to see if a patent has already been filed or granted that is similar to your patent. Patents may be searched in the USPTO Patent Full-Text and Image Database (PatFT). The USPTO houses full text for patents issued from 1976 to the present and PDF images for all patents from 1790 to the present.
All sequences (SEQ ID NOs.) and tables for listed patents or publications are available for viewing, without downloading, by accessing the proper document detail page and then submitting a SEQ ID NO or a mega table ID number.
Global Patent Search Network (GPSN) enables users to search the full text of multiple international patent collections. The initial collection available will be Chinese patent documentation from the State Intellectual Property Office (SIPO) of the People's Republic of China. Users can search published applications, granted patents and utility models from 1985 to 2012. The data available includes full text Chinese patents, English machine translations and full document images. This collection will be periodically updated to include additional years of coverage.
Customize a search on all or a selected group of elements (fields) of a patent.
The Patent Application Information Retrieval (PAIR) system provides IP customers a safe, simple, and secure way to retrieve and download information regarding patent application status.
This is text-primary
This is text-warning
This is text-success
This is text-danger
This is text-info
This is text-muted


Browse Illustrations on unDraw →SB Admin 2 makes extensive use of Bootstrap 4 utility classes in order to reduce CSS bloat and poor page performance. Custom CSS classes are used to create custom components and custom utility classes.
Before working with this theme, you should become familiar with the Bootstrap framework, especially the utility classes.


In Hyperbolic Geometry, there are two commonly used models: the Hyperbolic Plane and the Hyperbolic Disk. We will talk briefly about both of them but we will need some results from Möbius Transformations that we won't cover in details.
One of such results is that those transformations build an Isomorphism between the Hyperbolic Plane and the Hyperbolic Disk. To put it simply, an Isomorphism will preserve shapes and distances, so every result we achieve on one of them will be carried to the other as long as we're using Möbius Transformations to move from one to the other.
To construct the Hyperbolic Plane we begin by describing points and lines without any reference to distance.
Lets take the upper half-plane \( H = \{x + iy \text{ }; y > 0\} \) in \( \mathbb{C} \) as our Hyperbolic Plane.
Notice that the \(x\)-axis (horizontal axis) is NOT part of \(H\).
A Hyperbolic Line will be a semicircle in \(H\) whose center lies in \( \mathbb{R} \) and are orthogonal to \( \mathbb{R} \).
However we must also regard 'straight lines' that are perpendicular to \( \mathbb{R} \) as our hyperbolic lines.
Since the horizontal axis is not part of our set, that means those semi-circles and lines in the image above don't intersect
each other within our set, and therefore they are all parallel to one another.
Unlike Elliptical Geometry, this breaks the Fifth Postulate by having too many Parallels (infinite in fact) instead of just one!
A Möbius Transformation or Möbius Map is a function \(f\) of a complex variable that can be written in the form
\( f(z) = \displaystyle \frac{(az+b)}{(cz+d)} \) , where \( (ad-bc) \ne 0 \)
Without getting into too many details about those, it suffices for us to know that this particular family of
functions have the property of mapping Lines into Lines or Circles and mapping Circles into Circles or Lines.
Knowing that, we can conclude that Möbius Transformation maps Hyperbolic Lines into Hyperbolic Lines.
Our second Hyperbolic model is the unitary disk \( D = \{z \in \mathbb{C}; |z| < 1\} \).
Consider the following Möbius Transformation \( g(z) = \displaystyle \frac{(z-i)}{(z+i)} \).
It maps \(H\) into \(D\), which means that our results on the plane \(H\) are carried over to the disk \(D\).
The idea is that we somehow glued both ends of the \(x\)-axis from the \(H\) plane together
This model (as any Hyperbolic one) also has infinite parallels to a given line that cross the same point that's outside of it.


Sunrise Title Company
Specializing in helping
YOU
build
YOUR
American Dream
Home
About
Find Us
CONTACT US
offering professional and courteous
service
Sunrise Title Company has been a bedrock in the Uintah Basin since 1980
Learn More


John and Margo Geddie's Homepage. This is our amalgamated family. We
live in Houston. John is an attorney and Margo is a stockbroker. Matthew is a
technical whiz, a new Boy Scout (having just received the Arrow of Light award)
and a Fifth Grader, Sophie is an instrument-rated pilot and a junior at the
University of St. Thomas, and Ashley is a sophmore at SMU. (Last updated January
26, 2002)
E-Mail John B. Geddie
E-Mail Margo P. Geddie
All About the Geddie Family
Geddie Ships
(Scotland)


The Game of the Century
This is an excerpt of an essay written by Emma Pierson, who previously had a 1768 USCF rating. Full Essay available at https://www.chess.com/blog/batgirl/why-i-play-chess2
I have an Idea!
Explore the theme of ideas found in Inception, Parasite, and Hollow Knight.


Rock Paper Scissors Game
Rock
Paper
Scissor
player selection:
computer selection:
Player Score :
0
Computer Score :
0


Name
Gender
Male
Female
Race
Human
Elf
Dwarf
Qunari
Class
Mage
Rogue
Warrior
Age
Back.
Level
XP
Defense
Armor
Speed
AP
Health
±
Maximum
Current
Mana
±
Weapon
Attack
Damage
Range
Talents & Class Powers
Languages
Equipment
Gold
Silver
Copper
±
Spells
Name
MP
TN
±
Edit
Save
Load
Save
Clear
Notes
+
-
Cast
Cancel
Gold
Silver
Copper
+
-
Add/Remove Spells


HARDBALL A film review by Steve Rhodes Copyright 2001 Steve Rhodes RATING (0 TO ****): **
HARDBALL, directed by Brian Robbins (VARSITY BLUES) and written by John Gatins (SUMMER CATCH), contains more miraculous conversions than a revival. An awkward blend of THE BAD NEWS BEARS with BOYZ N THE HOOD, the movie strains credibility with every plot twist.
Set in the rough environment of an inner city ghetto where the kids are shot at, beaten up and offered drugs, it stars Keanu Reeves as a gambler and a loser named Conor O'Neill. Conor is an almost completely despicable character until, in the last act, he makes his saintly transformation.  Reeves plays an unsympathetic character and plays him badly, so his fans might want to skip this film. In a throwaway part, Diane Lane is given nothing to do as Conor's almost girlfriend.
Since Conor can earn five hundred a week, he agrees to coach a little kids' baseball team.  The team is so bad that a 16-to-1 loss is cause for minor celebration. Although Conor does little more than take attendance and lean against the fence, the kids miraculously learn the game of baseball without anyone teaching them. And just asking them to stop the bad language is all that is needed for them to cleanup their act. Although he pays the kids almost no attention, they are somehow inspired by his surly presence. "Don't you think I might have something better to do than worry about you guys and your little baseball team," he tells them on one of the many times when he abandons them.
The last act is a tear-jerker that makes the movie questionable for kids under 12 who may be significantly traumatized by it. You have to give the film this. Through a twist of fate, it is strangely topical. One of the kids is thrown off of the team because it is discovered that his mother has doctored his birth certificate so that he appears to be younger than he really is.
HARDBALL runs 1:40. It is rated PG-13 for "thematic elements, language and some violence," and would be acceptable for kids around 12 and up.
My son Jeffrey, age 12, thought it was a really good movie and gave it ***. His favorite character was G-Baby (DeWayne Warren).
The film opens nationwide in the United States on Friday, September 14, 2001. In the Silicon Valley, it will be showing at the AMC and the Century theaters.
Web: http://www.InternetReviews.com Email<EMAIL_ADDRESS>Want free reviews and weekly movie and video recommendations via Email? Just send me a letter with the word "subscribe" in the subject line.
========== X-RAMR-ID: 29467 X-Language: en X-RT-ReviewID: 249900 X-RT-TitleID: 1109876 X-RT-SourceID: 703 X-RT-AuthorID: 1271 X-RT-RatingText: 2/4
The review above was posted to the
rec.arts.movies.reviews newsgroup (de.rec.film.kritiken for German reviews).
The Internet Movie Database accepts no responsibility for the contents of the
review and has no editorial control. Unless stated otherwise, the copyright
belongs to the author.
Please direct comments/criticisms of the review to relevant newsgroups.
Broken URLs inthe reviews are the responsibility of the author.
The formatting of the review is likely to differ from the original due
to ASCII to HTML conversion.
Related links: index of all rec.arts.movies.reviews reviews


Event Location:
St. Edwards University
3001 S Congress Ave.
Austin, Texas
Abstract:
DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.
Speaker(s): Paul Stanton,
Abstract:
The ideal way to become a SQL Server professional is to get a degree, get a junior position, and then work your way up. But, the vast majority of data professionals don’t follow this path! Instead, most of us start out as “accidental DBAs” and fumble our way into a full time data career. This is not ideal, and we could all use some help navigating through resumes, job hunting, interviews, and negotiating. You’ll learn about all that in this session. We will also talk about how to get around a big obstacle for both women and men: how to get back to work after a long period of not working. How can I get a database job with no experience? What’s the best way to learn the newest technology? What resources are out there? Bring your questions, and we’ll explore the answers.
Speaker(s): Jennifer McCown,
Abstract:
First impressions have long-lasting effects. When dealing with an architecture change like migrating to Azure SQL Database the last thing you want to do is leave a bad first impression by having an unsuccessful migration. In this session, you will learn the difference between Azure SQL Database, SQL Managed Instances, and Elastic Pools. How to use tools to test migrations for compatibility issues before you start the migration process. You will learn how to successfully migrate your database schema and data to the cloud. Finally, you will learn how to determine which performance tier is a good starting point for your existing workload(s) and how to monitor your workload over time to make sure your users have a great experience while you save as much money as possible.
Speaker(s): John Sterrett,
Abstract:
Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? I will show you how to write stored procedures from scratch, using the design advice I’ve accumulated in my 20+ years of experience. Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!
Speaker(s): Sean McCown,
Abstract:
In the last releases, SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re
Speaker(s): Alex Grinberg,
Abstract:
Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? I will show you how to write stored procedures from scratch, using the design advice I’ve accumulated in my 20+ years of experience. Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!
Speaker(s): Sean McCown,
Abstract:
Have you tried implementing source control? How has your continuous integration (CI) process gone? This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging. At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy. Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.
Speaker(s): Elizabeth Noble,
Abstract:
Most IT folks aren’t a fan of writing documentation. We are far more interested in creating solutions, solving problems, and making things go faster, than in documenting how we did it. But, Future Us will need to know what Today Us meant with this procedure’s parameters, and what that job is even for. Coworkers will thank us for explaining choices made for design, development, and admin. How can we do this without a big Word document? T-SQL comments are simple and natural to create, and can reduce your future troubleshooting time by ten times or more! In this session you’ll learn innovative options for documenting using comments, like using expanded flower boxes, headers, “extended commenting” (also known as help systems), and more. We’ll also talk about the options available for non-comment-able objects: tables, SSIS packages, and SSRS reports. Documenting via comments serves YOU. They’re your repository of tribal knowledge, your exobrain, and your minion. Come learn all about it
Speaker(s): Jennifer McCown,
Abstract:
In this demo-rich session, we will show how VBA can be utilised to create and manage Power Query queries within Excel, using Excel functionality and external files, all without using Power Query directly. The Power Query UI is used to validate that queries and functions are bona-fide. We start by building a query from within Excel VBA to demonstrate the capability and functionality available to the developer. Then we will show how to manage a library of Power Query functions using this VBA technique, demonstrating the usage of one of these functions. Time permitting, we will go on to show how we can extend this technique, taking a multi-company dataset and splitting it into multiple queries, building a template query that can be used to create the multiple queries. All of this will be done without using the Power Query UI, nor even opening Power Query. It is assumed that delegates will be familiar with VBA and Power Query, using the Power Query UI, basic M, and Power Query functions.
Speaker(s): Bob Phillips,
Abstract:
SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.
Speaker(s): Jay Falck,
Abstract:
How do you learn Biml when you don't have years of SQL experience? Is Biml even worth my time and energy when I'm still working on perfecting my SSIS skills? It seems like a lot of work, what is in it for me? In this session you will learn: Why Biml is worth your time and effort. How to identify ideal SSIS packages for conversion. How to convert those packages into Biml. How to troubleshoot your Biml build errors when Google fails you. How to automate SSIS package creation with BimlScript.
Speaker(s): Melissa Stein,
Abstract:
Presented by Redgate DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX. We’ll discuss the techniques used to include the data
Speaker(s): Steve Jones,
Abstract:
R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level. Come to this session to get an introduction to the R language including: - installing and Configuring R and RStudio - RStudio Overview and Debugging - how to Access and Manipulate Data - install and Manage Packages - create and Use Variables - control Flows - functions - basic Graphing and Statistical Analysis. We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos. The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker(s): Jamey Johnston,
Abstract:
SQL Server 2017 and 2019 have arrived, bringing with them a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started! In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Speaker(s): Chris Hyde,
Abstract:
Your SQL Servers are misconfigured! And it is probably not your fault. 90% of the SQL Servers I have seen in my 18 year career are just wrong. Not “crash” or “won’t start” wrong. More like “why is the website so slow” wrong. We are going to roll through a clean install and look at some things that can be made right during the install. And then we will look at some configurations that can only be done after the install. Things like: · Instant File Initialization · Backup Compression · MAXDOP · TempDB configuration · Cost Threshold for Parallelism · And more if we have time! Fair warning…I’m going to overuse the phrase “It Depends” Dallas DBAs is dedicated to helping you find these issues, test them, remediate them and get the most stability, reliability and performance out of your SQL Server.
Speaker(s): Kevin Hill,
Abstract:
Users will learn the best practices for collaborating in the Power BI web service. We’ll review apps vs workspaces, sharing reports with non-Pro accounts, setting up email alerts for your favorite reports, Sharepoint collaboration, and more! This session is all about the Power of teamwork in Power BI!
Speaker(s): DeNisha Malone,
Abstract:
Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. I have stored in Azure Data Lake Store several gigabytes of US Census data at a reasonable rate per month. Now I can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.
Speaker(s): Russel Loski,
Abstract:
How often when creating a new table you just made the Clustered Index using an Integer column with Identity properties. Seems like that is all I have done for last many years. But, in the last two years I’ve really dove into indexes and finally with this presentation looked at what really makes a good Clustered Index with benchmarks and varying scenarios. In some scenarios a well-defined clustered index may out perform a covering non-clustered index. Results are very interesting and may surprise you.
Speaker(s): Mike Byrd,
Abstract:
You’ve looked at query plans and done some tuning, but you’re not sure what’s going on underneath. Hash Match? Merge Join? Watch both come to life in animations, and more! See (not just hear) the inner workings of a plan, and learn about the details that matter for performance. When plans make sense, tuning will become easier, and maybe even fun!
Speaker(s): Forrest McDaniel,
Abstract:
In this session we will talk about the pros and cons of using a non-relational database and where it might fit best into your applications. We will then demonstrate these concepts using Cosmos DB. Azure Cosmos DB is Microsoft's globally distributed, multi-model database service. Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure regions worldwide. You can also take advantage of fast, single-digit-millisecond data access using your favorite API including SQL, MongoDB, Cassandra, Tables, or Gremlin.
Speaker(s): Shawn Weisfeld,
Abstract:
The life of a DBA is evolving and your tuning skills should always be sharp. Tuning is one of the key components of a great DBA and developer. In this demo rich session we'll deep dive into performance tuning for On-Prem, PaaS, and IaaS. We'll discuss tips and techniques for troubleshooting bottlenecks and how to remediate them for hardware, OS, and the database.
Speaker(s): Daniel Janik,
Abstract:
As database administrators, we often are responsible for managing large amounts of databases so it can be difficult to understand who or what is using each of them and why. Yet we are responsible for making sure these databases are backed up, secure and cared for. As well as, we are responsible for leading projects such as upgrades and migrations where this information becomes relevant. If application owners and documentation exist, we can certainly utilize that, but what if it doesn’t or information is limited. This session will look at tips and tricks you can do to figure out what these mystery databases are so you can make better decisions on them. By figuring out what these mystery databases, you will be more equipped to make decisions on things several items such as the following: • Decommissions • Lower resource allocation and costs (especially for storage) • Better planning for database migrations • Troubleshoot connection issues • Better planning for SQL upgrades
Speaker(s): Dustin Dorsey,
Abstract:
Ever wonder how to select what columns need to be in an index definition and what columns should be in the INCLUDE clause. This session will take a deep dive in looking at two SELECT queries on the AdventureWorks2017 database and what indexes give the best, adequate, and poor performance and their relation to disk space utilization. Sometime what you have heard (word of mouth) is not always the overall best solution. This session is about 60% demos and yields some surprising results.
Speaker(s): Mike Byrd,
Abstract:
Do you have a solid social media marketing plan for 2019-2020? Are you sitting on the sidelines paralyzed at the thought of creating engaging content every day for Podcasts, Blog Posts, Twitter, Instagram, Instagram Stories, Instagram TV, Facebook, Linkedin, Twitch, YouTube and SnapChat? In this session, you will learn the 7.5 steps to create a never-ending fountain of meaningful and engaging content across all social media channels. You will gain actionable insight on how to connect with your community as we analyze how RedBull, Buffer, Virgin and Charity Water connect with their communities. At the end of the session, you will be equipped with the tools, resources, and energy-efficient shortcuts to create a custom and scalable marketing strategy.
Speaker(s): Peter Doyle,
Abstract:
This session is for you if you’ve ever built an amazing data set that was everything you needed, but then you went to create a dashboard, you got annoyed by any of the following: -Your boss won’t approve the costs to get PowerBI Desktop. -You’re not a coder, so learning R or Python sounds super scary -You add a whole bunch of columns to your data set and now your file size is gargantuan -You add a field to a pivot table and the grand total row makes no reasonable sense -Your average between two dates is 2.6166666667; how many hours and minutes is that? -You add a date field to a pivot table and the month names get sorted alphabetically -You add a graph to your dashboard, but have to add a table that will be hidden from a user later -The two new pivot tables make your dashboard looks out of whack Providing an overview of the above, the demos will give an insight into how powerful PowerPivot, PowerBI, and DAX can be. I'll provide cool tricks and new ideas on what to search
Speaker(s): Toni Haag,
Abstract:
What do you do when you have a performance or troubleshooting problem that you can’t figure out? One option is to open a support ticket with Microsoft Support (CSS). The CSS engineer will use a specific set of tools to collect and analyze workload data from your SQL Server. Based on this information they might recommend patches, configuration changes, or identify the worst-performing queries. But what if you could bypass support and do all of this analysis yourself? In this session, you'll learn how to use battle tested tools to analyze your workload and error logs. Armed with this information, you'll understand the root cause of the problem and propose solutions to performance and stability problems.
Speaker(s): Kerry Tyler,
Abstract:
You have been hearing about Azure CosmosDB but you haven't had a chance to explore it. In this session, you will learn the key concepts of Azure Cosmos DB. I will use many analogies to explain advantages and limitations of Azure CosmosDB. By the end of this session, you will be able to setup CosmosDB and know its available tools. I will cover the following topics in this session Why do we need another database system? How to setup Azure CosmosDB How to create database and containers. How much does it cost? Multi-Model Apis CosmosDB vs SQL Server How to Import Data into CosmosDB How to use Cosmos DB Emulator CosmosDB Limitations
Speaker(s): Hasan Savran,
Abstract:
You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following: – Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern. – Automatically execute each package multiple times and record the results for analysis. – Determine which package version should be used in production. The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
Speaker(s): David Stein,
Abstract:
Some people think of Oracle and SQL Server as mutually exclusive. In my experience many SQL Server customers use Oracle products to enhance their SQL Server databases because of replication challenges as well as enhanced security. Some of Oracle’s products, such as Oracle GoldenGate, Oracle GoldenGate Veridata, Database Firewall and Audit Vault can greatly enhance Microsoft SQL Server. This presentation covers the basics of what Oracle GoldenGate is, how it works with Microsoft SQL Server and a few case studies on how it has enhanced some large SQL Server installations. GoldenGate is a heterogeneous replication project. It can be used to migrate data between various databases as well as different versions of the same database product. It can be used for database upgrades and migrations, loading data warehouses and data lakes and a number of other purposes. This presentation will introduce you to Oracle GoldenGate, its uses and how to use it.
Speaker(s): Edward Whalen,
Abstract:
As more data services come online in Microsoft Azure, DBAs are being tasked with bringing these services into their organizations. Azure Databricks is one such service that has the appeal of combining scalable compute resources with collaborative development and analytic tools in Notebooks and workspaces. To the traditional DBA, however, many of the concepts and language support may be foreign.  This session is designed to introduce the DBA to the Azure Databricks workspace and show how to easily integrate it with upstream and downstream services like Azure Data Factory and Machine Learning.
Speaker(s): Rodney Landrum,
Abstract:
Do you know what makes a great data model? What does it mean to be Third Normal Form or a Star Schema? When would you use one over the other and why? How can you identify bad designs? In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!
Speaker(s): Leslie Andrews,
Abstract:
This session explains internal SQL Server XML processes and demonstrates how XML shredding could help to solve issues, speed up daily performance monitoring and detect problems. The difference between XML and JSON will be demonstrated, with an in-depth look at the SQL Server - JSON integration. During the session, the audience will be provided with plenty of code examples.
Speaker(s): Alex Grinberg,
Abstract:
Data Governance has been seen by many as a very SCARY and BIG thing requiring biblical efforts to understand and more so to implement. Our discussion will provide context for what, why, and how of Data Governance. You will have an understanding of this and more importantly a road map for how to begin to implement and evangelize within the organization.
Speaker(s): Warren Sifre,
Abstract:
PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions. In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
Speaker(s): Amy Herold,
Abstract:
We will be discussing the lifecycle of a Power BI Dashboard beginning from Accessing data, Data preparation, and cleansing, consuming the data for reports and deploying the reports to Power BI services, configuring security and making the Dashboards available to end users.
Speaker(s): Suresh Datla,
Abstract:
In 2018 creating a cube is one of the more common tasks in BI, however what happens when the cube you build/inherit is growing so much? This session shows how to handle tabular models of size and details the fundamental considerations required in order to allow it to continue to scale. It also delves into what to think about when moving or building your cubes in Azure.
Speaker(s): George Bryant,
Abstract:
Most are talking about it, some have migrated to it and others are just overwhelmed. If you thought Azure was the color of the sky and you are wanting to learn about MS Azure then this is the session for you. Join me for a fun journey to learn the very basics of Azure. Some how-tos, some whys, and some demos. This is a level 0 session, #N00b, #Imabeginner
Speaker(s): Tamera Clark,
Abstract:
Dynamic SQL for the Developer DBA. In this class we will learn how to use Dynamic SQL on a day to day basis. Building Dynamic Tables from a wide variety of parameters passed into your query; Building Dynamic Column headers for those tables and using Pivot to display the results into a grid format. We will also explore passing parameters into and out of your SQL Query, creating dynamic search strings, and creating multiple databases, table structures using cross database scripting and Dynamic SQL.
Speaker(s): Steven Tidwell,
Abstract:
Want to run SQL in Azure. This session will cover all of your options from running SQL in a Windows or Linux VM to Azure SQL PaaS offerings. This is an introductory session. At the end of this session you will have a good understanding of what SQL options are available in Azure and how to create and manage each one.
Speaker(s): Mark Moore,
Abstract:
Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you'll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Speaker(s): David Stein,
Abstract:
Programmers have learned how to design programs, but they haven't really thought about how to design data. First normal form requires that the columns in a table be scalar values. But how many database people actually know what a scale is or have any background in measurement theory? Likewise, how many people invent encoding schemes by simply numbering a list of values? This session should make you into a better database programmer.
Speaker(s): Joe Celko,
Abstract:
The session aim is to get people excited and curious more about ML without digging in coding or deep concepts. We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting Lots of hands-on
Speaker(s): Mohamed Mawla,
Abstract:
A few years back virtualization changed the way to work with SQL and infrastructure. Now the next chapter is opening and it’s all about containers. Containers can make the DBA’s job of creating and deploying servers much easier freeing them up for other tasks such as performance tuning and security. In this session, we will go over the concepts of containers, their general capabilities, and then build, connect and configure a SQL Server in a container for use as a private lab.
Speaker(s): Chris Bell,
Abstract:
Ntirety Lunch Session
Speaker(s): Mike Burek,
Abstract:
You can't wait to move your databases to an Azure PaaS offering so you don't have to patch and maintain an operating system and SQL Server. You looked at Azure SQL DB, but there are some limitations that prevent you from migrating to this service. Don't worry, you're not stranded. There is a new option designed to "Lift and Shift" your workload to Azure PaaS. It's a brand new offering that just came out of private preview and into public preview. We'll discuss this new offering, its advantages, and how you can migrate with ease.
Speaker(s): Ryan Adams,
Abstract:
One of most common problems a data professional may face is finding and syncing data changes efficiently between multiple systems. In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your workflows. Target Audience: Any DBA or developer that has ever faced the problem of moving data changes across databases.
Speaker(s): Martin Perez,
Abstract:
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session, you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. We will cover coding patterns that are developer friendly but are not SQL Server database performance friendly and show you how to rewrite them so they will run faster!
Speaker(s): John Sterrett,
Abstract:
Is blocking giving you grief? How do you know if locking and concurrency is dragging you down? In this session you'll learn the master techniques and tips to solving all your blocking and deadlock troubles.
Speaker(s): Daniel Janik,
Abstract:
Containers are dramatically changing the way that application developers design and build their systems. Databases will need to be a part of this revolution as every application needs a data store. Come see a future vision of how full stack application development might look in the next few years.
Speaker(s): Steve Jones,
Abstract:
In this session, we will build out a multidimensional data cube based on ACH transaction data. The data will be approximately 25 million rows of data. Once we go over the design and load of the data cube, we will look at the data mining capability built into SQL Server to see what kind of insight we can get from the data using SQL Server-based tools. We are going to simulate the data that a financial institution would be receiving in direct deposits and other ACH type transactions. Remember, if your organization is using the enterprise version of SQL Server, all of the associated tools are free to install and use.
Speaker(s): Robert Stewart,
Abstract:
Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to accelerate the learning curve in Microsoft Data Platform, based on my knowledge and experience, the proven strategies and techniques.
Speaker(s): Ganesh Lohani,
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/mike-byrd/1/aa0/bbb
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies. Presenter at many SQL Saturdays over last 6 years in United States, Europe, and Australia. Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced). Video presentations (for local SQL Server user groups or SQL Saturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
LinkedIn: https://www.linkedin.com/in/jayfalck
I started as a night shift computer operator out of high school. I moved to applications development after graduation from SAC. After a few years with the State as an applications developer, the manager of Systems Programming decided it would be better to have me on the inside looking out rather than on the outside trying to get in. I spent the next 14 years as a mainframe system programmer for two state agencies. In 1996 I moved to Healthcare IT and have been that ever since. I’ve spent most of the past 14 years doing ETL, performance and HIPAA security. In these various jobs, I’ve used all manner of databases including InfoTec IMP, IBM VSAM and DB2, Interbase, Informix, Universe, Oracle 9i and SQL Server from 6.0 to 2008 R2.
Rodney Landrum has been architecting solutions for SQL Server for over 15 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He has been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney was also a Microsoft Data Platform MVP from 2008 through 2016.
LinkedIn: http://www.linkedin.com/in/visibardd
Contact: https://wessexbi.wordpress.com/
I am an independent consultant based in the UK, specializing in all things Excel, especially delivering BI within Excel. I came to appreciate the power and versatility of Excel as an enterprise tool in the mid-90s when managing the delivery of a data warehouse project. Now a freelance consultant, I specialize in Excel automation and BI delivered via Excel. An 11 year veteran of Microsoft#39;s MVP program, my life mission is to persuade small and medium corporates that data analysis and BI is important to them too, and that Power BI can help then find that information, in a straight-forward and cost-effective manner.
LinkedIn: https://www.linkedin.com/in/edward-whalen-0460924/
Contact: https://www.perftuning.com
Edward Whalen is an Oracle ACE Director and the Chief Technologist at Performance Tuning Corporation (www.perftuning.com), a consulting company specializing in database migration, security, performance, administration, virtualization, and disaster recovery solutions with over 30 years of experience. He has extensive experience in system architectural design for optimal performance. His career has consisted of hardware, OS, database, and virtualization projects for many different companies. He has written nine books on Oracle products (15 books total), the last four from Oracle Press and several for Microsoft Press. He has also worked on numerous benchmarks and performance tuning projects with Oracle database products. Ed works primarily as
LinkedIn: http://www.linkedin.com/in/aherold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
LinkedIn: http://www.linkedin.com/in/jennifermccown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
LinkedIn: https://www.linkedin.com/in/dustindorsey
Contact: https://dustindorsey.com/
Dustin Dorsey has been architecting and managing SQL Server solutions for companies for well over a decade. While Dustin is skilled in many areas, he has a unique specialization in cost management and architecture around the data platform both on-premise and in the cloud that he has used to provide significant savings for multiple organizations and loves sharing information about this. Dustin is an avid speaker and can be seen writing articles on popular SQL websites, as well as, on his own blog at DustinDorsey.com. He is also active in the Nashville community as a local user group leader and co-organizer of his local SQLSaturday. Dustin currently serves as Director of Data Management at Lifepoint Health.
LinkedIn: https://www.linkedin.com/in/alex-grinberg-36773a6/
I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book "XML and JSON Recipes for SQL Server", also wrote number of articles for Simple-Talk and SQLServerCentral.com
LinkedIn: http://www.linkedin.com/in/way0utwest
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
LinkedIn: https://www.linkedin.com/in/sureshdatla/
Worked on the Microsoft stack for 19 years now. Built successful Data Analytics Practices before. Currently focused on Data Platform, Data Analytics, Power BI and ML. I do Dashboard in a day sessions at Irvine MTC once every month. I also, conduct OC power BI user group to build a strong Power BI Community. Worked with SQL Server product since it was version 7 and Power BI since its inception.
LinkedIn: http://www.linkedin.com/in/way0utwest
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
LinkedIn: https://www.linkedin.com/in/paulstan/
Contact: https://www.windocks.com/blog-2
Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.
LinkedIn: https://www.linkedin.com/in/ganesh-lohani-6275a716
Ganesh Lohani has 10 years of experience working with Business Intelligence platform and Data Analytics, with over 8 years of experience with MS BI tools and Business Intelligence processes. He is currently working for Stericycle as a senior Business Intelligence Developer. He also enjoy his evening and weekend time in providing online training, coaching and mentoring individuals who want to learn MSBI (T – SQL, SSIS, SSRS, SSAS, and Power BI ) products. He holds MSIS degree from University of Texas at Arlington.
LinkedIn: http://www.linkedin.com/in/ryanjadams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud. Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
LinkedIn: http://www.linkedin.com/in/jameyj
Contact: http://STATCowboy.com
Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.
LinkedIn: http://www.linkedin.com/in/russloski
Contact: http://www.sqlmovers.com
Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.
LinkedIn: https://www.linkedin.com/in/alex-grinberg-36773a6/
I have more than 20 years of IT experience. My primary focus is with the latest Microsoft technologies including .NET (VB and C#), SSRS and SSIS. I provide services in tuning, optimization, analysis and development for the creation of new applications, converting legacy technologies (SQL Server, VB.NET and C# ) and site training. I have worked for CSC, VerticalNet, IDP, LSAC , and TMNAS (to name a few) and I am currently employed with Cox Automotive. I am Apress author book "XML and JSON Recipes for SQL Server", also wrote number of articles for Simple-Talk and SQLServerCentral.com
Member of ANSI X3H2 Database Standards Committee for ten years, Author of Joe Celko series of books on SQL and databases for MKP/Elsevier. Author of over a dozen columns in the trade press in the US and Europe.
LinkedIn: http://www.linkedin.com/in/jennifermccown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
LinkedIn: http://www.linkedin.com/in/wsifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQL Saturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Trilingual Principal Consultant amp; Team Tech lead at a global Tech Consulting Mohamed had worked with large SQL server environments such as financials and gov of hundreds of SQL server instances and enormous amounts of data. His favorite subjects are Cloud Analytics, performance tuning, High Availability, especially Replication and Disaster recovery. Certified Google Cloud and Azure Data Engineer. When not working, Mohamed carries his cameras and takes a trip somewhere.
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
LinkedIn: https://www.linkedin.com/pub/leslie-andrews-csm/9/491/b89
Contact: https://www.lace.technology/blog
Leslie Andrews is an IT professional with almost 20 years of experience working with databases, designing databases, as well as designing and developing applications against those databases. 2018-2019 Idera ACE.
LinkedIn: http://www.linkedin.com/pub/daniel-janik/12/15b/606/en
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQL Saturdays.
LinkedIn: http://www.linkedin.com/in/DeNishaMalone
Contact: https://www.denisham.com
DeNisha fell in love with data modeling and management while tutoring T-SQL Querying in college. She self-taught herself Power BI's functionalities after a Business Intelligence internship in fall of 2015 - and has been sticking with the development of Microsoft's BI suite ever since; growing tremendously as the application spreads through enterprises. Outside of BI, her hobbies include mentoring and working with non-profits to enhance IT in the minority communities.
I have been using SQL Server since MS split it off from Sybase in 1994. I love data and finding out what ti can tell the business. At 65, I have started a Master's of Science degree in Business Analytics so I can become even better at making data knowledge.
LinkedIn: http://linkedin.com/in/excelguru1000
Toni has a knack for creating fancy-looking, prescriptive dashboards - her preferred languages are R and DAX in Excel. She just recently graduated with her MBA and MS Business Analytics from UTD this past December - WHOOSH. She's also a proud Texas Tech graduate - WRECK 'EM; earned her Bachelor of Business back in 2012 and minored in Mandarin Chinese -- she finally made it to China this past March! You should check out her Emerging Tech hackathon submission where she won first place and a wicked cool Oculus Quest: https://devpost.com/software/carbon-freightprint-h7a6gx
LinkedIn: https://www.linkedin.com/in/hasansavran/
Contact: http://h-savran.blogspot.com/
Hasan Savran is a BI Architect at Progressive Insurance Company. He spends his days architecting cutting edge business solutions by using the latest Web and Database technologies. He is a Microsoft Data Platform MVP, Microsoft Certified Solutions Developer. Hasan has spoken at many SQL Saturdays, Code Camps and User groups. He is an active member of the HTML5 and WebAssembly W3C groups. He likes to write about SQL, CosmosDB, C#, and Front End development on his blog.
LinkedIn: https://www.linkedin.com/in/kerrytyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
LinkedIn: http://www.linkedin.com/pub/david-stein/8/ba8/705
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
LinkedIn: https://www.linkedin.com/in/mark-moore-795876a?trk=hp-identity-name
Contact: http://blogs.msdn.com/b/markm
Mark Moore is a Cloud Solutions Architect working for Microsoft in North Texas. Mark has been with Microsoft for 25 years serving in various roles in Services and Sales. Prior to Microsoft Mark worked at Digital Equipment Corporation serving Federal and Government customers in San Antonio, Texas. Mark currently resides with his Wife (Deanne) in the DFW area.
LinkedIn: http://www.linkedin.com/pub/david-stein/8/ba8/705
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
LinkedIn: http://www.linkedin.com/pub/daniel-janik/12/15b/606/en
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQL Saturdays.
 For over a decade he's applied his math skills in various industries, and has become specialized in SQL Server performance. His current goal is to animate all the operator algorithms in query plans.
LinkedIn: https://www.linkedin.com/in/elizabeth-a-noble
Elizabeth Noble is a Director of Database Development in the metro Atlanta area. When she was introduced to her first database over 10 years ago, it was love at first sight. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all of the things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.
LinkedIn: https://www.linkedin.com/in/thepeterdoyle/
On Jan 12, 2019, Peter attended his first SQL Saturday and experienced an engaging and uplifting community that encouraged everyone regularly to give back. That experience resulted in teaching eleven sessions and delivering a SQL Fundamentals pre-conference the last six months of the year. He is passionate about sharing knowledge on building a solid T-SQL foundation without wasting time. Peter's journey from minimal Excel knowledge to writing Dynamic SQL all started from watching Youtube videos for three hours every morning before work. Managers took notice of the results and transferred him to the reporting department. A few months later, a co-worker suggested he should learn SQL Server and his world of data has never been the same.
LinkedIn: https://www.linkedin.com/in/mrgbryant
George has over a decade of experience in the Business Intelligence industry and is an active member of the BI community across the Midwest. His knowledge spans multiple industries including, retail, manufacturing, finance, and medical, however recent years has seen him focus on the analytics in sports. George specializes in BI architecture and end to end development in order to deliver advanced analytics and metrics to multiple organizations across the country. In recent years George has focused on and worked primarily in the Azure cloud, utilizing both established and recent offerings.
LinkedIn: http://www.linkedin.com/in/Kevin3NF
Contact: http://www.dallasdbas.com/Blog
I have been working with Microsoft Database technologies since 1994, in Design, Data Modeling, Development and Administration. 18 years of that time have been with SQL Server, going all the way back to 6.5. I find that I am most passionate about the Admin and HA/DR side, but will still dive into design when called upon. The Azure cloud is exciting and I believe is the future of SQL Server. I love teaching new and accidental DBAs all of the things I didn't know when I started.
LinkedIn: https://www.linkedin.com/in/shawnweisfeld
Contact: http://www.usergroup.tv
Shawn (http://www.shawnweisfeld.com<EMAIL_ADDRESS>is passionate about building awesome applications and websites with .NET technologies and Azure. He is currently a Technical Evangelist for Microsoft based in Austin TX and founder of http://UserGroup.tv. Read his full bio at http://about.me/shawnweisfeld
LinkedIn: http://www.linkedin.com/in/johnsterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
LinkedIn: https://www.linkedin.com/in/sqlcodemonkey
Contact: https://www.sqlcodemonkey.com
I am currently the Technical Lead for Client custom projects. I have been writing SQL Code starting in SQL 7. Over the years I have put on many hats, DBA, Developer, Web Developer, C#, VB.NET, Cold Fusion and Java. But at the end of the day, I prefer to write SQL. Local Chapter Leader for the South Montgomery County SQL Server User Group in Montgomery County, Texas.
LinkedIn: http://www.linkedin.com/in/johnsterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
LinkedIn: https://www.linkedin.com/in/mikeburek
Contact: http://tikiwiki.mikeburek.com
He started by building a complete computerized inventory management system for a multi-state store. Next, he managed Texas Medicare and Medicaid claim data to keep it processing, and building new monitoring metrics. Afterwards, he processed and analyzed marketing data on tens of millions of customers and sent hundreds of millions of multi-lingual marketing messages worldwide. Upgrading those marketing skills, he then worked to process and query tune marketing data for tens of thousands of worldwide enterprise customers, bringing in tens of millions of dollars per campaign. Now he monitors database servers to keep them running well, tunes queries, and helps businesses build new ETL processes. He also runs the Austin, TX user group.
LinkedIn: http://www.linkedin.com/pub/mike-byrd/1/aa0/bbb
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies. Presenter at many SQL Saturdays over last 6 years in United States, Europe, and Australia. Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced). Video presentations (for local SQL Server user groups or SQL Saturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
Martin Perez specializes in data quality management, SQL tuning and development for SQL Server. Administration Systems adapt and evolve with the company's needs for day to day operations by efficiently tackling workflow challenges through personal training, trouble shooting, and consultation.
LinkedIn: http://www.linkedin.com/in/tameraclark/
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
Melissa is a database developer for HealthAxis Group and spends her days doing ETL using SSIS and BIML. She taught David everything he knows.
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.
The following is a list of sponsors that helped fund the event.
Ntirety, A Division of HOSTING
Solisyon GmbH / Community Support


Sales Analysis
Add Store Location
Name of Location
Min Cust Per Hour
Max Cust Per Hour
Avg Cookies Per Hour
Create A New Store
Cookies per hour