DenverSQL Archives - Page 3 of 3 - DawaBI

DenverSQL

ColoradoSQL in August

All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so bring a co-worker.

BoulderSQL

Third Tuesday

Level 3 Communications

Room 4LA-07

1025 Eldorado Blvd
Broomfield, CO 80021

 

Presenter: Scot Reagin ( web ) SJReagin & Associates

 

Having developed and delivered public and private training in the use of specific technologies (including DTS/Integration Services, Analysis Services, and MDX), best practice implementation strategies, and overall information architectural concepts, Scot is a respected speaker at business and technical conferences including TDWI, SQL Connections, Microsoft Tech-Ed, and PASS (Professional Association for SQL Server).

The presentation will cover Security/Dynamic Security, Backup/Recovery, and the automation of partition creation/processing.

 

SpringsSQL

Third Wednesday

Mr. Biggs

5825 Mark Dabling Boulevard
Colorado Springs, CO 80919

 

Presentation 1:

Presenter: Gabriel Villa ( blog | twitter )

Intro to “Denali” SQL Server Security

Get up to speed on the new security features in “Denali”, the next version of SQL Server. Disclose the new permissions, roles and encryption added to Denali. You’ll discover some commonly overlooked practices in securing your SQL Server databases. Learn about physical security, passwords, privileges and roles, and preventative best practices. I’ll demonstrate auditing and .Net code samples to use on your applications to prevent vulnerabilities.

Originally from El Paso, Texas, Gabriel has over 10 years’ professional developer experience using Microsoft technologies. Gabriel is an MCPD, ASP.NET Developer and an MCTS in SQL Server 2008 Database Development. He has developed desktop, web and database systems for the medical, retail, imports distributors, and automotive industries. Gabriel recently moved with his wife and three kids to Colorado Springs, where he works for a small ISV developing software for the big-ticket retail industry.

 

Presentation 2:

Presenter: Chris Shaw ( blog | twitter )

Utility Databases

If you were asked what average runtime was of your slowest stored procedure, could you provide the answer? What if you needed to provide that information for last month? Do you review your error logs each day? Do you know the growth percentages of your databases for the past year or even the past month? If your database has an unusual growth event will you know about it?  In the utility database that we create during this session we will track stored procedure information along with information about the hard drives such as free space. We will look at how you can have the errors in your error logs emailed to you each day. The goal of this session is to help you automate and centralize as many of your day-to-day tasks as you can.

Chris Shaw started his database career while in the Marine Corps working with Lotus Ami Pro databases somewhere in 1993. From there he went on to companies such as Wells Fargo, Pulte Mortgage and Yellow Pages Inc., and later consulted with insurance companies including Anthem Blue Shield. Chris has enjoyed writing and speaking about SQL Server over the last 10 years at events such as SQL Connections, Pass and SSWUG Ultimate conferences. Chris received the Microsoft MVP award.

 

DenverSQL

Third Thursday

Microsoft DTC Office

7579 Technology Way, Suite 400
Denver, CO 80237

 

Presenter: Chris Shaw ( blog | twitter )

Utility Databases

If you were asked what average runtime was of your slowest stored procedure, could you provide the answer? What if you needed to provide that information for last month? Do you review your error logs each day? Do you know the growth percentages of your databases for the past year or even the past month? If your database has an unusual growth event will you know about it? In the utility database that we create during this session we will track stored procedure information along with information about the hard drives such as free space. We will look at how you can have the errors in your error logs emailed to you each day. The goal of this session is to help you automate and centralize as many of your day-to-day tasks as you can.

Chris Shaw started his database career while in the Marine Corps working with Lotus Ami Pro databases somewhere in 1993. From there he went on to companies such as Wells Fargo, Pulte Mortgage and Yellow Pages Inc., and later consulted with insurance companies including Anthem Blue Shield. Chris has enjoyed writing and speaking about SQL Server over the last 10 years at events such as SQL Connections, Pass and SSWUG Ultimate conferences. Chris received the Microsoft MVP award.

By |August 15th, 2011|Uncategorized|

ColoradoSQL in June

All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so bring a co-worker.

BoulderSQL

Third Tuesday

Level 3 Communications

Room 4LA-07

1025 Eldorado Blvd
Broomfield, CO 80021

Warm-up Presentation

Transaction Basics

Paul Paiva

