| Requests | 0.307237 s | |||
|---|---|---|---|---|
| 2,806.3203 kB | ||||
| Benchmark | Min | Max | Average | Total |
| "management/roles/players" (1) |
0.313221 s
|
0.313221 s
|
0.313221 s
|
0.313221 s
|
|
2,818.4219 kB
|
2,818.4219 kB
|
2,818.4219 kB
|
2,818.4219 kB
|
| Kohana | 0.020196 s | |||
|---|---|---|---|---|
| 59.5391 kB | ||||
| Benchmark | Min | Max | Average | Total |
| find_file (83) |
0.000082 s
|
0.000419 s
|
0.000243 s
|
0.020196 s
|
|
0.5313 kB
|
2.5547 kB
|
0.7173 kB
|
59.5391 kB
|
| Database (default) | 0.014144 s | |||
|---|---|---|---|---|
| 35.5625 kB | ||||
| Benchmark | Min | Max | Average | Total |
| SHOW FULL COLUMNS FROM `users` (1) |
0.000983 s
|
0.000983 s
|
0.000983 s
|
0.000983 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT `user`.`id` AS `id`, `user`.`email` AS `email`, `user`.`username` AS `username`, `user`.`password` AS `password`, `user`.`logins` AS `logins`, `user`.`last_login` AS `last_login`, `user`.`avatar_id` AS `avatar_id`, `user`.`team_id` AS `team_id` FROM `users` AS `user` WHERE `user`.`id` = '1' LIMIT 1 (1) |
0.000263 s
|
0.000263 s
|
0.000263 s
|
0.000263 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SHOW FULL COLUMNS FROM `teams` (1) |
0.001274 s
|
0.001274 s
|
0.001274 s
|
0.001274 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT `team`.`id` AS `id`, `team`.`short_name` AS `short_name`, `team`.`full_name` AS `full_name`, `team`.`description` AS `description`, `team`.`success` AS `success`, `team`.`training` AS `training`, `team`.`email` AS `email`, `team`.`phone` AS `phone`, `team`.`street` AS `street`, `team`.`street_no` AS `street_no`, `team`.`zip_code` AS `zip_code`, `team`.`city` AS `city`, `team`.`avatar_id` AS `avatar_id`, `team`.`join_date` AS `join_date` FROM `teams` AS `team` WHERE `team`.`id` = '19' LIMIT 1 (1) |
0.000236 s
|
0.000236 s
|
0.000236 s
|
0.000236 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SHOW FULL COLUMNS FROM `roles` (1) |
0.000808 s
|
0.000808 s
|
0.000808 s
|
0.000808 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` JOIN `role_users` ON (`role_users`.`role_id` = `role`.`id`) WHERE `role_users`.`user_id` = '1' (1) |
0.000292 s
|
0.000292 s
|
0.000292 s
|
0.000292 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` WHERE `name` <> 'login' AND `name` <> 'admin' (1) |
0.000258 s
|
0.000258 s
|
0.000258 s
|
0.000258 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` WHERE `name` = 'player' LIMIT 1 (1) |
0.000281 s
|
0.000281 s
|
0.000281 s
|
0.000281 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT `user`.`id` AS `id`, `user`.`email` AS `email`, `user`.`username` AS `username`, `user`.`password` AS `password`, `user`.`logins` AS `logins`, `user`.`last_login` AS `last_login`, `user`.`avatar_id` AS `avatar_id`, `user`.`team_id` AS `team_id` FROM `users` AS `user` JOIN `role_users` ON (`role_users`.`user_id` = `user`.`id`) WHERE `role_users`.`role_id` = '3' AND `team_id` = '19' LIMIT 30 (1) |
0.000217 s
|
0.000217 s
|
0.000217 s
|
0.000217 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '1' AND `role_id` IN ('3') (1) |
0.000242 s
|
0.000242 s
|
0.000242 s
|
0.000242 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '1' AND `role_id` IN ('4') (2) |
0.000181 s
|
0.000206 s
|
0.000193 s
|
0.000387 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '1' AND `role_id` IN ('5') (2) |
0.000169 s
|
0.000175 s
|
0.000172 s
|
0.000344 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '1' AND `role_id` IN ('6') (1) |
0.000206 s
|
0.000206 s
|
0.000206 s
|
0.000206 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '1' AND `role_id` IN ('7') (2) |
0.000159 s
|
0.000185 s
|
0.000172 s
|
0.000344 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '1' AND `role_id` IN ('8') (2) |
0.000186 s
|
0.000283 s
|
0.000234 s
|
0.000469 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '2' AND `role_id` IN ('3') (1) |
0.000187 s
|
0.000187 s
|
0.000187 s
|
0.000187 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '2' AND `role_id` IN ('4') (2) |
0.000168 s
|
0.000177 s
|
0.000172 s
|
0.000345 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '2' AND `role_id` IN ('5') (2) |
0.000161 s
|
0.000163 s
|
0.000162 s
|
0.000324 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '2' AND `role_id` IN ('6') (2) |
0.000176 s
|
0.000185 s
|
0.000180 s
|
0.000361 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '2' AND `role_id` IN ('7') (2) |
0.000157 s
|
0.000163 s
|
0.000160 s
|
0.000320 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '2' AND `role_id` IN ('8') (1) |
0.000173 s
|
0.000173 s
|
0.000173 s
|
0.000173 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '22' AND `role_id` IN ('3') (1) |
0.000220 s
|
0.000220 s
|
0.000220 s
|
0.000220 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '22' AND `role_id` IN ('4') (2) |
0.000178 s
|
0.000196 s
|
0.000187 s
|
0.000374 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '22' AND `role_id` IN ('5') (2) |
0.000180 s
|
0.000232 s
|
0.000206 s
|
0.000412 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '22' AND `role_id` IN ('6') (2) |
0.000163 s
|
0.000165 s
|
0.000164 s
|
0.000328 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '22' AND `role_id` IN ('7') (2) |
0.000153 s
|
0.000156 s
|
0.000154 s
|
0.000309 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT COUNT(*) AS `records_found` FROM `role_users` WHERE `user_id` = '22' AND `role_id` IN ('8') (2) |
0.000184 s
|
0.000218 s
|
0.000201 s
|
0.000402 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` JOIN `role_users` ON (`role_users`.`role_id` = `role`.`id`) WHERE `role_users`.`user_id` = '1' AND `name` <> 'login' AND `name` <> 'admin' (1) |
0.000257 s
|
0.000257 s
|
0.000257 s
|
0.000257 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` WHERE `role`.`id` = '4' LIMIT 1 (3) |
0.000173 s
|
0.000215 s
|
0.000199 s
|
0.000597 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.8516 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` WHERE `role`.`id` = '5' LIMIT 1 (3) |
0.000177 s
|
0.000203 s
|
0.000186 s
|
0.000559 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.8516 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` WHERE `role`.`id` = '7' LIMIT 1 (3) |
0.000160 s
|
0.000175 s
|
0.000165 s
|
0.000496 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.8516 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` WHERE `role`.`id` = '8' LIMIT 1 (2) |
0.000176 s
|
0.000248 s
|
0.000212 s
|
0.000424 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` JOIN `role_users` ON (`role_users`.`role_id` = `role`.`id`) WHERE `role_users`.`user_id` = '2' AND `name` <> 'login' AND `name` <> 'admin' (1) |
0.000806 s
|
0.000806 s
|
0.000806 s
|
0.000806 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` WHERE `role`.`id` = '6' LIMIT 1 (2) |
0.000190 s
|
0.000227 s
|
0.000208 s
|
0.000417 s
|
|
0.6172 kB
|
0.6172 kB
|
0.6172 kB
|
1.2344 kB
|
|
| SELECT `role`.`id` AS `id`, `role`.`name` AS `name`, `role`.`description` AS `description` FROM `roles` AS `role` JOIN `role_users` ON (`role_users`.`role_id` = `role`.`id`) WHERE `role_users`.`user_id` = '22' AND `name` <> 'login' AND `name` <> 'admin' (1) |
0.000229 s
|
0.000229 s
|
0.000229 s
|
0.000229 s
|
|
1.6172 kB
|
1.6172 kB
|
1.6172 kB
|
1.6172 kB
|
| Player | 0.092612 s | |||
|---|---|---|---|---|
| 46.3984 kB | ||||
| Benchmark | Min | Max | Average | Total |
| manage_players (1) |
0.092612 s
|
0.092612 s
|
0.092612 s
|
0.092612 s
|
|
46.3984 kB
|
46.3984 kB
|
46.3984 kB
|
46.3984 kB
|
| Application Execution (5) | 0.363496 s | 0.481668 s | 0.409012 s | 0.387001 s |
|---|---|---|---|---|
| 3,982.8359 kB | 4,028.8672 kB | 4,004.2375 kB | 4,006.1953 kB |


