Stop Verbosity
Description
Stop Verbosity is a jQuery plugin that limits the amount of text that is permitted in a textarea element by replicating the maxlength attribute for the textarea. A line of text, the indicator/counter, counts characters used or remaining when text is entered into the textarea. Once the limit is reached, there is no more text input from typing, pasting or drag and drop.
Default Options
$('textarea').stopVerbosity({ limit: 10, limitFromTextArea: false, indicatorPosition: 'after', indicatorId: '', indicatorElementType: 'p', indicatorPhrase: ['Used', '[countup]', 'of', '[limit]', 'characters.', '[countdown]', 'characters remaining.', 'The maximum is', '[limit]', 'characters.', '
', 'Permits multiple counts up:', '[countup]', 'and counts down:', '[countdown].', 'This indicator is customizable.' ], indicatorUpdateSpeed: 0, existingIndicator: '', generateIndicator: true, showIndicator: true, useNativeMaxlength: true, textLengthChange: false, useMaxlength: true, beforeAttachment: null, afterAttachment: null, existingText: 'clear' });
limit (integer)
The number of characters that are allowed in the textarea.
limitFromTextArea (boolean)
By default false, which only takes the limit from the plugin. If true, then the limit is taken from the textarea's maxlength.
indicatorPosition (string)
Could be 'before' or 'after'. 'before' inserts the indicator before the textarea. 'after' inserts the indicator after the textarea.
indicatorId (string)
Optional id if you wish to quickly refer to the indicator for styling.
indicatorElementType (string)
Should be either a 'p' or 'span' tag since the indicator is text.
indicatorPhrase (array of strings)
Specify your custom text with quotes for an item in the array. '[countup]', '[countdown]', and '[limit]' are the only reserved variable strings. This means these string variable will change on textarea input.
indicatorUpdateSpeed (number)
The delay placed on the indicator before update. This is a number that is represented in milliseconds.
existingIndicator (object)
Supply an indicator element that is already on the page. Has to be a jQuery object ex. $('#my-textarea-indicator')
generateIndicator (boolean)
By default, the indicator will be set to true for auto generation.
showIndicator (boolean)
The indicator will be shown, unless this is set to false.
useNativeMaxlength (boolean)
Uses the browser's maxlength if supported when set to true. However, setting this to false will use the plugin's implementation of maxlength. Should only set to false for testing purposes.
textLengthChange (boolean)
Triggers an event when set to true. Allows for a callback when there is a change in the text length of the textarea. This is useful for doing something that this plugin does not provide.
useMaxlength (boolean)
When set to false, maxlength is not implemented on the textarea. If the indicator is still present, the plugin will act as character counter. Set 'useMaxlength' to false to allow for overflow.
beforeAttachment (function)
Accepts and runs the function that is provided before the plugin initializes (attaching events).
afterAttachment (function)
Similar to beforeAttachment but runs the function after plugin initializes.
existingText (string)
Could be 'clear' or 'truncate'. Determines how existing text is treated during initialization. The 'clear' option will clear out any existing text during initialization, while the 'truncate' option will truncate any excess characters to the right based on the limit.
Examples
Default Configuration
//The default has countdown and countup counters inside the indicator //Has the same settings as the default options $('#default').stopVerbosity({});
Customize Phrase
//Customize the indicator phrase $('#customize-the-phrase').stopVerbosity({ indicatorPhrase: ['This is a custom indicator phrase.', 'This one only counts down. Only', '[countdown]', 'characters', 'left.' ] });
Plugin's Maxlength
//Switch to using the plugin's maxlength implementation //The plugin will automatically use this mode if maxlength is not supported //Should only set this to false for testing purposes $('#use-plugin-maxlength').stopVerbosity({ useNativeMaxlength: false, limit: 6, indicatorPhrase: ["This textarea is using the plugin's implementation of maxlength.", '
 The plugin will automatically use this mode', 'if maxlength is not supported.
 Should only set this to false ', 'for testing purposes. Only', '[countdown]', 'characters', 'left.' ] });
Character Limit
//Change how many characters may be enter into the textarea $('#adjust-limit-value').stopVerbosity({ limit: 5, indicatorPhrase: ['The amount of characters is now limited to 5. Only', '[countdown]', 'characters', 'left.' ] });
Limit from Textarea
//The limit from the textarea element overrides the limit supplied by the plugin. $('#limit-from-textarea').stopVerbosity({ indicatorPhrase: ['Using maxlength from textarea. The limit is', '[limit]','characters.' ], limit: 20 });
Indicator Position
//Change the position of indicator to appear before the textarea $('#indicator-before-textarea').stopVerbosity({ limit: 6, indicatorPosition: 'before', indicatorPhrase: ['Indicator now goes before the texarea.', 'Only', '[countdown]', 'characters', 'left.' ] });
Custom Indicator Id
//The indicator can have a custom id $('#custom-id-for-indicator').stopVerbosity({ limit: 7, indicatorId: 'this-is-a-custom-id-for-the-indicator', indicatorPhrase: ['Choose a custom id for your indicator.
', 'The id of the indicator is "custom-id-for-indicator".
 Only', '[countdown]', 'characters', 'left.' ] });
Indicator Element Type
//Modify the element type of the indicator $('#change-indicator-element-type').stopVerbosity({ limit: 8, indicatorId: 'span-element', indicatorElementType: 'span', indicatorPhrase: ['The element type of the indicator is now', 'a "span".
 Used', '[countup]', 'characters of', '[limit]', 'characters limit.' ] });
Update Speed
//The update speed of the indicator could be changed $('#change-update-speed').stopVerbosity({ limit: 9, indicatorUpdateSpeed: 90, indicatorPhrase: ['Make your indicator update slower by specifying', 'a number in milliseconds.
 This one has a delay of 90 milliseconds.', '[countup]', 'characters of', '[limit]', 'characters limit.' ] });
Existing Indicator
//Use an element on the page for the indicator $('#existing-indicator').stopVerbosity({ limit: 10, existingIndicator: $('#an-existing-indicator'), indicatorPhrase: ['If you already have an indicator element on the page,', 'use it instead.
', '[countup]', 'characters of', '[limit]', 'characters limit.' ] });
No Indicator
This is not an indicator. This is to show that the indicator can be disabled.
The limit is 5 characters.
//Choose not to show the indicator at all //as to use only the maxlength attribute on the textarea $('#no-indicator').stopVerbosity({ limit: 5, showIndicator: false });
Change Event
//Triggers a text length change event //Made sure to set textLengthChange to true $('#text-length-change').stopVerbosity({ textLengthChange: true, indicatorPhrase: ['When the text length changes, the "sv-textLengthChange"', 'event will occur.
', 'Have now used', '[countup]', 'characters of', '[limit].' ] }).on('sv-textLengthChange', function (evt, infoObj) { console.log('There is a text length change for the textarea.'); console.log('Textarea information:', infoObj); //Or do something else here that is //based on the length of currentTextLength //Could be useful for attaching classes onto //the textarea or indicator for styling });
No Maxlength
//No maxlength //Could be a time to use in conjunction with //the sv-textLengthChange event $('#no-maxlength').stopVerbosity({ limit: 1, useMaxlength: false, indicatorPhrase: ['Disable maxlength for no constrain on the amount of text', 'input.
 Use this option to allow for overflow or to only use the indicator. ', '
 Used', '[countup]', 'characters so far. Counting down characters:', '[countdown].', 'The limit is', '[limit]', 'character.' ], textLengthChange: true }).on('sv-textLengthChange', function (evt, infoObj) { console.log('There is a text length change for the textarea.'); console.log('Textarea information:', infoObj); //If infoObj.exceededLimit is true, (limit has been exceeded) can now do something about it });
Before Attachment
//Before attaching plugin, do something with callback $('#before-attachment').stopVerbosity({ indicatorPhrase: ['Stuff to run before the plugin attaches itself.', '[countdown]', 'characters used', 'of', '[limit].' ], beforeAttachment: function () { console.log('Before attaching, do something.'); } });
After Attachment
//After attaching plugin, do something with callback //Reference the infoObj after finishing attachment $('#after-attachment').stopVerbosity({ afterAttachment: function (infoObj) { console.log('Info object is ', infoObj); console.log('Finished attaching, do something.'); } });
Text Truncation
//Existing text in textarea is trucated if text is greater than the limit. $('#text-truncation').stopVerbosity({ indicatorPhrase: ['Original words in textarea was "a lot of words".', 'The limit is', '[limit]', 'of', 'characters.' ], limit: 10, existingText:'truncate' });
Notes
Tested on Opera >= 12.10, Ie >= 6 but 7, Firefox 22, Chrome 28 with jQuery 1.10.2. Attention has been made to the plugin to implement a maxlength that replicates the default maxlength behavior in a textarea. Text overflow is only allowed when setting the plugin's 'useMaxlength' to false. The plugin by default, constrains text and peforms text truncation. Simple substring operations are not done. The maxlength follows the maxlength that are in present in recent versions of Firefox, Ie, and Chrome. This plugin will use the browser's native maxlength and will fallback to the plugin's implementation when lacking maxlength support or with only partial maxlength support. Since Ie9 has faulty support for maxlength, this plugin will monitor the textarea for exceeding the limit and impose the plugins's maxlength. However, this will also override Opera 12 maxlength implementation. To normalize behaviors of browsers, the textarea is cleared upon page refresh and tab key press is prevented when text is highlighted with the mouse. This plugin is mainly a theoretical exercise because most of the newer major browsers do have full support for maxlength (IE >= 10, Firefox >= 4, Opera >= 11, Chrome >= 6). Older browsers version that do not support maxlength in textarea, tend not to be supported by Jquery. The existence of this plugin is then intended to be of use with Ie 6-9. Information of form support from here. Since browsers do not have an undo or redo event in textareas, this plugin will not support undos or redos in the textarea when using the plugin's implementation of maxlength.


Emmanuel2J
My Projects
GitHub repositories that I've built.
My Interests
Topics that I like.
Dart
Music
Python
My Thoughts
Articles I've written.
The title of my blog post
Oct 28, 2021


{{drug}}
Other
{{drug}}
Other
{{drug}}
Other
{{drug}}
Other
{{cancer}}
Other
{{cancer}}
Other
{{cancer}}
Other
{{cancer}}
Other
{{value.value}}
{{value.value}}
{{value.value}}
Other
{{value.value}}
Other
{{value.value}}
Other
{{value.value}}
Other
{{ file }}
Not found in record
Double Check
Not found in record
Double Check
{{modalFieldName | buttonSelect }} about {{field.displayName}}:


Home
Table
Service
Staff
Booking
Welcome to the Vancouver Restaurant
Click here to see tables
Click here to see Staff
Click here to see Booking
New Booking
Customer Name
Customer Phone
Available Table
Available Services
Booking Date
Customer Time


Here is a list of some of the projects that i have been working on during my first week at Moringa.
Tellvinch is a really simple guy who is welcoming to anyone with good intentions.I was born and raised in from a very humble family.In my family of only three members,i have one elder sister and my mother who is a single parent.I went to Mbagathi primary then followed by Upperhill School for my secondary education.I have tought in a primary school for almost one year before joining Moringa School.I love coding alot.I find it fun.Thats the main reason why i joined Moringa school.I also joined to sharpen my skills and get a well paying job in future.I know i will.
I love dancing alot.I have even started my own dancing academy called Talent 8 which is based in Kibra.Apart from dancing i love listening to music and singing.I have decided to save the best for the last,"eating" I literally eat alot.I never choose the food i eat as long as its delicious.


Keep the private keys safely on your Ledger device and use Kukai to access the Tezos blockchain.
You need to open the Tezos Wallet app on your Ledger device and set the derivation path.


Steven Stamkos injury update: Tampa Bay Lightning star (lower body) misses most of win
by Rudi SchullerThe Tampa Bay Lightning won their game Thursday vs. the Chicago Blackhawksbut lost their captain in the process.
Steven Stamkos left the 4-2 victory after suffering a lower-body injury in the first period, according to Tampa Bay coach Jon Cooper. Stamkos played just over five minutes in the contestbut remained on the bench for the second and third periods.
"He wanted to be on the bench with his teammates and cheer them on," Cooper said."I thought that was a big move for him and us."
Cooper offered no updates on the severity of Stamkos' injury, and it's not known whether the 29-year-old forward will have to miss additional time. Tampa Bay was also without Nikita Kucherov on Thursday.
Stamkos leads the Lightning with 20 points (seven goals) this season.


Complete the following form to submit a run
Please enter username:
Please enter user code:
Please select you mode
Guest mode
Member mode
SU test mode (internal use only)
Please all options which apply
Option 1
Option 2
Otpion 3
Please select resolution
high
medium
low
To reset to default settings:


| Block Assessment Survey. | |
| External link to .apk (Github) | |
| External link to source zip (Github) | |
|
App Description
Creating unique community driven datasets is made easier by allowing users to complete numerous surveys regarding livability of their neighborhoods. Utilizing Firebase realtime data storage and gps tools, community organizers can more easily generate data that can lead to real change in their neighborhoods. |
|
| External link to YouTube video | |
|
List of external libraries and code used in this project
Firebase Libraries, Google Geolocator |


Activates a Microsoft application. If the application is not already activated, this function will load the application into memory.
Syntax
APP.ACTIVATE.MICROSOFT(app_id)
App_id is the ID number associated with the Microsoft Application.
| App_id | Application |
| 1 | Microsoft Word |
| 2 | Microsoft PowerPoint |
| 3 | Microsoft Mail |
| 4 | Microsoft Access (for Microsoft Windows only) |
| 5 | Microsoft Fox Pro |
| 6 | Microsoft Project |
| 7 | Microsoft Schedule + |
Remarks
Returns TRUE if the application is activated successfully. Returns FALSE if the application is not activated successfully.
Related Function
APP.ACTIVATE Switches to an application.
Return to index


Hmm it’s August already and that’s mean my time in Binus is just two months left. Yeah, my contract will be ended on 31st October ( I hope so :P ). There are so much experiences that I got while working in Binus, not mentioning the technical experiences but more about the life experiences.
The last 3 weeks I was busy taking my IELTS preparation course, it’s teach you to get accustomed to the IELTS test. The course has 4 parts : the speaking ( in which I needed the most ), the writing ( I have difficulties to write in Indonesian but now I have to write in English, damn ), the reading and the listening. The parts that I most feared are the speaking and the writing ( that’s why I am practicing right now by writing my blog post using English :P ). The IELTS course will be over on 23rd August and that’s mean I have to take the test in September or October so that I can start to looking for the universities in November and December ( I hope it’s not late ).
To tell you the truth, actually I feel a bit scared and not sure if my decision right now is the best. It’s just funny because I remembered that I was so sure about my plan to study abroad. I remembered how I convince my mother about my plan. At first she didn’t agree, she prefer that I continue my study in Singapore because she said it’s closer than Australia. But my father is different, he looks happy when I told him that I want to continue my study. I know that my father put so much faith in me, my sister told me that my father keep telling his friends about my plan to continue my study in Australia. From that I can conclude that he is hoping something big from me, I am happy to heard that and at the same time feel burdened because it’s all my choice to study abroad and my father give all the decision up to me. How if I can’t be what my father wanted me to be ? How if in the end I just ended up wasting his money ?
Maybe it’s just a pessimistic side of me, but after working for about one year and several months has made me questioned several things. The first is what I want to achieve and to do in this life. I keep asking my friends about this question : “What is the differences between you die now and later ?”  Others said that you can’t paid back for what your parents had gave to you, and there is also ‘confucius’ alike opinion : “You must find it by yourself, as long as you keep living, you will find your purpose eventually”.
The second is about the reason why I should take my master degree and abroad. First time I decided to take the master degree is because I already completed my bachelor and I think it will be better if I can continue it to master. So simple, no particular reasons such as for getting good job or showing people that I have money to take my master degree. Time goes by, I started working, feels how to live by your own feet, see how other people struggling with their problems and realize how lucky I am. I am happy to be lucky, I am happy that I have a chance to continue my study abroad but it’s feels like taking another people luck. I am thinking at the moment that maybe I don’t deserve this, why not my sister ? why not my brother ? why me ?
The third is, let’s say I continue my study abroad, after wasting so much money and in the end I can’t pay back what I already wasted. One of my friend in my IELTS course said that if you decided to study abroad, don’t ever think to return to Indonesia before you can pay back what you had wasted. And it’s not included with the plan if I am getting married.
I think right now I just full of confusion, lack of planning, motivation, and reasons. So let’s living this life and wondering what surprise I’ll get next.


created 05/08/00
Write a program that creates a file containing TotalCount random integers (in character format) in the range 0 to HighValue-1. Write PerLine integers per line. Separate each integer with one space. End each line with the correct line termination for your computer.
The user is prompted for and enters HighValue, which should be an integer larger than zero. Then the user is prompted for and enters PerLine, which is an integer greater than zero, and TotalCount, which also is an integer greater than zero. Finally the user is prompted for and enters the file name.
Use a BufferedWriter
with a FileWriter
for output.
Construct a Random object
and use its
method
C:\Programs>java RandomIntData Enter HighValue-->100 Enter how many per line-->10 Enter how many integers-->100 Enter Filename-->rdata.dat C:\Programs>type rdata.dat 4 12 54 10 38 97 40 11 80 16 36 41 67 67 93 58 62 12 50 99 18 42 9 28 45 6 68 72 80 28 86 63 22 17 68 18 59 50 6 50 90 8 68 61 9 24 77 34 62 61 63 8 15 17 67 58 34 56 12 50 43 85 39 77 30 68 89 88 65 68 84 29 42 74 48 55 19 82 95 3 39 27 25 96 41 39 18 84 39 88 82 58 84 90 74 35 24 89 85 92Click here to go back to the main menu.
The previous program used a BufferedWriter between the program and the FileWriter stream. Using a buffer is supposed to increase the efficiency of the program. Does it?
Modify the previous program so that it does not use newLine() (but still uses BufferedWriter). Use it to create a file of 1,000,000 integers. Time how long this takes with a watch.
Now modify the program by removing the BufferedWriter. Again create a file of 1,000,000 integers and time how long it takes. Is there a difference? (On my system there was a sizeable difference.) Be sure that the two versions use exactly the same logic. That is why the newLine() method has to be removed.
Click here to go back to the main menu.Write a program that creates a text file that contains a power of two table in HTML format. The file could be called "twoPowerTable.html". When it is viewed with a browser you will see something like:
| Power of 2 | Value |
|---|---|
| 0 | 1 |
| 1 | 2 |
| 2 | 4 |
| 3 | 8 |
| 4 | 16 |
| 5 | 32 |
| 6 | 64 |
| 7 | 128 |
| 8 | 256 |
| 9 | 512 |
| 10 | 1024 |
The file should start with something like:
 <title>Powers of Two</title>

Power of 2	Value

And end with:

Each line of the table looks like:

0	1

Look at the HTML tutorial at the end of these notes if you are interested.
Click here to go back to the main menu.End of Exercises.


Hi, I'm Alyssa. I like writing code and writing stories.
My website's a work-in-progress. In the meantime, you can catch me at these places:


Event Location:
San Jacinto College - South Campus
13735 Beamer Rd
Houston, Texas
Abstract:
Attend the lunch demo and see how you can use Master Data Services and Maestro to: • Create a golden record for any subject area in a matter of minutes Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment? • Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything? • Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting • Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
Speaker(s): Gene Webb,
Abstract:
At some point in your SQL life you will be asked to calculate or visualize geospatial data. Microsoft SQL server has unique optimizations and frameworks for handling just this circumstance. Not to be confused with Geometric data (square and linear), Geographic data offers even more complexity as you deal with the curvature of the earth and its radial impact on queries. Jared Nielsen is the Principal of the FUZION Agency and the CTO of Online and Digital for Universal Weather and Aviation and contends with geographic data on a daily basis. FIR Boundary intersection, optimized flight planning, weather map overlay and multi-level airspace computations all involve some very interesting SQL Server geographic manipulations that may be interesting for you to experience if you haven't already. Please join me for an in-depth review with helpful resources to guide you on your way as you incorporate Geospatial data into your own applications.
Speaker(s): Jared Nielsen,
Abstract:
In this session, I want to talk about 5 major differences between SQL Server and Oracle, namely: 1. Backup, Restore, Recovery (RMAN vs T-SQL/Powershell) 2. Schema (Single vs Multi tenants) 3. Alter Index Rebuild (defragmentation) 4. AWR, ASH vs DMV/DMF (Performance Trouble-shooting) 5. Data Guard Mode vs AO Availability Group Mode (synch, asynch). I will reference my prior year presentation (SQLSaturday#308) how to automate Backup, Restore, Recover SQL Server, Alter Index for Defragmentation, and monitoring backups and agent jobs by using Powershell/T-SQL. I will also reference my prior year presentation (HASSUG 11/2012) Trouble-shooting with Active Session History (powershell and T-SQL). I will show Oracle 12C in Oracle SQL Developer. Target audiences should have SQL Server DBA working knowledge and basic knowledge in Oracle on these topics.
Speaker(s): Jason Wong,
Abstract:
As a manager or team leader giving effective feedback is vital to the success of projects. In this session we will discuss soft skills and best practices to give feedback, performance improvement, and even disciplinary actions. Learn how to handle confrontation tactfully.
Speaker(s): Christine Assaf,
Abstract:
New features have been added to the last couple of Excel releases in order to bring the most used desktop reporting application to a full-featured Business Intelligence reporting tool for Multidimensional Cubes. This session will be filled with demonstration of all these new features with slides only as references to more detailed explanations and uses. Pivot Tables will be the main focus of this 75-minute session with visual tools that enhance graphs and dashboards. You will leave this session with your brain firing on all cylinders to create cool dashboards with color enhanced backgrounds to signal to users where they should focus their efforts. The new Timeline object makes you breathe a sigh of relief about report filtering by dates. Slicers will give you clues of what data is present. Indicators, data-driven formatting, and spark lines focus attention on what is important to the viewed data set.
Speaker(s): Thomas LeBlanc,
Abstract:
It's 2:30 a.m., and you've just gotten that call no ETL developer wants to get: an SSIS package has failed unexpectedly. Immediately, you start asking yourself: "What could have caused this?", "What do I do to fix the data from this failed execution?", and, most importantly, "Could I design the package in such a way that this doesn't happen again?" In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we'll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We'll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.
Speaker(s): Tim Mitchell,
Abstract:
Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.
Speaker(s): Christine Assaf,
Abstract:
This session will give the basics of starting a tabular model with Analysis Services 2014 and PowerView from Excel 2013. We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in PowerView from Excel 2013.
Speaker(s): Thomas LeBlanc,
Abstract:
What is master data management and why should I care about it? What does the master data services components of SQL Server do for me? Overview of all features of MDS How to build out an MDM subject area How to use MDS for reference data management How to use MDS for data quality How to use MDS with a data warehouse to improve data quality
Speaker(s): Gene Webb,
Abstract:
In the world of extraction, transformation, and loading (ETL), everything we do involves moving data from one point to another. However, very often the focus in SSIS package development is on functionality, not security. When building internal data transformation and movement processes, it is easy to forget that these operations broaden our security footprint, and must be actively managed to ensure that ETL doesn’t become the weak link in the security chain. In this presentation, we’ll discuss the security features in SQL Server Integration Services, while reviewing best practices for securing your ETL infrastructure while providing enough (but not too much) access to those ETL assets. Among the topics we’ll cover: Properly securing connection passwords in SSIS Using package protection levels Restricting access to deployed packages Using role-based security for SSIS deployment and execution Using execution proxies
Speaker(s): Tim Mitchell,
Abstract:
Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in VR. We will follow a query from beginning to end and "runthrough" the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
Speaker(s): Todd Kleinhans,
Abstract:
With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about: Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.
Speaker(s): Jennifer McCown,
Abstract:
You know that Biml can automate ETL loads, but 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:
In this Session, 3 different approaches to using Tracing and Extended Events will be covered. 1. The Long Running Query. 2. The Thousand Paper Cuts - De-Parameterization Aggregation 3. Looking at Space Between SQL Calls (how to determine when application slowness does NOT involve the SQL Server). With each of these approaches we will go over Setting up both tradtional Traces and the newer Extended Events to capture the information you need. How to analyze and make sense of the captured data. Lots of demos and take-away scripts in this session.
Speaker(s): Mindy Curnutt,
Abstract:
Performance troubleshooting is detective work. We'll have a lab system being assaulted by PowerShell scripts (to simulate live users), and simulated performance problems like those that can make your on-call cell phone ring too much! Do you think you have what it takes to find these "needle in the haystack" issues and resolve them quickly? This will be a highly interactive session where we will locate the rogue queries together, work through solutions, implement them and measure the results. In this episode we'll focus primarily on improper indexing as a common underlying problem and all will walk away with much better troubleshooting skills and an upgraded knowledge of performance tuning!
Speaker(s): Jim Murphy,
Abstract:
For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We'll also go over the cardinality estimator changes in 2014. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.
Speaker(s): Lori Edwards,
Abstract:
This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.
Speaker(s): Mindy Curnutt,
Abstract:
The new Minion solutions are taking the SQL community by storm, and no wonder: they’re free, simple to use, and deeply configurable. In this session I’ll show you the benefits to Minion Reindex and Minion Backup: • Simple installation and configuration for all shops, large or small • Single or multi-server installation script • Table-based configuration eliminates the need for excessive jobs • Highly customizable options • Flexible include and exclude options, including the use of regular expressions • “Statement only” option generates statements without running them • Extensive logging • Live insight into the current maintenance operation Minion Backup also provides a truly superb specialty: dynamic backup tuning. Minion Reindex and Minion Backup scale to the size of your enterprise, from one to thousands of instances. With Minion’s true configurability and enterprise features, you can do things never before possible in your maintenance routines.
Speaker(s): Sean McCown,
Abstract:
This is a special session with multiple presenters showing how to utilize free-ish/no-charge Cloud Offerings (e.g., storage, apps) – available from around the Globe at this point-in-time Jun 2015. Even though the free-ish/no-charge offerings are steadily disappearing (e.g., Free Google Apps), this session will show content that applies to both personal/family and SMB’s (Small/Medium Businesses). Expect to walk away with goodies (-: as always :-) … and with answers to questions, such as: – How do I get started with the Global Cloud today? – Any gotchas to keep in mind? – After this session, where do I go for more ... in Houston? PRE-REQUISITE: None other than an interest to utilize the cloud. NOTE: The 3 presenters, Tex (20+ year technologist), Valentino Zane (budding technologists), are with Hybrid Decisions#174; Corp and are presenting on behalf of the “Houston Cloud Cluster User Group”. #171;#177;#187;
Speaker(s): Anthony {Tex} Moreign,
Abstract:
Flash disk and/or SSD technology options have been creeping into SQL Server database deployments more frequently. Knowing what options are out there and how they differ is key to successful deployments because the flash revolution is here to stay, and not all flash is created the same. Oracle ACE Bert Scalzo will present the many significantly different alternatives for utilizing flash disk and/or SSD in SQL Server deployments. Additionally, he will review SQL Server 2012 and 2014 features that support or best utilize flash.
Speaker(s): Bert Scalzo,
Abstract:
Come and enjoy your lunch while learning about what new and exiting changes are coming in SQL Server 2016.
Speaker(s): Mark Moore,
Abstract:
We're all told to watch our weight and to exercise more. Join Dell Software who will show you painless exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastries not provided). In this session, you will learn all about SQL Server’s wait statistics; statistics that the database engine stores about the resources it is waiting on. Armed with this information, SQL Server professionals like you can make better informed decisions on which areas of your environment to tune to ensure greater impact on performance. Join this session to discover where to find, interpret, and use this information to tie down problem areas in your SQL Server environment. This won't be only be about how to fix that problem query, but we'll also talk about how to improve overall performance for all your users.
Speaker(s): Patrick Okeeffe,
Abstract:
As ones responsibilities grow as a senior Database Administrator many more factors come into play to achieving both the realities and perception of high availability. The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success. While some Database Administrator will argue this is out of my scope of responsibilities why should I care about building of professional relationships, managing expectations, helping with setting standards and procedures? The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem.
Speaker(s): George Govantes,
Abstract:
If you manage a large environment then you know how hard it can be to make sure all your SQL Servers adhere to best practice settings and more importantly is making sure they stay that way. I'll show you how to check those settings across all your servers with Central Management Server and how it can help you manage a disperse environment. You will also learn how to leverage the power of Policy Based Management to help you enforce those settings and standards in your enterprise. Best of all you will see how to get alerts sent to you when one of your standard settings is changed.
Speaker(s): Ryan Adams,
Abstract:
The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.
Speaker(s): Sean McCown,
Abstract:
Nobody has a step-by-step plan for your career. But, you do need to know the general direction you’re heading in; which roads go that way (and which ones dead end); and what might be worth stopping for along the way. For example, working for a small shop might be a dead end career move, or it could be a fantastic shortcut to somewhere you really want to be. Getting that next certification might be a worthy way to spend your time, or it might be running around in circles. Want to find out how to get to the next great place in your career? Get solid advice from the people who have already been there. If you want to be somewhere in five years, start moving today.
Speaker(s): Jennifer McCown,
Abstract:
Will do an overview of the PIVOT and UNPIVOT functions and how to manipulate your data in really cool ways. Then we will move on to how to deal with Cursor functions and looping through data, then the joys of #tables vs @tables for your temporary table issues.
Speaker(s): Steve Allison,
Abstract:
Technical Details Flash vs. SSD—Why DBAs should care about the difference How Flash changes storage architecture designs How current storage architecture designs compare Two rather special Flash-based offerings from HGST
Speaker(s): Bert Scalzo,
Abstract:
This session will give an overview of how to use SQL to find performance bottlenecks, determine their source and the effects of flash storage technology on database architecture. Also included is a live demo of SQL running on a flash storage array. Flash storage is the new wave of technology hitting data centers and database design. With any new technology, knowledge is power. Flash storage comes with a new set of pros cons, new economics and changes in architecture that highlight what it has to offer while avoiding the common traps. Before migrating or testing, learn the what's, how's and when's.
Speaker(s): Matt Henderson,
Abstract:
Learn about Cisco Unified Computing System (UCS) and why it is an optimal platform for Microsoft SQL Server. During this session we’ll discuss key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Virtual Interface Adapters, and how they help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.
Speaker(s): Bill Shields,
Abstract:
Azure SQL Database is Microsoft Platform as a Service (PaaS) offering. Although similar to SQL Server, it does have some differences. This session covers best practices and use cases.
Speaker(s): John Cook,
Abstract:
You need to implement AlwaysOn Failover Clustering or Availability Groups, but need help with the Windows Clustering part. This session will guide you to success. We'll talk about how to plan your network, DNS, Active Directory, and storage. I'll provide you with a check list you can use to plan your implementation. We'll see how to choose the right quorum model for a robust failover configuration that ensures your database is always available.
Speaker(s): Ryan Adams,
Abstract:
Foreign Keys have a bad rap – they cause performance issues, they inhibit some inserts, deletes and updates, etc. This may be true, but let’s further explore why we even have them and how they can benefit and maybe even improve performance. This session will concentrate on many demos including the attributes associated with foreign keys. The attendee will walk away from this session with a better understanding of Foreign Key utility and their maintenance.
Speaker(s): Mike Byrd,
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.
Speaker(s): Jim Murphy,
Abstract:
Every SQL Server system that you work with has a tempdb database. In this session, learn how tempdb is structured, what it is used for, and what common performance problems are tied to this shared resource. Gain an understanding of tempdb contention and the snapshot isolation version store and how to detect problems with both. You will leave this session with a new confidence in what configuration and file settings may prevent problems in your environment.
 What do you need to know? This session will cover this topic from first-hand experience.
Speaker(s): Amy Herold,
Abstract:
Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.
Speaker(s): Lance Tidwell,
Abstract:
In part 1 you learned how to plan your network, DNS, Active Directory, and storage. You know what you need to plan a successful implementation and now it's time to put the plan into action. I'll demonstrate setting up a multi-subnet cluster so you know exactly how to do it when you get back to the office. I'll also show you things like Node Draining, Priority Startup, Cluster Aware Updating, and Dynamic Quorum that ensure your database is always available.
Speaker(s): Ryan Adams,
Abstract:
Are you struggling with performance issues and your current tools aren’t providing any helpful answers? This presentation outlines a pragmatic response-time approach that any DBA can use—from new to expert--to tune SQL statements and quickly improve performance. Using real-life case studies, we’ll show you how to put this approach into action.
Speaker(s): James Barnes,
Abstract:
This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate.
Speaker(s): Daniel Janik,
Abstract:
SQL Server has some of the best monitoring tools out there. But what about that server you just discovered?  Or, what if you need additional information that your monitoring tool isn't providing? Or, would you like execution plans and lock information for further analysis? All this and more is possible using the industry standard sp_whoisactive, created by Adam Machanic, to monitor and log activity on your SQL Servers. This session will teach you how to log and query the wealth of information sp_whoisactive provides.
Speaker(s): Rudy Rodarte,
Abstract:
SQL Server Integration Services has a number of tasks and components built into the standard toolbox, however there are times the functionality you are looking for just doesn't exist. This session will introduce you to scripting in SSIS including script tasks and the three script components types; source, destination, and transformation. We will also discuss when to consider using custom and third party components over scripting. This session is not meant to teach you how to develop software with C# or Visual Basic, however coding examples will be demonstrated. Prior knowledge of programming is a benefit but not required.
Speaker(s): David Valentine,
Abstract:
Everyone is talking about the advantages of Biml, but how do you get started? In this highly interactive presentation, I’ll guide you through the process of creating your first BimlScript. During the process we’ll cover the basics of Biml syntax, language options for generating BimlScript, recommended methods of storing and using metadata, and a lot more. As an added bonus, you’ll leave the presentation with BimlScripts you can adapt to use in your own environments using tools that you already have.
Speaker(s): David Stein,
Abstract:
Microsoft recently introduced the Power BI Designer to empower self-service business intelligence charts, reports, and dashboards—without writing code. This session will begin with the Power BI Designer to build charts from data stored in SQL. Then we will bring those charts into a Power BI dashboard and review the options available there. Finally, we'll examine the underlying technology: Power Query, Power View, and Power Pivot, which are free Excel 2013 add-ons that provide additional capability not yet available through the Power BI Designer.
Speaker(s): Theresa Eller,
Abstract:
Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance and functionality of your queries. We will dive into a few TSQL tricks with features that include Common Table Expressions, Table-Valued Parameters, OUTPUT INTO, Window Functions and COALESCE.
Speaker(s): David Valentine,
Abstract:
This will be an introduction to what a data warehouse is and how to build it using the BI stack tool Integration Services. It will mainly cover how to design a data warehouse, dimension tables and fact tables.
Speaker(s): Robert Stewart,
Abstract:
Get a brief overview of the many facets of SQL Server from a developer's point of view. From back ups to T-SQL hacks; this session has something for everyone.
Speaker(s): Dane Schilling,
Abstract:
Perhaps you've heard about the power of SQL Server Reporting Services. Or, you have created some basic reports and you're ready to automate delivery. If so, this session is for you. You'll learn how to create your first SSRS report using Business Intelligence Design Studio (BIDS) and deliver reports to the business automatically in under an hour.
Speaker(s): Rudy Rodarte,
Abstract:
This session will show how an organizational asset hierarchy is leveraged together to provide predicate-based Row Level Security on tables in an Azure SQL Database without application changes. Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating an Azure SQL Database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS using Excel.
Speaker(s): Jamey Johnston,
Abstract:
Take a fascinating journey into how our minds work and discover how binary and mathematical patterns found in music can be used to learn the underlying language of music theory and applied to other disciplines.
Speaker(s): Brian Rigsby,
Abstract:
Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
Speaker(s): Vicky Harp,
Abstract:
For companies looking to achieve data scalability without large capital expenses, SQL Azure provides a flexible, economical alternative to hosting your data on-prem. In this session we will demonstrate how to create a SQL Azure database and how to manage scalability and geo-replication. We will also explore how SQL Server Management Studio allows you to interact with your data on-prem, as well as key differences between SQL Server and SQL Azure. There will also be a demonstration of creating a SQL Azure API using Azure Mobile Services.
Speaker(s): Brian Gogle,
Abstract:
SQL Server is a business-critical component for the line-of business applications and regular monitoring is essential in order to maintain optimal operations as well as to perform effective troubleshooting. Creating a performance baseline of the essential Windows Server and SQL Server performance metrics can help you to both track the health of your SQL Server instance as well as enable you to quickly troubleshoot performance problems. This session will cover the important tools that you can you can use to monitor your SQL Server instances, the essential system metrics to monitor and what they mean to your system’s performance.
Speaker(s): Umair Khan,
Abstract:
We've all installed SQL Server and, most of the times, the default settings work just fine. This is a beginner session that will help you to understand what those settings mean along with why there might be times that you want to use something other than the defaults and how that might impact your server. We'll also talk about unattended installs, both with and without a config file. This can really help to standardize your SQL Server installations and save you some precious keystrokes.
Speaker(s): Lori Edwards,
Abstract:
A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA's, developers and system admins.
Speaker(s): William Assaf,
Abstract:
Your databases are growing faster than your servers. Large tables consume ever-increasing amounts of storage while putting a drag on query response time. What’s a DBA to do? The data compression feature of SQL Server is one tool DBAs can use to save storage space and improve performance. In this presentation you will learn about the types of data compression, how to determine when compression is the right option, and how to make the magic happen
Speaker(s): Justin Randall,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/billshields
Contact: http://blogs.cisco.com/author/billshields
Bill is a Sr. Marketing Manager on the Cisco UCS Global Marketing team. He joined Cisco in November 2010. His duties include managing the development Cisco#39;s UCS TCO/ROI tools and providing sales team support, marketing for UCS Mini and UCS M-Series, and delivering server competitive analysis and positioning. Bill#39;s certifications included a Six Sigma Green Belt from the American Society for Quality and the PMP from the Project Management Institute.
LinkedIn: http://www.linkedin.com/profile/view?id=29648544amp;trk=hb_tab_pro_top
Contact: http://Thomas-LeBlanc.com
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com
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: 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: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: https://www.linkedin.com/pub/bert-scalzo/0/624/782
Contact: http://www.bertscalzo.com/page3.html
Bert Scalzo is an Oracle ACE, author, speaker, consultant, and a major contributor for many popular database tools used by millions of people worldwide, including ERwin, ER/Studio, DBArtisan, Rapid SQL, Aqua Data Studio and TOAD. He has 30+ years of database experience and has worked for several major database vendors. He has BS, MS and Ph.D. in computer science plus an MBA. He has presented at numerous events and webcasts. His areas of key interest include data modeling, database benchmarking, database tuning and optimization, "star schema" ata warehousing, running databases on Linux or VMware, and using NVMe flash based technology to speed up database performance.
Contact: http://dbace.us
Jason Wong has 25+ years experiences working as programmer, apps admin, IT Applications Manager, Sr. DBA in greater Houston area. He has been a SQL Server community speaker since 2008. His career profile, education, publication, travel experiences, along with other interests can be found on his web site. (no commercials, no tracking) http://dbace.us
LinkedIn: http://www.linkedin.com/pub/todd-kleinhans/0/920/981
Contact: https://toddkleinhans.wordpress.com/
Todd Kleinhans has been using SQL Server since the last millennium. He has served in different roles across many industries but he's mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group. He is on Twitter: @toddkleinhans and blogs at https://toddkleinhans.wordpress.com/
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: https://www.linkedin.com/in/mindycurnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
LinkedIn: https://www.linkedin.com/profile/view?id=12189003amp;trk=nav_responsive_tab_profile
Contact: http://www.ingenioussql.com
Dave Valentine is a Development DBA with over 15 years of experience with SQL Server and development technologies, specializing in Business Intelligence and ingenious solutions. Dave has also been an Adjunct Professor at Metropolitan State University for the past 15 years educating students in Database Management and Application Development. Dave started giving back to the SQL community a few years ago by presenting at Local PASS Chapters, SQLSaturday Events, and blogging at IngeniousSQL.com.
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: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: https://www.linkedin.com/company/the-fuzion-agency
Contact: http://www.FUZIONAgency.com
Rather than accepting the status quo, I believe in learning everything, and nothing, and mixing it all together until you have a strange, unique and ethereal blend of technology, marketing, knowledge, wisdom, creativity, passion, charity, caring, and humility. I think that being uncategorizable is the goal since life is the voyage, not the destination, so too should work be that extension of the undefinable so you
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.
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: http://www.linkedin.com/in/sqlwatchmen
Contact: http://sqlwatchmen.com/blogs/jim/
Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90#39;s. He is the CEO of SQLWatchmen, LLC., a managed DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central. He has been a professional DBA and developer for over 25 years and has run a consulting company full time since 2001.
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 SQLSaturdays 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 SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
LinkedIn: https://www.linkedin.com/in/mindycurnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
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/sqlwatchmen
Contact: http://sqlwatchmen.com/blogs/jim/
Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90#39;s. He is the CEO of SQLWatchmen, LLC., a managed DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central. He has been a professional DBA and developer for over 25 years and has run a consulting company full time since 2001.
LinkedIn: https://www.linkedin.com/in/john-cook/
Contact: https://www.red-gate.com/simple-talk/author/johnpaulcook-2/
John Paul Cook is a psychiatric nurse practitioner and instructor of psychiatric nursing. He is former Data Platform Solutions Architect for Microsoft and before that a 9 time Microsoft MVP. John understands both the clinical aspects of healthcare and the technical aspects. He provides a unique perspective in being able to explain clinical concerns and issues to technical people. John is passionate about improving mental health in the community, including in the technical community.
LinkedIn: http://www.linkedin.com/in/loriedwards/
Contact: http://www.sqlservertimes2.com
Lori Edwards currently holds the position of Solutions Engineer for SentryOne. Prior to working with SQLSentry, she spent 11 years working as a production DBA. She also has volunteered for PASS since 2009 on the Program Committee, ERC, Nomination Committee and speaking at SQLSaturdays.
LinkedIn: https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile
Contact: http://blogs.sqlsentry.com/justinrandall
Justin Randall is a Senior Consultant at SQL Sentry, LLC. He has over 30 years of data management experience in a variety of roles from Enterprise Data Modeler to DBA, supporting development in DB2, Sybase, and SQL Server. Justin frequently speaks at SQL Server User Group meetings and SQLSaturdays, and has presented at several SQLintersection conferences. His current professional interests are SQL Server performance monitoring and tuning, and career development.
LinkedIn: https://www.linkedin.com/in/georgegovantes/
SQL Architect and Senior SQL Database Administrator with over 20 years of experience turned Chief Information Security Officer, Certified Information Security Manager, and Governance Risk and Compliance Certified Professional that helps organizations develop cloud and on-prem Identity and Information Security programs. He also trains and consults in the area of IT leadership and the development of high-performance teams.
Contact: http://www.daneschilling.com
From modeling databases to writing complex reports Dane Schilling has utilized MS SQL Server nearly every working day for the last sevenyears.
LinkedIn: https://www.linkedin.com/in/christineassaf
Contact: https://www.hrtact.com
Christine Assaf is an experienced HR pro who is passionate about the mental health of employees, leadership, and organizations. She is a leadership development professional with over 15 years experience in human resources and 20 years in business management. She holds a BS in Business Management, received her HRM certification at LSU, and is finishing up her master's degree at Colorado State University in Industrial and Organizational Psychology. She is a certified DDI Trainer, experienced public speaker, and is dedicated to teaching others about ways to support a culture of "expressiveness" in the workplace that creates connectivity.
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 SQLSaturdays.
Contact: http://www.rodolforodarte.com
Rudy Rodarte works at Dimensional Fund Advisors as a DBA optimizing existing TSQL code, deploying SQL Server 2012, and implementing DB change tickets. Previously, Rudy spent 3 years at HotSchedules.com maintaining databases used by all major restaurants in the US. Rudy also spent 9 years at Dell Inc, in Americas Services Parts creating and maintaining logistics databases that managed inventory in the Americas. Away from the keyboard, Rudy is a big fan of Liverpool Football amp; the Baylor Bears
LinkedIn: https://www.linkedin.com/profile/view?id=12189003amp;trk=nav_responsive_tab_profile
Contact: http://www.ingenioussql.com
Dave Valentine is a Development DBA with over 15 years of experience with SQL Server and development technologies, specializing in Business Intelligence and ingenious solutions. Dave has also been an Adjunct Professor at Metropolitan State University for the past 15 years educating students in Database Management and Application Development. Dave started giving back to the SQL community a few years ago by presenting at Local PASS Chapters, SQLSaturday Events, and blogging at IngeniousSQL.com.
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 SQLSaturday 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.
Contact: http://www.toadworld.com/members/bert_5f00_scalzo/blogs/default.aspx
Bert Scalzo is a renowned database expert, Oracle® ACE, author, and Chief Architect at HGST. With three decades of database experience, Bert’s webcasts garner high attendance and participation rates. Bert has an extensive academic background that includes a BS, MS, and Ph.D. in computer science, as well as an MBA. He wrote two books for SQL Server users: Introduction to SQL Server: Basic Skills for Any SQL Server User Database Benchmarking: Practical Methods for Oracle SQL Server.
LinkedIn: http://www.linkedin.com/in/genewebb
Contact: http://None
Gene Webb is a Regional Sales Executive with The Profisee Group based in Alpharetta Georgia. Profisee is the successor to Stratature the company that built Master Data Services (MDS) and sold the product to Microsoft in 2007. Profisee focuses around Master Data Management (MDM) and as a Gold ISV provides solution sets built on MDS and the Microsoft Stack. Gene spent 7 years working at Microsoft as a SQL Server and Developer Tools solution specialist and an ISV Developer Evangelist.
LinkedIn: http://www.linkedin.com/in/AnthonyTexM
Contact: http://www.hccug.org
{Technologist | Speaker | Writer | Founder} … 25 years counting … – Founder Chief Architect, Hybrid Decisions® Corp (www.HybridDecisions.com | 2005) – Founder President, Houston Cloud Computing User Group (www.HCCUG.org | 2008) – for more info see http://linkedin.com/in/AnthonyTexM «±»
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/christineassaf
Contact: https://www.hrtact.com
Christine Assaf is an experienced HR pro who is passionate about the mental health of employees, leadership, and organizations. She is a leadership development professional with over 15 years experience in human resources and 20 years in business management. She holds a BS in Business Management, received her HRM certification at LSU, and is finishing up her master's degree at Colorado State University in Industrial and Organizational Psychology. She is a certified DDI Trainer, experienced public speaker, and is dedicated to teaching others about ways to support a culture of "expressiveness" in the workplace that creates connectivity.
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/in/genewebb
Contact: http://None
Gene Webb is a Regional Sales Executive with The Profisee Group based in Alpharetta Georgia. Profisee is the successor to Stratature the company that built Master Data Services (MDS) and sold the product to Microsoft in 2007. Profisee focuses around Master Data Management (MDM) and as a Gold ISV provides solution sets built on MDS and the Microsoft Stack. Gene spent 7 years working at Microsoft as a SQL Server and Developer Tools solution specialist and an ISV Developer Evangelist.
Contact: http://vickyharp.com
Vicky Harp is the Group PM Manager for the SQL Server Tools Team, which is responsible for the full set of experiences from drivers and scripting libraries, to GUI tools, to the Azure Portal. She has been building tools for SQL Server for 15 years.
James is a senior sales engineer focusing on Systems Management and Database Tools at SolarWinds. He has nearly 20 years of experience managing all manner of environments with experience in server, virtualization and storage technologies. He also has extensive experience developing software solutions in several languages. He lives with his wife and son in Austin TX.
LinkedIn: http://www.linkedin.com/in/loriedwards/
Contact: http://www.sqlservertimes2.com
Lori Edwards currently holds the position of Solutions Engineer for SentryOne. Prior to working with SQLSentry, she spent 11 years working as a production DBA. She also has volunteered for PASS since 2009 on the Program Committee, ERC, Nomination Committee and speaking at SQLSaturdays.
Contact: http://www.dbguidesign.com
Robert has been involved with SQL Server since it split from Sybase in the mid 1990s. He is currently the DBA/Enterprise Architect for TDECU. He was involved with HAL-PC for over 20 years. He is currently co-leader of the Database and GUI Design Workshop users group that meets the second Saturday of each month.
Contact: http://vickyharp.com
Vicky Harp is the Group PM Manager for the SQL Server Tools Team, which is responsible for the full set of experiences from drivers and scripting libraries, to GUI tools, to the Azure Portal. She has been building tools for SQL Server for 15 years.
LinkedIn: https://www.linkedin.com/profile/view?id=17936460
DBA and architect for over 15 years focusing on high performance SQL Server applications and large scale data warehouses. Matt has been working with SQL on all-flash databases for several years and heads the program at Violin Memory for high performance database tuning for flash devices.
Contact: http://lancetidwell.com
Lance Tidwell, from the Austin, TX, area, has worked as a SQL Server DBA for the last 11 years. During his time as a DBA he has found his passion for all things SQL, but specifically for performance tuning. He has a life-long quest to always be learning new things; currently this quest has lead him to explore more about the Data Analytics/ Data Science areas.
Contact: http://steve.evengame.com/
I am an quot;Accidental DBAquot; who has been coding for nearly 40 years. I started in Basic with data files stored in text files. I have worked up building applications that needed data. In 2008 I took on a partner who allowed me to start focusing on data concerns. Since then, I have battled and self trained to learn the ins and outs of Microsoft SQL and we build and maintain professional cloud based solutions for small to medium sized businesses.
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.
Patrick O’Keeffe is a Director of Software Engineering at Dell Software, where he specializes in the design and implementation of diagnostic and performance products for Microsoft SQL Server, and tools for data provisioning and publishing. Patrick has over 15 years’ experience in leading software development teams, software engineering and architecture and is based in the Dell Software Austin, TX facility. He can be contacted at<EMAIL_ADDRESS>and is @pokeeffe on Twitter.
LinkedIn: https://www.linkedin.com/in/williamdassaf/
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA's. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of "SQL Server Administration Inside Out" by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
LinkedIn: http://www.linkedin.com/profile/view?id=29648544amp;trk=hb_tab_pro_top
Contact: http://Thomas-LeBlanc.com
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.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.
Contact: http://www.rodolforodarte.com
Rudy Rodarte works at Dimensional Fund Advisors as a DBA optimizing existing TSQL code, deploying SQL Server 2012, and implementing DB change tickets. Previously, Rudy spent 3 years at HotSchedules.com maintaining databases used by all major restaurants in the US. Rudy also spent 9 years at Dell Inc, in Americas Services Parts creating and maintaining logistics databases that managed inventory in the Americas. Away from the keyboard, Rudy is a big fan of Liverpool Football amp; the Baylor Bears
LinkedIn: http://linkedin.com/in/khanumair
Umair works as a product marketer in the infrastructure management customer solution unit. He has over seven years of experience working in the software industry with roles spanning from software development, IT management, marketing and pre-sales. Umair has an MBA in Solutions Marketing and Innovation, with an undergraduate degree in software engineering.
Contact: http://zendeveloper.blogspot.com
Brian#39;s formal education is in music, but he is an eighteen year software development veteran. His unorthodox presentation style is both inspirational and entertaining.
LinkedIn: http://www.linkedin.com/in/theresaeller/en
Contact: http://www.techresa.com
Theresa Eller is a SharePoint and Office 365 Administrator with a passion for customer success. Her diverse background includes degrees in Public Relations and Teaching and Learning with Technology, as well as 20 years of experience providing technical support, training, and project leadership. Theresa is a leader, speaker, and blogger in the SharePoint and Office 365 Community.
LinkedIn: http://www.linkedin.com/in/bgogle
Contact: http://briangogle.com
I have had a very diverse career that has always been very focused on insights and how they improve performance. I am currently the Data and Analytics Lead for the Central Region for Neudesic. Prior to consulting I was Vice President of Information Services with Mosaic, a retail services company. leading a forty person team in the U.S. and Canada and architecting a Microsoft BI solution that was accessed by over 1,000 clients from over 140 retailers and retail manufacturers. Before joining Neudesic I served as the Data Management Practice Area Lead for Slalom Consulting in Dallas.
The following is a list of sponsors that helped fund the event.


At NZME we value the communities that gather around our brands and take pride in bringing you premium content worthy of your attention. It’s important to us that whatever we are bringing you, whether it’s the latest news, hit music or in-depth conversation, it’s what you want and its meaningful to you. But to give you more of what you want we need to understand you. This means, with your permission, using the information that you give us to make sure our products and services are on point.
We understand how important your personal information is and that we need to earn your trust, by being honest and transparent about what we do. It’s our job to ensure you really understand what information we collect from you, how we use it and how we keep it safe. We take our commitment to your privacy seriously.
We are committed to complying with privacy laws and standards. For information about the New Zealand Privacy Act 1993 and how it protects all personal information in New Zealand, click here.
To make it easy and clear for everyone, we’ve simplified our Privacy Policy language. No more jargon. It’s now straightforward and to the point.
In this Privacy Policy we (meaning NZME Limited and its related companies) aim to answer your questions about privacy and personal data use at NZME:
- What kinds of information does NZME collect?
- Who does NZME share my information with?
- How might NZME use my information?
- What happens if I interact with any of NZME’s content providers, advertisers or partners?
- How does NZME use cookies and similar tracking technologies?
- How can I control the personal information NZME collects from me?
- Can NZME make changes to this policy? How will I find out?
If you have any other questions about our approach to privacy and personal data use please feel free to contact us by email or by mail to NZME, 2 Graham Street, Private Bag 92198, Victoria St West, Auckland 1142, New Zealand.
We gather information for many reasons but ultimately it allows us to develop, tailor and deliver our services, and inform our marketing and advertising. We will not collect personal information unless it is for a lawful purpose that is connected with one of our functions or activities, and having that information is necessary for that purpose.
The information we gather includes the following types of information about our users, including you:
1. Personal information provided by you when you interact with us or if you link, connect, or log in to your account with a third-party service (e.g. Facebook). This may be when you use or purchase our products or services, when you subscribe or register to use our products or services, when you agree to a background or credit check, when you communicate with us including when you call us, when you post information on discussion boards or comment publicly on our articles, and when you provide us with your feedback or respond to surveys you are asked to participate in.
2. General location information (e.g. your physical or postal address or your device’s IP address) or more specific location information (e.g. precise location from your mobile GPS) when you use certain features of our services. Your mobile device may allow you to control or disable the use of location services in your device’s settings menu.
3. Additional information about you that is publicly available (e.g. we may collect your property information held by local councils).
4. Aggregated information generated by our systems or third party systems we use, which track traffic to and from our sites but does not relate to you personally (this information is generally anonymised, but may include the device, applications or operating system you’re using, your IP address, and your geo-demographic information).
5. Other information that does not personally identify you.
If you choose not to provide personal information that we need from you this may mean some of our products or services will not be available to you or function in the same way.
We will not collect information about any person that we know to be under the age of 13. Nor will we collect special categories of personal information, such as information about your race, political opinions, religion, health or sexual orientation, unless you have chosen to provide that information to us.
We may need to share or disclose:
1. information that we gather, including your personal information, with our related companies. These are the companies partly or fully owned by NZME and their use of the information remains governed by this privacy policy.
2. some of your personal information to our third party service providers so they can help us provide and manage our services (e.g. they help us with service functionality, customer service, billing and invoicing, and conducting research and analysis). We will limit their access to your personal information so they only have what is necessary to perform the tasks we ask of them, and we take steps to ensure they use your personal information consistently with this privacy policy.
3. aggregated tracking information (that is information about our users that we anonymise and combine so that it no longer identifies any individual user) and other information that does not personally identify you to third parties (such as our advertisers and partners) for business purposes such as helping with market analysis, audience profiling, marketing and advertising.
4. non-personal information such as hashed data, click stream information, browser type, and information about your interactions with advertisements which is generated through the use of cookies, beacons, and similar technologies and collected by third parties when you use our services. This information may be combined with other information collected from different websites or online services, and other linked or connected devices. These third parties may use such non-personal information to improve their own services and consistent with their own privacy policies. Please see our section on cookies below for more information.
5. your personal information to third parties when we believe in good faith that we are required to do so by law.
7. your personal information to other third parties provided we have your prior authorisation, which we will usually obtain at the time of collecting the information from you or when you later authorise us to share it.
A list of third parties who may be provided with information, and a description of how those third parties may use this information, can be found here.
We use the information we collect for many reasons that support enable us to provide our services, from ensuring we understand our users and how they engage with us, to informing our marketing and helping our advertisers do the same.
We may use the personal information we collect from you:
1. for verification of your identity and assisting you in case you forget your password or login details where these are necessary to access any of our products or services;
2. for authorising and processing credit card transactions which you enter into online. Credit and debit card information is sensitive information and we do not collect it or store it. We use third party payment solution providers and only engage those that comply with strict industry standards and security processes;
3. to assist in providing the products and services requested by you, including by sending you service communications relating to the services you have opted into;
4. to provide information to you about other websites, products and services, which we consider may be of interest to you;
5. to identify and prevent harm to us or others, including detecting fraud, spam, data security incidents, and other harmful activity;
5. to measure and improve our advertising and for other marketing, promotional and publicity purposes, including carrying out direct marketing, market research and surveys;
6. to sell advertising space on our sites and ensure that you are shown the advertising and information that is most relevant to you and your interests. Our services are funded in part by advertising and we use the information we collect to help explain our audience to our advertisers when they are looking for the right platform for their message; and
7. for any other uses that you authorise.
When you use our services, you may interact with third parties that advertise with us or provide content or link through our sites. We do not control them or what they do and if you provide them with personal information, even while using our sites or services, they may not follow the same privacy policies as us. We recommend you check any relevant privacy policies before providing your personal information to any third party.
Some of our advertisers use third party companies to serve advertisements when you visit our sites. These companies may use information (not including your name, address, email address or telephone number) about your visits to our sites, including information gathered by cookies, in order to provide advertisements about goods and services of interest to you. We do not control the practices of these companies and they may not follow the same privacy policies as us.
We always recommend that you check any relevant privacy policies before providing your personal information to any third party.
Why does NZME use cookies?
We use cookies (and other tools which perform similar functions, like beacons, and local storage)to gather and store information about your use of our services. These tools do not identify you directly but the information collected will be linked to a unique user identifier code that is assigned to you. This allows us to use the information collected by the tools to understand more about your viewing habits and interests, and helps us to deliver our services to you.
How is cookie information used?
We may use the information generated by cookies or similar tools to:
1. track traffic patterns to and from and across our sites such as the pages you visit, the time you spend on each page, the date and time of your visit, and referring pages (pages you came from or go to);
2. ensure advertising is being shown to the most appropriate person based on this data and limit the frequency of display for certain ad formats; and
3. enable you to use certain services as a member without having to log on each time and to visit member-restricted areas of the site.
We may also use online measurement companies and other service providers to analyse our cookie information and help us manage and optimise our digital businesses and communications. These companies take information about visits to our sites to assist us with analysing the site's performance and the effectiveness of advertising so we can optimise our services for users and advertisers. Details of these service providers and the information they may collect can be found here.
To the extent we are aware a user is based in the European Union, we do not use, collect or store tracking data for interest-based advertising purposes.
We may allow third-party companies to serve ads and use cookies or similar tools to collect certain information when you visit our websites. These companies may use non-personally identifiable information and precise geo location and user device identification (if you have provided your consent to us) during your visits to our sites in order to provide advertisements about goods and services likely to be of greater interest to you. To learn more about this interest based advertising practice or to opt-out of this type of advertising, you can visit networkadvertising.org. Third party companies may also use your non-personal information collected in this way in aggregated form or for statistical purposes.
How can you control cookies and the cookie information we collect?
Most browsers accept cookies automatically but you can choose to refuse cookies by turning them off in your browser and/or deleting them from your hard drive. You do not need to have cookies turned on to use our websites, but you may need them for customisable areas of sites we may develop in the future.  This could affect your browsing experience.Additionally you can consider utilizing your browsers “Private Browsing” feature to prevent cookies being stored long term. Modern web browsers offer private browsing features such as "Incognito Mode" in Chrome or "Private Browsing" in Safari.
If our intended collection, use or disclosure of your personal information is outside what we have set out in this Privacy Policy we will give you the option to:
1. opt out prior to signing up for a service and not receive certain services or participate in certain interactive areas; or
2. opt in prior to signing up for a service.
You may opt out from receiving these messages at any time by following the unsubscribe instructions contained in the message.
You may also access or modify your registered accounts at any time on your user profile page for the service. Here you will also be able to update your subscriptions to electronic newsletters and other messaging you have opted into.
If you want to cancel or modify any other account you have with us, please contact us by email or by mail to NZME, 2 Graham Street, Private Bag 92198, Victoria St West, Auckland 1142, New Zealand.
It is essential to us that you trust us and are comfortable sharing your information with us. We understand how important your personal information is and so our goal is to ensure that privacy protection and data security is paramount in all aspects of our data infrastructure and processes.
We design our services with your safety in mind. We maintain industry standard security technology which we monitor routinely. We also have dedicated teams to look after your privacy and information security and where we use third parties to store data we ensure their security meets our standards.
At the same time, no service can be completely secure. If you have any concerns that an account you have with us or personal information has been put at risk, for example if someone could have found out your password, please get in touch straight away.
Any personal information that you provide to us will be collected and managed by us at 2 Graham Street, Auckland, New Zealand. We will only keep your personal information for as long as reasonably required for the purposes we collected it and in accordance with this policy, unless we are required to hold it for longer under law.
Under the Privacy Act 1993 you have the right to ask us for access to the personal information that we hold about you. You may also ask us to update or correct that information at any time and as often as necessary.If you want us to delete information about you or suspend your account, please note that we may need to retain certain information as required by law or for legitimate business purposes. If you withdraw your permission to use your personal information, unless there are other reasons that mean the information must be retained, we will delete that information. However, when you unsubscribe from marketing communications, we will keep your email address to ensure that we do not send you any marketing in the future.
If you want to find out what personal information NZME holds about you, please feel free to contact us by email or by mail to NZME, 2 Graham Street, Private Bag 92198, Victoria St West, Auckland 1142, New Zealand.
We reserve the right to make updates and changes this policy from time to time. If we do revise this privacy policy, we will notify you either by making site announcements that are visible the next time you visit any of our sites or we will send mail or email notification to you.
Updated: April 2019