An overview of what transactions are all about. The following areas will be covered:

  • What is a transaction?
  • What is a distributed transaction?
  • When should I use a transaction?
  • How to use transactions during ad hoc work in the SSMS query window to safeguard against accidents.

Actual code samples will be presented and executed, live!

 

Paul Paiva has 16 years experience in virtually all aspects of Microsoft SQL Server.  In these years he has worked in the roles of production DBA, database developer, database architect, applications developer, business intelligence and data warehouse developer, and instructor for students aspiring for MCDBA certification.  He has performed numerous data migrations and supported large databases (3 Terabyte, 1+ billion rows) with high transactions. Presently he is an independent SQL Server consultant with CoCreative Solutions.  He is a member of the Professional Association for SQL Server (PASS), blogs about lessons learned from a developer’s approach to SQL Server administration, and has been the co-president of the Boulder SQL Server Users’ Group for the past two years.

 

Main Presentation

Isn’t That Spatial?

Jason Horner (twitter)

 

This presentation is a 1hr deep dive into the spatial features introduced in Sql Server 2008.  We will cover the basics of working with spatial data including: importing, querying, and visualizing.  As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.

 

Jason has been working with SQL Server since version 6.5 and currently holds several Microsoft certifications including: MCSD, MCDBA and MCTS. His most recent focus has been architecting large scale BI solutions. Previously, he helped architect, design, and build several high volume OLTP systems in a wide range of business domains.

SpringsSQL

Third Wednesday

Mr. Biggs

5825 Mark Dabling Boulevard
Colorado Springs, CO 80919

Warm-up Presentation

Isn’t That Spatial?

Jason Horner (twitter)

 

Isn’t that Spatial is a 30 minute whirlwind tour of the spatial features introduced in SQL Server 2008. We will cover the basics of working with spatial data including: importing, querying, and visualizing. As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.

 

Jason has been working with SQL Server since version 6.5 and currently holds several Microsoft certifications including: MCSD, MCDBA and MCTS. His most recent focus has been architecting large scale BI solutions. Previously, he helped architect, design, and build several high volume OLTP systems in a wide range of business domains.

 

Main Presentation

Managing SQL Server Permissions

Mike Fal

When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have ‘sa’ access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.

 

Mike Fal is a SQL Server DBA with 10+ years of experience, with some brief excursions into Oracle and Netezza. He currently works for a nation-wide marketing agency, supporting over 100 database servers with databases from 1 GB to 4 TB in size. Mike holds a Bachelor’s Degree from the University of Colorado at Boulder and has been caught playing trombone in public on more than one occasion.

DenverSQL

Third Thursday

Microsoft DTC Office

7579 Technology Way, Suite 400
Denver, CO 80237

Warm-up Presentation

Securing Your Service Accounts

Brandon Tucker

 

“What are service accounts, and how do they affect me?” Everyone’s asked it before, and some have never gotten the proper answers. Though it’s unlikely to answer all the questions of the universe in this 30-minute presentation, we’ll explore the security concerns with service accounts, pitfalls to avoid, and considerations to streamlining your SQL Server service accounts!
Over the past five years, Brandon has explored the SQL Server product as both a developer, administrator, and consultant. Starting in Salt Lake City, he translated his academic knowledge base into real-world scenarios in the health insurance, education, and transportation industries. Brandon has presented at Code Camps/User Groups in UT, as well as User Groups/SQL Saturdays here in Denver. On the side, Brandon casually DJs electronic music and enjoys disc golf, skiing, and beer. He currently holds a BS Computer Science from Neumont University (by way of Bucknell University) and an MCITP: Database Developer.

Main Presentation

SSIS Data Transformations

Mike Sexton
The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

 

Stunningly handsome yet surprisingly humble, Mike Sexton spent the first ten years of his career as a public defender in New York. Realizing he could make far more money as a junior programmer than as a lawyer with 10 years’ experience, he had a revelation, the words of which that are not appropriate for a family publication. Since then Mike has traveled the lands taming errant database applications, publishing and blogging at www.sqlmountain.com. He recently published Applied Architecture Patterns on the Microsoft Platform, which may be found at finer bookstores. Mike can be found living the high life in Colorado with a hot blonde on his arm.

By |June 15th, 2011|Uncategorized|

ColoradoSQL in May

All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so bring a co-worker.

BoulderSQL

Tuesday May 17

Level 3 Communications

Room 4LA-07

1025 Eldorado Blvd
Broomfield, CO 80021

 

Presentation

Managing SQL Server Permissions