Event Location:
The Microsoft Technology Center
5404 Wisconsin Ave, Suite 700
Chevy Chase, Maryland
Abstract:
One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!
Speaker(s): Chris Hyde,
Abstract:
It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability. You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.
Speaker(s): Sebastian Meine,
Abstract:
In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform agnostic and ubiquitous as the internet. In that same note, github, the most popular service for hosting git repositories has become so ubiquitous that Microsoft chose to host the source code for its OSS fork of the .NET framework there instead of its own codeplex. What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS. In my session. We'll cover: What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github? We will be covering using git from both the command line and Visual Studio.
Speaker(s): Justin Dearing,
Abstract:
In this Session, 3 different approaches to using Extended Events will be covered - culminating in a non-traditional approach of using them to determine what is MISSING -- thus the application / network portion of a user experience. We will cover using XEvents to do the following: 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). Each approach will detail the following: Creating an Extended Events Session to capture the information you need for each scenario. How to analyze and make sense of the captured data. Lots of demos and take-away scripts!
Speaker(s): Mindy Curnutt,
Abstract:
Your database servers are insecure, and you know it. Unfortunately, so does the person upstairs who just wants to take a peek. That executive who wants a copy of the database to build some reports on the plane knows it. So does the call center rep who’s trying to provide great service to the customer on the phone. And the hacker who’s attacking your website? Yeah, they know it, too. We can no longer rely solely on the same old security practices to protect our data. We need to secure the data at its source. In this full-day course, we will take a tour of security for the Microsoft data platform, particularly SQL Server. The complex security needs of SQL Server itself will be presented as a series of layers to give participants a framework for planning and implementation. By the end of the day, participants will gain familiarity with tools and techniques they can use to protect their systems from common threats.
Speaker(s): Ed Leighton-Dick,
Abstract:
"As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times. It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer. This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact. You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage
Speaker(s): Jason Brimhall,
Abstract:
As DBAs, we are asked all sorts of impossible questions. Who dropped that important table last month? Why was everything slow last week? Who made that user a sysadmin? You’d have to be a mind reader to know the answers to some of those, right? Not necessarily! SQL Server can help you find information about these and other common problems with its default trace and system_health Extended Events session, but you have to know how to collect and interpret the data they provide. In this session, we’ll explore what system_health and the default trace are, what information they contain, and how to use them to find the answers you’re searching for.
Speaker(s): Ed Leighton-Dick,
Abstract:
Did you know that most employers -- whether looking for a full time employee, contractor, or consultant – interview people because of their technical skills and experiences, but hire and keep them for their social capital? In times of economic downturn, it’s not the person who is the most competent who stays; it’s the one who’s most competent, likeable, and connected. Socially adept people also get invited to the table more often for big projects and are promoted (or extended) more frequently than purely ‘competent’ individuals. Whether or not you’ve been in your role for a few months, years, or even decades – or you’re looking for a new job and new opportunities -- strategic networking is the way to make yourself more relevant, more attractive for projects and promotion – or more hirable by potential customers. Join us for an interactive session to strategize the best actions to increase your social capital and network your way to success!
Speaker(s): Lisa Margerum,
Abstract:
You know about the cloud but you’re not there yet. Is it hard? Is it easy? How do you get started? Come to this session and see for yourself. We’ll start with nothing and end up with a deployed Azure SQL Database. We’ll even run a quick PowerBI report and enable Geo-Redundant Disaster Recovery with a few clicks. The goal is to take the mystery out, to show the capabilities and get you thinking about what going to the cloud could look like and what it can do for you and your company. I believe the future belongs to those who have this knowledge and know where to apply it. This will be nearly PowerPoint free and we’ll log into my Azure Portal and build out an environment from scratch and learn as we go. We’ll migrate data from an “on-premises” database into our SQL DB and we’ll query it. You’ll leave with an understanding of the capabilities, some resource links outlining what we did and hopefully some curiosity to see what else is up there in the cloud as you start exploring.
Speaker(s): Mike Walsh,
Abstract:
Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out. This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.
Speaker(s): Rie Irish,
Abstract:
Based on the award-winning interview television show Inside the Actors Studio, this session is an interview with a “SQLebrity” from the community. Interview subjects will share their path to success, discussing both their successes and their failures along the way. Host Andy Mallon persuades his interviewee (Rie Irish) to discuss personal experiences during his chats while discussing the highlights and lowlights of her career. We will talk about Rie's childhood, how she got started in the business, her early career, and behind-the-scenes trivia. The interview concludes with the Proust Questionnaire, made famous by Bernard Pivot (Apostrophes) and James Lipton (Inside the Actors Studio). Attendees will also have an opportunity to ask their own questions.
Speaker(s): Andy Mallon,
Abstract:
This session will feature a real story of a customer who was running into performance and scaling issues on a big iron Oracle RAC system and why they decided to consider the magic of the Column Store for this situation. Discussion will focus on the existing environments for testing both SQL 2016 and Oracle as well as the methodologies used for testing. We will examine the decisions made for choosing indexes (both traditional and column store) for the main tables in the data warehouse as well as the partitioning strategies employed. We will wrap up the discussion with the results of the testing and where they are now.
Speaker(s): Rick Heiges,
Abstract:
Almost everyone uses SSMS to write queries and to browse around on the server - but do you use all of the features that SSMS offers to increase your productivity? Most people use few of these, and probably don't even know that many of these features even exist. Come to this session, consisting almost entirely of demos in SSMS, to see features built in to SSMS that will improve your experience and productivity. Time permitting; we'll also go into some 3rd party products that also increase your productivity in SSMS.
Speaker(s): Wayne Sheffield,
Abstract:
It seems like web apps are getting all the love and at first glance it may be hard to identify a good way to use the database in containers. This session will review the concept of containers and attempt to identify ways we might benefit from this new technology as we support our users.
Speaker(s): Carlos L Chacon,
Abstract:
How secure is Power BI and how do I apply user security? Come to this session to learn two things: 1. How secure Power BI really is in the cloud? We will go over what architecture Power BI uses to secure the data. 2. How does user security work Power BI? We will cover "who can see what" from a user point of view.
Speaker(s): Ravi Kumar,
Abstract:
Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker(s): Jim Donahoe,
Abstract:
With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.
Speaker(s): Brian Carrig,
Abstract:
We've all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for inserts? Are they ever a good idea? For this installment of Rick's "Weird Stuff" series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.
Speaker(s): Rick Lowe,
Abstract:
Are you a contractor or freelancer? Do you have dreams of creating your own consulting company? Branding expert Ivan Carter wants to empower you with simple to use concepts that can propel you forward, increase your value and build strong loyalty among the customers you want to reach and work with. By understanding the 7 easy concepts you can create a brand the not only your future clients will love, but will make you feel more confident as well.
Speaker(s): Ivan Carter,
Abstract:
While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker(s): Amy Herold,
Abstract:
SQL Server R Services: Microsoft acquired Revolution Analytics in early 2015, and introduced R services (in-database/stand-alone) with SQL Server 2016. With the first Microsoft Data Science summit behind us last Sept, in Atlanta, let us review what R Services in SQL Server brings to the table and see how it complements/supersedes features that are available with other R offerings (R GUI, Microsoft R Client [R Studio], Microsoft R Open [RROpen], Microsoft R Server[RREnterprise] etc.,)
Speaker(s): Azhagappan Arunachalam,
Abstract:
Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role. In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery. By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.
Speaker(s): Jim Donahoe,
Abstract:
Graphs are everywhere! Microsoft has been adding a lot of new features to SQL Server 2017, and among them SQL Graph has been one - one that holds a lot of promises, though it's still in its early stages (at least with Microsoft products). Microsoft recently added Graph DB to their DocumentDB (product) and released it as Cosmos DB. In this session, we'll take a look at what this feature brings to the table, and how it compares with other Graph databases.
Speaker(s): Azhagappan Arunachalam,
Abstract:
Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Speaker(s): Jason Brimhall,
Abstract:
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.
Speaker(s): Kevin Feasel,
Abstract:
Most of us have heard that using the NOLOCK hint is not recommended. But why is this? What is it about NOLOCK that sends most DBAs into a tizzy? And how about other hints such as ROWLOCK and RECOMPILE - are they OK to use? Come hear a discussion on why exactly query hints cause problems when used excessively, and watch some demos of NOLOCK craziness in action.
Speaker(s): Rick Lowe,
Abstract:
Both DBA’s and Developers should be acutely aware of what it takes to ensure that every call to SQL Server has the best chance of reusing a previously generated query plan. Having to generate a new plan each time will waste precious resources and ultimately prevent you from obtaining peak performance and scalability for that SQL Server Instance. We will cover the fundamentals of how query plans get reused and how you need to write your code to take advantage of that. Lots of demos will show just how critical some of your code choices can be in order to obtain peak performance.
Speaker(s): Andrew Kelly,
Abstract:
This full-day session on Friday, Dec. 8, 2017 will focus on principles for designing and implementing a data lake. There will be a mix of concepts, lessons learned, and technical implementation details. This session is approximately 70% demonstrations: we will create a data lake, populate it, organize it, query it, and integrate it with a relational database via logical constructs. You will leave this session with an understanding of the benefits and challenges of a multi-platform analytics/DW/BI environment, as well as recommendations for how to get started.
Speaker(s): Melissa Coates,
Abstract:
Continuous Integration Delivery isn’t a new concept. Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up. Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I’ll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments. We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.
Speaker(s): John Morehouse,
Abstract:
This session will cover how to apply security in SQL Server Analysis Services Multidimensional Cube. Details of what we will cover: - Cube security - Admin security - Cell level security - dynamic data driven security
Speaker(s): Ravi Kumar,
Abstract:
In this session we will cover Service Broker use cases and how to setup, configure and use Service Broker.
Speaker(s): Edward Corcoran,
Abstract:
So you've decided to take the leap into presenting. Maybe it's at your local user group, maybe it's at SQL Saturday. This talk will guide you through the process of selecting a topic, preparing for it and actually giving it. We'll talk about what can go wrong and how to handle that. We'll also talk about what can be done to prevent something from going wrong in the first place. What are some good guidelines to follow and when can, or even should, you break them. This will be partly interactive so come with questions and be prepared to be asked some.
Speaker(s): Greg Moore,
Abstract:
This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven't gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.
Speaker(s): Amy Herold,
Abstract:
Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.
Speaker(s): Jonathan Stewart,
Abstract:
Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups. We will define and cover important metrics and alerts you need to manage a database in an Availability Group. You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.
 If so, few things are more important than a solid understanding of SQL Server indexes. In this session you will learn the basics of index internals and design, and then use that understanding to explore some common indexing anti-patterns. This session starts from the ground up, so it is suitable for anyone wanting to learn more about indexes.
