text:
The MythBusters first exploded onto our screens in 2003 when it aired on the Discovery Channel. The first episode introduced us to Adam Savage and Jamie Hyneman, who we would go on to watch for over 250 episodes conducting more than 3 000 experiments.
After busting urban myths, Internet fan theories, movie scenes and generally blowing up stuff, the popular show announced that it was starting to wind down. There has been problems with ratings and viewership for a while, which is a normal decline for most shows and the team announced that they had anticipated the end.
The M7 Build Team consisting of Kari Byron, Tory Belleci and Grant Imahara were the first to say farewell back in 2014. But the whole team reunited recently to end off the show the only way these guys know how – with a bang.
As Adam said goodbye he became all of us and choked up:
The team also bid farewell to poor Buster – the show's test dummy that has taken a beating of a life time:
People like Neil deGrasse Tyson, Vince Gilligan, Chris Hardwick and Jonathan Banks break down some of their favourite myths that got busted. Drop us a comment and let us know which experiments or explosions were your favourites.


text:
Cookie Use Notification
This site uses cookies to provide you with a more responsive and personalised service.
By using this site you agree to our use of cookies as set out in our cookie notice. Please read our cookie notice for more information on the cookies we use and how to delete or block the use of cookies.
Current Location:United KingdomChange Location
United Kingdom
Home > News > Cushman & Wakefield creates EMEA Corporate Development Group
Cushman & Wakefield has appointed Joep van de Vorstenbosch to lead a new team focused on sourcing, evaluating and executing strategic investments across its EMEA business
Joep joins from Canaccord Genuity Group where he advised pan-EMEA real estate clients on corporate finance and M&A activity. Prior to this Joep, who is Dutch, worked in real estate investment banking at Citi and Deutsche Bank.
In these roles, Joep worked with a variety of real estate companies on a wide range of transactions, including M&A, financial restructuring and equity / debt capital markets transactions. At Cushman & Wakefield, Joep will lead a newly-created EMEA Corporate Development Group supporting key figures in in the firm's EMEA leadership team.
John Forrester, Chief Executive EMEA, Cushman & Wakefield, said: "Joep brings a track record of delivery and this is the perfect time for him to join the firm. We have made no secret of the fact that there are parts of our EMEA business we want to strategically enhance if we find the right fit and that process will accelerate with Joep coming on board."
Joep van de Vorstenbosch, International Partner, Cushman & Wakefield, said: "It's very exciting to join Cushman & Wakefield at such an opportune time. I am looking forward to working with the senior team across EMEA to help the business to achieve its growth agenda and further establishing the firm's position as a global leader in real estate services."
Head of EMEA Communications
London, United Kingdom
Phone +44 203 296 4326
Contact me

subset: commoncrawl


text:
|10/12/13: Lazer Kitty at Everyday Music
I've said it before and I'll say it again: I LOVE AUTUMN. Bright, chilly afternoons make for phenomenal daydreams and my listening habits over the past few weeks have evolved to match the changing scenery--namely, a steady diet of Superior Viaduct's repress of Sensations' Fix's 1974 debut "Fragments of Light", and "Wrong to Run", that gorgeous new TJ Max disc from Debacle Records. Well, as of the 8th of this month you can add the new disc by Seattle's Lazer Kitty to that list. The Seattle-based trio consisting of Scot Porter (aka. Vox Mod), brother Kyle Porter (founder of Unsound America and a ton of other stuff), and Jason Jordan (formerly Exohxo) is prolific. Don't believe me? Between December of 2010 and June of 2012 they published more than 24 hours worth of improv-y, space-rock-y goodness to their bandcamp. "Moons" marks their first effort in almost a year and a half and listening to "Dino Wipeout" it's clear that they are as strong as ever. The track delivers careening percussion work tempered by sticky sweet, futuristic synths, and a baseline warm enough to make Simon Gallup jealous. My only regret is that you guys can't hear the live version of this song that I recorded at their Everyday Music in-store last Saturday. No word on a physical release yet but keep an eye on lazerkitty.com for more.


text:
Why bother with electric Christmas lights when the trees are already bright with colour. Across the street I can see sumac, oak, crepe myrtle and poplar. Each tree is spiced with gold and red and every colour in between.
In exchange, we give our neighbours holly trees laden with red berries and a wild mulberry. It was a flashy neon green last week but today is the clearest yellow. Thanks to the rain the wet bark looks like cinnamon. Humble and magnificent.
This is supposed to be a time of hope. A time when our ancestors feared the longest night of the year. That sounds so wrong to me. Hope is for suckers. Let us be steadfast, resolute or determined instead.
All around me I see the signs that life is more determined than hopeful about survival. Tiny wild carrot and bedstraw seedlings blanket the soil protecting it from winter rain. Here and there Englemann's Daisy and Texas bluebonnets already display lush rosettes of green. When the time is right they will explode with colour. Outlier pink evening primroses are already in bloom. "Come bees. Remember spring with us."
The tradition is to see winter as death. I think the land has a completely different point of view.
This anole must have some powerful telepathy because somehow I noticed her even though she was absolutely torpid from the cool morning air. Maybe I subconsciously spotted that amazing eyeshadow. The leaf she was using for camouflage nearly meant her end because when I pass by evergreens I have a habit of shaking off fallen pecan leaves that get caught in the branches. As if moulting in the cold wasn't uncomfortable enough … being launched into the wide blue yonder would have hurt a whole lot more.
She remained in that spot for hours. Steadfast.
The news from the Paris is that our leaders have failed us and the planet. All talk; no action. Father Christmas won't be coming this year so we must look to older icons. Demeter relentlessly searching the earth for her missing daughter; Mary fearlessly cradling her infant in the straw. See hope there if you like. I see fierce women doing what needs to be done. Steadfast. Resolute. Determined.