Technorati Tags: ,User Group

Mike Fal

When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have ‘sa’ access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.

Mike Fal is a SQL Server DBA with 10+ years of experience, with some brief excursions into Oracle and Netezza. He currently works for a nation-wide marketing agency, supporting over 100 database servers with databases from 1 GB to 4 TB in size. Mike holds a Bachelor’s Degree from the University of Colorado at Boulder and has been caught playing trombone in public on more than one occasion.

SpringsSQL

Wednesday May 18

Mr. Biggs

5825 Mark Dabling Boulevard
Colorado Springs, CO 80919

 

Presentation

Encryption, Compliance and Auditing

Tom Norman (twitter)

I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let’s look at what we can do to help us pass audits and comply with the laws around us. We will explore the features in SQL Server 2008 which help us.

 

Tom Norman, Sql Server Database Administrator, TSYS. Tom has been working with Sql Server since 1998. He has worked internationally with Sql Server. His current responsibilities include Replication, Performance and Server Compliance of all Production databases in the US and UK. Tom and his team are currently working on a project to upgraded several products to Sql Server 2008 R2 and bring them into PCI compliance. Tom is the past President of the Denver Sql Server User Group.

DenverSQL

Thursday May 19

Microsoft DTC Office

7579 Technology Way, Suite 400
Denver, CO 80237

 

Warm-up Presentation

Isn’t That Spatial?

Jason Horner (twitter)

Isn’t that Spatial is a 30 minute whirlwind tour of the spatial features introduced in SQL Server 2008. We will cover the basics of working with spatial data including: importing, querying, and visualizing. As time permits, we will dive into some best practices for working with spatial data and ways to improve spatial query performance.

Jason has been working with SQL Server since version 6.5 and currently holds several Microsoft certifications including: MCSD, MCDBA and MCTS. His most recent focus has been architecting large scale BI solutions. Previously, he helped architect, design, and build several high volume OLTP systems in a wide range of business domains.

Main Presentation

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

Glenn Berry (twitter | blog)
The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

Glenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. He recently completed the Master Teacher Program at Denver University – University College. He is the author of two chapters in the book SQL Server MVP Deep Dives, and blogs regularly at http://sqlserverperformance.wordpress.com.

By |May 16th, 2011|Uncategorized|

DenverSQL UG Meeting: Tim Mitchell presents Dirty Data? Clean it up!

Denver SQL Server User Group – Thursday, February 17, 2011

Main Presentation
“Dirty Data? Clean It Up! By Tim Mitchell”

Dirty Data? Clean It Up!

Dirty data is everywhere, and it’s headed for a database near you.  Extraction, transformation, and loading (ETL) can be difficult, but often the most challenging component of that process is the validation and clean up of data.  Information must be cleansed in such a way that it retains its original message and business value, while conforming to the expectations of the destination system(s).  In this session, we will discuss some of the high-level challenges of dealing with dirty data, along with some infrastructure-agnostic recommended practices for doing so.  Further, we will dig in and get our fingernails dirty (pun intended) on some specific ways that SQL Server Integration Services (SSIS) can be used to cleanse incoming data.

 

About the Presenter

Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer.  He has been working with SQL Server for over 7 years, working primarily in business intelligence, ETL/SSIS, database development, and reporting.  He has earned a number of industry certifications and holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP.  Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area.  As an active member of the community, Tim has spoken at venues including numerous SQL Saturday events, Houston Tech Fest, and various user groups and PASS virtual chapters.  He is a board member and speaker at the North Texas SQL Server User Group in Dallas, is co-chair of the PASS BI Virtual Chapter, and is an active volunteer for PASS.  Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on HDIDS.com.  You can read his blog at TimMitchell.net or follow him on Twitter attwitter.com/Tim_Mitchell.

 


As usual, we will make time for question and answer sessions, networking, and eating. Prizes will be awarded at the conclusion of the meeting.

Our meeting location has changed!

Starting in January 2011,
we will be meeting at the Microsoft headquarters!7595 W. Technology Way, Suite 400
Denver, CO 80237
(720) 528-1700
map

Meeting Agenda:
5:30 – 6:00 – Food / Socializing
6:00 – 6:10 – User Group Business
6:10 – 6:30 – Open Panel/Questions & Answers
6:30 7:00 30 minute presentation
7:00 – 8:00 Main presentation
8:10 – Give Away / Wrap-Up

By |February 17th, 2011|Uncategorized|