Speaker(s): Mark Wilkinson,
Abstract:
For the last 25 years SQL Server DBAs administered SQL databases using only Windows GUI. For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it's flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.
Speaker(s): Slava Murygin,
Abstract:
Knowing how to help yourself when using SQL Server is a skill. What do I do when I get stuck? How do I learn more about a particular feature of SQL Server? Where do I go? Who do I ask? What options are out there for learning and assistance? In this session, I'll answer those questions. You will leave this session with a bountiful list of resources, links, and ideas to "Help you get your feet back on the ground".
Speaker(s): Mindy Curnutt,
Abstract:
Why do some planes with very few issues crash while a plane with no engine power can land safely on the Hudson with no loss of life? Every company will eventually have a disaster. It's just a matter of size and scope. This talk is a general overview of how to respond to an incident and talks about the roles of management and IT. This is not your typical discussion of disasters focusing on how to make a backup plan or enable high availability. I'll touch upon what we can learn from plane crashes and how those lessons can be applied to the IT environment in general.
Speaker(s): Greg Moore,
Abstract:
We will explore the capabilities of Azure Data Lake, and use cases for implementation. Options for integration of the data lake with SQL Server, Azure SQL DW, Azure SQL DB, and Azure Blob Storage will be discussed, as well as the role of U-SQL and PolyBase in a multi-platform system. You will leave this session with suggestions for getting started with organizing, populating, and securing Azure Data Lake Store and Azure Data Lake Analytics.
Speaker(s): Melissa Coates,
Abstract:
Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption? The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues. Highlight of topics 1. Why corruption occurs? 2. Detecting corruption – how SQL Servers detects corruption at the page level. 3. Different types of corruption- e.g. False alarms, memory corruption etc. 4. Limitation of DBCC how to speed the DBCC process. 5. Undocumented DBCC commands. 6. Monitoring I/O errors. 7. Verifying backup for corruption.
Speaker(s): Stephen Muliokela,
Abstract:
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
Speaker(s): Jamie Wick,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/ivancarter/
Ivan is a Branding Specialist at SimpleFastMarketing. In his role he works to simplify complex problems with compelling design story telling. He thinks strategically and systematically to capture a clear and concise idea that can engage clients at every level. He problem solves by utilizing research, insight by making the complex simple. He brings projects from conception to implementation, while thinking about how they apply in the real-world. Ivan guides his clients to find their own visual language, so they can express their goals to customers quickly. Ivan is currently serving on the board of PSSUG (http://pssug.org/), a nonprofit that is dedicated to further the education of the local data community.
LinkedIn: https://www.linkedin.com/in/jamiewick/
Contact: http://blog.wicktech.net
Jamie Wick is the Systems Database Engineer for The College of William Mary and has been working with SQL databases for the past 10+ years. His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Masters degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications. He is the Chapter Leader of the Richmond SQL Server Users Group, a volunteer and speaker at regional SQL events (User Groups/SQLSaturdays), helps run the SQLSaturday RVA events, and is an avid photographer.
LinkedIn: https://www.linkedin.com/in/gregdmoore
Contact: https://blog.greenms.com
Greg Moore is a graduate of RPI. There, he majored in CompSci, but probably spent as much time hiking, canoeing, caving and rock-climbing as he did studying. He started working with SQL Server 4.21a in 1995 and has survived numerous upgrades. He's been a Director and later VP of IT at several startups including PowerOne Media, TownNews and Traffiq and now consults. These days, when he's not busy with playing with SQL Server or spending time with his family, he can often be found underground caving or teaching cave rescue with the NCRC. While his focus is on the operations side of DBA, his interests include DR, performance and general IT problem solving. He is the author of: IT Disaster Response: Lessons Learned in the Field.
Az Arunachalam has been working with SQL server since v4.21/SQLNT. He started his career with troubleshooting at chip level, worked as a network engineer managing Novell NetWare networks, graduated into managing Windows NT, moved onto development, administered databases, and is currently working as a database architect. He#39;s excited about all the cloud offerings that Microsoft and others have made possible, and in sharing his findings with aspiring data enthusiasts.
Lisa is a coach, educator, and networking expert who helps people make the changes they need to succeed. She is a Principal Consultant for Contacts Count, LLC, the premier networking training company, and has a Ph.D. in leadership and from Andrews University an M.Ed. in Instructional Systems from Pennsylvania State University and received her coaching certification in leadership and transition from the prestigious Hudson Institute of Coaching. For over 20 years, Lisa worked as a leader and innovator within the fields of healthcare and IT. Passionate, goal-oriented, and motivated, Lisa believes that everyone should have the opportunity to become the phenomenal person they want to be. She is also adjunct faculty at Wilmington University’s G
LinkedIn: https://www.linkedin.com/pub/stephen-muliokela/32/a45/830
I have been a DBA for many years now and currently hold multiple SQL Server certificates. In addition, I am also a Six Sigma Blackbelt.
LinkedIn: http://www.linkedin.com/in/melissacoatesprofile
Contact: https://www.CoatesDataStrategies/blog
Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa's website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
Az Arunachalam has been working with SQL server since v4.21/SQLNT. He started his career with troubleshooting at chip level, worked as a network engineer managing Novell NetWare networks, graduated into managing Windows NT, moved onto development, administered databases, and is currently working as a database architect. He#39;s excited about all the cloud offerings that Microsoft and others have made possible, and in sharing his findings with aspiring data enthusiasts.
LinkedIn: http://www.linkedin.com/in/eleightondick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
LinkedIn: https://www.linkedin.com/in/tracyboggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC. Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com. Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
LinkedIn: http://www.linkedin.com/in/mikepwalsh
Contact: https://www.straightpathsql.com
Mike Walsh is an experienced SQL Server professional and has worked with SQL Server since version 6.5. He has been in the role of DBA, developer, and performance tuner, but always leans on his DBA and tuning experience. He has been awarded the SQL Server (now Data Platform) designation 6 times since 2011 and is a current MVP. He runs a SQL Server consultancy focused on DBA services and cloud enablement. He has spoken several times at PASS and regional events.
LinkedIn: http://www.linkedin.com/pub/rie-irish/2/34a/78/
Rie lives with her family just north of Atlanta, Georgia. She worked as a SQL Server DBA, manager director for over 20 years. She's worked in many industries including the non-profit sector, education, big pharma, and e-commerce. She was awarded the MVP in the Data Platform 3 times beginning in 2017 and gave that up to accept her role as a Senior Program Manager with Microsoft in 2019. She is very involved with the Atlanta MDF User Group, SQL Saturday Atlanta and is co-leader of the PASS Women in Tech virtual group.
Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.
LinkedIn: http://www.linkedin.com/in/melissacoatesprofile
Contact: https://www.CoatesDataStrategies/blog
Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa's website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.
LinkedIn: https://www.linkedin.com/in/carloslchacon
Contact: http://sqldatapartners.com/blog
Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.
I have over 12 years of experience working with SQL Server and Business Intelligence Technology. My current focus is cloud technologies: Power BI, Azure Analysis Services, Azure SQL Data Warehouse, Azure Data Factory. As a PFE at Microsoft, I regularly deliver 2 - 4 day training workshops.
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated... eventually specializing more on performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
Contact: http://www.sqlflipflopsdba.com
Jim is a Premier Field Engineer for Microsoft in the Data/AI space. He lives in Pittsburgh in a small suburb. He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS). He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.
I have over 12 years of experience working with SQL Server and Business Intelligence Technology. My current focus is cloud technologies: Power BI, Azure Analysis Services, Azure SQL Data Warehouse, Azure Data Factory. As a PFE at Microsoft, I regularly deliver 2 - 4 day training workshops.
LinkedIn: http://www.linkedin.com/in/sebastianmeine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
LinkedIn: https://www.linkedin.com/pub/slava-murygin/9/b95/858
Contact: http://slavasql.blogspot.com/
Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.
LinkedIn: http://www.linkedin.com/pub/rick-heiges/1/b93/777/
Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx
Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002.
LinkedIn: http://www.linkedin.com/in/WayneSheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
LinkedIn: https://www.linkedin.com/in/gregdmoore
Contact: https://blog.greenms.com
Greg Moore is a graduate of RPI. There, he majored in CompSci, but probably spent as much time hiking, canoeing, caving and rock-climbing as he did studying. He started working with SQL Server 4.21a in 1995 and has survived numerous upgrades. He's been a Director and later VP of IT at several startups including PowerOne Media, TownNews and Traffiq and now consults. These days, when he's not busy with playing with SQL Server or spending time with his family, he can often be found underground caving or teaching cave rescue with the NCRC. While his focus is on the operations side of DBA, his interests include DR, performance and general IT problem solving. He is the author of: IT Disaster Response: Lessons Learned in the Field.
Contact: http://www.m82labs.com
I am a father of 4, and live in Raleigh North Carolina. I love fixing problems, and learning new technologies that can help me fix those problems faster and better than I did the time before. In my spare time I like to read, speak, and learn new things. I currently work as a Database Administrator at ChannelAdvisor where I solve fairly interesting problems on fairly large databases. You can often find me on Twitter where I talk about SQL, beer, and anything else I find interesting.
LinkedIn: http://www.linkedin.com/in/eleightondick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
LinkedIn: https://www.linkedin.com/in/sqllocks/
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments. Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
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 SQL Saturdays 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/aherold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Contact: http://www.sqlflipflopsdba.com
Jim is a Premier Field Engineer for Microsoft in the Data/AI space. He lives in Pittsburgh in a small suburb. He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS). He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.
LinkedIn: http://www.linkedin.com/in/amtwo
Contact: http://www.AM2.co
Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003. Andy is the founder of the BostonSQL User Group, and previous co-organizer of SQL Saturday events in Boston. He blogs at am2.co. Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.
Microsoft PFE
LinkedIn: http://www.linkedin.com/in/aherold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
LinkedIn: https://www.linkedin.com/in/sqlrus
Contact: http://www.sqlrus.com
John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
LinkedIn: https://www.linkedin.com/in/justindearingnyc
Contact: http://www.justaprogrammer.net
Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry. Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.
Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx
Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated... eventually specializing more on performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
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 SQL Saturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
The following is a list of sponsors that helped fund the event.