text:
MatchesAll times
Scrappy starters, fighting finishers
Our nominees savaged bowlers and turned matches around dramatically
Ireland's spinners help seal third place in low-scoring game
Gareth Delany and Simi Singh helped reduce Namibia to 20 for 3 in the Powerplay as Ireland defended 136
Top Headlines
- The road to World Cup 2023: how teams can secure qualification, from rank No. 1 to 32
- Namibia's Christi Viljoen earns four-match suspension
- Namibia, PNG secure ODI status after wins over HK and Oman
- Oman continue dominance with win over Hong Kong
Norman Vanua saves the day to put PNG in final
Namibia lose control of a middling chase as PNG's discipline shines through
Smit, Scholtz spark whirlwind fightback to send Namibia to T20 World Cup
Oman were well ahead in the chase before Namibia's spinners began a dramatic collapse
Namibia storm past Singapore into the playoffs behind captain Erasmus
The Namibia juggernaut notched their fourth straight win, while Singapore fell to their fourth straight loss to crash out
Scholtz four-for backs up Baard, Erasmus fifties as Namibia win big
Bernard Scholtz produced the tournament's best haul of 4 for 12 to decimate Kenya in their chase
Namibia decimate Coetzer-less Scotland
Scotland looked deflated coming up against a rested Namibia unit, who stormed to their first win of the tournament by 24 runs
PNG crush Namibia after Tony Ura, Assad Vala set platform with century stand
Namibia's net run-rate takes a hit too as they lose their second in a row, this one by 81 runs
Five players to watch at the T20 World Cup qualifiers
Some fast-scorers and miserly bowlers will hope to make a name for themselves in the UAE over the next two weeks
The road to World Cup 2023: how teams can secure qualification, from rank No. 1 to 32
For the first time, even Full Members will go head-to-head in a bid to secure their World Cup spot - no more just depending on the rankings
Namibia's Christi Viljoen earns four-match suspension
The 31-year-old was found to be in violation of ICC's Anti-Racism Code during the T20 World Cup Africa Qualifiers in May
Namibia's emergence from 'dark place' leaves Gerhard Erasmus confident of the future
After a narrow miss last year, ODI status has been secured, and with it, according to Namibia's captain, a greater chance of young players staying longer in cricket
Oman, Namibia players crowd WCL Division 2 Team of the Tournament
Zeeshan Maqsood to lead the team, which has Davy Jacobs and Ali Khan among its biggest stars
Namibia, PNG secure ODI status after wins over HK and Oman
Canada needed to restrict USA to 211 if they were to regain ODI status, but USA's last-wicket pair denied them with a boundary in the final over
Oman continue dominance with win over Hong Kong
USA brush aside PNG to notch second win while Namibia overpower Canada
Ali Khan five-for turns Namibia chase upside down in two-run thriller for USA
Oman comfortably overcame Canada and PNG held their nerve against Hong Kong on the second day of the World Cricket League tournament
Oman ride on Mohammad Nadeem's sizzling form to overcome USA
Anshy Rath stars in Hong Kong's win over Canada while Namibia squeeze past PNG in low-scoring thriller
Six players to watch out for at WCL Division Two 2019
A bruising timer of the ball, one of the best death bowlers in Associate cricket, an offspinner, a legspinner are among our six picks
A shot at renaissance for sides in WCL's curtain call
With the death of the World Cricket League after this event, the tournament gives teams a chance to resurrect, with ODI status also up for grabs for four teams
Albie Morkel retires from all forms of cricket
The South Africa allrounder remains tied to the game having signed on as a coaching consultant for Namibia
Pierre de Bruyn appointed Namibia head coach
His first challenge will be to try and help the team finish in the top four of a six-team qualifying tournament for the CWC League 2
The World Cup catches political heat
The day in 2003 that Andy Flower and Henry Olonga took a political, and potentially dangerous, stand against the Zimbabwe government
Namibia withdraw from South Africa's provincial competitions
Namibia, who made the final of the Sunfoil three-day cup earlier this year, cited challenges around logistics and expenses to end an involvement that stretches back more than 20 years
An offspinning allrounder, an ice-cool finisher, a teenaged legspinner
Four players from Canada, two each from Namibia, Nepal and Oman, and one from the champion side UAE make up ESPNcricinfo's team of the tournament
Top Run ScorersFeb'19 to Jan'20
Top Wicket TakersFeb'19 to Jan'20
Dailies: England wrap up victory despite van der Dussen 98
Our daily round up from the world of cricket
Zed, Marty, Viv: Mike Whitney picks his best XI
Who's leading in every format
Home and away: bowlers who travel well and those who don't
Your shots: pictures by fans
Hate to Love: the pre-2004 Zimbabwe side
Records index
Most runs, most wickets, and a whole lot more
How many leagues can cricket take?
The cricket calendar
Schedule of upcoming international games
Pat Cummins, the naive and fragile boy who became the world's top bowler
Longreads you don't want to miss
Bharat Arun: 'I need to help bowlers understand their own rhythm'


text:
Empty Stomachs From Guantanamo to Palestine
Friday, 26 April 2013 00:00 By Patrick O. Strickland, Truthout
(Photo: Joe Catron / Flickr)
Ramallah, Occupied West Bank - Official numbers estimate that nearly half of the prisoners presently being detained in Guantanamo Bay are on hunger strike. On April 16, clashes broke out when guards attempted to forcefully move detainees from their communal cells into single-person cells.
According to The Guardian, "around a dozen [prisoners] are being force-fed to keep them alive," but other media put the number at over 15.
Amnesty International condemns the use of force-feeding, noting that it "it may amount to cruel, inhuman or degrading treatment." During such force-feeding sessions, detainees are strapped to restraint chairs for hours at a time, and their extremities are tightly tied, their mouths gagged, and their nostrils subjected to invasive feeding tubes.
Further reports have emerged suggesting that the guards have displayed "deliberate indifference" to the hunger strikers, denying them drinkable water and basic medical necessities in a heartless attempt to crush their resolve and put an end to the mass hunger strike.
Despite appeals from lawyers and human rights organizations, who point out that several of the prisoners are on the brink of death, US District Judge Thomas Hogan denied an emergency motion for relief filed by one of the detainees, Musa'ab Omar Al-Madhwani, a Yemeni national arrested at just 22 years old and held for over a decade with neither charge nor trial. According to Hogan, Al-Madhwani had "self-manufactured" the "imminent danger" of death that his rapidly declining health now poses.
The hunger strikers, being held as part of the broader "war on terror" despite the United States government's inability to prosecute them, highlight the resounding hypocrisy of the Obama administration. In 2007, while campaigning for his first presidential term, Obama vowed to "close Guantanamo, reject the Military Commissions Act and adhere to the Geneva Conventions."
Upon ascending to presidency, Obama signed an executive order to close the detention center within one year. After retreating from political opposition, however, the White House granted itself an additional six months in July 2009. Since then, a series of limp excuses and ineffectual groans of intent have alighted from Washington, but Guantanamo, the moral outhouse of the American justice, remains the dumping ground for suspects that are ostensibly guilty of nothing more than being Muslim in shady places at the wrong time.
Meanwhile, a similar drama, draped in all the same moral infringements and bombastic insults to the basic tenets of habeas corpus, unfolds in Israel and the Occupied Palestinian Territories. According to Addameer Prisoner Support Network, 4,812 Palestinians were being held in Israeli military prisons as of February. From this total, 219 are classified as children, 31 of whom are under 16-years-old. 178 Palestinians are presently detained under the file of "administrative detention," in which they are thrown behind bars indefinitely on the testimony of "secret evidence," denied both charge and trial. According to Palestinian officials, 207 prisoners have died in occupation prisons since 1948.
Throughout the last few years, several prisoners launched lengthy hunger strikes that chalked up a number of successes against their jailers. In early 2012, administrative detainee Khader Adnan, accused of being an Islamic Jihad activist, staged a highly publicized 66-day hunger strike that, though it nearly costing his life, resulted in his eventual freedom.
Following in his footsteps, Hana Shalabi astoundingly went 43 days without food until Israel grudgingly agreed to release her. Shalabi rallied the Palestinian street behind her and inspired some 2,000 prisoners to go on mass hunger strike against their imprisonment. In exchange for ending their collective strike, Israeli Prison Services unenthusiastically agreed to end solitary confinement, allow family visits for prisoners from the Gaza Strip, improve basic living conditions and to not extend the sentences of then-present administrative detainees.
Nonetheless, Gavan Kelly of Addameer said in an interview that "Israel has reneged on almost all of the obligations on which it agreed." Nothing could accurately portray the truthfulness of this statement more than the case of Samer Al-Issawi, a Jerusalem-born administrative detainee who has pressed on for over eight months without food.
Israeli Prison Services tried to strike a deal in which Al-Issawi would be deported to Europe or Gaza. After stating his steadfast commitment to returning to his Jerusalem village or taking his hunger strike to the point of death, alongside months of Israeli officials vowing that the government will not cave in to Al-Issawi's demands, Israel has grudgingly agreed to release him to his Jerusalem village.
Throughout the highly emotional trajectory of his hunger strike, an international campaign has sprung up to raise awareness about the plight of prisoners in Israeli lockup. From Guantanamo to Palestine, prisoners have served to cultivate a nascent form of international solidarity that unmasks the dual duplicity of American empire and its favored colonial outpost. Their empty stomachs continue to deliver a number of stultifying blows to the institutions of injustice.
Copyright, Truthout.
Patrick O. Strickland is a freelance journalist whose writing has appeared at Al Jazeera English, Al-Akhbar English, CounterPunch, Middle East Monitor, Fair Observer and elsewhere. He is presently working on his first book, a brief history of unarmed resistance in Palestine. Follow him on Twitter at: P_strickland_
Donations can be sent to the Baltimore Nonviolence Center, 325 E. 25th St., Baltimore, MD 21218. Ph: 410-366-1637; Email: mobuszewski [at] verizon.net. Go to http://baltimorenonviolencecenter.blogspot.com/
"The master class has always declared the wars; the subject class has always fought the battles. The master class has had all to gain and nothing to lose, while the subject class has had nothing to gain and everything to lose--especially their lives." Eugene Victor Debs
Friday, April 26, 2013
Empty Stomachs From Guantanamo to Palestine
Posted by Max Obuszewski at 8:00 PM
No comments:
Subscribe to: Post Comments (Atom)