Denver SQL Server UG September meeting

For the past 1 1/2 years now we’ve been hosting two presentations each meeting.  The first presentation is typically a 30 minute intro level topic and the second a 60 minute more advanced topic.  This month we are giving something else a go.  We are hosting two 60 minute presentations.  The first topic is Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class being presented by Brooke Philpott of SQL Sentry.  The second presentation is Efficient Operational Data Replication (ODR) with the Attunity CDC Suite for SSIS by Doug Wheaton of Attunity.  Attunity is also the featured sponsor for this month.

 

Here is more detail:

SQLSentry02-72

The first presentation, “Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class” will be given by Brooke Philpott of SQL Sentry.
SQL Server provides multiple ways to insert data using ADO.NET. We’ll explore individual writes as well as batched writes in non-RPC and RPC form, with a focus on using the internal SqlCommandSet class to get as close as possible to bulk-copy performance, without the restrictions. Along the way we’ll look at the impact of the various methods on the SQL Server plan cache, and address ways to prevent plan cache bloat when using high-volume inserts, ultimately arriving at a method that is very fast and has minimal impact on the plan cache.
Brooke Philpott is a Senior Technical Lead at SQL Sentry, Inc. Brooke is the lead developer of SQL Sentry’s award-winning software products. He was also part of the DBA team managing the largest SQL Server hosting shop in the Southeastern United States. Brook has BS in Mathematics from Davidson College. His hobbies include cooking, photography, music, and video games. You can read his blog here: http://brooke.blogs.sqlsentry.net/

 

attunitylogo

The second presentation, “Efficient Operational Data Replication (ODR) With the Attunity CDC Suite for SSIS” will be given by Doug Wheaton of Attunity.
During this presentation you will learn how to leverage your SQL Server skills and software to reduce cost and accelerate operational data replication (ODR), synchronization, and real-time integration of heterogeneous data sources including SQL Server, Oracle, and DB2. Doug will explain CDC (change data capture) and ODR concepts and benefits as well as how you can use them to enable operational reporting and business intelligence or to maintain data consistency across systems.
Doug Wheaton is a Senior Software Engineer at Attunity and has over 20 years of experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences throughout the US on the topic of data integration using Microsoft SSIS.
Location:

AmeriTeachlogo
AmeriTeach
7800 East Dorado Place, Suite 150
Greenwood Village, CO 80111
720-346-1710
Meeting Agenda:
5:30 – 6:00 – Food / Socializing
6:00 – 6:10 – User Group Business
6:10 – 6:15 – Open Panel/Questions & Answers
6:15 – 7:15 – Presentation 1
7:15 – 8:15 – Presentation 2
8:15 – 8:20 – Give Away / Wrap-Up

 

And of course: SQL Saturday #52 Colorado is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free with the exception of a $10 lunch fee; all other costs are covered by donations and sponsorships. Please also let friends and colleagues know about the event.
Registration for the 9/25 event is now open at: http://www.sqlsaturday.com/52/register.aspx

By |September 16th, 2010|Uncategorized|

Denver SQL Server User Group Board Meeting Notes from 20090901

 

To address a few questions on what does the board actually do and to bring more visibility to all of the members plus non-members, I thought I’d write-up some notes from last weeks board meeting.  We are always looking for feedback as to what you think is not working, or maybe what is so we can focus more on it. Please let us know any thoughts; good or bad.

 

The board typically meets once a month on the first Tuesday.  A few days prior to the meeting we will email each other different agenda items to be discussed.

 