About Us
How RateMyCourse was created
RateMyCourse was created to allow students from different universites to check with others in their university to see which courses would be suitable for them based on their majors and class needed left before graduation. This website allows people to check with other students in their major to see what classes they can take and whether or not it would this class would be suitable for them. You can filter through enjoyment of the class, diffuctly, overall experience, and grade recieved.
How Was The Idea Created
I first discovered this idea, as there were many people I saw struggling find courses in time before registration was being filled up. This gave me the idea to create a platform for people to discover courses for that fulfill their major requirements and would be a enjoyable class for them, as a lot of times this not been the case for me.
What Has Been Done So Far
Currently, the website allows for people to enter their university, and see the enjoyment of the class, diffuctly,overall experience, and grade recieved. Students are able to give a one through five star rating out of these three filters. You can also see what professors students have taken and see if this professor has gotten good reviews for that class.
What Will Need To Be Done(Updates)
We will be implementing more filters for people. We will also in the future allow for suggestions to people based on the classes they have taken and see if that class would be a good match for them. This will allow students to see what classes are suited for them, and tailor them to pick their classes based on the indicators
How To Contact Us
The best way to contact us would be through email, and that is Contact@RateMyCourse this can also be found at the bottom of the page.


Tales of the trade #5: How to author a super successful MySQL blog
Check out the following tutorial that teaches you how to become a popular MySQL blog author: Complete strip: tales-of-the-trade-make-your-mysql-blog-popular-full.png
Check out the following tutorial that teaches you how to become a popular MySQL blog author: Complete strip: tales-of-the-trade-make-your-mysql-blog-popular-full.png
This post concludes my impressions from some of the talks I’ve been to.
I opened this day’s sessions with a smile.
Antony Curtis and Arjen Lentz have authored the OQGraph storage engine a while back. I had every intention to try it out, but never got round to it. Which is why I was happy to find this session in the conference. OQGraph is a specialized engine, and comes to solve hierarchal or otherwise graph-related queries, such as: “who are the descendants of a given node”, “find a route from a to b”, etc. MySQL does not support the RECURSIVE syntax as Oracle does, and does not provide out-of-the-box solution for that.
The syntax is just excellent: you just write something like SELECT * FROM my_graph WHERE from_node = ‘empusa fasciata’ AND to_node = ‘homo sapiens’ to find a route. Otherwise just use WHERE from_node = ‘Heathrow Central’ to find all outgoing links. So this is just plain old SQL, no new syntax involved.
I rounded corners. It is also possible (and required) to specify an algorithm. Do you want Djekstra? BFS? You specify it in the query. The result of a route query is a rowset, where each row is a step in the route, along with its sequence within the route. So you can do your ORDER BY, LIMIT etc. I find that syntax-wise, OQGraph is very intuitive!
I’d like to criticize and stress some opinions on free and open blog posts, including such appearing on planet MySQL.
This post is completely free. You don’t need to pay or register to read it, not will you require to pass personal details to comment.
If you happen to see this post on some website, which only provides you with 1st couple of sentences, then asks you to login in order to view the complete text – you should know you need no registration to read this.
[Clarification: I’m not actually asking you to vote for me :D, the title just follows a previous post]
Diego Medina has published a JavaScript code that can be embedded in your blog posts, and which allows for voting on Planet MySQL from within your blog.
Shared below is how to set this up for WordPress users. This is not a WordPress plugin, mind you. You’ll need to manually edit the WordPress template files (can be done from the Dashboard->Appearance->Editor->Single post).
The page you’re likely to edit is single.php, but depending on your template this can change. The explanation below assumes a single post page. This can also be worked out for your blog’s home page, which lists several entries.
Since there is no point in presenting the Planet MySQL voting widget for entries which do not relate to MySQL, the code verifies that the post is in the ‘MySQL’ category. You need to change this if your categorization differs. Mind that the category’s name is case sensitive.


