text:
Parents testify at April 2015 CPS BOE meeting
7 parents testified this month about the need for CPS to invest in district run schools. CPS just recieved proposals to open another 9 charters with 32 campuses. Jennie Biggs of RYH shared our infographic showing there are over 12k empty seats in existing charter schools. Given the budget crisis and enrollment decline at our district, we find it financially irresponsible to keep opening more schools.
Some parent testimonies:
Belding, LSC rep Lynn Ankney
I appreciate the opportunity to speak about my passion for my neighborhood school and how I believe CPS has an opportunity to strengthen our city through stronger support of district run schools. I'd be remiss in my testimony if I didn't acknowledge my unyielding support and love for my neighborhood school is in spite of the ongoing challenges we parents face against a district that is fraught with controversy and has a seeming propensity towards privatizing our public schools. My name is Lynn Ankney and I live in Old Irving Park. My son and daughter attend our neighborhood school, Belding. I've served on the Belding LSC since 2007 and co-founded Friends of Belding. In short, I not only drink the Belding Kool-Aid, I help make it. At the risk of sounding immodest, you want more parents like me across CPS. Why? Because I'm never moving and am committed to making our neighborhood school, Belding, the best it can be. I had a vested interest before my kids attended and I'll want to see it thrive long after my kids have graduated. All residents have "skin in the game" either directly or indirectly when it comes to their neighborhood CPS. And that's my point: There is an inextricable link between our neighborhood schools and the communities they serve. Show me a thriving neighborhood school and I'll point to an influx or families, rising home values and real estate listings touting the local CPS. Unfortunately, the reverse is true. We all know schools are a MAJOR reason families with children approaching school age flee Chicago and head for the suburbs. Give parents a reason to stay in the city. There are many other "Beldings" across Chicago and there can be many more if CPS would wise up and realize our world class city's strength is through the patchwork of diverse, vibrant neighborhoods and no neighborhood will prosper without a solid school at the heart of that community. So here's my pitch to our Mayor and you: neighborhood schools matter! Invest in neighborhood schools and you're going a long way to strengthening the communities in which they reside, attracting and most importantly RETAINING the local families who have the motivation and power to make their neighborhood school excel and become the anchor of their community.
Laurie Viets, Beard school
Hello. My Name is Laurie Viets and I am theproud parent of three children who attend Beard Elementary School. Beard School is a specialty Chicago Public School –districtfunded-that services students with special needs from Pre-K to 3rd grade. My 3.5 year oldgirl/boy twins, River and Raven, are part of pre-k in the Ready to Learnprogram with Raven receiving special services through an IEP for DevelopmentalDelay. My oldest child, Canyon, isAutistic and was blessed with the opportunity to attend Beard for two years ofpre k and is now in kindergarten. As I was staring at my computer screen trying to decide how tomake everyone understand how truly life changing this public school is to myfamily and so many others- my Facebook feed was blowing up with more and morestories of corruption and scandal and conflict of interest…it was overwhelmingand it kind of made me just want to give up and go to bed. Then I thought, NO. We need these positive stories more than ever. We need people to know that despite all the negative, soulsucking garbage that is coming out of Chicago and all the political trash talkagainst Chicago's public schools and it's teachers, that there are incredible publicschools in CPS. In the case of Beard we are blessed with amazing, brilliant, kind,creative, wonderful teachers and staff who have made it their life's work toeducate, inspire and protect children with special needs. Each and every child in theirclassrooms has unique challenges to learning and these men and women work tofind the right technique to reach them. They go above and beyond everyday. I am so thankful for them and what they do for my kids. To see my Autistic son learning to readand write and do math is life changing. To see him play 5 oranges in the school play of "The Very HungryCaterpillar" made me cry. I love our school. I am so grateful for the funding that makessuch a magical place possible. Iam terrified that when the budgets come out in June that we will be decimated. We can't let that happen. 2 minutes is not enough time for you to know Beard. So please accept an invitation frommyself and my children to come and visit. You will be inspired. Andyou could probably use a little of that right now.
Erin Rensink, Darwin school
Hello my name is Erin Rensink. I have been a parent at Darwin Elementary School in Logan Square for the past three years. We chose Darwin because we believe in its mission, we wanted to stay in our neighborhood and most of all I believe in public education. Darwin has come a long way in the short three years we have been parents there. It's been quite the ride. Despite CPS putting it on a closing list and cutting 750,000 of funding three years ago when my son was in his first year of pre-school it is thriving. I am here to ask for equitable funding and equitable support of our public schools.
Let me tell you about a few of the great things that are happening just four blocks from my home at Darwin. We now have a game changing leadership program as well as Concert Band, Rock Band, Ukelele Choir, Concert Ukelele Choir and Junior Ukelele Choir, Guitar, Concert Choir and Piano Lab. Our school now has an after school program facilitated by Columbia College that focuses on art, science, English and math. Kindergarten through 6th grade started flamenco class after school just yesterday. Our teachers and administrators have been working hard to find the funding for these programs through grants and partnerships. We have no support from CPS to make these great programs in our school happen and that is a shame. Darwin in working hard to make this a school for all neighborhood children. I can only imagine what an amazing place our school would be with sufficient funding.
I have nothing but the utmost gratitude and love for the hardworking teachers and administrators that make our school the inspiring place that it is. We love our neighborhood school. We need a strong PUBLIC school system. Every child and parent in Chicago should have that choice. I would love for CPS to be able to share more of the successes in our public schools. Thank you.
Kerry Murphy, Dever school
Good morning. I am an elected LSC parent rep at Dever elementary. As you are aware, I've been here before to discuss overcrowding at Dever, but today I am here to discuss the wonderful things happening at the school despite serious overcrowding and other top-down mandates that the school has no control over.
Dever is a school where my kids are valued and their relationships with teachers are strong. The dedicated lunchroom staff serves hot lunches and cold breakfasts to the students every day, even though our lunchroom is understaffed. The school stays relatively clean, thanks to the school staff and parent volunteers who step up to clean in the absence of enough custodians. We find creative ways to keep up with the unfunded mandates handed down by the Board of Ed. The wonderful administration and staff have worked to obtain the Creative Schools Certification, even though they wheel the music and art classes around on carts. A dance instructor now leads class in the multipurpose room to fulfill the unfunded PE requirement, at the same time and in the same room as our kids are eating their lunch. The school has recess to fulfill the unfunded recess mandate in a non-fenced in concrete area. Thankfully, as of yet no child has been hit by a car. We now have 3 kindergarten classrooms of 30 kids each, with no classroom assistants to fulfill the unfunded full day kindergarten program. Dever lost the funding for all after school programs this year, so we dipped into our school budget to offer at least some after school programs for our students.
As you can see, the decisions made by our administration and staff are in the best interests of the children and Dever should be held up as an example of the kind of school model that should be replicated in other neighborhood schools. It's time for the mayor to hit the reset button and approve policies that lift our district schools up, not bring us down. Stop destabilizing neighborhood schools by shifting dollars over to privately run charter and contract schools. We have done our part at the school level, now do yours.
Arts Budget Charter Schools CPS Board of Ed District Run Schools Elementary Schools Positive School Stories Under Resourced Classrooms and Schools


After passing through St. George, head to Hurricane on I-15, and take Exit 16 toward Hurricane. Continue on that road to the third stoplight, where you will begin to see signs for Sand Hollow State Park. Turn right, and follow the road for about three miles. The entrance to the park will be on your left, just after you see the Sand Hollow Resort sign.
Please be there 30 min early. At the gate to the park, tell the attendant you are there for a tour with ATV and Jeep Adventures, and they will let you through as we have already paid for your entrance into the park. See below for instructions after you get through the gate.
Travel time from Saint George- 25min.
Travel time from Las Vegas- 2 hr. 10 min.
While heading south toward Hurricane on I-15, take Exit 16 toward Hurricane. Continue on that road to the third stoplight, where you will begin to see signs for Sand Hollow State Park. Turn right at the stoplight, and follow the road for about three miles. The entrance to the park will be on your left, just after you see the Sand Hollow Resort sign.
Please be there 30 min early. At the park's gate, tell the attendant you are there for a tour with ATV and Jeep, and they will let you through for free because we have already paid for your entrance into the park. See below for instructions after you get through the gate.
Head south from Springdale, through Rockville, and down the mountain. At the bottom, you'll see a gas station on your left and a stoplight. Turn left at the stoplight, and head toward Hurricane. Pass through Hurricane until you see a Walmart and Maverick gas station on your right. After passing them, you'll come to a stoplight with signs that read, "Sand Hollow State Park." Turn left onto that road, and follow it about three miles to the entrance of the park, which will be right after you see the Sand Hollow Resort sign.
Please try to be about 30 minutes early. When you get to the gate, tell the attendant you are there for a tour with ATV and Jeep Adventures, and they will let you through. You do not need to pay an entrance fee, we have already done so.
Travel time from Zions National Park- 45min.
From the park entrance to to the parking lot where we will be waiting is 1.8 miles.
After passing through the gate, take your first right and follow that road past The Beach (which will have a lot of ATV's and UTV's sitting out around it), and continue on this road until you see a right hand turn into a parking lot.
Take an immediate right into that paved parking lot and you will see our guides at the far end waiting there with our white Ford F-250 truck and trailer.
Thank you for contacting us! Please fill out the form below and we'll get back to you as soon as possible. Our responses sometimes get lost in your junk folder, so make sure to check there. Thank you for considering us as your guide for your Utah ATV adventure!