text:
Things To Do: Prendiamo un aperitivo! - Aperol Spritz SocialsMonday, July 11, 2016
A quarterly digital magazine delivered directly to your inbox relaunching in 2020. The Playbook is a multimedia treatment shared privately and exclusively with our community members. From foodies and fashionistas to fitness enthusiasts and culture lovers, there is a story for everyone through the return to our origins of bespoke, inspiring, and taste-making content for the busy, modern lifestyle.
Italians have a reputation for doing it better; cuisine and socialising especially. Combining the two is Aperitivo: the 250 year old tradition of celebrating the end of the work day over drinks, nibbles, and convivial vibes. Think Afternoon Tea but less posh, more cosmopolitan, and not so bland. (Did we just diss the Great British institution that is Afternoon Tea? Oops!) Anyhow, we had the pleasure of participating in Aperitivo with a hands-on twist. We have the verdict. So if you're looking for things to do in London this summer, scroll on, prendiamo un aperitivo!
For the more curious among you, there are the social events: in which Aperol Spritz teams up with an array of London culture makers including Forza Win and The School of Life, to offer a series of interactive workshops.
Loris Contro, host with the most, and brand man at Campari group.
Learning the origin story of Aperitivo.
The finalists showing a little competitive spirit.
Spectating the sports.
The taste test. A fellow guest fancied himself as a connoisseur of cocktails and so judged each drink.
Results came in, Zoe was the swiftest and the finest bartender! She won a bottle of Aperol to take home.
Serving a piece of crostini: whipped butter beans with garlic, grilled veg, and toasted almonds on sourdough.
Panzanella: sweet datterini tomatoes, stale bread, pink onions, garnished with basil.
48 day aged rump steak served with salsa verde.
Zoe enjoying her panzanella
Convivial vibes.
Arrivederci, amici!
4 comments
- Anonymous11 July 2016 at 15:45
just wanted to say every time I read your blog it's like going on a mini holiday . Definitely want to go to this social with my boyfriend after work now. Really good post so keep it up - Louisa xxReplyDeleteReplies
Oh, that's a great compliment Louisa! Thanks for taking the time to read. The next social is on July 20th so register as soon as you can, I've hyperlinked the registration form for you here. I hope you get a space and enjoy the evening.Delete
Esmé Xo
Will definitely have to check this out when I move back to London (after 5 months in Italy) and year abroad nostalgia kicks in. Must have had at least 50 Aperol Spritzes while I've been here!ReplyDeleteReplies
Hey Fedora. Thanks for stopping by the blog. I'm sure your year abroad is going delightfully with that number, I'm envious! Fortunately, so many restaurants and bars here do serve Aperol Spritzes so you won't have to miss out. London looks forward to receiving you!Delete
Esmé Xo


