面试问sql优化
描述 (Description)
Technical training is an important part of our careers. Meeting professionals, learning about new technologies, and making the most of the time and resources that we have can make a profound difference on the work that we do.
技术培训是我们职业的重要组成部分。 与专业人士会面,了解新技术并充分利用我们拥有的时间和资源可以对我们所做的工作产生深远的影响。
SQLSaturday provides a quality, inexpensive, and fun way to learn and get involved in the SQL Server community. It is a free, full day of technical presentations from experts that will travel from around the world to help make these events a success!
SQLSaturday提供了一种优质,廉价且有趣的方法来学习和参与SQL Server社区。 这是来自专家的免费全日技术演讲,他们将来自世界各地,以帮助使这些活动取得成功!
介绍 (Introduction)
SQLSaturday came about in 2007 as a way to not only to bring free training to the SQL Server community, but to create a reusable conference model so that this concept could be easily implemented around the world. Andy Warren, Brian Knight, and Steve Jones were the initial founders of SQLSaturday.
SQLSaturday于2007年问世,它不仅是为SQL Server社区带来免费培训,而且是创建可重用的会议模型的一种方法,以便可以在全球范围内轻松实现此概念。 Andy Warren,Brian Knight和Steve Jones是SQLSaturday的最初创始人。
Since the first few SQLSaturday events in Florida in 2007-2008, the program has quickly expanded so that about 100 events are held per year, with #750 recently added to the calendar.
自从2007年至2008年在佛罗里达举行的前几场SQLSaturday活动以来,该计划已Swift扩展,因此每年约举行100次活动,最近在日历中添加了#750。
The Professional Association of SQL Server (PASS) owns, maintains, and manages the SQLSaturday program at the administrative level; each event is managed locally by teams of volunteers. The focus on decentralizing each SQLSaturday and recruiting strong teams of volunteers has allowed events to expand worldwide without the need for a complex management structure.
SQL Server专业协会( PASS )在管理级别拥有,维护和管理SQLSaturday程序; 每个活动都由志愿者团队在本地进行管理。 集中精力分散每个SQLSaturday并招募强大的志愿者团队已使活动可以扩展到全世界,而无需复杂的管理结构。
PASS is a non-profit organization that was founded in 1999 to promote education, training, and networking, with a focus on SQL Server technologies. They are run by community volunteers and have since created one of the strongest and most effective technical communities in the world!
PASS是一家非营利组织,成立于1999年,旨在促进教育,培训和网络建设,重点是SQL Server技术。 他们由社区志愿者管理,自此创建了世界上最强大,最有效的技术社区之一!
在SQLSaturday会发生什么? (What happens at a SQLSaturday?)
A SQLSaturday is a distinct event from other SQL conferences. While often run by user groups, it is not a user group meeting or a weeknight-style event. Instead, it is an all-day event that will feature technical sessions for much of the day. Because of the localized nature of SQLSaturdays, they will vary greatly from country to country and locale to locale. Some SQLSaturdays will draw over 500 people and boast 10+ tracks. Some will include breakfast, lunch, or both. Others are smaller and more intimate events that succeed with 50 attendees and a tightly-knit group of dedicated volunteers and speakers.
SQLSaturday是与其他SQL会议不同的事件。 虽然通常由用户组运行,但这不是用户组会议或工作日风格的事件。 取而代之的是,这是一整天的活动,在一天的大部分时间里都会举办技术会议。 由于SQLSaturdays的本地化性质,它们在不同国家和地区之间的差异很大。 一些SQLSaturdays将吸引500多人,并拥有10多个曲目。 有些将包括早餐,午餐或两者兼而有之。 其他的则是规模较小且更为私密的活动,成功举办了50名与会者,并由一群志趣相投的志愿者和演讲者紧密联系在一起。
This variability is a great strength of the program. Every SQLSaturday is a unique event with its own cadre of volunteers and sponsors that make it a success.
这种可变性是程序的强大优势。 每个SQLSaturday都是一次独特的活动,拥有自己的志愿者和赞助商干部,使其成功。
A typical SQLSaturday will start relatively early with registration & check-in. When attendees arrive, they can sign-in, grab any materials that are provided, and take this extra time to mingle with other attendees and the sponsors. This passive approach to networking has been very successful over the years, as it allows everyone to benefit from the collected knowledge and experience of each other.
典型SQLSaturday将相对较早地开始注册和签入。 与会者到达时,他们可以登录,获取所提供的所有资料,并花额外的时间与其他与会者和赞助商进行交流。 多年来,这种被动的联网方法非常成功,因为它使每个人都能从彼此收集的知识和经验中受益。
The bulk of the day is made up of technical sessions, which begin shortly after check-in and will continue throughout the day, breaking periodically for lunch, snacks, or a chance to take a deep breath and relax. The following is an example of what part of a SQLSaturday schedule looks like:
一天的大部分时间都是由技术会议组成,这些会议在办理登机手续后不久开始,并将持续一整天,定期休息以提供午餐,小吃或深呼吸和放松的机会。 以下是SQLSaturday计划的一部分的示例:
The session topics are wide-ranging, from business intelligence to query optimization to hardware, professional development and more! PASS provides few guidelines on this and encourages creativity when choosing tracks, sessions, and the subject matter therein.
会议主题范围广泛,从商业智能到查询优化再到硬件,专业开发等等! PASS为此提供了很少的指导原则,并在选择曲目,会议和主题时鼓励创造力。
Most SQLSaturdays will provide a variety of raffles and prizes for attendees. These are typically paid for by event sponsors, user groups, or the event itself. These are chances to win some cool swag, such as a drone, tablet, or Bluetooth speaker. Attending a free event and walking away with a fun and useful giveaway is quite a good feeling 🙂
大多数SQLSaturdays会为参加者提供各种抽奖和奖品。 这些通常由活动赞助商,用户组或活动本身付费。 这些都是赢得无聊赃物的机会,例如无人机,平板电脑或蓝牙扬声器。 参加免费活动并带着有趣和有用的礼物走走真是一种很好的感觉feeling
SQLSaturday如何工作? (How does SQLSaturday work?)
SQLSaturday is a 100% volunteer-run event. The organizers and presenters are not paid for the time and energy that they invest in these events.
SQLSaturday是100%志愿者运行的事件。 组织者和演示者无需为他们在这些活动上花费的时间和精力付费。
All of the funding for SQLSaturday comes from the support of sponsors. These can be businesses, colleges, non-profit organizations, or state/local agencies. Ownership of the event budget and all logistical details falls to the event planners. This model encourages each event to be efficiently run and self-sustaining. It also places a particular focus on gathering local and regional businesses to support their events, thereby giving back to the community they directly serve.
SQLSaturday的所有资金都来自赞助商的支持。 这些可以是企业,学院,非营利组织或州/地方机构。 活动预算和所有后勤细节的所有权归活动策划者所有。 该模型鼓励每个事件有效地运行和自我维持。 它还特别关注聚集本地和区域企业以支持其活动,从而回馈他们直接服务的社区。
Why go through all of the trouble to host a SQLSaturday? As an organizer, bringing SQL training to my local area was important to me as the nearest events were at least 3 hours away. In addition, it was a great growth opportunity for our user group. Creating our own SQ Saturday allowed our local group to expand immensely as we found new people interested in SQL Server technologies. It also provided a chance for anyone interested in leadership opportunities to help organize and volunteer at the event. The organizational and managerial experiences gained from this is invaluable and not easily found elsewhere
为什么要解决所有麻烦来托管SQLSaturday? 作为组织者,将SQL培训带到我的本地对我来说很重要,因为最近的活动至少要3个小时的路程。 此外,对于我们的用户群而言,这是一个巨大的增长机会。 创建我们自己的星期六SQ可以使我们的本地团队极大地扩展,因为我们发现了对SQL Server技术感兴趣的新人。 它也为任何对领导机会感兴趣的人提供了一个机会,以帮助组织和参加活动。 从中获得的组织和管理经验非常宝贵,在其他地方很难找到
我会学到什么? (What will I learn?)
PASS provides minimal guidance as to the topics and sessions that should be covered at SQLSaturday events. This ensures a schedule that is both diverse, but also inclusive of more advanced subject matter. The audience at events is broken somewhat evenly between software developers, database administrators, and business intelligence professionals. Here are some of the more common topics that are currently being covered at SQLSaturday events:
对于SQLSaturday事件中应涵盖的主题和会话,PASS提供的指导最少。 这确保了时间表既多样化,又包括更高级的主题。 活动的听众在软件开发人员,数据库管理员和商业智能专业人员之间平均分布。 以下是SQLSaturday事件中当前涵盖的一些较常见的主题:
-
- Report/warehouse performance 报告/仓库绩效
- Report building 报告建立
- Self-service BI 自助式商务智能
- Big data 大数据
- High availability, disaster recovery, backups 高可用性,灾难恢复,备份
- Azure/cloud-based database solutions 基于Azure /云的数据库解决方案
- TSQL and scripting TSQL和脚本
- Performance/optimization 性能/优化
-
- New features 新功能
- Existing features 现有功能
- New products/offerings 新产品/优惠
- Architecture/internals 建筑/内部
- Professional development 专业发展
-
- PowerShell 电源外壳
- Python Python
- Security 安全
- QA/automation 质量检查/自动化
- …and more! …和更多!
In short, if it relates to data, it will likely end up at a SQLSaturday event!
简而言之,如果它与数据有关,则很可能会在SQLSaturday事件中结束!
讲者 (Speakers)
SQLSaturday exists because subject matter experts from around the world volunteer their time and energy to share their knowledge with us. For a SQLSaturday (or any conference for that matter) to be successful, it needs a wide variety of speakers from different backgrounds and areas of expertise.
之所以存在SQLSaturday,是因为来自世界各地的主题专家自愿提供时间和精力与我们分享他们的知识。 为了使SQLSaturday(或与此相关的任何会议)取得成功,它需要来自不同背景和专业领域的各种各样的发言人。
Anyone can be a speaker! This is not something reserved for SQL legends or Microsoft employees. If you have a specific area of expertise that you want to share, or have a professional challenge that you overcame in a legendary way, then that knowledge may form the basis for a great SQLSaturday session. Many of the best speakers in the world became great by throwing their hat in the ring repeatedly until they got very good at this.
任何人都可以当演讲者! 这不是为SQL图例或Microsoft员工保留的内容。 如果您想分享特定领域的专业知识,或者以传奇的方式克服了专业上的挑战,那么这些知识可能构成了出色SQLSaturday课程的基础。 通过反复戴上帽子直到世界上最好的扬声器,他们变得非常出色,直到他们对此非常满意为止。
If you are interested in speaking at a SQLSaturday event, you can submit your session abstracts directly from the event home page:
如果您有兴趣在SQLSaturday事件上发表演讲,可以直接从事件主页提交会话摘要:
The link in the middle labelled “Speakers” will lead you to a PASS sign-in form, and then to the session submission form. A date will also be provided for when the call for speakers ends. Typically, the event schedule will be announced within a few weeks after this date.
中间标有“扬声器”的链接将带您到PASS登录表,然后到会话提交表。 发言人通话结束的日期也将提供。 通常,活动时间表将在此日期之后的几周内宣布。
Sessions are selected based on a number of criteria that will vary slightly from event-to-event. Some of the more common criteria are:
根据多个标准选择会话,每个事件之间的标准略有不同。 一些更常见的标准是:
- Written quality of the abstract. Like any publication, does it pass spelling and grammar checks and concisely describe the session’s purpose and content. 书面质量的摘要 。 像任何出版物一样,它是否通过拼写和语法检查,并简洁地描述了会议的目的和内容。
- Subject of the session. Is it interesting, in-demand, and relevant to SQLSaturday and its attendees? 会议主题。 它是否有趣,按需且与SQLSaturday及其参与者有关?
- Other submitted sessions. There can only be so many sessions on a single topic. Often, organizers need to juggle topics and sessions to ensure that the schedule contains a wide variety of subject matter and does not focus too much on any given area. You may check the list of already submitted sessions on the SQLSaturday event page in order to gauge if your proposed topic will fit a solid niche within the event. 其他提交的会议。 一个主题只能有如此多的会话。 通常,组织者需要考虑各种主题和会议,以确保日程安排包含各种各样的主题,并且不会将注意力集中在任何给定的领域上。 您可以在SQLSaturday事件页面上检查已提交的会话列表,以评估您建议的主题是否适合该事件中的固定对象。
- Speaker history & location. Being a first-time speaker is encouraged. SQ Saturday focuses on growing local and regional speakers in order to strengthen our technical communities and user groups. Events will often try to strike a fair balance between local and national speakers, as well as between new and experienced speakers. 演讲者的历史和位置。 鼓励您首次演讲。 SQ Saturday专注于增加本地和区域发言人,以增强我们的技术社区和用户群体。 活动通常会试图在本地和国家发言人之间以及新的和有经验的发言人之间取得平衡。
Once your session is selected, all that is left is to perfect the presentation, show up, and put on a great show!
一旦选择了会话,剩下的就是完善演示文稿,显示并进行精彩的表演!
Session feedback is solicited after all SQLSaturday sessions and events. For a group of data junkies, this is very helpful in understanding what topics are most useful and relevant to a quickly-changing market. Similarly, we want speakers to be given honest and direct feedback, thus allowing them to grow and improve as well. Feedback is used to improve everything from the event tracks to the variety of donuts provided with breakfast and is critical in allowing future events to succeed.
在所有SQLSaturday会话和事件之后都请求会话反馈。 对于一组数据迷来说,这对于了解哪些主题最有用且与快速变化的市场相关的主题非常有帮助。 同样,我们希望为演讲者提供诚实和直接的反馈,从而使他们也不断成长和进步。 反馈可用于改善从事件跟踪到早餐随附的各种甜甜圈的所有内容,对于使以后的事件成功至关重要。
赞助商 (Sponsors)
Free training is only possible if someone pays the bills and supports these events. Fortunately, there are many businesses, agencies, schools, and non-profit organizations that are happy to sponsor SQLSaturday events.
仅当有人支付账单并支持这些活动时,免费培训才有可能。 幸运的是,有许多企业,机构,学校和非营利组织很高兴赞助SQLSaturday活动。
Sponsorship costs vary from event-to-event, but typically are not expensive. Most common sponsor plans vary from $250 for minimal involvement to $1500 for those that want to be on-site and have a strong presence at the event.
赞助费用因事件而异,但通常并不昂贵。 最常见的赞助商计划从最低参与费的250美元到想要在现场并在活动中有很强势力的人的1500美元不等。
There are many benefits of sponsorship, including:
赞助有很多好处,包括:
- Advertising products, software, and services 广告产品,软件和服务
- Recruiting to fill open positions 招聘以填补空缺职位
- Company marketing & PR 公司营销与公关
- Supporting training for local employees, colleagues, and affiliates 对本地员工,同事和分支机构的支持培训
- Increase branding and reach by giving away literature, freebies, and raffle prizes 赠送文学作品,免费赠品和抽奖品,从而提高品牌知名度和影响力
Specific sponsor benefits vary from event-to-event, but will often include:
特定赞助商的利益因事件而异,但通常包括:
- Logo/branding on event materials and giveaways 活动材料和赠品上的徽标/品牌
- Inclusion in event raffles 纳入事件抽奖活动
- Included in opt-in email lists of event attendees 包含在活动参与者的选择加入电子邮件列表中
- Lunch demo sessions 午餐演示会
- Printed materials included in attendee bags 与会者包中包括印刷材料
- And more… 和更多…
Events are generally flexible with sponsors and will work to make their partnerships as beneficial as possible to those involved. SQLSaturday exists only because sponsors are consistently supporting events worldwide and helping make sure that they are well funded, attended, and advertised.
活动通常与赞助商灵活进行,将使他们的合作伙伴关系对与会人员尽可能有利。 SQLSaturday之所以存在,仅是因为赞助商一直在全球范围内支持活动,并帮助确保其资金,参与和宣传良好。
Precon活动 (Precon events)
Some SQLSaturday events will host all or half-day precon events on the days leading up to the big event. Precons are longer, more in-depth sessions that cover a given topic in far more detail.
某些SQLSaturday事件将在大型事件发生前的几天主持全部或半天的precon事件。 Precons是更长,更深入的课程,涵盖了给定主题的详细信息。
For SQLSaturday attendees, these are inexpensive ways to get even more out of the event. While precons are typically not free, they are inexpensive when compared to all other classroom or conference-style training. Many will include meals, snacks, or learning materials to make the experience more engaging.
对于SQLSaturday与会者来说,这些都是便宜的方法,可让您从活动中获得更多收益。 尽管前提条件通常不是免费的,但与所有其他课堂或会议形式的培训相比,价格便宜。 许多课程将包括进餐,点心或学习材料,以使体验更具吸引力。
Common precon topics include optimization/tuning, business intelligence, machine learning, database design, and new SQL Server features. The instructors are the best-of-the-best and put an immense amount of time and energy into ensuring that their precons are well-researched and presented, and that they are available for questions or further discussion after the event is over.
常见的precon主题包括优化/调整,商业智能,机器学习,数据库设计和SQL Server新功能。 讲师是最好的,并花费大量时间和精力来确保对他们的前提进行充分研究和介绍,并在活动结束后可以提出问题或进行进一步讨论。
If you are attending a SQLSaturday, check for precon events and find one that interests you, it’s a great decision 🙂
如果您正在参加SQLSaturday,请检查precon事件并找到您感兴趣的事件,这是一个不错的决定🙂
参与进来 (Getting involved)
SQLSaturday events can only be planned and run with the help of volunteers. Volunteers help in planning the event by coordinating food, sessions, dinners, hotel space, registration, and much more! In addition, volunteers will help run the event by staffing the check-in table, running errands, directing attendees where they need to go, setting up, cleaning up, and managing food or refreshments.
SQLSaturday活动只能在志愿者的帮助下计划和运行。 志愿者通过协调食物,会议,晚餐,酒店空间,登记等来帮助计划活动! 此外,志愿者将通过为值机台配备人员,安排差事,引导与会者需要去的地方,设置,清洁和管理食物或点心来帮助举办活动。
If you’d like to help, contact the coordinator of a SQLSaturday event near you! You can find an email address to the coordinator, as well as the event feed, Twitter info, and more on the event page. Scroll down past the introductory information and you’ll find some details that look like this:
如果您想提供帮助,请与您附近SQLSaturday事件的协调员联系! 您可以在活动页面上找到协调员的电子邮件地址,以及事件供稿,Twitter信息等。 向下滚动浏览介绍性信息,您会发现一些类似于以下内容的详细信息:
Not only is volunteering fun, but it is a great chance to support an amazing program, gain leadership skills, and work with a team of dedicated people towards creating a local training event. If you volunteer for my Albany, NY event, I promise you will be well-taken-care-of. Ask anyone in the area, if you don’t believe me!
志愿者活动不仅很有趣,而且是一个绝佳的机会,可以支持一项出色的计划,获得领导才能,并与一群敬业的人一起开展本地培训活动。 如果您自愿参加纽约奥尔巴尼的活动 ,我保证您会得到很好的照顾。 问该地区的任何人,如果您不相信我!
SQLSaturdays will often work with local and regional user groups in order to make events happen. If you do not have a SQLSaturday event in your area, consider starting one! If you can find a location and a handful of sponsors, then making an event like this happen could be a great experience for your user group, local community, and anyone else that gets involved!
SQLSaturdays通常将与本地和区域用户组合作以使事件发生。 如果您所在的地区没有SQLSaturday事件,请考虑开始一个! 如果您能找到一个位置和一些赞助商,那么进行这样的活动对于您的用户群体,本地社区以及任何其他参与其中的人来说都是一次很好的体验!
结论 (Conclusion)
In a world where free training and networking events are exceedingly rare, SQLSaturday has flourished for 10 years. If you have never been to one, consider making the trip! Many companies are happy to cover the costs of travel when the event is as inexpensive as this. The value of training combined with the chance to meet and trade ideas with industry experts and other professionals has been immeasurable. The consistently positive feedback that the program receives worldwide has continued to support its purpose, even as the number of SQLSaturdays has increased so quickly.
在免费培训和社交活动极为罕见的世界中,SQLSaturday蓬勃发展了10年。 如果您从未去过那里,请考虑旅行! 当活动价格如此便宜时,许多公司很乐意负担旅行费用。 培训的价值以及与行业专家和其他专业人员见面并交流想法的机会是不可估量的。 尽管SQLSaturdays的数量增长如此之快,但该程序在全球范围内获得的一致好评一直在支持其目标。
This is a great way to spend a Saturday!
这是度过一个星期六的好方法!
翻译自: https://www.sqlshack.com/everything-wanted-know-sqlsaturday-afraid-ask/
面试问sql优化