Last weeks notes are as follows:

  1. Group Sponsorship
    1. Given that we are a non profit organization with no real revenue stream, we rely heavily on our sponsors.  Our main swag source has put a freeze on anything new until further notice.  Therefore, we will need to start looking for some additional sources.  We will draft up some letters and start sending them out to potential new sponsors.  We’ve heard from several members that having the possibility of bring home some type of swag is always nice.
  1. Speakers
    1. Speakers are a large part of the user group and we’ve now gone to hosting two presentations at our regular meetings.  The two presentations, we aim to have an intro level topic for 30 minutes and then a 60 minute more advanced topic.   Tracking down quality speakers and getting them scheduled is a never ending job.  It seems that the stream of speakers always fluctuates throughout the year.  We are back to only having scheduled speakers for the next meeting.   We all will be searching for speakers.
    2. We discussed a topic idea that was suggested by a member around job hunting and the current market conditions.  We’ve had one Professional Development topic recently which was presented by Steve Jones on “Ways To Build Your Brand“.  We had a lot of great feedback from this presentation.  Given the member feedback, we will look at hosting another PD topic in the near future.  A rough guide for PD topics maybe 1 30 minute and 1 60 minute presentation in a year.
  1. Certification Study Group
    1. Chris Randall has been working with different vendors and sponsors on this regard.  For this initial study session, the idea is to focus on the Administration exams.  The bulk of the studying will be self study with a cram session on a Saturday (tentatively set for Nov. 14).  We will then take the exam as a group afterwards. We will take the feedback and our experiences with this initial session and refocus for a second.  The second session will focus on the Developer exam targeted for February.   We’ll then repeat this for the BI exam in April.
  1. Lab
    1. The hope and idea of the labs is to provide some additional hands on time with SQL Server while others around to help out.  We discussed the logistics and timing of this event and thought for the initial go or two that it would work out best to hold the labs the same date as the Certification Study Group sessions.  We realize that there maybe some conflict for folks that would like to attend both the Certification Study Group along with the Lab but hope this number will be relatively low.  We will take all feedback into consideration for future labs to improve the offering and value.
  1. SQLSaturday Denver
    1. The board, earlier this year,  discussed holding some sort of larger community event.  We all thought this was a great idea but wanted to focus on getting a certification study group and lab up and running first.  This summer,Steve Jones a co-founder of SQLSaturday, approached us about holding an event here in Denver.  We’ve had an initial discussion with the organizers of the Tech Tri-Fecta about merging a SQLSaturday with their event and all thought it was a great idea.  Our tentative aim is February for this combined event.  We are still seeking a facility to host this event.
  1. Mentors
    1. A member sent us an email a short time ago seeking information or if we offer any type of mentoring program.  This member is relatively new to SQL Server and is lacking real world experiences.  The board thought this was a great idea and we will roll out an initial offering shortly.  We thought the role we could play best, at least initially, would to be facilitators and connecting different members.
  1. Member Recruitment
    1. Getting new members along with increasing attendance rates at meetings helps for several reason.
      1. The more members we have the more diverse the knowledge pool becomes.  With more members, we have a broad range of backgrounds to potentially share by way of speaking, answering questions on the forums or at the meetings and potentially more mentors.
      2. The more members we get along with more folks showing up for meetings, the higher probability of attracting more sponsorship. Sponsorship of course helps with the food and refreshments that are offered at the meetings along with more swag.
      3. So, we are working on sending out targeted mailings to local colleges and universities. Some of which maybe great resources for hosting a SQLSaturday event.
  1. Board Elections
    1. In order to keep some fluidity after the elections three board positions were setup to have elections on the odd years with the other two the even years.  This way the entire board doesn’t have the potential to rotate out and the new board left trying to keep the momentum.  The elections are typically held in November and the re-elected or new board member starts officially the first of the year.  On the occasion that a sitting board member decides to step down, we may hold out of cycle elections. This year the following three positions are up for election:
      1. President – Term 2010 – 2011
      2. VP Marketing – Term 2010 – 2011
      3. Treasurer –  Term 2010 – 2011
  1. December Meeting
    1. This is always a debate as to if we should hold the meeting or not and if so, do we hold a typical meeting or something fun.  We’ve not yet decided but please let us know your thoughts.
  1. Book reviews
    1. We’ve had a few questions recently with regards to what has happened to the book review program that was recently started.  We’ve had a good initial response from this program.  Unfortunately, the major book publishers we were working with have stopped sending books.  We have and will continue to follow-up with these publishers as well as reach out to others.
    2. UPDATE: Wrox ROCKS!  Wiley publishing delivered to the group several books for review.  Thanks Wiley!

 

wrox_logo

By |September 10th, 2009|Uncategorized|

Presentation materials: Intro to Analysis Services (SSAS)

 

I did a presentation last week for the Denver SQL Server User Group (www.DenverSQL.org) and the Colorado Springs SQL Server User Group (www.SpringsSQL.org) on Intro to Analysis Services.  The slide deck can be found here.  Both were short presentations (30 minutes) aimed at getting folks started with Analysis Services.

Both user groups have gone to two presentations a night.  The first topic is aimed at entry level folks and is 30 minutes long.  The second topic is more advanced for 60 minutes.  If you are interested in speaking, let me know.  We are always looking for good speakers to present.

By |June 26th, 2009|Uncategorized|