text:
Audio podcast:
Enjoy the Podcast?
Don't miss an episode, subscribe via iTunes, Stitcher or RSS
Leave us a review in iTunes
Target Audience:
All developers who write T-SQL code and aim to improve performance and discover free tools and resources.
SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.
Duration: 75 Minutes
Why I Want to Present This Session:
- This topic is my passion and my daily work.
- I want to give back to community knowledge that I learned from my senior peers.
Slide Deck:
Additional Resources:
Zip file with presentation and demos on OneDrive: Crash Course Presentation
Session Transcript:
Brent Ozar: Vladimir Oselsky is going to be talking about a crash course on better SQL development, so take it away Vladimir.
Vladimir Oselsky: Well, thanks so much for inviting me and having me here, so my name is Vladimir Oselsky. At least that's how people pronounce it in America. Back home it would be something like Vladimir Oselsky, which probably nobody can even understand. Currently senior software developer at the small software company. Yes, I was born and raised in Siberia since a few people are asking about it, and it does get cold there, but few people don't realize it can get very hard. One of the places I lived it used to get above a hundred degrees, high altitude mountains, in the winter minus 60, somewhere over a hundred.
I have a bachelor's degree in Software Engineering Technology, so I know some .NET and somehow got into SQL. Alright, that's enough about me, let's jump into the agenda. So wrote better SQL development, how to become better SQL developer? And that's something I had to work through few years ago, trying to understand the platform because I came out of school with a bachelor's degree in Programming but I still didn't understand SQL Server. I might have wrote a few queries but that wasn't enough to actually have a job. Then I started learning about all the different tools and then I start learning from other people on my team members, and most of them were senior Oracle people that were in the business for almost 30 years and they could write SQL with their eyes closed. One phrase that I learned not that long ago, and I don't know who has it copyrighted, so apologies, apologies, it depends.
I learned that in SQL Server, you can't always apply the same solution to all your problems, and that was one of my initial problems that I was doing myself. I was trying to use the same approach in all the different scenarios. So then we're going to jump into T-SQL code and we're also going to talk about this amazing command – oh my Zoomit's not working, let me start my Zoomit. It doesn't start automatically…
Brent Ozar: I thought for sure you were going to show truncate table.
Vladimir Oselsky: No. Alright, this one actually belongs to Brent Ozar, but I think I'm in a better position to say it. It's DBCC cp because [crosstalk] database [inaudible] consistency.
Brent Ozar: I love it.
Vladimir Oselsky: Well, that's enough with the fun and games, so when it comes to T-SQL coding, like I said, there are so many different ways to solve a problem, like sometimes you need to use a CTE, sometimes you use derive table sub-queries, sometimes table variables, temp tables, but you can't always apply it to the same scenario. And then when it comes to stored procedure design, there are so many different ways people write stored procedures, getting the same results yet some of them are faster than others.
When it comes to cursors, like I said, one of my first jobs was working with Oracle people and they loved cursors. I wrote a cursor every day on the job and then I came to SQL Server and I was told never to use a cursor. I wasn't explained why, I was just told not to use a cursor. So we'll look a little bit into it, why a cursor is not a curse. Talk a little bit about error handling, execution plans, and some tools. So let's go to next slide. When it comes to understanding the platform, back when I first started with SQL Server, SQL Server 2008 R2 was just coming out and they were adding all the geography, geometry data types, adding user defined table types, CLR and other functionality.
I wanted to learn all about it and then I realized that I don't have time to learn everything there is about SQL Server. I found small niche that I can focus on and get better instead of trying to learn everything. But with all the different versions of SQL Server available, you need to understand what's different between them and what each version can do better. Because sometimes – well, one of the things we'll talk about, for example, RAISERROR versus THROW, and in SQL Server, THROW became available in SQL Server 2012, if I'm not mistaken. Trying to work in SQL Server 2008 R2 or prior can't use that, so have to change the code and have to change how I'm handling stored procedures. And then we'll talk about tools because when I was working with Oracle, there was pretty much the only one tool, Toad. Everybody worked with Toad and a few people used the SQL developer. When I came to SQL Server, everybody's using SSMS. And then finally, Microsoft two years ago announced SSDT so now there's more integration with Visual Studio and I'm actually going to be doing all the demos in the new SSMS versions 14, I believe it is now, which looks even more like a Visual Studio. And then there's also the little program called LINQPad, I'll demonstrate why I actually like using it.
When it comes to SQL tuning, we have to look at execution plan. I know there are some people that are able to do the query tuning strictly by looking at statistics and execution times, but I'm a visual person. I like to see what I'm working on, and by seeing that visual plan in SSMS, it just doesn't work and I'll show how much better it is in the Plan Explorer. And this is not a presentation trying to sell Plan Explorer because believe me, I can't sell it, it's free and I'm not a spokesperson for SentryOne and there's just – won't be enough time to even cover Plan Explorer even the smallest bit. We're just going to look at it briefly.
So now let's just jump straight into demo. Slides are okay but demos is where it is. Can you guys see my screen alright? Alright, so CTEs, if I'm not mistaken, they were introduced in SQL Server 2005 or so, and one of the first ways I started using them was trying to combine queries. So instead of writing subqueries and having this long mass that is hard to read and understand, I would just take the code and write it as a CTE. Because now I define it, I know what I'm selecting, what I'm working with, I can define multiple things and it's all pretty. Everything has a place and once I go to joiner to it, it's very simple, there's no extra code to look at.
So I started using CTEs everywhere until I went to SQL Saturdays and I heard that CTEs could be bad.
So why can CTEs be bad? So let's look at CTE, code runs fine, everything is good, we'll look at the execution plan and right away we see a problem with execution plan in SSMS. There's just not enough real estate to look at everything that you're seeing, and most of the time you're not going to be looking at the simple plan like this where there's only one query. When you're debugging stored procedures, you're going to be looking at maybe a hundred different queries and you have the scroll bar and you're constantly trying to find that one thing that you want to work on.
So CTEs, why can they be bad? Well, one thing I didn't know, CTEs underneath the hood actually treated as views in SQL Server. So SQL Server will create a view and then select from it, so one of the problems that exist with the views if you nest them deep enough, SQL Server is going to lose all statistics into objects that you're selecting from. So in that sense, you will only be able to – when you look at estimated row count, you will only see one row coming back from that CTE. So if you nest them like you do view, you're going to screw up the execution plan and you won't be able to – and you will get a bad execution plan because SQL Server is estimating one row versus how many are actually coming from that.
So what do you do if you need to nest it? Well, you write a sub-query because no matter how far you nest a sub-query, SQL Server is going to unwrap it for you before executing it, so there will still be statistics associated with it. So temp tables – we'll show that in Plan Explorer. Temp tables, I love temp tables because one of the easiest things I've found, I'll just select whatever I want and then I'll just throw it into temp table because once in a while, I'm just a lazy programmer who doesn't want to spend their time trying to figure out how to create the table, which column it's going to be. So I'm just going to throw a select into statement and SQL Server is going to create all the columns for me, and then I'm going to select from it.
So let's execute it. Forgetting my execution plan – so if we look at the execution plan, and we find one of the select statements from the temp table, we'll see that estimated row count actually corresponds to the actual row count. So there is more things you can do with the temp table than you can with table variables, because with the temp table you can actually create indexes on it, they have primary keys, you can have non-clustered indexes, whereas table variable would only have a – you can have a primary key on table variable. But there is something else that comes with the table variables.
So now Plan Explorer, so I run the same command, and instead of using temp tables, I'm running to table variables and doing the same select. So query almost identical but if we look at execution plan, query is very different. Looking at select from table variable, we have estimated row count one, so then being a smart programmer, I decided well, I'll just use table variables for very small data sets and then use temp tables for large data sets.
Well, going back to SQL Saturdays, I learned there's actually a way to enable table variables to be a little smarter. And I don't remember exactly who was talking about it but there is a trace flag, 2453, and it produces something interesting. So exactly same query running with the different trace flag, we have a different execution plan. Which, if we go back to temp table, it looks very much like the execution plan that came from a temp table. And if we look at what's going on here, we'll actually find that estimated row count and the actual row count are identical even though just before, selecting from that same table variable, we're only getting one estimated row versus the whole everything.
So do your research, don't go to your production system and start turning on trace flags, this is not what this session is about, this session is about different possibilities that you have to approach a problem. So now, this trace flag will enable some statistics in table variables and you will be able to get much better execution plan instead of just one row.
So what about running stored procedures? When we write stored procedures, normally our stored procedures can be very simple. We just have a parameter and have some work and return some data. But what happens when we want to get a whole list of parameters? Well, we concatenate strings, and they're in the front end, and then we want to split those strings in the back end. That puts extra load on the SQL Server, and unless you're using SQL Server 2016, you don't have a string split built-in function for it. So you're either going to write a CLR or do something else to split those strings. Well, what's the alternative? Well, the alternative is using table variables.
So how do you create table variables? Well, very easy. You create a type, give it a name, last table, define your columns, and you can even specify there's a primary key. So in my case, I just want to demonstrate just passing a single column to a stored procedure; so how does it actually look on the front end? I know not many of you might be .NET developers but when working with a .NET code and calling SQL stored procedures to pass the table, it's called SQL data type structured, and you're just passing a whole object to it.
So now instead of somebody who's a front end developer having to do extra work of taking that data table that they had and converting it to comma separated string for you, they just take that whole IEnumberable structure and they'll pass it to you.
So how does it look on the back end? So once we pass the whole data table to stored procedure, since it acts identical to table variable, we'll just join to it. So now I don't have to split my strings, worry about anything else, I'm just joining to it, and now I can make my stored procedure smarter and if I add option recompile or do something else to actually enable statistics into it, because just like the problem exists with table variables, there's probably not going to be any statistics with it.
So let's look what happens when you actually call it. Let's clear the cache, make sure my flag is turned off, execute the stored procedure but only pass a single item to it. And now we have to find where it's being selected and estimated rows, one. So we'll – well, we passed one item and we're getting one row, so I think we're in a good scenario.
What happens if we're trying to pass a hundred items? So let's execute it, we're running a hundred items to list and passing that whole list to stored procedure, we're only getting 17 items back, but what happens in execution plan? We're still getting the same number of rows, we're still only getting one row. So I had – well, I guess table variables always estimates one row. It's apparently not; so let's free proc cache, around our hundred rows, go back, find it… Estimated number of rows, still one. Alright, now we execute this again and this doesn't work all the time but what actually happens with SQL Server when it's using table variables, it will store the number of rows during the first execution. So if your first execution was with a single row, you will get one row estimated for every subsequent execution.
Then the trace flag that we talked about earlier that affects table variables, it also affects table valid parameters. And in this case, we're still getting one row; so something is still cached. Let's try this again, and we're still getting one row. Alright, I must be doing something wrong in here. That's what happens when you're trying to work with something that doesn't generate exactly same result every time.
Brent Ozar: Oh well.
Vladimir Oselsky: So this trace flag will affect table valid parameters but be careful when working with it and make sure it's exactly what you need and it's not going to produce additional problems for you. So cursors, why is cursor such a big problem in SQL Server? And I'm not going to mention him because he might actually be listening, but this guy who shall be left unnamed, wrote this amazing blog post on the different options that you can associate – that you can include on cursors and what they do. See, when coming from Oracle, I knew that Oracle implementation, of course, was very fast. I didn't understand why implementation in SQL Server was so bad. So then I learned that when SQL Server was implementing cursors, they created the cursor that can do absolutely everything. Cursor can go backwards, cursor was go forward, can traverse, can skip forward, can skip back. Well, most of the time when we're running a cursor, all we need is the cursor that goes one row at a time and it's only going forward. So the way we can define our cursor to do that is by using these two options: local and fast forward.
So read the blog post, I included the link in the slides, it will explain in more details that we have the time for, but fast forward will force the cursor to only be a cursor that can be traversed forward one row at a time instead of doing all this other stuff that we don't really need the cursor to do. And as you will find from the blog post, that it reduced memory usage, reduces the duration, even reduces pages in tempdb; and all we did was define extra options with cursor. So if you do have to use a cursor, at least now you know that there are options you can include with it to make it go faster. We're doing good on time.
Error handling – when it comes to error handling, it was the second nature to me as a .NET developer. I learned try-catch blocks pretty much right off the bat, so working with SQL Server, I forgot when the try-catch blocks were introduced but I was glad that they were. So the way I see it, it is a last option for us developers to make the code fail gracefully. A lot of times, we don't want the code to fail and just commit – some changes to be committed halfway through it. For example, if we're trying to delete some data or trying to insert it, we want everything to be executed, not just the beginning of it. And then if it fails halfway through it, we want to be able to rollback. One of the easiest way, encapsulate it in a transaction with a try-catch block, we can catch that there and roll it back.
So what we do with that error, well, that's up to each developer. Sometimes you will just want to print that error message to the screen because you don't really want anybody else to know that your stored procedure failed, but when you go to execute it, you'll be able to see that error message.
What about if you want that error message to be an actual error message? Well, you can re-throw it by either catching all the appropriate information with it and then using a RAISERROR or simple in SQL Server 2012 and higher you can just use the THROW command and if you use it from a catch block, it will act as a re-throw. So whatever exception was caught, it will just throw it again.
So let's look at the execution of it. So we execute a stored procedure that caught an error, nothing really happened, well, because we print, so to see an actual message, we would have to go to the messages tab. So if this is something that's being caught from a front end and they are not reading back the messages, they won't even know that your stored procedure failed. They just won't get the results back. When you execute a stored procedure that actually throws an error, there will be additional information sent to the front end. Or even if you're running it from SSMS, it will change tabs for you, so you know right off the bat that there is the error and what it is. Plus, you get this nice red text versus just the black text that you get from printing that error message.
So I was talking about difference in THROW versus RAISERROR, and everybody does know that this is RAISERROR…
Brent Ozar: That's great, I've never heard it called that before.
Vladimir Oselsky: You must have never listened to videos from Tobias.
Brent Ozar: No.
Vladimir Oselsky: Yes, he's like this is RAISERROR, I was like what is he talking about? And he's like yes, otherwise, it would have been RAISERROR.
Brent Ozar: Nice.
Vladimir Oselsky: So what's the difference? Well, one with THROW an error, we just have a very simple statement. We just print, throw in error and select from table. Well, we don't get that select from table. Instead, we get the error message being thrown, so we would expect the same thing with the RAISERROR. Well instead, we get the same error message but we get some additional information. 16 rows affected. We go back to the results and we actually find that the select was still executed, so even though you raised the error, you still got the select statement. Well sometimes, you don't want your code to continue going if you're raising an error based on some sort of user condition, you would want it to stop. Instead, in this case, we find that RAISERROR still goes on and you still get that select statement, which in my case it's not bad but what if it's a delete statement or something else that you don't want to do if the error was raised?
So we think, well then RAISERROR is bad and we're not going to use it. Well, actually not. We're going to use the same RAISERROR, same select from statement but we're going to wrap it in a try-catch block. All of a sudden, that select statement is no longer being executed because RAISERROR will act different when it's inside try-catch block than it will outside of it. So if you have stored procedure that doesn't have a trap-catch block and you have RAISERROR, the execution will continue. If you have a stored procedure with a begin – with a try-catch block and you have RAISERROR, the execution – it will stop execution and you won't get that select statement, which is actually very similar scenario to what happens if we just have a generic error message.
So here we're just doing some simple division by zero, which will give us an error but execution still continues. So I'm not sure why Microsoft decided to do it but with raising the error, you get the same behavior as you would if your code generated an error. But you wrap that same code in the try-catch block and all of a sudden when the error is thrown, it will catch it and the execution will no longer continue. So just something to consider, there is differences when it comes to what SQL Server will do to it.
Alright, so let's talk about Visual Studio SQL Server data tools. Being a .NET developer, I lived in the Visual Studio. So when I found out that I can actually do my SQL Server development in Visual Studio, I was very excited because I could do all the things in Visual Studio that I learned and loved. So this is not an SSDT presentation, this is just a slight glimpse into what can be done with it. So here, we have a table, stored procedure and one of the biggest difference between writing code in Visual Studio SSDT project versus writing in SSMS, if we already created the stored procedure, we'll need to write it as an alter statement every subsequent time.
When working on the code in Visual Studio, you always define how it's going to be. So I never have to write an alter statement because it will actually complain. So it's always going to be a create stored procedure, never an alter statement. Of course with SQL Server 2016, you can use create if exist I believe…
Brent Ozar: Drop if exist.
Vladimir Oselsky: Yes, drop if exist. So there are some extra possibilities. But right off the bat, using Visual Studio, you write a declarative code so you write the code how you want it to be, not how it is and how we're going to change it. So we have one simple table, one stored procedure and we have a table call attendees with three columns, ID, first name and surname, and I know if I ever call it surname because maybe we're running our application that's going to go worldwide and they don't always call it last name.
So then we rolled out the application and everybody is happy until the manager comes along and says well, we're not going to roll out the application worldwide, it's going to be only for America and we want to call it last name. So as a developer, you would come in and you would change it to last name and it's all great until you go back to stored procedure, and now your stored procedure doesn't work because well, it expects a surname but we changed our table to last name. Now we're back to generating the code, trying to rename all the instances of that stored procedures that we need to do, so there just has to be a better way of doing it.
So with Visual Studio, there are some other capability that you have. One of it is this refactor menu. With the refactor, there's this little nifty thing called rename, so let's see what happens if we use the rename. So we'll give this a new column name, we save it, it says, well, I'm going to change the column name, and we click apply. So looked almost identical to what we did before, instead, when we go to stored procedure now, stored procedure automatically changed because Visual Studio will keep track of dependencies of the objects and when it notices that that object changed, it will actually rename it for you. So just one little feature that – I mean, something that I wished you could do in SSMS, you can do it very easily in Visual Studio. So now instead of trying to find all the stored procedures that you wrote, in every instance when you used that column, you just bring the code into Visual Studio, change it using – you refactor the code and now all of a sudden you get that code changed for you.
So one of the things that you will notice, there's a file called here refactor log, so what it does, it actually saves whenever columns were changed, and if anybody using Redgate products, this is some of the things it can read and when you're deploying it, it can generate different code, it will generate a code for you to alter a column name in the table, but it also knows that it needs to generate the code for stored procedures to change it. Well, talking about Redgate, one of the features that we have from Redgate is schema compare. But for those of use that work for companies that don't want to buy Redgate tools because they don't feel like their developers are worth spending money on, we're left to using the tools that are available to us.
One of those is we get a schema compare as part of SSDT and all you have to do is come to tools SQL Server and do a new schema compare. Well, I already set it up and I'm comparing my local project that I'm running in Visual Studio to the local instance database, and you get this nice little graphical interface of what happened. Well, I have more tables than I have in my target, than I have in my project, so we can drop them, we have a change and we know exactly what the change was. So for those of us that don't have Redgate tools and schema compare, we can use tools that are available to us. So if somebody has Visual Studio as part of a product that they already use, this is some of the things they can do without trying to buy extra tools.
Another thing I saw from Redgate is new – one of their new capabilities with I believe, ready roll, which will probably make SSDT projects almost obsolete, but we'll see where it goes. We will probably have to spend some time playing with it to see exactly what we can do with this.
Brent Ozar: Dana asks, "Do these features work only in the one database that you're in or can they look across all the databases on a server to do this?"
Vladimir Oselsky: Well, so with the schema compare, you would have to select specific databases to compare. So you can compare between servers, you can compare databases to databases on the same server, but it's whatever you have access to. So if you have access to that database, you can see it otherwise you won't be able to compare it.
Alright, we talked about a tool called LINQPad. And let me start it up… And of course, it goes to the wrong screen. So one of the things that I love about this tiny little tool, it's very lightweight. I used to use – back when I was running a lot of c# code, so I could write small snippets of code without having to start Visual Studio. I wanted to just write a small code, execute it and just be done with it. Well, I realized that I can do the same thing with SQL statements. So over here, I have my Glenn Berry scripts; that absolute necessity when it comes to troubleshooting performance.
So with all the different scripts you have, for example, where is my sp_who3. Once in a while, somebody calls you and says, hey something is running on the server, we're not sure what's going on, so we come in here, and we can just execute it. So it runs really fast and the fact that this – I don't have to fire up SSMS and sometimes SSMS can crash on me or I have too many windows, or doing something else with it, this is just one of those tools I use to organize my scripts and when they need something to run really quick or to run – it's like, I didn't want to run it against this database, I want to run it against different database. So it can be done very easily and again, this tool is free so just by using some free tools, you have more capabilities.
This is not going to replace SSMS and if you come in here you won't be able to do any of the administrative things you expect SSMS to do like creating schemas for you or doing anything else, this is just a lightweight tool that you can use for querying databases.
Alright, back to Plan Explorer. One of the jobs I had earlier in my career was they gave me a SQL Server and said we want this database to be moved from 2008 to 2012 and make sure to optimize every stored procedure. They had over 200 stored procedure, so now I'm working through every stored procedure trying to performance tune it. So I don't know how I happened to go find Plan Explorer, but I fell in love with the fact that there's just – you can click on any individual statement and you're looking at the plan diagram just for that statement. And if you have multiple screens – give me one second – you can actually use a whole real estate of that screen to see the plan.
So with a small plan, it probably doesn't really matter but when the plans are bigger – let me find a bigger plan – it becomes much easier to see the bigger picture of it. And the bigger your screen you have, it's just that much easier than trying to see that scroll bar in SSMS, scrolling back and forth trying to find that one execution that we need.
But I learned about another little thing right off the bat. When it comes to this cost in SSMS, the cost is estimated. So this is just what SQL Server thinks is going to cost you. So how do you find the most offensive query when you execute a stored procedure and it has hundred different statements and you have to go through and look through each one of those statements? Well, in here I can sort by the duration that each statement took and I have this wonderful statement that took 42 seconds, but the estimated cost was only 0.4%.
So if I was going only based off estimated cost, I would never look at this query because you will just won't expect it to be taking most of your time. So then when it comes to actually figuring out what's wrong with the plan, well, this one is quite easy. We have index seek with 274 million records coming back.
So very quickly, just visually coming, I was able to identify a problem. Well, if we have 275 million records, so I go look at the base table and the base table only had about 700,000 records. So there was some poorly written code, but when looking at the execution plans in Plan Explorer, let's say there's a plan that we don't really care what it's doing. We can just come in here and hide it, and then we're only looking at the part that we care about. We can filter by cost and do many other things that just – you can't do right off the bat in SSMS.
Another easy way of figuring out where your problem is by doing this cumulative and then we can easily see which lag of the query we actually need to look at and the bigger then queries get, the more we can easily roll out to find the problems that we're looking for. So let's change it back to pro note, let's see line width, or we can change it to data size. So with a single click, just making very, very simple changes and now we're looking at total data coming back instead of number of rows.
So once again, this tool is free from SentryOne. I'm not a spokesperson from SentryOne, I know a few people that work there and they'll probably appreciate if you use their product but when it comes to Plan Explorer, you can just go to their website and download it for free. No email address required so they're not going to spam you with a whole bunch of emails asking you to buy the rest of their products. This is just something that they offer to the community. I believe Aaron Bertrand added a link to your Slack channel, which includes a full webinar on Plan Explorer. There is just so much more that we can talk about when it comes to Plan Explorer that we just won't have the time. Like this whole index analysis tab, we can probably spend the whole hour just going over what they can show you on index analysis.
But – so this is just one of the tool you use and it's something that can help you with development. And of course, when working with the big stored procedures, a lot of times we go for this low-hanging fruit where we see most of our time being spent and we can tune it pretty quick. But when the time is spread all against multiple statements, then it becomes a little harder because you have to tune each statement instead of just finding one statement that causing the most offense. That will be it.
Let's go back to slides that we went over everything, and of course, I didn't click on the right slide. So tools, so everything – so the Visual Studio, there's a community edition that you can download completely for free, this is one of the links you can go through. There are some restrictions when it comes to using it in your organization, so you can't just download it and use for your business but you can use it for personally, and of course SQL Server developer edition.
One of the companies I worked for previously actually had – gave me a MSDN license so it was really easy for me to get all the things that I needed. Without having MSDN license, it becomes a little more complicated when you're trying to run presentations and you need a SQL Server. So what do you do? Well, you would just download either express edition or evaluation. With SQL Server 2016 develop edition being free, now you can download it – you still have to jump through some hoops to get it and there's multiple blog posts on multiple ways you can get developer edition downloaded for free.
Time for Q&A, so I believe we actually ran a little quicker than estimated, probably because…
Brent Ozar: You're doing good, you're doing good. It's always – timing online ones is always trickier and a lot of people ran early today too. Samuel says, "Does LINQPad have IntelliSense?"
Vladimir Oselsky: Yes, when it comes to LINQPad, there is option for IntelliSense, but unfortunately it's a premium feature that you would have to buy. The cost is not that much, but it would just be a little bit extra.
Brent Ozar: Got you. Teddy says, "Did you show that when you right-click on a query plan in Management Studio, it'll open in SQL Sentry Plan Explorer?" He loves that so much he didn't…
Vladimir Oselsky: No, I didn't show it and there's actually one of the – there is a reason why not to use it, so let me go back to temp tables. I don't have the plug in on it. If you execute the plan in the SSMS and then you move it to Plan Explorer, some of the data will not be populated. So it's always better to execute the query out of the Plan Explorer because then you get additional information that they capture while running it. Otherwise you won't get it. One of the things – I mean, I also like about Plan Explorer, and you were talking about posting to your website, they offer you an option to anonymize your code. So then it'll take a second – my computer is thinking. It should be one of those buttons that says do not press during…
Brent Ozar: During live presentation.
Vladimir Oselsky: During live presentation. Alright, so now that execution plan no longer has any of your proprietary information. So you will see use database one, variable, column names, so now you can still show the plan XML and you can share that XML through Brent Ozar, Paste the Plan without exposing any of your schema information and also you won't be exposing the command you're running. People will still be able to read your command but at least they won't be able to know what those objects are.
Brent Ozar: If anyone ever sends me a query that looks like that to troubleshoot, I'm going to give you the finger, and it's not going to be the index finger. Who wants to read that? That's heinous.
Vladimir Oselsky: Well, at least you can still see the joins and if somebody has a cross join here you can just smack him and say well, fix that cross join before you send me the query. But at least it can be helpful when you're sharing online and you don't want to give more information. Plus, they give you an option to post to SQL performance, which one of the places that Aaron Bertrand lives on. At one point I thought Aaron Bertrand was a hive of people because every time I saw somebody posting a question on Stack Overflow, before the question was even posted Aaron Bertrand already had the five-paragraph answer on what was wrong with their SQL statement.
Brent Ozar: Yes, he is really – yes, really quick with that stuff. Well, thank you very much, sir. We really appreciate you taking the time to present today. I want to thank everybody from the audience for handing out with us today, thanks for hanging out on Friday, April the 21st. Great presentation Vladimir and have a great weekend everybody. We really appreciate you hanging out with us this weekend.
Vladimir Oselsky: Alright, thank you so much and if you have any questions, send them to my email address. You can look me us on Twitter, LinkedIn and can check out my blog. It doesn't have too many things but once in a while I post something just – it's more about trying to keep my own skills sharp and trying to remember stuff that I solved so that I can find in the future. So thank you so much.
Vladimir Oselsky
Latest posts by Vladimir Oselsky (see all)
- Crash Course on Better SQL Development - April 21, 2017