Standard FOP Extensions | print-friendly |
By "extension", we mean any data that can be placed in the input XML document that is not addressed by the XSL-FO standard. By having a mechanism for supporting extensions, FOP is able to add features that are not covered in the specification.
The extensions documented here are included with FOP, and are automatically available to you. If you wish to add an extension of your own to FOP, please see the Developers' Extension Page.
SVG
Please see the SVG documentation for more details.
PDF Bookmarks
To use this standard FOP extension, you need to add a namespace entry for http://xml.apache.org/fop/extensions on the root element.
You can provide outlines inside the root object (but outside any page-sequences or other formatting objects). Here's an example of an outline entry:
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:fox="http://xml.apache.org/fop/extensions"> <fox:outline internal-destination="sec3"> <fox:label>Running FOP</fox:label> <fox:outline internal-destination="sec3-1"> <fox:label>Prerequisites</fox:label> </fox:outline> <fox:outline> </fo:root>
It works similarly to a basic-link. There is also an external-destination property, but it isn't supported currently. See the pdfoutline.fo file in examples/fo/basic for a more complete example.
Continued-label (for table-header/-footer
Please see examples/fo/basic/contlabel.fo


Hot Restaurant
Current Reservation and Waiting List
Make Reservation
Home
Current Reservations
Waiting List


welcome to web dev documentation
Web
basics
for
new
learners
Hello World, We are Software Engineers
Web
basics
for
new
learners


EQN2GRAPH(1) EQN2GRAPH(1) NAME eqn2graph - convert an EQN equation into a cropped image SYNOPSIS eqn2graph [ -unsafe ] [ -format fmt ] DESCRIPTION Reads an EQN equation (one line) as input; produces an image file (by default in Portable Network Graphics format) suitable for the Web as out‐ put. Your input EQN code should not have the .EQ/.EN preamble that that nor‐ mally precedes it within groff(1) macros; nor do you need to have dollar- sign or other delimiters around the equation. The output image will be clipped to the smallest possible bounding box that contains all the black pixels. Older versions of convert(1) will produce a black-on-white graphic; newer ones may produce a black-on- transparent graphic. By specifying command-line options to be passed to convert(1) you can give it a border, force the background transparent, set the image's pixel density, or perform other useful transformations. This program uses eqn(1), groff(1), and the ImageMagick convert(1) pro‐ gram. These programs must be installed on your system and accessible on your $PATH for eqn2graph to work. OPTIONS -unsafe Run groff(1) in the `unsafe' mode enabling the PIC macro sh to execute arbitrary commands. The default is to forbid this. -format fmt Specify an output format; the default is PNG (Portable Network Graphics). Any format that convert(1) can emit is supported. Command-line switches and arguments not listed above are passed to con‐ vert(1). FILES /usr/share/groff/1.21/tmac/eqnrc The eqn(1) initialization file. ENVIRONMENT GROFF_TMPDIR The directory in which temporary files will be created. If this is not set eqn2graph searches the environment variables TMPDIR, TMP, and TEMP (in that order). Otherwise, temporary files will be created in /tmp. BUGS Due to changes in the behavior of ImageMagick convert(1) that are both forward and backward-incompatible, mismatches between your eqn2graph and convert(1) versions may produce zero-sized or untrimmed output images. For this version of eqn2graph you will need a version of convert(1) that supports the -trim option; older versions of eqn2graph used -crop 0x0, which no longer has trimming behavior. SEE ALSO pic2graph(1), grap2graph(1), eqn(1), groff(1), gs(1), convert(1). AUTHOR Eric S. Raymond<EMAIL_ADDRESS>Groff Version 1.21 31 December 2010 EQN2GRAPH(1)


This document presents my efforts to solve the Alex vs Fedor algorithm problem given as a challenge on HackerRank.
Given an arbitrary weighted graph, find all the potential spanning trees and all the potential minimal spanning trees so that a fraction can be outputted that will reflect the probably of randomly selected spanning tree, being a minimal spanning tree.
Incomplete - As of this writing, the latest submission for this problem yields the following results:
correct result for Test cases
- #0
- #38
- #1
- #4
- #9
- #10
- #36
- #37
- #39
- #40
All other Test cases, a vast majority, timeout. There appears to be a 4 second limit for the problem.
This problem takes some interpretation. While the problem is presented as a game, I think it was critical to note that the participant picking a spanning tree to be a minimal spanning tree “… became too lazy to look for minimal spanning trees and now picks some arbitrary spanning tree…”. This effectively makes the problem into a probability of an arbitrarily selected spanning tree, being a minimal spanning tree. Being a simple random probability, we simply need to output the fraction of
m / a
Where
m = Number of all potential minimal spanning trees in the graph
a = Number of all potential spanning trees in the graph
Given that all spanning trees in a graph could be identified. Each spanning tree could be summed to a total cost for each spanning tree. The lowest of these values would identify the total cost of a minimal spanning tree. And the number of trees that are of that value could be identified. We would then be in a position to output the required values.
For identifying the number of all spanning trees in a graph I found references to a Laplacian Matrix which, along with Kirchhoff’s theorem could be used to calculate the number of spanning trees. While this would provide the denominator that we need for our fraction. It would not tell us how many of the spanning trees are minimal and does not give us information about the costs of these trees.
I attempted to use Kruskal’s algorithm to find a minimal spanning tree, so that we at least know what the weight of such a tree would be. But this does not tell us how many minimal spanning trees are in the graph.
My understanding is that every node is connected to a minimal spanning tree by an edge is that has the lowest weight among all edges that connect that node. Krushal’s algorithm supports this, as it seeks to identify the minimum weight edge to connect each node when constructing a minimal spanning tree. Therefore, each additional edge connecting a node that is this same minimum weight, among all the connecting edges, would represent a potential alternate spanning tree. Therefore we should be able to count all such alternate edges to identify the number of all potential minimal spanning trees. This calculation should give us the numerator for our probabilistic ratio.
We will summarize the following data structures that are used throughout the solution class:
- Edge class
- Node
- visited
Edge class
Edge is defined as a class to hold information about an edge in a graph. It contains only the weight of the edge and start and end nodes.
class Edge {
long weight;
int startNode;
int endNode;
}
Node
Node is defined as a class to hold information about a node, or vertex, in a graph. It contains the nodeID (an integer) and a LinkedList of Edge objects that lead to adjacence nodes. When a node in instantiated, an edge may be passed to constructor to be included in the initial LinkedList created for the node. Usually this would be the first edge connecting the node to the tree, or the only edge connecting the node in the case of an minimal spanning tree.
class Node {
int nodeID;
LinkedList adjacencyList;
public Node(int r, Edge edge) {
nodeID = r;
adjacencyList = new LinkedList();
if (edge != null) adjacencyList.add(edge);
}
}
visited
A package level HashMap, visited, to track the nodes visited while processing Kruskal’s aglorithm to find an MST.
static HashMapvisited;
main
The main method is almost exclusively dedicated to loading the STDIN data, including taking in the X, Y and Z parameters for each edge in the graph to be evaluated. A graph HashMap is initialized to hold a representation of the graph defined by the inputs. A loop in main sets false for each of these nodes in visited and calls the method addToGraph to add each of the nodes along with the edge connecting each. (Both calls are needed to take into account that all edges are bidirectional.) Last within this loop for each edge inputed, is a call to the method addEdgeToLaplacianMatrix to … The last statement of main outputs a string with this required answer for each graph. countOfMSTs is call to return the numerator and countOfSpanningTrees is called to return the denominator.addToGraph
*** Content TBD (To Be Drafted) ***
For now, here is the code:
static void addToGraph(int x, Edge edge) {
Node nodex;
if (graph.containsKey(x)) {
nodex = graph.get(x);
nodex.adjacencyList.add(edge);
} else {
nodex = new Node(x, edge);
}
graph.put(x, nodex);
}
I made all this stuff up


A drug is any substance that causes a change in an organism's physiology or psychology when consumed. Drugs are typically distinguished from food and substances that provide nutritional support. Consumption of drugs can be via inhalation, injection, smoking, ingestion, absorption via a patch on the skin, or dissolution under the tongue..
by Carine Fox, 19/08/2016
Read moreCannabinoids are chemicals found in cannabis. The most notable cannabinoid is the phytocannabinoid tetrahydrocannabinol, the primary psychoactive compound in cannabis. Cannabidiol is another major constituent of the plant. There are at least 113 different cannabinoids isolated from cannabis, exhibiting varied effects.
Stimulants are widely used throughout the world as prescription medicines as well as without a prescription (either legally or illicitly) as performance-enhancing or recreational drugs. The most frequently prescribed stimulants as of 2013 were lisdexamfetamine, methylphenidate, and amphetamine.
know MoreDepressants are drugs that inhibit the function of the central nervous system (CNS) and are among the most widely used drugs in the world. These drugs operate by affecting neurons in the CNS, which leads to symptoms such as drowsiness, relaxation, decreased inhibition, anesthesia, sleep, coma, and even death.
know MoreOpioids are a class of drugs naturally found in the opium poppy plant. Some prescription opioids are made from the plant directly, and others are made by scientists in labs using the same chemical structure.
know MoreHallucinogens are a class of drugs that cause profound distortions in a person's perceptions of reality, otherwise known as hallucinations. While under the influence of hallucinogens, users might see images, hear sounds or feel sensations that seem to be real but aren't.
know MoreMexican drug gangs have often targeted such facilities in the past, with the aim of killing suspected street-level dealers from rival gangs. The Irapuato massacre was one of the deadliest attacks on a rehab center since 19 people were killed in 2010 in Chihuahua city in northern Mexico. More than a dozen attacks on such facilities have occurred since then.
Sri Lanka's navy seized $65 million worth of crystal methamphetamine and ketamine on Wednesday in the country's biggest drugs bust, officials said. Acting on a tip-off, authorities raided a flagless vessel in the country's southern waters and arrested nine Pakistani men suspected of smuggling the drugs. Navy personnel, wearing special protective clothing in case the suspects had COVID-19, found 605 kilogrammes of crystal meth, also known as ice, and 579 kilogrammes of ketamine, said Navy Commander Piyal de Silva.
Johnny Depp has enjoyed a renaissance of sorts in recent years thanks to his roles in such big franchises as Pirates of the Caribbean and Tim Burton's new Alice in Wonderland films. In the world of Hollywood, where a renaissance isn't always possible, Depp's particular comeback is especially impressive. During the 1990s, the actor was perhaps more famous for his partying. He and former girlfriend Kate Moss would spend days at a time immersed in the party scenes of L.A. and NYC, usually high on cocaine.
Robert John Downey Jr. (born April 4, 1965) is an American actor, producer, and singer.Today, Iron Man star Robert Downey, Jr. is the highest paid actor in Hollywood, but things haven't always been easy for him. It wasn't too long ago that he was addicted to alcohol, cocaine, and heroin. At one especially low moment, he was even arrested after racing his car down Sunset Boulevard while intoxicated. Fortunately for superhero fans everywhere, Downey Jr. was able to vanquish his bad habits and resurrect his acting career.
Help Center
Frequent Questions
Sitemap
Contact Usp
About Drugs.com
Advertising Policy
Attribution & Citations
Drugs.com Blog


Family want former IRA man Kevin McGuigan's body moved
by Michael McHugh, Press AssociationThe family of a former IRA member who was shot dead four years ago want to move his body.
Kevin McGuigan Snr was gunned down at Comber Court in the Short Strand, Belfast, in August 2015.
The father-of-nine was treated by paramedics at the scene before being taken to the Royal Victoria Hospital, but he died from his wounds.
Lawyer Laura McMahon wrote to a coroner on behalf of relatives who believe he should be exhumed and reburied.
She said: "The family are keen that they are together in death.
Read More: Grave of murdered IRA prisoner Kevin McGuigan sealed in concrete
"I am sure you will appreciate their motivation and where they are coming from."
Coroner Paddy McGurgan said he would be committing a criminal offence if he ordered the body moved for purposes outside the coronial process.
"This is one of those areas where the law is exceptionally clear in relation to the limit of my powers."
Mr McGuigan's death followed the murder of Jock Davison in the Markets area of the city three months earlier.
Read More: PSNI 'had information about a gun' two weeks before Gerard 'Jock' Davison murder
Mr Davison (47) was a former IRA commander and former friend of Mr McGuigan.
On Wednesday the coroner held a brief hearing on legal matters surrounding a future inquest. He directed that the full inquest go ahead without a jury.
Thousands of pages of non-sensitive material and a significant amount of sensitive papers need to be sifted through, lawyers told the preliminary sitting.
Mr McGurgan decided that suspects who have not been charged but may be mentioned during the inquest should be publicly known by ciphers to protect their identities.
He said it was too early to set a date for the full inquest and scheduled another review hearing for March.
Mr McGuigan's death led then PSNI chief constable George Hamilton to state that the Provisional IRA still existed and some of its members were involved in Mr McGuigan's murder.
He said there is no evidence that the killing was sanctioned by the organisation.
His statement prompted the UUP to pull out of the five-party ruling Executive.


Reports constants (
public static final
fields) declared in abstract classes.
Some coding standards require declaring constants in interfaces instead.


Welcome to the Waterfront Skills module.
In this module, you will learn about the unique characteristics of waterfronts, how to use rescue watercraft, as well as waterfront-specific rescue skills. You will also learn about boating safety and the appropriate use of personal flotation devices (PFDs).
At the end of this course, you will be able to answer these questions.
Assignment 3
Complete the waterfront rules worksheet.
Assignment 2
Read the boating safety and PFDs article.
Assignment 1
Watch the waterfront skills video.
Assignment 5
Read textbook pages 27, 29, 30-32, 34-36, 43, 76, 100-104, 107-108 and 153-160.
Assignment 4
Complete the textbook review questions.


Before Change
Drawn samples from the parameterized uniform distribution.
from ...numpy import ndarray as np_ndarray
input_type = (isinstance(low, np_ndarray), isinstance(high, np_ndarray))
if dtype is None:
dtype = "float32"
if ctx is None:
ctx = current_context()
if size == ():
size = None
if input_type == (True, True):
return _npi.uniform(low, high, low=None, high=None, size=size,
ctx=ctx, dtype=dtype, out=out)
elif input_type == (False, True):
return _npi.uniform(high, low=low, high=None, size=size,
ctx=ctx, dtype=dtype, out=out)
elif input_type == (True, False):
return _npi.uniform(low, low=None, high=high, size=size,
ctx=ctx, dtype=dtype, out=out)
else:
return _npi.uniform(low=low, high=high, size=size,
ctx=ctx, dtype=dtype, out=out)
def normal(loc=0.0, scale=1.0, size=None, dtype=None, ctx=None, out=None):
rDraw random samples from a normal (Gaussian) distribution.
Samples are distributed according to a normal distribution parametrized
After Change
if dtype is None:
dtype = "float32"
if ctx is None:
ctx = str(current_context())
else:
ctx = str(ctx)
if dtype is not None and not isinstance(dtype, str):
dtype = np.dtype(dtype).name
if size == ():
size = None
return _api_internal.uniform(low, high, size, ctx, dtype, out)
def normal(loc=0.0, scale=1.0, size=None, dtype=None, ctx=None, out=None):
rDraw random samples from a normal (Gaussian) distribution.


本书pdf是文字版，书签良好。
The Schrödinger Equation
The Particle in a Box
Operators
The Harmonic Oscillator
Angular Momentum
The Hydrogen Atom
Theorems of Quantum Mechanics
The Variation Method
Perturbation Theory
Electron Spin and the Spin–Statistics Theorem
Many-Electron Atoms
Molecular Symmetry
Electronic Structure of Diatomic Molecules
Theorems of Molecular Quantum Mechanics
Molecular Electronic Structure
Electron-Correlation Methods
Semiempirical and Molecular-Mechanics Treatments of Molecules


This is just filler text I dont know if Ill need it.
This is just filler text I dont know if Ill need it.
| ID | Student ID | Assignment Type ID | Date Assigned | Date Due | Date Submitted | Status | Grade | Action |
|---|---|---|---|---|---|---|---|---|
| {{a.id}} | {{a.studentId}} | {{a.assignmentTypeId}} | {{a.dateAssigned | date: 'MM-dd'}} | {{a.dateDue | date: 'MM-dd'}} | {{a.dateSubmitted | date: 'MM-dd'}} | {{a.status}} | {{a.grade}} |


The HTML id attribute is used to specify a unique id for an HTML element.
You cannot have more than one element with the same id in an HTML document.
A class name can be used by multiple HTML elements, while an id name must only be used by one HTML element within the page:
JavaScript can access an element with a specific id with the getElementById() method:
You cannot have more than one element with the same id in an HTML document.
Using The id Attribute
- The id attribute specifies a unique id for an HTML element. The value of the id attribute must be unique within the HTML document.
- The id attribute is used to point to a specific style declaration in a style sheet. It is also used by JavaScript to access and manipulate the element with the specific id.
- The syntax for id is: write a hash character (#) character, followed by an id name. Then, define the CSS properties within curly braces { }.
- In the following example we have an
 element that points to the id name "myHeader". This
 element will be styled according to the #myHeader style definition in the head section:
<!DOCTYPE html>

My Header

Difference Between Class and ID
A class name can be used by multiple HTML elements, while an id name must only be used by one HTML element within the page:

My Cities

London

London is the capital of England.

Paris

Paris is the capital of France.

Tokyo

Tokyo is the capital of Japan.

HTML Bookmarks with ID and Links
- HTML bookmarks are used to allow readers to jump to specific parts of a webpage.
- Bookmarks can be useful if your page is very long.
- To use a bookmark, you must first create it, and then add a link to it.
- Then, when the link is clicked, the page will scroll to the location with the bookmark.
Using The id Attribute in JavaScript
The id attribute can also be used by JavaScript to perform some tasks for that specific element.JavaScript can access an element with a specific id with the getElementById() method:

Chapter Summary
- The id attribute is used to specify a unique id for an HTML element
- The value of the id attribute must be unique within the HTML document
- The id attribute is used by CSS and JavaScript to style/select a specific element
- The value of the id attribute is case sensitive
- The id attribute is also used to create HTML bookmarks
- JavaScript can access an element with a specific id with the getElementById() method


{% endif %}
Please upload a DICOM file for inspection:
(can download from here some DCM samples)
{% if content %}
or select from the history list:
(files already uploaded)
{% for img in content %}
{{img["filename"]}}delete
{% endfor %}
{% endif %}
{% include 'footer.html' %}


Frequently Asked Questions
Can Aikido be used for self-defense?
Yes, Aikido can be a very effective form of self-defense. However, it can take considerable time and effort before Aikido, or any other martial art can be used effectively in a self-defense situation.
Does Aikido take longer time to master and apply than other martial arts?
The simple answer is "yes". A year in Karate/Tae Kwon Do/Kempo and you can probably fight much better than before. It takes well over a year before you start feeling comfortable enough with Aikido techniques to imagine using them in “real life situation”. The complex answer is "no" in the sense that one should never feel like they have "mastered" an art. If they do then they’ve stopped growing. Martial arts is a way of life.
Is Aikido better than karate/judo/any other martial art?
The answer to this question is very subjective. There are many different but equally valid reasons for studying a martial art, such as for self defense, spiritual growth or enlightenment, general physical health, self-confidence etc. Different martial arts, and different styles within a particular martial art, emphasize different aspects. It’s a personal choice.
Does Aikido have competitions?
O-Sensei felt that competition was incompatible with Aikido, therefore the majority of Aikido schools do not have any competition. Most Aikido training, even in schools with competitions, is of a co-operative rather than antagonistic nature, with both thrower (nage) and throwee (uke) working as partners and trying to optimize the experience of the other. This working partnership is also necessary to minimize the chance of injury from practicing potentially dangerous aikido techniques, and to develop both partners’ capacity to "take ukemi", to be relaxed and able to take care of oneself when responding to "falling" or being thrown in a martial situation.


Linux Kernel Development
Driver development requires the Linux Kernel Development Package. This package provides
the kernel API header files and build environment for compiling the source code.
The standard user-space header files and libraries can not be used.
You will need to ensure the kernel header files are present. They are normally located
in /usr/src/kernels/{version}/include/linux or run rpm -q kernel-devel to
so if the package is installed.
If you do not have the kernel development package, you will need to search the web for
an RPM to download and install. The RPM must match your kernel version and architecture
exactly (i.e. i686 or x64 or SMP). Use uname -a to get the exact kernel version
you are running.
The following site can be used to locate an RPM package:
RPM Search at pbone.net
Building
Building the driver is done from the command shell using the provided Makefile.
The driver is simply built with make. You do not need to be root
to compile the driver module. The resulting file will be lscpcie2.ko.
You do need to be root to install it into the kernel.
A version string can be set in the source which can provide a
unique identification for the software that uses the driver (i.e. to make sure you
are really running the version you just compiled!)
Installing
The driver can be installed using the insdrvr script for testing. You will
need to unload any currently installed driver using rmdrvr before installing
the new one - insmod will complain otherwise.
Diagnostic outputs can be enabled with the debug parameter. Specify insdrvr debug=1
to enable logging. Messages can be viewed using dmesg. The prinkt() function
is used to send output to the log.
If you do not get any errors, then you can assume the module is installed. You can double
check with dmesg or lsmod or cat /proc/driver/lscpcie2.
For permanent installation on the system and auto-loading of the driver when the system
starts, its probably easiest to run the following script files commands:
- From the Software directory:
- From the Demonstration directory (as root):
- ./removeDrvr.sh
- ./installDrvr.sh
This will rebuild the driver, copy it to the expected locations in Demonstration/, remove
the old driver from the system files and locations, and then install the new one.
Running
Use the demo applications to open and exercise the driver or see the tests directory
for examples of basic driver operation, but not related to any specific demo.
A Lattice PCIe Eval board, with a proper demo bitstream, must be installed in the system
in order for the driver to actually create device nodes and therefore allow a user program
to open and use it. You will need a hardware device for the driver to really exercise
its functionality. Otherwise only the init and remove functions will be executed.
Debugging
Diagnostic messages and errors are output to the system log (/var/log/messages).
The dmesg command will also display printk messages from the kernel.
Remember to load the driver with the debug=1 option to enable all messages to
come out - errors and warnings will always be logged.


Mapillary Carto Image Wizard
Use the 22-digit string of characters in the URL of the photo you’d like to put
Add Another Image
Get GeoJson


COMEBACK?
Celtic star Brown refuses to rule out Scotland return if Clarke’s side make Euro 2020
by Gareth LawSCOTT BROWN has refused to rule out a sensational Scotland return at the Euros.
The Celtic skipper quit the international scene for a second time in February 2018.
But Brown, 34, has left the door open to pulling on the national shirt again if Steve Clarke’s side make it through March’s play-offs.
Asked if Clarke was to sound him out, Brown said: “They still have two games to get through but you never say never.
“It would be phenomenal to get to a finals after 22 years. Football’s a funny game and you never know.
“I’m in a good place fitness-wise in terms of my body and I make sure I keep myself ticking over.
“But it’s been hard for me to watch the Scotland games because you always want to be playing in them. I need to look after No 1 though.
“My wish is I could still be playing for Celtic and Scotland at the age of 45.
“But there comes a time when you have to make sure your body’s okay and give yourself the best chance of continuing to play for your club.”
Scotland find out if they’ll face Bulgaria, Romania, Hungary or Israel in the first game at Hampden on March 26 when the draw takes place at 11am this morning.
Brown originally quit playing for the country in August 2016 to focus on staying in peak condition for Celtic.
Gordon Strachan then persuaded him to reverse that decision two months later and he faced England twice in the 2018 World Cup qualifiers.
But he hung up his boots again at the start of last year with 55 caps.
Brown said: “It’s a regret of mine we never managed to get to a finals. We came close against Norway in 2009 but we didn’t get there.
“If big Chris Iwelumo had just stuck that chance away, it would’ve made me a happy man but it wasn’t to be.
“We’ve had other chances but didn’t get there. I remember watching the games at France 98.
“I was 13 and my mum had put Scotland flags all around the windows and outside in the street. I don’t know what she was playing at!
“It was great and it shows you the whole country wants us to get back there again.”
It looks unlikely the SPFL will be able to aid Clarke with the fixtures before the play-off — but Brown isn’t giving up hope.
He said: “I’m sure the SPFL and clubs will help him as much as they can.
“It’s a huge occasion and we must make sure we give Scotland as much hep as we can.
“We need to put the clubs on the backburner for four or five days to make sure we give Steve the best options possible.”
Brown returns to work with the Hoops tomorrow when they host Livingston in the Premiership.
He added: “The international breaks have been incredible — they’ve allowed me to go away and relax, play golf and recharge my batteries. That’s been good for me.”


Comet parameter: skip_researching
- This parameter is valid only when output_outfiles is set
to 1 and each of
output_pepxmlfile,
output_sqtfile, and
output_sqtstream are set to 0.
- When .out files only are set to be exported, this parameter will look to see if
an .out file already exists for each query spectrum. If so, it will not re-search
that particular spectrum.
- When set to 0, all spectra are re-searched. When set to 1, the search is skipped
for those spectra where an .out file already exists.
- Valid values are 0 and 1.
- The default value is "0" if this parameter is missing.
Example:
skip_researching = 0
skip_researching = 1


Your Address Here
Some text here, CA
Zip code here, AUS
<EMAIL_ADDRESS><EMAIL_ADDRESS>Phone: (+61) 555 12345
Mobile: (+61) 555 12345
Fax: (+61) 555 12345


SubTrajectory connects interface states of ComputeStages. More...
#include <storage.h>
Public Member Functions | |
| void | fillMessage (moveit_task_constructor_msgs::Solution &msg, Introspection *introspection=nullptr) const override |
| append this solution to Solution msg More... | |
| void | setTrajectory (const robot_trajectory::RobotTrajectoryPtr &t) |
| SubTrajectory (const robot_trajectory::RobotTrajectoryConstPtr &trajectory=robot_trajectory::RobotTrajectoryConstPtr(), double cost=0.0, std::string comment="") | |
| robot_trajectory::RobotTrajectoryConstPtr | trajectory () const |
| Public Member Functions inherited from moveit::task_constructor::SolutionBase | |
| const std::string & | comment () const |
| double | cost () const |
| const StagePrivate * | creator () const |
| const InterfaceState * | end () const |
| void | fillInfo (moveit_task_constructor_msgs::SolutionInfo &info, Introspection *introspection=nullptr) const |
| bool | isFailure () const |
| void | markAsFailure () |
| auto & | markers () |
| const auto & | markers () const |
| bool | operator< (const SolutionBase &other) const |
| order solutions by their cost More... | |
| void | setComment (const std::string &comment) |
| void | setCost (double cost) |
| void | setCreator (StagePrivate *creator) |
| void | setEndState (const InterfaceState &state) |
| void | setStartState (const InterfaceState &state) |
| const InterfaceState * | start () const |
| template<Interface::Direction dir> | |
| const InterfaceState::Solutions & | trajectories () const |
| Retrieve following (FORWARD) or preceding (BACKWARD) solution segments. More... | |
| virtual | ~SolutionBase ()=default |
Private Attributes | |
| robot_trajectory::RobotTrajectoryConstPtr | trajectory_ |
Additional Inherited Members | |
| Protected Member Functions inherited from moveit::task_constructor::SolutionBase | |
| SolutionBase (StagePrivate *creator=nullptr, double cost=0.0, std::string comment="") | |
SubTrajectory connects interface states of ComputeStages.
|
inline |
|
overridevirtual |
append this solution to Solution msg
Implements moveit::task_constructor::SolutionBase.
Definition at line 155 of file storage.cpp.
|
inline |
|
inline |
|
private |


Rosegarden - Open source MIDI sequencer that I work on. On GitHub.
QBASIC Programming for Kids - My QBASIC book. Written in simplified English. Very popular with non-native speakers as well as kids.
acpid2 - The acpid version 2.  I'm the current maintainer and co-author.
Setting Up a Private Git Server - Had to do this for work. Pretty easy actually.
Git Conflict Resolution - How to resolve conflicts with the various git commands.
Object Oriented Design: The Controller Pattern - That's NOT Object Oriented!
Callbacks in C++ - Experiments with various approaches to implementing this common pattern.
Linux - My Linux page.
Open Source - Open Source software that I've found useful.
Books? I can recommend 3:
Sprites Tutorial - My Sprites in QBASIC tutorial.
Computer Science for Kids - Resources for kids to learn programming.
Kids Computer Book Collection - Books I've collected.
SupaSoft - My software "company".
Simula - Collection of links related to Simula, the first object oriented language.
What Compsci textbooks don't tell you: Real world code sucks by David Mandi - A great article on The Register.
<- Back to my homepage.
Copyright ©2007-2015, Ted Felix. Disclaimer


The playlist is a collection of media files that we are currently playing. The playlist area has columns to display the song's Name, Artist, Album and Length information, based on the current file's metadata. Five checkboxes/buttons provide different playlist options including Repeat, Loop, Shuffle, Save and Delete the playlist. The name of the playlist is also shown.
Play/Pause button starts or pause the playback of the curent media file.
Stop button ceases the current media file.
Next and Back buttons skip to the next or previous songs in the playlist.
Volumn button and the slider besides it mutes, raises or decreases the volumn.
Slider shows the progress of the playback, which could be manually dragged to advance/rewind the song.