Cyber criminals are targeting more government entities by finding holes in dated legacy systems, which are inadequate in protecting the network, data, and users. Federal organizations need to invest in contemporary IT security and data protection—and need to do this quickly before it's too late.
Barracuda Networks offers robust, reliable, and easy-to-manage security and data protection solutions that protects your network, data and users against sophisticated cyber threats.
Barracuda proudly manufactures all products in the United States.
Barracuda strives to make products that are accessible to users with disabilities. Below are links to Voluntary Product Accessibility Template (VPAT) responses for several Barracuda Networks products. These VPAT responses indicate how Barracuda products meet the requirements of the federal government's Section 508 standards.


text:
Lisboa, Portugal
 Campolide — freguesia
Estação Ferroviária de Campolide

Outros usos
Campolide (álbum) — de Sérgio Godinho

Desambiguações de topônimos

redpajama_set_name: RedPajamaWikipedia


text:
The 2018 Basque Pelota World Championships were the 18th edition of the Basque Pelota World Championships organized by  the FIPV.

Participating nations

 (10)
 (4)
 (1)
 (7)
 (11)
 (2)
 (14)
 (1)
 (1)
 (12)
 (2)
 (14)
 (5)
 (8)

Events
A total of 14 events were disputed, in 4 playing areas.

Trinquete, 5 events disputed

Fronton (30 m), 4 events disputed

Fronton (36 m), 4 events disputed

Fronton (54 m), 1 event disputed

Medal table

References

World Championships,2018
2018 in sports
International sports competitions hosted by Spain
World Championships,2018
World Championships


The emergence of sporting outfits in the early 20's affected the acceptance of casual apparel in modern times. In the past, informal garments can be defined as a combination of denims and tees. Men and females are now possessing a difficult time deciding on the suitable everyday outfits, due to the fact of the numerous alternatives the marketplace presents.
Get all your other measurements that you want for apparel, sneakers and jewelry and you are prepared to go searching. You do not have to fret about dimensions if you know what your measurements are. Most of the time dimensions among Online clothing brands are incredibly different, so do not count on sizing. Only if you come across a model that you get a ton, will you be ready to depend on a consistent dimension inside of that particular label.
They want to differentiate amongst very good high quality garments and high-priced (not resilient) garments. For example most of the Online clothing brands have light content but heavy premiums, appears that they are only charging for their manufacturer identify and id.
Are you not far too eager on the strategy of male clothing Stores purchasing? Are you additional at ease shopping from a clothes shop? Don't stress, acquiring trend clothing online is not that major a hassle as you assume. Causewaymall makes lifetime quite straightforward for you when it will come to obtaining garments on-line. And given that it concentrates on East Asian garments, you will generally get what you want.
Therefore, you do not want to forecast that the dress on prom is to be the size of the common costume. You ought to know that you can change a gown when it is a larger dimension. And it is hard to alter a costume when it comes out with a more compact measurement. You can have a check out at the specialist tailor to measure you undergarments as you can have the correct measurements. Now, you can match your measurement with the dimension chart of the costume currently being offered at the online clothing store. If you do not uncover out the precise dimensions of the dress, you can go for a larger sizing as you can change it easily centered on your measurement.
One of the most well known places to obtain employed male clothing Stores is eBay. Verify the people suggestions rating prior to bidding or obtaining. Feedback is the quantity that is shown subsequent to the person name. If you click on the number you can see responses left and received by the customer. You can inform proper away what type of vendor they are by looking through through the comments. If the human being is suggest or insulting, consider buying from another person else. You can get s truly very good offer on ebay, in particular if the bidding begins really reduced and there is little, or no other bidding.
What is the item that commonly sells in the marketplace? The very best area of interest to opt for is a requirement item. What are the standard desires that individuals need in get to are living? These are foods, clothing and shelter. So food and shelter could have a problem with the market. But apparel is not and it is a extremely expandable niche. You can start out by just selling females male clothing Stores then shifting into menswear, then accessories and shoes as time goes by. Prospects are limitless.
When fleece trousers initial strike the industry males were being the major focus on market. Now they are common with women, teenagers and tiny kids. Moms like them due to the fact they make dressing toddlers and toddlers so effortless and they wash up so effectively.
For all other sorts of lingerie you must know her clothes sizing and measurements if feasible. You can discover out by looking at her Online clothing brands to see if she is an eight or 10 and so on. Even so her apparel might say that she is a S, M or L, so shell out desire to that also.
Importantly, all these going on apparel are now accessible at selected online clothing store. These outlets are unquestionably way in advance of their competition. They are reputed for their unique clothes range which they provide to their enormous customer foundation at real price. Go by way of their apparel catalog with males's apparels like shorts, jackets, trousers and shirts. You would undoubtedly slide in love with the exquisite outfits line that these shops supply to their treasured consumers. Also, if you have young children and are searching out for some fashionable footwear for him then check out out the Nike Footwear and such other shops for attractive gives, discount rates and deals. They also have a definitely outstanding catalog of hand luggage, trekking luggage, notebook luggage and much more.
You'll almost certainly want to get a birthday cake comprehensive with candles. You can either bake a cake yourself or purchase 1 of the bakery. Remember keep in mind any attainable food allergic reactions that the friends may have. Photos of a birthday cake will be a excellent reminder of the birthday for several years to occur, so make absolutely sure you get one particular that's colourful and will stand out nicely in pictures.


text:
Q: Checking existing array have given value or not In following code i have define empty array houseTotal, now I would like to push value inside array which is unique and not exist previously. I have use some, unique, sort filter but its pushing all the value it gets. Here is my code:
            let houseTotal = [];
            await rel.map((each, index) => {
                if (
                    !isEmpty(each.house_detail) ||
                    !houseTotal.some(el => el === each.house_detail._id)
                ) {

                    houseTotal.push(each.house_detail._id);
                }
            });
            return houseTotal.length;

What I have done mistake here ? Thank you.

A: If houseTotal is to have UNIQUE values and no duplicates.. I'm going to assume "duplicates" can be == each other and I'll use the Array.includes function
        let houseTotal = [];
        await rel.map((each, index) => {
            if (
                !isEmpty(each.house_detail) ||
                !houseTotal.some(el => el === each.house_detail._id)
            ) {
                let detail=each.house_detail._id
                if(!houseTotal.includes(detail)){houseTotal.push(detail);}
            }
        });
        return houseTotal.length;

A: And I got the solution, it was small mistake I have made on above code, I forgot to change object id returning from mongo to string so just added toString().
let houseTotal = [];
        await rel.map((each, index) => {
            if (
                !isEmpty(each.house_detail) ||
                !houseTotal.some(el => el === each.house_detail._id.toString())
            ) {

                houseTotal.push(each.house_detail._id.toString());
            }
        });
        return houseTotal.length;

redpajama_set_name: RedPajamaStackExchange


"To the great Margarida Xirgu, actress with an immaculate artistic career, a genius of Spanish theatre and an admirable creator"—Federico García Lorca. The free spirit of these words by Spain's greatest poet, inscribed in the stone before this sculpture, reveal better than any the immense talent and art of this famous Catalan actress.
She was born in 1888, began acting professionally in the company of Josep Santpere (another important figure in Catalan theatre) before forming her own in the Teatre Romea (across the street from this sculpture). In 1914 she moved to Madrid, where she collaborated closely with Lorca, premiering in almost all of his major plays such as Yerma and Blood Wedding. In 1939, after a South-American tour of the former's works, the fascist victory in Spain forced her to remain in exile in Chile and Uruguay, where she died in 1969.
The balanced abstraction of this piece conjures the easy grace and lively spirit of a talented performer and energetic intellectual. There is a suggestion of arms raised in a Yerma-esque entreaty to the fertile moon in the upper section—although instead of that character's plea for pregnancy, this actress might identify with a fuller idea of the female principle embodied there through the trunk-like strength of the lower torso. The piece's stark profile redefines its Gothic environment as Xirgu would have reinvented her stage space according to the needs of her performance, a perfect fit between form and space, figure and scenario.
Statue in memory of Margarida Xirgu by Eudald Serra, 1988. Plaça Canonge Colom, off C/ Hospital, opposite Teatre Romea.


text:
Elona Mobile Mod Apk Damage/Defense Multiplayer
Rated for 12+
Tons of content and Puzzles to Solve
Unlock and Upgrade weapons
Other Exciting Features
Do you love RPG epic adventure games with lots of characters (Avatars) and vast open-world to explore in 2D graphics? If yes, then Elona Mobile is a game for you.
Developed and Published by LTGAMES Global and NOA (Japan-Oriented Studio), Elona Mobile has received amazing feedback since its initial release. The game was first published in 2007 for Android, Windows, and iOS users and is currently available on Play Store. It has been downloaded over 1M+ times and received an average rating of 3.9+ by 14K+ reviewers worldwide.
Elona Mobile is an RPG Roguelike Single-Player game with 2D Graphics and tons of content to enjoy. The main theme of Elona Mobile is to explore the vast land of North Tyris a dangerous Island full of predators and Dungeons. It all starts when the main character tries to escape Etherwind using a shipwreck and unfortunately fell into a Storm and later finds himself in North Tyris.
Now, it's on you to embrace this epic journey to survive on Island and be whatever you wanted to be whether a former, warrior or a marauder. Build your own Business tycoon once you have all the necessary items to make it happen and turn this North Tyris into the safest Island to live.
In this article, we'll do an in-depth overview of Elona Mobile explaining different features and gameplay story. So, stay tuned and read this article till the end.
Similar to other offline RPG games Elona Mobile also features tons of content for you to enjoy with an interesting story. Here Puzzles are represented as findings and players will have to complete these findings (quests) in order to progress and earn rewards. Elona Mobiles offers more than 100+ findings to complete all with unique locations to explore and new characters ( characters with unique qualities such as power-ups) to deal with. Maybe you like this similar game Tailed Demon Slayer Mod APK.
Players can also enjoy 11 races and 10 classes as an additional bonus story and earn epic rewards including in-game coins and characters.
In order to survive in North Tyris, upgrading your weapons and skills is one of the most important things to do. In the beginning, surviving might be easy as the predators you face won't be so powerful. However, as you progress the more dangerous predators you'll have to deal with, and defeating them won't be easy. So, for long-term Survival on North Tyris don't forget to upgrade your weapons and unleash their full potential.
Create a Dream life
Do you want to become a famous chef or a farmer to build a Business Tycoon, this game has everything for you. You can create your own fantasy dream life and choose who you want to be in Elona Mobile's open world.
Events and Treasure
Apart from attractive story-driven gameplay to follow Elona Mobile also features hidden treasures to find and events to participate in this.
Create a Unique Strategy
As the Genre RPG (Role-playing-game) suggest strategy is one of the most important aspect to develop if you (as a gamer) wanted to progress in this challenging game. Create a unique strategy using a mix-up of different weapons and shields to defeat others and protect yourself from being killed.
Ads-Free Experience
Just like most of the android games, if you were thinking Elona Mobile would also have ads then you are wrong. Because this game offers an ads-free experience, not a single time while playing you'll have to experience ads.
In the end, I would say Elona Mobile is fun to Play game if you are looking for a 2D roguelike gaming experience. With over 100+ quests to complete, character customizing, and an exciting gaming story to follow, I believe it is with downloading Elona Mobile.