text:
The Characters
The Timeline
An Excerpt
Feedback Forum
About the Author
Useful Links
About Grand Oak Books
Acadia Lost: a Novel
by A.M. Hodge
A remarkable tale, vividly told of living characters facing extreme conditions, this book will leave you wanting more....I came to learn how many North Americans can trace their roots back to this period of violence and dislocation and to understand that the what happened to the Acadians could and did happen to others throughout the centuries. This is a novel that transcends its message and becomes a lesson for all ages. --
Stephen R. Pastore, author of Guilt, Never on These Shores and Time and Other Stories.
powered by Network Solutions®


text:
tag:blogger.com,1999:blog-1730550333811416772.post6735527134113675549..comments2020-01-17T08:25:21.722-05:00Comments on Bye Felicia ... Hello Life!: "The One with More Mendacity"Felicia Lifehttp://firstname.lastname@example.com:blogger.com,1999:blog-1730550333811416772.post-70842106652282909462018-06-23T01:36:19.832-04:002018-06-23T01:36:19.832-04:00Howdy! I could have sworn I've been to this si...Howdy! I could have sworn I've been to this site before but
after reading through some of the post I realized it's new
to me. Nonetheless, I'm definitely delighted I found
it and I'll be bookmarking and checking back firstname.lastname@example.com:blogger.com,1999:blog-1730550333811416772.post-21758950079695290582018-05-29T10:32:14.675-04:002018-05-29T10:32:14.675-04:00Wow. That is such a crazy story and I couldn't sto...Wow. That is such a crazy story and I couldn't stop reading. Great post!Sarahhttp://email@example.com:blogger.com,1999:blog-1730550333811416772.post-53577888605546982922018-05-26T13:20:35.741-04:002018-05-26T13:20:35.741-04:00Wow what a story. You should also right books you ...Wow what a story. You should also right books you could start a firstname.lastname@example.com:blogger.com,1999:blog-1730550333811416772.post-4727336422771870062018-05-26T11:23:53.829-04:002018-05-26T11:23:53.829-04:00At the beginning of your book-worthy stories, we a...At the beginning of your book-worthy stories, we all felt bad and sad, while admiring your strength. After this one, whoah! You are blessed to have seen the selfish scumbag hiding behind the suit. Too bad, you, and more importantly, the children had to go through so much pain for a life lesson like this one.Ana Marie Warrenhttps://email@example.com:blogger.com,1999:blog-1730550333811416772.post-67891856360231010502018-05-26T07:47:44.270-04:002018-05-26T07:47:44.270-04:00This is insane ! This guy is bad news. I feel like...This is insane ! This guy is bad news. I feel like Im watching a tv saga !firstname.lastname@example.com:blogger.com,1999:blog-1730550333811416772.post-50997839945402080942018-05-26T05:19:04.187-04:002018-05-26T05:19:04.187-04:00Sorry you had to go through this but I'm glad ...Sorry you had to go through this but I'm glad you've made some5hing positive out of it. Keep writing!Sam Kenyonhttps://email@example.com:blogger.com,1999:blog-1730550333811416772.post-6975229316779157762018-05-25T15:40:48.286-04:002018-05-25T15:40:48.286-04:00So deceitful! I am so sorry you had to go through ...So deceitful! I am so sorry you had to go through this. My mind would be racing!Gracehttp://email@example.com:blogger.com,1999:blog-1730550333811416772.post-15362079246244677192018-05-25T13:32:14.085-04:002018-05-25T13:32:14.085-04:00Glad you're always looking for lessons learned...Glad you're always looking for lessons learned through such adversities! firstname.lastname@example.com:blogger.com,1999:blog-1730550333811416772.post-75094307117258872672018-05-25T11:58:13.508-04:002018-05-25T11:58:13.508-04:00Wow what a crazy story. I had trouble following a ...Wow what a crazy story. I had trouble following a bit of it but that may be from starting w this article and not at the beginning. Mistyhttp://firstname.lastname@example.com:blogger.com,1999:blog-1730550333811416772.post-57744876398690532632018-05-24T13:40:57.079-04:002018-05-24T13:40:57.079-04:00Unbelievably very deceitful. I wonder if you can ...Unbelievably very deceitful. I wonder if you can relate this to your "Trumpster" post as well. I can't wait for the next one.Tina Rutger, email@example.com:blogger.com,1999:blog-1730550333811416772.post-52984031663546214762018-05-24T11:29:20.715-04:002018-05-24T11:29:20.715-04:00Your stories could be a series! There are characte...Your stories could be a series! There are characters you root for and characters that make you want to pull your hair!
Next one please!Jeorgina Padhttps://firstname.lastname@example.com:blogger.com,1999:blog-1730550333811416772.post-7788422023080743842018-05-24T11:19:19.954-04:002018-05-24T11:19:19.954-04:00It seems that this guy has a very shady history, n...It seems that this guy has a very shady history, not just with women, but also with work.
I'm sorry you had to go through so much because of his selfishness. He did provide you great material for writing.MontanaPhDhttps://firstname.lastname@example.com:blogger.com,1999:blog-1730550333811416772.post-73833972881228086832018-05-23T23:36:07.041-04:002018-05-23T23:36:07.041-04:00Just when you thought it/he couldn't get worse...Just when you thought it/he couldn't get worse. Can you imagine if you discovered all these when you're already married?! It's good that you're seeing this now as a you being fortunate enough to escape a email@example.com:blogger.com,1999:blog-1730550333811416772.post-78515275519359053522018-05-23T22:59:18.222-04:002018-05-23T22:59:18.222-04:00Whoah! This character is really bad news. What a f...Whoah! This character is really bad news. What a fraud!Julianne firstname.lastname@example.com


text:
Lucy Anne Cooper was the second of five children born to Sir Richard Powell Cooper and Elizabeth Anne Asmall. Sir Richard was the first baronet of Shenstone Court; an honour bestowed on him in 1905 by Edward VII in recognition of his contributions to agriculture. There is little known about the early life of Lucy Anne. The autobiography of MRD Foot, Lucy's step-grandson, states that she went to Cape Town in search of a husband and there in May 1902 she married (then Major) Richard Mildmay Foot, whose first wife had died seven years before. Richard Foot had two children from his first marriage; Richard Cunningham Foot and Linsey Kathleen Foot.
A few years after their marriage Lucy and Richard Foot moved to White Hill, Berkhamsted, which was owned by the Cooper Family and was located close to Berkhamsted Castle i.e. to the east of the road also called White Hill.
Richard, who had been promoted to the rank of Brigadier General, died in 1933 shortly after his 67th birthday when Lucy was 57 years old. Shortly after his death, Lucy installed a Seat of Remembrance by his grave.
After her husband's death, Lucy, who was always known as Dolly, continued to live at White Hill. She was a keen dog-owner, having three Cairn terriers and a breeder of greyhounds. She continued with the breeding of the Beorcham line of prize-winning Irish Setters which had been started by her husband, including the renowned 11-year-old sire Beorcham Blazes, veteran at Crufts 1935. In addition, she was a well-respected farmer breeding cattle at Hamberlins Farm, Northchurch. According to Bucks Herald 23rd July 1937, 'Mrs Foot escorted a tour of international sheep farmers arranged by Thomas Cook & Son Ltd … to see her famous prize-winning Jerseys Red Poll milking herd'. She specialised in producing milk low in tuberculosis bacilli. It is recorded that during World War II (WWII) this milk was purchased by Madame De Gaulle while she lived close to Ashridge with her daughter.
It was during WWII that Lucy received a letter from the Hertfordshire War Agricultural Executive Committee (HWAEC) instructing her to plough and sow wheat on part of Northchurch Common. She initially refused to do so, saying that it had been common land since before the Normans came. The reply from the HWAEC threatened jail if she did not comply with their request. Consequently, she did agree and according to MRD Foot, "produced 3 excellent crops of wheat".
In September 1946, following a minor operation at a London Clinic, Lucy unexpectedly and suddenly died. She was buried in the same grave as her husband, located between the Cooper Memorial and the central arch.
Following Lucy's death, White Hill was taken over by the Cooper family, who sold it to a builder. According to MRD Foot, the builder made sure the house burnt, felled all the trees, built 17 houses and then died.
The Bucks Herald 27th September 1946 announced that 'The Death of Mrs L A Foot of Berkhamsted, well-known cattle breeder and exhibitioner is a sad loss to the farming community of this district. She had proved herself a sound businesswoman, a keen breeder of pedigree cattle and an active worker for the NFU. Mrs Foot followed her father's example with a life-long practical interest in agriculture. In 1917 she took over Church Farm, Great Gaddesden and in 1925 she established the model dairy farm at Hamberlins, one of the finest 'clean milk' farms in the country.'