redpajama_set_name: RedPajamaCommonCrawl


On the state highway of Latur-Nanded, Chakur is a small Taluk place now popular for its biggest water park in Maharashtra. Chakur is 35 kms from the Latur city. Chakur is famous all over Maharashtra for its rare combination of rich biodiversity heritage and modern world amusement park.
Wadwal Nagnath in Chakur is known for its famous bio diversity hill. It is 600- 700 feet tall hill and derives its name from the village Wadwal-Nagnath where it is located. The hill is also known as Sanjeevini Bet. The famous biodiversity hill is located at a distance of 16.5 kms from Chakur and is at a distance of 39 kms from Latur.
The hill is very famous for its unique feature of producing a very rare species of Ayurvedic plant. These kinds of plants are rare and they grow only in specific Uttara Nakshatra. It attracts many well-known Ayurvedic practitioners from all over the world, especially during the time of Uttara Nakshatra in the months of July and September. It becomes a sort of medicinal fare during those times of the year. A Yatra is held annually; when thousands of pilgrims from various far ways districts as well as nearby places visit the Sanjeevini Bet.
During this time the Government holds Vaidya Samelan for local practitioners and tourist scientists visiting the village. The Vrindawan Amusement and Water Park located about 1 km from Chakur is a great place for fun seekers of all age. Spread over 120 acres of scenic land, the park is the combination of natural and man-made fantasy land. It is definitely the biggest Amusement and Water Park in Maharashtra. The water park is packed with new features like Rain dance, Pendulum, Multi-lane white slide, Run-away raft slide, Red dragon slide, Cyclone and Amusement park Bumper car, Boating , Mini Toy Train, Children park, coin games, Battery Cars etc.
The first and the biggest wet park in the region has four landing pools, one activity pool and 8 water slides of different shapes and sizes even including a few small ones for the children. Within the amusement park there is a very good resort which provides a great place to relax after having a great fun time. It is located on the Latur – Nanded Highway. Within the amusement and water park there are food corners for food lovers as well. Children simply love the place as it offers everything at the same place and a lot of rides for them to enjoy.
The Sai Nandavanam is a temple dedicated to the lord Shiva. It is surrounded by mango plantations all around and you will definitely consider it one of the most beautiful places in India to develop architecture. It is designed in the shape of Shiva Linga on top of a hillock.
It is a complete package of spirituality and entertainment. The temple and its surrounding premises allow people of all ages to flock together and have the time of their lives. The Sai Nandavanam is still under development and is proposed to become a major tourist attraction of Maharashtra. It will definitely bring out the city of Chakur more in the limelight.
Chakur has become a shining jewel in Latur, Maharashtra's kitty. It attracts international scientists who want to study rare herbs at Sanjeevini Bet while the Sai Nandavanam attracts tourist from all the places to have wonderful time in the serene environment of the temple. Also, there is hardly anyone who does not love to dance in the rain!! For them, the Vrindawan Amusement and Water Park is a spot they must not miss at any cost.


A tea party is probably the most convenient and elegant way to tackle afternoon events. You can use it for anything from an anniversary, baby shower, birthday party, social gathering, and pre-wedding event. Traditionally, afternoon parties are perceived to be quite formal, but that doesn't have to be the case nowadays. You can work with a catering service to make sure that you get the most fun and interesting tea party, no matter the event.
To make a proper tea party, there are a lot of things you need to consider. For example, you need to think about the type of foods you're going to present with the tea. Do you want to go for the traditional English scones with jelly, or do you want it to have a unique twist with delicate tapas dishes instead? What about the dress codes? How do you make sure that everybody is dressed appropriately to your theme?
If you're concerned with these issues, then you're in luck. We have compiled a comprehensive guide on how to hold an afternoon tea event below. You can discuss these steps in details with your catering service to ensure the most memorable tea party ever!
To start off, you need to think about the theme of the event. Think about the formality and the theme of the event and arrange your invitations accordingly. Each style of invitation has a different level of formality. For example, an email invitation is usually perceived to be more casual and homely, while a serious calligraphed invitation is obviously more serious and formal. You can also include a dress code in the invitation to ensure that every attendee gets the memo as well.
Afternoon tea parties and finger foods are inseparable. Traditional English afternoon tea catering usually consists of sweet pastries like scones, cakes, bread, and fruits. If you're looking for a more international event, you can offer tapas dishes, cold cut plates, cheeses, and sandwiches to tie your guests over. You need to make sure that it's consistent with your theme, as you'd want your party to be coherent to ensure that the event is classy and graceful.
Moving on from the food to the arrangements. First, you need to think about the venue. Is it indoor or outdoor? Will there be a speech podium of some sort? How can you arrange the tables so that everybody has easy access to the food? How is the table going to be decorated? We also suggest that you have a themed food table as well. For example, an English tea table should be where the scones and English cakes are, and the oriental table is lined with green tea and Japanese sweets. Your guests are guaranteed to be satisfied this way.
As tradition dictates, the teacups and saucers are to be placed on the left of the teapot. If your afternoon tea event is a rather formal one, then you should keep these classic tea traditions in mind. Additionally, you should make sure that the tea is brewed ahead of time so that the guests can refill their pot easily. This will help the event to go smoother and ensure that all of your guests have enough tea to enjoy. Also, make sure that you provide each table with a way to discard their teabags and spoons so that they don't pile up on the plates, making it looks messy and dirty.
As for the decorations, we suggest you talk to a florist. You can tell them the event's theme, budget, and preferred colours. This will help to keep the decorations that fit with the rest of the party.
We understand that all of this can be overwhelming to think about, which is why you might need professional help. A high-tea catering specialist can help you to come up with an appropriate theme for your event. What's more is that you can be a part of every process and this will ensure that the party has your characteristics in it. So, if you're looking to come up with an idea for an afternoon tea party, give Elegant Touch a call today.