text:
Thanks to youtuber dondrapersayswhat's uncanny ability to memorise the exact moments in movies where characters speak certain words, we now have a mash-up of Mark Ronson and Bruno Mars' Uptown Funk composed completely from the lines of over 280 movies.
The mashup features all the classics and works surprisingly well, we can't seem to get enough.
Now that's pretty funk'd up!


text:
I've finally finished off my unit the new plastic Boar Boyz. I decided to do 15 of them, and it ended up taking me a few weeks (mostly because of school taking up so much time). Anyway, they're done, and I really like how they turned out. I used the GW painting article as a basic guide, but deviated in a few areas. The one disappointing thing is how these guys rank up... or rather, don't rank up. You basically can't get them to go together end to end, so I had to make the movement tray longer. I guess heroic scale is creeping again.
Here are a few pics, but a full batch of work in progress shots as well as a complete list of paints are posted at miniwargaming.com.
Again, check out the full article (way more pictures and list of paints) over at miniwargaming.com (free article, no login required).


text:
San Diego Premiere: The Case of The Stolen ElectionFeat. Greg Palast Live
Join me on Tuesday, May 1 at 6pm at the University of San Diego for the SoCal premiere of the #TrumpStoleIt update of The Best Democracy Money Can Buy: The Case of the Stolen Election.
After the screening Greg Palast and the crew from KNSJ Radio will answer your questions.
At the event, we'll also memorialize Greg's mom, San Diego activist Gladys Palast, who passed away last Monday. Read more


text:
High-fives went to three senior Hurley Pediatrics residents Dec. 13, 2017, when match results were announced nationwide for pediatric fellowships.
Three Hurley seniors are headed to fellowships around the country:
- Nadine Peart MD. Pediatric Infectious Diseases Fellowship, Johns Hopkins University, Baltimore, Md.
- Komalben Parmar MD. Pediatric Endocrinology Fellowship, University of Connecticut, Hartford, Conn.
- Dunya Mohammad MD. Prematched to Pediatric Nephrology Fellowship, Wayne State University/Children's Hospital of Michigan, Detroit, Mich.
"A huge, huge congrats - we are so proud of them," said Program Director Mona Hanna-Attisha MD MPH.
According to the National Resident Matching Program's 2018 Medical Subspecialty Matching Program report for Internal Medicine and Pediatric Residency graduates, 4,242 (77.3%) of certified applicants matched to a medical subspecialty in 1,716 programs that are enrolled in the matching service. (Some programs recruit outside of the match.) Of the 1,657 certified programs, 1,318 (79.5%) programs completely filled their positions, while 4,242 (87.8%) individual positions were filled.
National matching results for some of the above-listed fellowships include:
- Endocrinology (all subpspecialty programs, including adult and pediatric): 86% (267) of its applicants matched to this specialty.
- Infectious diseases: 93% (313) of its applicants matched to this specialty.
- Nephrology (all subspecialty programs, including adult and pediataric): 96% (271) of its applicants matched to this specialty.


text:
If you are travelling before we leave the EU, there are no changes to the cover your policy provides.
If we leave the EU and it is without a deal, you will then need a Green Card.
It's important to note that some of the requirements in this article might change, depending on what terms are decided when the UK leaves the EU: You can view official Brexit updates from GOV.UK. What is a Green Card?
A Green Card is a document that can be presented to law enforcement officers when needed, it provides proof of insurance. It is a physical document, printed on green paper and cannot be issued in an electronic format.
Do I need a Green Card?
If you are travelling to Europe (including Ireland) you will need a Green Card.
I need a Green Card, what do I do and what happens next?
Call our customer services team as soon as possible, it could take up to four weeks to issue so please call us as soon as you know your travel plans. We will need to know
There is no charge for the Green Card, once processed we will send this to you, make sure you take the Green Card and your insurance certificate with you on your travels Where can I get more information?
The Association of British Insurers (ABI) has provided some useful information, click here to find out more.


text:
Every country has its own set of beliefs and superstitions, and Vietnam is no exception. Just like its other Asian counterparts, these superstitions are very notable during the Lunar New Year festival. "You're not suppose to cry or be sad during the New Year's days, it'll bring you bad luck." Cleaning is also out of the question and apparently you should eat certain food for luck.
For other times of the year, there are a plethora of superstitious "dos" and "don'ts" which most people here in Vietnam do generally comply. Trying to make sense of it all is quite a difficult task as Western ideologies and science can't explain it. We've compiled a list below of interesting Vietnamese superstitions:
• You should avoid drinking a lot of beverages with ice as ice is believed to cause a sore throat and lead to sickness.
• If you come across a wedding its consider bad luck, however if you happen to come across a funeral, it's good luck.
• Avoid wearing a white band, scarf, or cloth around your head as it is symbolic of death, which is why mourners wear white clothes around their heads at funerals.
• Vietnamese people also believe it is a very bad idea to play with your shadow and often reprimand children for doing so.
• You also shouldn't shower after eating or late at night as it can caused significant illness.
• Some people sleep with knives under their pillow as a means to ward off evil or unwanted spirits.
• Don't bang your utensils or chopsticks against your bowl as it is believed to call spirits.
• Also be wary of numbers as it can influence your luck. This is why many car owners strive for license plate numbers that are considered good or lucky.
Joining Halong Bay Heritage Marathon, a breath-taking route, runners will have the unique chance to see stunning attractions of a World Heritage Site.
Address: DHA Vietnam, 2nd floor, V+ mall, Hoa Binh Green City Building, 505 Minh Khai street, Hai Ba Trung district, Hanoi, Vietnam.
Mobile:+84 97 818 5561 (Monday to Friday, from 9:00 a.m. to 5:00 p.m.; Hanoi time GMT+7)
Email: email@example.com