SQL 2019 is on track to become one of the most awesome releases – the product touches so many realms of the data platform, it's truly mind boggling.
Since I have such a keen interest in Hekaton/In-Memory OLTP, when the CTPs are released for a new version of SQL Server, I look forward to any potential announcements about that feature.
So far, there's been only one publicly announced enhancement for In-Memory OLTP in SQL 2019: system tables in TempDB will be "Hekatonized". This will forever solve the issue of system table contention in TempDB, which is a fantastic use of Hekaton. I'm told it will be "opt in", so you can use this enhancement if you want to, but you can also back out of it, which would require a restart of the SQL Server service.
But there's at least one other enhancement that's not been announced, although the details of its implementation are not yet known.
When you start to research the Hekaton feature, most are shocked to learn that CHECKDB does not verify anything about durable In-Memory tables: it silently ignores them.
That appears to have changed in SQL 2019, although either the informational message about what it does is misleading, or behind the scenes it does something different.
supported with memory optimized tables. This object has been skipped and will not be processed.
There are 101 rows in 3 pages for object "inmem_table".
Why do I say the message is misleading?
Because durable data for memory-optimized tables is not stored in pages, but instead in a streaming fashion in files known as checkpoint file pairs (or data and delta files). Also, while it's true that there are 101 rows in this table, the engine pre-creates a number of data and delta files, and it would make DBAs sleep a lot better at night, if all of those files were verified as being corruption free.
We'll just have to stay tuned to the future CTPs and RTM of SQL 2019 to see how all of this shakes out.
This entry was posted in Corruption, DBA, In-Memory OLTP, SQL Server, SQL2019 on November 19, 2018 by Ned Otter.
I recently saw a thread on twitter, where the OP talked about setting the max size for an In-Memory OLTP container. I responded as I always do: it's not possible to set a limit on anything having to do with storage for In-Memory OLTP.
Unfortunately, that's not correct: through SSMS or TSQL, you can in fact set a max size for a container.
But you should not ever do that…..
The log for database 'InMemTest' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Cannot continue the execution because the session is in the kill state.
Note that I've not yet found a way around this. The OP from that thread on twitter said he had to actually restart the SQL Server service to resolve the issue with that database, but I don't see why that would make any difference (when I tried it, the database attempted recovery, but eventually went offline).
Setting a max size for the container is a really, really really bad idea, because it guarantees that the database will have some form of outage when you hit the threshold. The bottom line is that containers must be free to grow, period. That's part of the capacity planning good DBAs will do before deploying the In-Memory OLTP feature.
This entry was posted in DBA, In-Memory OLTP, SQL Server, SQL2017 on July 19, 2018 by Ned Otter.
In-Memory OLTP has been included in the last three releases of SQL Server, starting with 2014 through 2017, and now runs on Linux, Windows, Azure SQL Database, and Azure Managed Instances. Additionally, since SQL 2016/SP1, the In-Memory OLTP feature has been available in non-enterprise editions.
It most likely means that it's only a matter of time before a memory-optimized database lands on your doorstep, and you'll probably have no idea how or why it's different.
For a while now, I've been working on a script to evaluate a SQL Server environment for anything related to In-Memory OLTP, and I had help with testing, general suggestions, and final touches from Konstantin Taranov and Aleksey Nagorskiy; their assistance was invaluable. Konstantin suggested to Erik Darling and Brent Ozar that my script be included as part of their great Blitz series, and the the result is…..sp_BlitzInMemoryOLTP.
It is now part of the awesomeness known as the First Responder Kit, and the direct link to the script can be found here.
sp_BlitzInMemoryOLTP reports on two categories: instance level and database level.
First let's discuss which parameters it sp_BlitzInMemoryOLTP accepts, and then we'll break out the results, section by section.
This flag determines whether or not to simply report on the server-level environment (if applicable, i.e. there is no server-level environment for Azure SQL Database). With this parameter, memory-optimized databases are ignored. If you specify @instanceLevelOnly and a database name, the database name is ignored.
If you don't specify a database name, then sp_BlitzInMemoryOLTP reports on all memory-optimized databases within the instance that it executes in, or in the case of Azure SQL Database, the database that you provisioned. This is because the default for the @dbName parameter is N'ALL'.
It's also possible to report on a specific database name.
The results of calling sp_BlitzInMemoryOLTP this way are explained later in this post.
If you only want to report on a specific memory-optimized table, you would supply a value for the @tableName parameter, and sp_BlitzInMemoryOLTP will search through all memory-optimized databases, looking for memory-optimized user tables that match. There is currently no wildcard matching for the @tableName parameter.
Using the @debug =1 parameter tells sp_BlitzInMemoryOLTP to only print the TSQL statements that would have been executed. This allows you (or more likely, me) to resolve problems like missing quotes, or other potential issues that can occur when using dynamic SQL.
In the comments, please let me know other things about memory-optimized environments and/or databases you'd like to see included in the script.
When you execute sp_BlitzInMemoryOLTP, it runs several queries that pertain to the In-Memory OLTP environment. It should be noted that if there are no results for a given query, i.e. no temporal memory-optimized tables, sp_BlitzInMemoryOLTP does not return an empty result set (this keeps the clutter to a minimum).
For example, it could be that a memory-optimized filegroup has been added to a database, but no memory-optimized objects have been created. Depending on the version of SQL Server, there might not be details about the containers or files within them, so sp_BlitzInMemoryOLTP won't return information on that.
● Section 6: the value of the committed_target_kb column from sys.dm_os_sys_info. The amount of memory that SQL Server can use for the In-Memory OLTP feature is a percentage of the committed_target_kb value. But be forewarned, this value is not static. Details in my post here.
● Section 7: whether or not instance-level collection of execution statistics has been enabled for all natively compiled stored procedures. Enabling this on a production server could be considered drastic. More details can be found in my post here.
● Section 8: if running Enterprise, if there are any resource groups defined, and which memory-optimized databases are bound to them. Binding memory-optimized database to a Resource Pool (using Resource Governor) is considered a best practice, but unfortunately this capability is still Enterprise only. But if you're on that edition, you should also be monitoring how close to the out of memory threshold you're getting, and fire an alert when required. More details in my post here.
database layout, which includes mdf, ldf, ndf, and containers, and the size in various formats (KB/MB/GB). The totalSizeMB column is the total for the entire database (uses a Window Function).
The output in the photos that follow was returned from executing sp_BlitzInMemoryOLTP, for a database named OOM-DB. You can get information on all memory-optimized databases if you don't supply a database name when calling sp_BlitzInMemoryOLTP.
● Section 3: indexes on memory-optimized tables. It's helpful to know how many, and what type of indexes there are.
● Section 4: average chain length for HASH indexes (if any). When a HASH index is created for a memory-optimized table, a value must be supplied for what's known as the "bucket count". But it doesn't get adjusted automatically, and as a result, it can cause performance problems. More details here.
● Section 5: Number of indexes per memory-optimized table. SQL 2014 and SQL 2016 have a limit of 8 nonclustered (RANGE) indexes per memory-optimized table. That ceiling was lifted in SQL 2017, and I've tested creating several hundred indexes on a single memory-optimized table (but please don't do that in production!).
● Section 9: if using the temporal feature for memory-optimized tables, the amount of memory consumed by hidden temporal internal tables (which are memory-optimized). For temporal tables, there's a difference between how things are handled if the temporal table is memory-optimized. I've written about that in this post.
● Section 10: memory structures for LOB columns (off-row). For memory-optimized tables, LOB columns are actually stored as separate tables, and this can lead to performance problems. MCM Dimitri Korotkovitch has a great post on it here.
● Section 11: memory-optimized table types. Yes, tables and table types can be memory-optimized, and you'll want to be aware of the potential gotchas with those memory-optimized types, as detailed in my post.
● Section 12: all database files, including the name, size, and location for each container.
Sections 13 through 15 pertain to the amount of storage consumed by durable memory-optimized tables. The files that persist durable data to storage go through several state changes over time. As a result, the storage footprint for memory-optimized databases that contain durable data can be surprisingly large, relative to the amount of data that's stored in memory (Microsoft suggest 4x memory-optimized data size as a starting point). So it's a good idea to keep an eye on the storage footprint.
Here, the breakdown is a bit different, taking into account the type of file.
For each type of file, i.e. DATA or DELTA, aggregated the storage consumed and number of files for each file type, PER CONTAINER.
In the prior example, we saw that there were a total of 11 files of fileType DATA with a fileState of ACTIVE, across all containers for this memory-optimized databases.
This result shows the breakdown of each fileType and fileState PER CONTAINER. The container named InMemDB_inmem1 has 3 files that have a fileType of DATA and a fileState of ACTIVE. So we expect to see 8 more files with this type and state, in the remaining containers. Sure enough, we see that the container named InMemDB_inmem2 has an additional 8 files with a fileType of DATA and a fileState of ACTIVE.
Understanding how In-Memory OLTP works (with all of its various gotchas) can only be addressed by putting in the required time. If you read the documentation, and then study the real-world deployment concepts detailed in my extensive blog post series on In-Memory OLTP, you'll be on the right path. Once you begin to wrap your brain around In-Memory OLTP, you'll need some help evaluating memory-optimized environments and/or databases, and that's where sp_BlitzInMemoryOLTP can help.
This entry was posted in DBA, In-Memory OLTP, sp_BlitzInMemoryOLTP, SQL Server on June 1, 2018 by Ned Otter.
This post will cover memory requirements and usage, and what happens if you run actually reach OOM, also known as "Out Of Memory", a condition that strikes fear in the hearts of DBAs supporting memory-optimized databases. We'll also cover CPU-bound conditions.
At a high level, the memory that's allocated to the In-Memory OLTP engine comes from the SQL Server 'max memory' setting, as does everything else within SQL Server. But beneath that level, we need to be aware of memory pools.
if you are running Enterprise Edition, you can use Resource Governor to configure a Resource Pool. Memory-optimized databases can be bound to separate pools, or multiple databases can be bound to a single pool. If you don't bind a memory-optimized database to a pool created with Resource Governor, then all memory allocations for In-Memory OLTP for that database comes from the Default pool.
if you are NOT running Enterprise Edition, all memory for In-Memory OLTP is allocated from the Default pool.
If using the Default pool, then as a result of deploying the In-Memory OLTP feature, there can be performance issues with on-disk workloads.
The following image shows that as we add rows to memory-optimized tables – and put pressure on the buffer pool – the buffer pool responds by shrinking, and that can affect disk-based workloads. If we then delete rows from memory-optimized tables, the buffer pool can expand. But what if we don't delete rows from memory-optimized tables? Then the buffer pool will stay in its reduced state (or shrink even more), and that can cause problems due to buffer churn (continually having to do physical I/Os to retrieve pages from storage, for disk-based workloads).
Astute readers will consider using Buffer Pool Extensions (BPE), which is available in Standard Edition only. Yes, you could do that, but BPE retrieves a single 8K page at a time, and can actually make performance worse. And in case you're wondering, no, it's not possible to compress memory-optimized data that's stored in memory. Think Windows will actually page out any of the memory allocated to In-Memory OLTP? That's simply not possible.
If you are running Enterprise Edition, then this problem gets solved by creating a resource pool. Now, to be clear, that doesn't mean you can't run out of memory for memory-optimized objects. It only means that your In-Memory workload can't affect the on-disk workload, unless of course you configure the resource pool incorrectly. I've got a blog post on how to monitor resource pools here.
Let's create a resource pool, with an artificially low upper bound, and insert rows until we hit the limit.
The only thing that can prevent GC from working is a long running transaction.
We are supposed to base our belief of how much memory is available for our memory-optimized databases, upon committed_target_kb from the sys.dm_os_sys_info DMV. Memory available for In-Memory OLTP is expressed as a percentage of committed_target_kb, based on total system memory, which is detailed here. Prior to SQL 2016/SP1, the In-Memory OLTP feature was only supported on Enterprise Edition, and the amount of memory allocated to SQL Server was limited to what the operating system supported.
But in a post-SQL 2016/SP1 world, things are different, because the In-Memory OLTP feature is now supported on non-enterprise editions. This means that people will start deploying In-Memory OLTP on servers with a lot less memory than is possible with Enterprise, and therein lies a potential issue.
The problem is that committed_target_kb is a moving target.
Applies to: SQL Server 2012 through SQL Server 2017.
If committed_target_kb is larger than committed_kb, the memory manager will try to obtain additional memory. If committed_target_kb is smaller than committed_kb, the memory manager will try to shrink the amount of memory committed. The committed_target_kb always includes stolen and reserved memory.
Those parts about "the current state of the system including its load" and "the memory requested by current processes" concern me. If there is x amount of memory available on a server, and you check the value of committed_target_kb when the server is "at rest", then under load there might in fact be much less memory available. I believe this is one of the main causes of OOM for memory-optimized workloads, especially when people do a POC on under-provisioned machines (like laptops).
The process of recovering a database is different for databases with durable memory-optimized data.
Step 1: the backup file is read, and the various types of of files are created. For example, all MD/NDF/LDF and data and delta files are created.
It should be noted that if the backup contains both on-disk and memory-optimized tables, none of the on-disk data is available until all of the memory-optimized data has finished streaming. When restoring a backup – whether the database has memory-optimized data or not – the process short-circuits if there isn't enough free space to create the files in Step 1. Unfortunately, no such validation of available memory is done for Step 3. That means you can spend a long time creating files on disk, then spend an additional lengthy amount of time streaming data to memory, only to find that you don't have enough memory. If you think Microsoft should change this, please upvote my Connect item.
When data is streamed into memory, the wait type will be WAIT_XTP_RECOVERY.
Also, setting Read Committed Snapshot Isolation ON or OFF, will cause restreaming.
Additionally, the speed of restreaming is directly influenced by the number of volumes that you have created containers on, and the IOPS available from those volumes.
Open a DAC (Dedicated Admin Connection). Then delete rows, and/or move data from memory to disk.
If you attempt to move data from memory-optimized tables to disk-based tables, i.e. using SELECT INTO, please note that it's possible to create schema for memory-optimized tables that you can't simply migrate to disk.
So how does hitting OOM affect workloads for memory-optimized databases?
SELECT still works, and also DELETE and DROP, but of course INSERT and UPDATE will fail.
The first item in this list, "many indexes on large memory-optimized tables (2014, 2016)" has supposedly been addressed in SQL 2017.
LOB columns are actually stored as separate memory-optimized tables, and as noted by Dmitri Korotkevitch (blog) in this post, can impact performance.
The "incorrect bucket size for HASH indexes" issue persists to this day. If the bucket count is too low, there will be many sets of key columns that hash to the same value, increasing the chain length, and having not only a terrible effect on performance in general, but database recovery in particular.
These are rough guides, but should be observed at first, and then tuned as required.
This concludes the series on resources issues for In-Memory OLTP.
This entry was posted in In-Memory OLTP, Memory, SQL Server, SQL2017, Storage on January 16, 2018 by Ned Otter.
This is a continuation of Part 1 and Part 2 of this blog post series, related to resource issues/requirements for memory-optimized databases.
In this post, we'll continue with simulating what happens to a memory-optimized database when all volumes run out of free space.
After installing the Windows feature we can set the quota for the folder, but we shouldn't enable it just yet, because first we have to verify the current size of the folder.
On my server, I created a quota of 1.5GB, and then enabled it.
Now let's INSERT rows into the table, in batches of 1000, until we reach the limit (the INSERT script is listed in Part 2, I'm trying to keep this post from getting too long).
Once the quota has been reached, we receive the dreaded 41822 error – this is what you'll see when all of the volumes where your containers reside run out of free space (if even one of the volumes has free space, your workload can still execute).
Just out of curiosity, we'll verify how many rows actually got inserted. On my server, I've got 4,639 rows in that table, and the folder consumes 1.44GB. So theoretically, there was enough space on the drive to create more checkpoint files, but it seems as though the engine won't just create what it can to fit in the available space. It's more likely that the engine attempts to precreate a set of files, and it either succeeds or fails all at once, but I've not confirmed that.
A file that has the fileType of MERGE TARGET is the new set of combined data/delta files from the File Merge process. Once the merge has completed, the MERGE TARGET transitions to ACTIVE, and as we stated earlier in this series, ACTIVE files can no longer be populated.
But what about the source files that the MERGE TARGET is derived from? After a CHECKPOINT, these files transition to WAITING FOR LOG TRUNCATION, and can be removed. It should be noted that it can take several checkpoints and transaction log backups for CFPs to transition to a state where they can actually be removed. That's why Microsoft recommends 4x durable memory-optimized data size for the initial storage footprint.
In the images that follow, we can see that the formerly distinct transaction ranges of 101 to 200, and 201 to 300, have been combined into a single CFP, which has the range of 101 to 300.
File Merge – and the requisite file state changes that CFPs must go through – explain why backups for memory-optimized databases can be considerably larger than the amount of data stored in memory. Until CFPs go through the required state changes, they must be included in backups.
The File Merge process requires both storage and IOPS, as it reads from both sets of CFPs, and writes to a new set. Let's say your workload requires 500 IOPS to perform well. We've just added another 1,000 IOPS as a requirement for your workload to maintain the same level of performance: 500 IOPS each for the read and write components of File Merge. That's why Microsoft recommends 3x workload IOPS for your memory-optimized storage.
What happens to your memory-optimized database when all volumes run out of free space?
In my testing of inserts that breached the quota for the folder, I saw no affect on database status. However, if I created the database, set the quota to a much lower value, and then created a memory-optimized table, the database status became SUSPECT. In a real-world situation, with hundreds of gigabytes or more of memory-optimized data, the last thing you want to do is a database restore in order to return your database to a usable state.
I was able to set the database OFFLINE, and then ONLINE, and that cleared the SUSPECT status. But keep in mind, that setting the database OFFLINE/ONLINE will restream all your data, so there will be a delay in database recovery due to that.
What can you do if your volumes run out of free space?
Well, in SQL 2014, your database went into "SUSPENDED" mode (not suspect), and it was offline, until perhaps you added more space and restarted the database (not sure, I didn't test that). In SQL 2016+, the database goes into what's known as "delete-only mode", where you can still SELECT data, but modifying data is limited to deleting rows and/or dropping indexes/tables. Of course, SELECT, DELETE, and DROP to nothing to solve your problem: you need more free space.
But keep in mind that if there was no additional free space on the volumes to precreate CFPs, then it's not likely that there will be enough free space to write a new set of CFPs for DBA-initiated File Merge.
The only thing you can do to remedy this situation is to either free up some space on the existing volumes, or create a new container on a new volume that has free space.
In Part 4, we'll discuss memory in the same ways we've discussed storage – how it's allocated, and what happens to your memory-optimized workload when you run out of it.
This entry was posted in DBA, In-Memory OLTP, Memory, SQL Server, Storage, Uncategorized on January 1, 2018 by Ned Otter.
Entire database in memory: Fact or fiction?
Advances in hardware and software have converged to allow storing your entire database in memory (depending on how large it is), even if you don't use Microsoft's In-Memory OLTP feature.
HP Gen9 servers support NVDIMM-N (known as Persistent Memory), which at that time had a maximum size of 8GB, and with 16 slots, offered a total server capacity of 128GB. Hardly large enough to run today's mega-sized databases, and also there was no way to actually store your database there. So the use case for SQL Server 2016 was to store log blocks for transaction logs there. This could be beneficial in general, but particularly when using durable memory-optimized tables. That's because WRITELOG waits for the transaction log could be a scalability bottleneck, which reduced the benefit of migrating to In-Memory OLTP.
There were other potential issues when using Persistent Memory, detailed in this blog post. But what's not covered in that post is the fact that deploying NVIDMM-N reduced the memory speed and/or capacity, because they are not compatible with LRDIMM. This causes you to use RDIMM, which reduces capacity, and because NVDIMM-N operates at a slower speed than RDIMM, it also affects total memory speed.
HP has since released Gen10 servers, and they have changed the landscape for those seeking reduced latency by storing larger data sets in memory. For one thing, they raise the bar for what's now referred to as Scalable Persistent Memory, with a total server capacity of 1TB. To be clear, NVDIMM-N is not used in this configuration. Instead, regular DIMMs are used, and they are persisted to flash via a power source (this was also the case for NVDIMM-N, but both the flash, DIMM, and power source were located on the NVDIMM-N).
In this video, Bob Ward demonstrates ~5x performance increase for the industry's first "disklesss" database, using a HPE Gen10 server, SUSE Linux, Scalable Persistent Memory, and columnstore (presumably on a "traditional/formerly on-disk table", not a memory-optimized table, although that's not specifically detailed in the video).
Brett Gibbs, Persistent Memory Category Manager for HP servers, states in this video that even databases that use In-Memory OLTP can benefit from Scalable Persistent Memory, because the time required to restart the database can be significantly reduced. He stated that a 200GB memory-optimized database that took 20 minutes to restart on SAS drives, took 45 seconds using Persistent Scalable Memory. However, no details are provided about the circumstances under which those results are obtained.
We are left to guess about the number of containers used, and the IOPS available from storage. It may be that in both cases, they tested using a single container, which would be a worst practice. And if that's correct, to reduce database restart time all you had to do was spread the containers across more volumes, to "parallelize" the streaming from storage to memory.
I'm assuming that the 45 seconds specified represents the amount of time required to get durable memory-optimized data from flash storage back into memory. If that's correct, then the reduction of time required to restart the database has nothing to do with the Scalable Persistent Memory (other than memory speed), and everything to do with how fast flash storage can read data.
The HP video also details how there might be a licensing benefit. It's stated that if your workload requires 32 cores to perform well, and you reduce latency through the use of Scalable Persistent Memory, then you might be able to handle the same workload with less cores. I'd love to see independent test results of this.
If you are considering placing a database entirely in memory, and don't want to be tied to a specific hardware vendor's solution, In-Memory OLTP might be an option to consider.
Maintaining referential integrity – Microsoft recommends keeping cold data in on-disk tables, and hot data in memory-optimized tables. But there's just one problem with that: FOREIGN KEY constraints are not supported between on-disk and memory-optimized tables. Migrating all data to memory-optimized tables solves this specific issue.
Native compilation – if you want to use native compilation, it can only be used against memory-optimized tables. If you can deal with the potential TSQL surface area restrictions, migrating all data to memory-optimized tables might allow greater use of native compilation.
Single table structure – if you were to keep cold data on disk, and hot data in-memory, you would need to use two different table names, and perhaps reference them through a view. Migrating all data to memory-optimized tables solves this problem.
Unsupported isolation levels for cross-container transactions – it's possible to reference both on-disk and memory-optimized tables in a single query, but memory-optimized tables only support a subset of the isolations that are available for on-disk tables, and some combinations are not supported (SNAPSHOT, for example).
Near-zero index maintenance – other than potentially reconfiguring the bucket count for HASH indexes, HASH and RANGE indexes don't require any type of index maintenance. FILLFACTOR and fragmentation don't exist for any of the indexes that are supported for memory-optimized tables.
Very large memory-optimized database size – Windows Server 2016 supports 24TB of memory, and most of that could be assigned to In-Memory OLTP, if you are using Enterprise Edition. This is way beyond the capacity supported by the current line of HP servers using Scalable Persistent Memory.
One extremely crucial point to make is that if you decide to migrate an entire database to In-Memory OLTP, then database recovery time must be rigorously tested. You will need to have enough containers spread across enough volumes to meet your RTO SLA.
This entry was posted in DBA, In-Memory OLTP, Memory, SQL Server on December 10, 2017 by Ned Otter.
This multi-part blog post will cover various resource conditions that can affect memory-optimized workloads. We'll first lay the foundation for what types of resources are required for In-Memory OLTP, and why.
Let's take storage first – why would a memory-optimized database require storage, what is it used for, and how much storage is required?
You'll need more storage than you might expect, to hold the files that persist your durable memory-optimized data, and backups.
No one can exactly answer that question, as we'll explain over the next few blog posts. However, Microsoft's recommendation is that you have 4x durable memory-optimized data size as a starting point for storage capacity planning.
A memory-optimized database must have a special filegroup designated for memory-optimized data, known as a memory-optimized filegroup. This special filegroup is logically associated with one or more "containers". What the heck is a "container"? Well, it's just a fancy word for "folder", nothing more, nothing less. But what is actually stored in those fancy folders?
Containers hold files known as "checkpoint file pairs", which are also known as "data and delta files", and these files persist durable memory-optimized data (in this blog post series, I'll use the terms CFP and data/delta files interchangeably). You'll note on the following image that it clearly states in bold red letters, "NO MAXSIZE" and "STREAMING". "NO MAXSIZE" means that you can't specify how large these files will grow, nor can you specify how large the container that houses them can grow (unless you set a quota, but you should NOT do that). And there's also no way at the database level to control the size of anything having to do with In-Memory OLTP storage – you simply must have enough available free space for the data and delta files to grow.
This is the first potential resource issue for In-Memory OLTP: certain types of data modifications are no longer allowed if the volume your container resides upon runs out of free space. I'll cover workload recovery from resource depletion in a future blog post.
"STREAMING" means that the data stored within these files is different than what's stored in MDF/LDF/NDF files. Data files for disk-based tables store data rows on 8K pages, a group of which is known as an extent. Data for durable memory-optimized tables is not stored on pages or extents. Instead, memory-optimized data is written in a sequential, streaming fashion, like the FILESTREAM feature (it should be noted that you do not have to enable the FILESTREAM feature in order to use In-Memory OLTP, and that statement has been true since In-Memory OLTP was first released in SQL 2014).
How do these data/delta files get populated? All that is durable in SQL Server is written to the transaction log, and memory-optimized tables are no exception. After first being written to the transaction log, a process known as "offline checkpoint" harvests changes related to memory-optimized tables, and persists those changes in the data/delta files. In SQL 2014, there was a single offline checkpoint thread, but as of SQL 2016, there are multiple offline checkpoint threads.
OOM_DB_inmem1 and OOM_DB_inmem2 are containers (folders), and they'll be used to hold checkpoint file pairs. You'll note in the DDL listed above, that under the memory-optimized filegroup, each container has both a name and filename entry. The name is the logical name of the container, while the filename is actually the container name, which represents the folder that gets created on disk. Initially there are no CPFs in the containers, but as soon as you create your first memory-optimized table, CFPs get created in both containers.
If we have a look in one of the containers, we can see files that have GUIDs as names, and are created with different sizes.
This is definitely not human-readable, but luckily, Microsoft has created a DMV to allow us to figure out what these files represent.
Below we can clearly see that there are different types of files, and that files can have different "states", which is central to the discussion of the storage footprint for memory-optimized databases, and backups of those databases. There are different values for container_id – remember we said that a memory-optimized database can have one or more containers. Next, we should pay attention to the fact that all entries for the "relative_file_path" column begin with "$HKv2\". This means that in each container, we have a folder with the name "$HKv2", and all data/delta files for that container are located there.
At this point, it's time for a discussion of the various file states. I'll stick to SQL 2016+ (because SQL 2014 had more file states).
We'll discuss the first three now, and save MERGE TARGET and WAITING FOR LOG TRUNCATION for later.
PRECREATED: as a performance optimization technique, the In-Memory engine will "precreate" files. These precreated files have nothing in them – they are completely empty, from a durable data perspective. A file in this state cannot yet be populated.
UNDER CONSTRUCTION: when the engine starts adding data to a file, the state of the file changes from PRECREATED to UNDER CONSTRUCTION. Data and delta files are shared by all durable memory-optimized tables, so it's entirely possible that the first entry is for TableA, the next entry for TableB, and so on. "UNDER CONSTRUCTION" could be interpreted as "able to be populated".
ACTIVE: When a file that was previously UNDER CONSTRUCTION gets closed, the state transitions to ACTIVE. That means it has entries in it, but is no longer able to be be populated. What causes a file to be closed? The CHECKPOINT process will close the checkpoint, changing all UNDER CONSTRUCTION files to ACTIVE.
That's the basic rundown of the file states we need to know about at this point.
In Part 2, we'll dive deeper into the impact of data/delta file states and the storage footprint for memory-optimized databases.
This entry was posted in DBA, In-Memory OLTP, Memory, Storage, Uncategorized on November 24, 2017 by Ned Otter.
This entry was posted in DBA, In-Memory OLTP, SQL Server on October 24, 2017 by Ned Otter.
The feature 'NONCLUSTERED COLUMNSTORE' is not supported with memory optimized tables.
It fails because we can only create a CLUSTERED columnstore index (CCI). For 25 years, Microsoft SQL Server differentiated between indexes that physically ordered data on storage (CLUSTERED) and those that did not (NONCLUSTERED). Unfortunately, they chose to ignore that pattern when creating the syntax for memory-optimized tables; using the word CLUSTERED is required when creating a columnstore index on memory-optimized tables.
Can we create a clustered columnstore index on a memory-optimized table that is defined as SCHEMA_ONLY?
Column store indexes are not allowed on tables for which the durability option SCHEMA_ONLY is specified.
Success! Let's attempt to create a NONCLUSTERED index….
The operation 'ALTER TABLE' is not supported with memory optimized tables that have a column store index.
Ooops – no can do. Once you add a clustered columnstore index to a memory-optimized table, the schema is totally locked down.
What about if we create the CCI and nonclustered index inline?
Awesome! We've proven that we can create both clustered columnstore and nonclustered indexes, but we must create them inline.
Operation not supported for memory optimized tables having columnstore index.
Hey, when I said that the schema is locked down once you add a clustered columnstore index, I mean it!
What type of index maintenance is possible for indexes on memory-optimized tables?
For HASH indexes there is only one possible type of index maintenance, and that's to modify/adjust the bucket count. There is zero index maintenance for RANGE/NONCLUSTERED indexes.
Let's create a memory-optimized table with a HASH index, and verify the syntax for rebuilding the bucket count.
How about trying to rebuild the bucket count if we created the memory-optimized table with inline CCI and HASH indexes?
You can't rebuild that index if you also have a columnstore index on the table. We would have to drop the columnstore index, reconfigure the bucket count for the HASH index, and then recreate the columnstore index. Both the drop and the create of the columnstore index will be fully logged, and executed serially. Not a huge problem if the amount of data is not too large, but it's a potentially much larger problem if you've got a lot of data.
Can we create a columnstore index on a memory-optimized table variable?
-- fails--Msg 102, Level 15, State 1--Incorrect syntax near '@Table1'.
Msg 35343, Level 16, State 1, Line 22 The statement failed. Column 'Notes' has a data type that cannot participate in a columnstore index. Omit column 'Notes'.
Msg 1750, Level 16, State 1, Line 22 Could not create constraint or index. See previous errors.
For memory-optimized tables, LOB columns prevent creation of a clustered columnstore index.
Msg 41833, Level 16, State 1, Line 29 Columnstore index 'CCI_InMemLOB' cannot be created, because table 'InMemLOB' has columns stored off-row.
Columnstore indexes can only be created on memory-optimized table if the columns fit within the 8060 byte limit for in-row data.
Reduce the size of the columns to fit within 8060 bytes.
ENABLE "Actual Plan" and SELECT – which index is used?
Now highlight the EXEC statement, and click "Estimated Plan" – which index is used?
The SELECT statement uses the columnstore index, but the natively compiled procedure does not (that's because natively compiled procedures ignore columnstore indexes).
In this post, we've covered some of the finer points of indexing memory-optimized tables. Never know when they might come in handy….
This entry was posted in columnstore, DBA, In-Memory OLTP, Indexing, SQL Server on October 18, 2017 by Ned Otter.
This blog post demonstrates various approaches when using native compilation to insert rows into parent/child tables.
First, let's create tables named Parent and Child, and relate them with a FOREIGN KEY constraint. Note that the Parent table uses the IDENTITY property for the PRIMARY KEY column.
Next, we attempt to create a natively compiled procedure that performs an INSERT to the Parent table, and tries to reference the key value we just inserted, with @@IDENTITY.
This works, but there are other approaches to solving this problem.
Next, we'll try to DECLARE a table variable, and OUTPUT the new key value.
Inline table variables are not supported with natively compiled modules.
But again we have issues with unsupported T-SQL.
Now we'll try creating a memory-optimized table variable outside the native procedure, and then declare a variable of that type inside the native procedure.
This compiles, so now let's test it.
This works great, but for completeness, we should test other possibilities.
This time, we'll recreate the tables, but we'll leave off the IDENTITY property for the Parent table. Instead of IDENTITY, we'll create a SEQUENCE, and attempt to generate the next value within the native module.
ParentID INT PRIMARY KEY NONCLUSTERED – no IDENTITY property used here!
The operator 'NEXT VALUE FOR' is not supported with natively compiled modules.
But this fails, because as the error states, we can't use NEXT VALUE FOR within native modules.
How about if we generate the next value for the sequence outside the module, and pass that value?
This also works, so we'll add it to our arsenal. But there's one weird thing – the value that was inserted into the Parent table is –2147483647, which is probably not what we intended. So we'll have to tidy up our SEQUENCE a bit.
In this post, we have verified three different ways to successfully insert into parent/child records, when using native compilation.
This entry was posted in DBA, In-Memory OLTP, Native compilation on September 11, 2017 by Ned Otter.


Our diving safaris in the Philippines, for one day or more.
All Scotty's Dive Centers organize many diving safaris on a regular basis, so you can schedule your dive safaris with us!
Depending on your location in the Philippines, you will use our luxury bangka boat (Scotty's 2), the Rainbow Runner, or any of your preferred boat from our fleet.
There are many diving places around us.
Some of these diving sites are far that we usually send a boat for the whole day with 2 or 3 dives on the site. These day safaris are very popular at Scotty's because you will dive where no other divers have been. Plus the diving sites have a stunning underwater biodiversity!
Check out below the different destinations of our diving safaris, and in all cases do not hesitate to contact us.
Our scuba diving safaris from Boracay.
For one day or more, we have some scuba diving safaris near and around Boracay.
Depending on the distance from Boracay, we might ask for a minimum of scuba divers participation for the safari. If you are alone, we can help you to find scuba divers who would like to join the safari.
Diving at the Hinugtan dive place is a full day dive safari by boat with three dives at Hinugtan. Dive into the vivacious underwater scenery along a wall full of sea fans and gorgonians, a forest of corals, and many different kinds of schools of fish. You can dive 2 to 3 times for a day trip or just one time for a half day journey.
The Maniguin island is 1 hour away at an average of 25 knots (47-48 km/h) by our speed boat from Boracay. With a local bangka boat, it can take more than 4 hours. This is a day dive safari, so prepare yourself to be astonished first by the underwater visibility which is more than 30 meters (100 feet). Secondly, by the unusually rich biodiverse animals like the big napoleon fish (AKA Humphead wrasse), manta rays and other kinds of rays, schools of barracudas, trevally fish, school of jacks and so on.
Dive safari at Laurel island.
Dive safari at Sibay Island.
The Sibay Dive Safari is a full day safari with three dives at the different diving sites of Sibay Island. Sibay Island is located at 43 kilometers (23 nautical miles) from our dive center in Boracay, which take less than 2 hours with our speed boat to go to the different dive sites of Sibay. Prepare yourself to encounter sharks, manta rays, schools of barracudas and much more.
Our scuba diving safaris from Bohol and Panglao.
Around Bohol and Panglao Islands, there are some diving places where it can take a while by boat to go to. This is why we have some dive safaris for a full day diving.
These scuba diving safaris usually include at least two dives in these diving places, although three scuba dives is often on the different dive spots.
Dive safari at Pamilacan Island.
Pamilacan Island is located at 17 kilometers (9 nautical miles) from our dive center in Bohol, Panglao. The dive safaris of Pamilacan is known for whale and dolphin watching between March and June (the sedentary dolphins can be watched all throughout the year though). The seabed of Pamilacan is covered by sea fans, huge gorgonians and many different species of colorful corals. Pamilacan is a day dive safari.
The Cervera shoal dive safari.
Off the shore of Panglao Island, the Cervera Shoal diving site is known as the Snake's Island because there are many white and black banded sea snakes on the south part of the diving site. The current can be powerful to "brutal" on the surface, this is why the Cervera Shoal is well-known to the experienced drift divers. We usually combine the dive safari with Pamilacan Island.
Dive safari at Cabilao island.
Cabilao island is known as the best diving place, with its different dive sites, between Bohol and Cebu. Cabilao is a haven for underwater photographers, and we can't even speak enough about the great opportunities for macro photography. Cabilao is home to the famous pygmy seahorse and the most beautiful species of nudibranchs in the Philippines. Diving at Cabilao Island will take the full day as a dive safari.
Balicasag Island is a marine sanctuary where you can dive with sea turtles. It's usually a day trip dive safari with 2 or 3 dives at Balicasag. There are many diving sites around Balicasag Island, but the most popular dives are for the turtles, which are quite shallow on the plateau at around 10 meters (33 feet) eating seaweeds and algae around 3 o'clock.
Our scuba diving safaris from Mactan and Cebu.
Mactan and Cebu are located right in the middle of the coral's triangle, which means that there are a lot of dive safaris to do nearby.
From one full day to 2 to 3 days, you can do a lot of diving safaris around Cebu and Mactan.
Hilutungan Island is in the Hilutungan channel and from our Scotty's Dive Center in Mactan, it's a day dive safari which can also be, depending your needs, a half day safari. The Hilutungan dive site is a marine sanctuary and a well-known diving spot for the local divers.
More about Hilutungan dive safari.
Dive into one of the best diving spots in Mactan and Cebu. Nalusuan Island offers wealthy and healthy marine life and a wide diversity of fishes. The Nalusuan destination is a day dive safari with 2 to 3 dives around Nalusuan Island. This dive safari can be combined with a stop to dive at the Hilutugan Island marine sanctuary.
More about Nalusuan dive safari.
Hilutungan and Nalusuan dive safari.
Hilutungan and Nalusuan dive safari can be done for half a day or a full day dive safari as they are on the same way. These two magical islands are also known for island hopping and tours and are surrounded by a marine sanctuary. The marine sanctuary is for all divers, from the beginner to the more experienced divers.
Known for its famous sardine run, Moalboal has many marine sanctuaries that stretch out within the area. It can take less than 3 hours from our Scotty's Dive Center in Mactan to go to Moalboal. Moalboal might have one of the biggest marine biodiversity on the Cebu Island because Moalboal is located in the southwest of Cebu facing Negros Island.
San Juan wreck, Liloan, Cebu.
Explore the sunken MV San Juan ferry of Liloan wreck as this real life immersed "Ro-Ro" is one of the best wrecks for technical divers, but deep recreational divers can enjoy the top of the dive site and play around the wreck too. The 60-meter long ship had sunk in the year 2000, resting down to 50 meterd in the Liloan bay. Due to the distance of diving on this wreck, it can be a half day safari.
More about the Liloan wreck.
Malapascua island is best known for having a great and amazing scuba diving spots with great sightings of amazing marine life residents. Malapascua has many diving spots, but Malapascua is mostly well-known for its Thrsher sharks sightings. Diving in Malapascua is atleast a full-day dive safari (two day are best) and can be done mostly during the dry season when the sea is flat.
More about diving at Malapascua.
Dive safari at the Camotes islands.
The Camotes Islands houses an underwater paradise underneath, a beautiful wall filled with colorful corals and sponges, decorated with sea fans, crinoids, and tropical marine species. Don't miss to capture the beautiful and mesmerizing colors of the ocean floors of the Camotes Islands and its marine life residents. Diving to the Camotes Islands is a day dive safari, but can easily become a multiple day dive safari.
More about the Camotes islands.
Dive safari at Cuatro islas.
Get into one of the most beautiful places to visit here in the Philippines, and a sure not-to-miss dive spots in the world. Dive into Cuatro Islas in Leyte, as it is one of the most beautiful marine sanctuaries spreading through the four islands inhabited by thousands of stunning marine diversities. Diving at Cuatro Islas is a whole day dive safari.
Cabilao island is known as the best diving place with its different dive sites between Bohol and Cebu. Cabilao is a haven for underwater photographers, and we don't even speak enough about the amazing opportunities for macro photography because Cabilao houses the famous pygmy seahorse and the most beautiful species of nudibranchs in the Philippines. Cabilao is also home to the hammerhead sharks, as well as the white tips and black tips reef sharks.
The Caubian cave dive site is less than 45 minutes from our dive center headquarters in Mactan. Diving in the Caubian cave is for experienced divers and we even recommend it for tech divers. The average depth is around 40 meters (130 feet), and exploring the cave is a must to do. On the way back you will have all the time to observe the amazing marine life along the wall during your decompression.
The Danajon Bank double-barrier coral reef is one of the six underwater double-barrier reefs in the world which is made of corals. This unique feature of the Danajon Bank make this dive site a unique dive spot in the Philippines, and even in the world due to the numerous species of corals. This double barrier reef is also known for possible encounters of tiger sharks, as well as bull sharks.
Diving at Capitancillo Island is a day dive safari from our dive center headquarters in Mactan. This safari is unique of its kind as Capitancillo is literally in the middle of nowhere. This is why a significant biodiversity surrounds Capitancillo Island and almost nobody is going or has been to the Island. This day trip dive safari is a must-do if you are in Mactan or Cebu.
More about diving at Capitancillo.
Diving with whale sharks is a unique experience, the biggest fish in the world (yes, it is a fish and not a mammal) is living in Oslob the whole year-round. Oslob is less than 3 hours away by car from our Scotty's Dive Center in Mactan, and this day trip safari starts very early in the morning to be in the water with the whale sharks before 10 o'clock, followed by a second dive at the Sumilon Island.
Balicasag Island is a marine sanctuary where you can dive with sea turtles. It's usually a day trip safaris with 2 or 3 dives at Balicasag. There are many diving sites around Balicasag Island, but the most popular dives are for the turtles which are quite shallow on the plateau at around 10 meters (33 feet) eating seaweeds and algae around 3 o'clock.
Whale shark diving and watching in Oslob.
Get PADI master scuba diver and be part of an elite group of divers.


text:
China's socialist democracy the most effective: Xi
Source: Xinhua| 2017-10-18 11:28:37|Editor: Liangyu
BEIJING, Oct. 18 (Xinhua) -- China's socialist democracy is the broadest, most genuine, and most effective democracy to safeguard the fundamental interests of the people, Xi Jinping said Wednesday at the opening session of the 19th National Congress of the Communist Party of China (CPC).
The very purpose of developing socialist democracy is to give full expression to the will of the people, protect their rights and interests, spark their creativity, and provide systemic and institutional guarantees to ensure the people run the country, he said.
"We should not just mechanically copy the political systems of other countries," he said.
The CPC stresses the unity of Party leadership, the people running the country, and law-based governance.
Party leadership is the fundamental guarantee for ensuring that the people run the country and governance in China is law-based; that the people run the country is an essential feature of socialist democracy; and law-based governance is the basic way for the Party to lead the people in governing the country, Xi said.
The system of people's congresses must be upheld and improved to ensure the people's exercise of state power, he said.
The CPC gives play to the important role of socialist consultative democracy, holding that "The essence of the people's democracy is that the people get to discuss their own affairs."
A coordinated approach will be adopted to promote consultations carried out by political parties, people's congresses, government departments, Chinese People's Political Consultative Conference (CPPCC) committees, people's organizations, communities, and social organizations.
A central leading group for advancing law-based governance in all areas will be set up to exercise unified leadership over the initiative to build rule of law in China.
The CPC will strengthen oversight to ensure compliance with the Constitution, advance constitutionality review, and safeguard the authority of the Constitution, Xi said.
He also stressed reform of Party and government institutions as well as the development of the patriotic united front.
The political system of socialism with Chinese characteristics is a great creation of the CPC and the Chinese people, Xi said. "We have every confidence that we can give full play to the strengths and distinctive features of China's socialist democracy, and make China's contribution to the political advancement of mankind."
KEY WORDS: the,people,democracy,based,said,Chinese,socialist,country,governance,and
"); //})


President Trump will use an executive order "next week" to end the catch and release policy he's detested for so long, he said in a speech Thursday.
America will "no longer release" undocumented immigrants found in the U.S., and instead will hold migrants in "massive tent cities" until their deportation or asylum proceedings, Trump said Thursday. The administration is currently building "massive cities of tents" along the border to accommodate for the expected influx of detainees, Trump added, insisting against evidence that it would be "totally legal" to indefinitely detain families.
Under the forthcoming executive order, "migrants seeking asylum will have to present themselves lawfully at a port of entry," Trump added. That defies international law that says anyone can claim asylum in another country no matter how they enter. Trump also likened his so-called "zero tolerance" policy to parent-child separations under former President Barack Obama, though he neglected to mention that families were only split under Obama when a parent faced a criminal charge.


text:
LATEST CD/DVD
Type band name, album name, artists name etc here...
Search all our articles by typing band name, album name, artists name etc here...
ATTENTION IRON MAIDEN FANS: KEITH WILFORT TO UNDERGO OPEN HEART SURGERY IN CALIFORNIA
Keith Wilfort is a big name in the early history of Iron Maiden. Keith was one of the band's first ever true fans, 'inventor' of the first ever Iron Maiden t-shirt and became the band's first ever fan club secretary.
Keith is not in good shape at the moment and is in hospital in California where he now lives and requires open heart surgery to replace his aortic valve.
He's had to have his teeth removed in preparation for the surgery and to save him from further infection. The surgery will almost certainly go ahead today (Friday 21st February).
The after care and medication alone will cost thousands of dollars and donations from the Metal community are coming in thick and fast to the GoFundMe page that Keith's family have set up. You can visit the page and donate by clicking here.
Two people have made anonymous donations of $1000 each and although Keith is in high spirits, he wants his teeth back so he can swear at everyone properly.
The band have been informed, and Metallica have also been alerted, due to the connection between the bands over the years.
So far the donations have hit $3,500, which is staggering in three days.
Keith and his family are updating his Facebook page with all developments and you can follow them by clicking here.
Donate by clicking here.


text:
Hill Real Estate
Broker's Price Opinion
Amy Hill Carter, Broker/Owner
amy.hill.carter@gmail.com
Yuba City, CA, 95991
Listing Agent: Victoria Ascher
Courtesy of: EXp Realty Of California Inc.
Stunning 4 BD 2BA home updated home near Hillcrest Park. This Open-concept layout features a fabulous massive kitchen and updated flooring, baseboards, and paint. Don't miss this opportunity to own a true gem!
Yuba City UnifiedElementary School
Yuba City UnifiedMiddle School
Yuba City UnifiedHigh School
County: Sutter
City: Yuba City
Neighborhood: 12410
674 Almond Street, Yuba City, CA, 95991
MLS# MTR223002513
Courtesy of: Keller Williams Realty-Yuba Sutter
Listing Agent: Victoria Ascher Courtesy of: EXp Realty Of California Inc. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data maintained by MetroList® may not reflect all real estate activity in the market. All information has been provided by seller/other sources and has not been verified by broker. All measurements and all calculations of area (i.e., Sq Ft and Acreage) are approximate. All interested persons should independently verify the accuracy of all information. All real estate advertising placed by anyone through this service for real properties in the United States is subject to the US Federal Fair Housing Act of 1968, as amended, which makes it illegal to advertise "any preference, limitation or discrimination because of race, color, religion, sex, handicap, family status or national origin or an intention to make any such preference, limitation or discrimination." This service will not knowingly accept any advertisement for real estate which is in violation of the law. Our readers are hereby informed that all dwellings, under the jurisdiction of U.S. Federal regulations, advertised in this service are available on an equal opportunity basis. Updated: 30th January, 2023 2:26 PM (UTC)
Min$100,000$150,000$200,000$250,000$300,000$350,000$400,000$450,000$500,000$550,000$600,000$650,000$700,000$750,000$800,000$850,000$900,000$950,000$1,000,000
Max$100,000$150,000$200,000$250,000$300,000$350,000$400,000$450,000$500,000$550,000$600,000$650,000$700,000$750,000$800,000$850,000$900,000$950,000$1,000,000


Chairs of the four major bodies which report directly to the Prime Minister or relevant Ministers, including the Commission's Chair Professor Allan Fels, released a joint media statement on Australia's current system of employment services.
As the chairs of the four bodies that report directly to the Prime Minister and Ministers involved in this area, we, Ms Lin Hatfield Dodds (Australian Social Inclusion Board), Mr Tony Nicholson (Prime Minister's Council on Homelessness), Prof Allan Fels (National Mental Health Commission), and Dr John Herron (Australian National Council on Drugs), today call on governments and all political parties to recognise the pressing need to improve the effectiveness of current employment systems in place for people with complex needs.
Employment is critically important for those who are experiencing alcohol, drug, mental health, homelessness and other social exclusion issues and can help people to successfully address and manage such problems. Effective employment services for the significant number of people affected by these issues can have real benefits for affected people, their families, the community, and the economy.
Australians with multiple and complex needs want to and can make a contribution to their community and society by engaging in meaningful and durable work. Unfortunately, it can be very difficult for people dealing with these problems to find and keep work. For these groups of people there is a real need to develop a more effective, client-focused system of employment assistance that creates a more direct line of sight to an appropriate job.
Under the current arrangements, employment services are not well equipped to deal with the complex range of issues experienced by these clients. Directly utilising the specialist services from the homelessness, alcohol and other drugs, and mental health sectors to address unemployment for people with complex needs is a reform that would reduce the significant barriers to employment faced by people with complex needs. The Job Services Australia system is currently being reviewed before the next phase of the system is introduced in 2015. Now is the time for everyone, including the health, welfare and business sectors, to come together to provide a renewed employment assistance system that supports people with complex needs to be able to get and keep a decent job.