In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is SQL. Now let us start with basic of Microsoft SQL Server and how to work with it. I am a fan of MS SQL Server. It is easy to use, Developer Friendly, Best performance … Continue reading Starting with MS SQL Server
Hi Guys, When you generate a script to create a Stored Procedure, below three statements are generate by default. SET ANSI_NULLS on SET NOCOUNT on SET QUOTED_IDENTIFIER on Why do we need these. Why Management Studio thinks we would require these options. Let us understand each one of these one by one. SET ANSI NULL ON : … Continue reading SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.
Hello Guys, Lately, one of my friend asked me a Question, "If Delete is in progress and query get erred out or Timeout, will already deleted data will be rolled back, considering we do not have any transaction? " My previous Answer was NO, After I executed the below statements. I will create two tables, PkTable – Having … Continue reading Consequences of Timeout/Error on a Delete statement
It seems to be the most basic thing but this post is specifically to those who have just started or want to start their career in Database Domain. When you are a novice. You have only idea about what is a Database. But in practical life how companies are actually managing it? Let us start with … Continue reading A Basic Introduction of Database, Tables and SQL.
Since the day I wrote my first blog. My friends are eagerly waiting for just one topic. The Indexing. I was trying to avoid this one, as I believe there is lot already written about it. But I cant anymore, after all my life is at stake. :p Indexing is the most important thing to … Continue reading Clustered Index and related Interview Questions
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for previous blog: https://sqldose.wordpress.com/2015/08/30/how-sql-store-your-data/ ) But how SQL Server maintains information about the pages? How SQL Server know which page is free and which has been allocated? There has to be a metadata* for the above. … Continue reading GAM and SGAM
Longing for that dream villa vacation already? Square Mile has rounded up some of the world’s most jaw-dropping villas available to rent. You'll never want to hand back the key…
Make like 007 and escape to one of the jewels of the Caribbean. Set on a cliff overlooking the sea and facing a secluded cove, this house is everything you want from your dream island home. First built in the 1940s, it was later remodelled in the 1960s by the inspirational theatre designer Oliver Messel and was most recently renovated in 2014. The spectacular beachfront estate is simply magical with its deep balconies and verandas, coral stone terraces, pastel green shutters iconic from Messel and its grand private stairway leading directly to the cove’s sugary white sands. We also love that an 18ft speedboat is at the ready for our waterskiing whims! 10 bedrooms, sleeps 20; for more info, www.oliverstravels.com / +44 (0) 800 133 7999
This beautiful cottage couldn’t be better positioned right in the heart of a working tea plantation in the hills of Galle, overlooking the jungle to one side and the sea from the other. The house is spacious and quite literally the definition of ‘airy’ as the main living room is open to the skies with a tall tree erecting from a central orchid garden and growing through the roof’s quirky partial opening. In a nod to Galle’s rich colonial past, the romantic cottage has a terracotta tiled roof and baby-blue shutters. Our favourite touch is the beautiful veranda with a lily pond and stylish in-built sofas - the perfect spot from where to look over the tropical hills and enjoy a sundowner. 6 bedrooms, sleeps 12; for more info, www.sjvillas.co.uk / +44 (0)20 7351 6384
One of the most exclusive sole-use safari villas, Melton Manor is perfect for intrepid explorers looking for something really special to come back to after a long day of wildlife spotting. The contemporary luxury farmhouse has an air of old-world glamour with its colonial interiors and elegant verandas with fabulous bush and river views. Aside from having a private butler, wildlife tracking team, park ranger and 4X4 safari jeep for daily game drives, dining is also a big event. The in-house chef whips up the most delicious farmhouse dishes, served under the stars surrounded by romantic candlelight. 4 bedrooms, sleeps 8; for more info, www.capeportfolios.com / +44 (0) 808 234 2554
A staycation has never looked so glam until now. Hamptons chic meets Cornish cool at Little Polgarron, a newly opened five bedroom beach house on Booby’s Bay, north Cornwall. We love the Jill Stein interiors which have a light, airy coastal vibe and that all bedrooms have floor-to-ceiling sea views as well as freestanding baths. On a cloudy day, take refuge in the villa’s own cinema room for some old time classic screenings. 5 bedrooms, sleeps 10; for more info, www.simonescapes.com / +44 (0)1244 784152
Stark, bold and minimalist in design, Beachwood is the ultimate beachfront retreat with its stylish open-plan spaces and direct access to one of Costa Rica’s most exclusive beaches. We love the enormous floor-to-ceiling louvre doors which unveil spectacular sea views. Santa Teresa is renowned as a surfer’s paradise, but we’ll gladly keep it simple and have an in-villa massage and yoga session on offer, or better yet, just roll directly from the bed and onto the sleek day loungers by the infinity pool to enjoy the ocean breeze...The evening then promises lobster, freshly prepared by the private chef. Heaven! 4 bedrooms, sleeps 8; for more info, www.i-escape.com / +44 (0) 117 946 7072
An award-winning mansion in the hills of Girona, Mas Mateu is fit for a king. The sprawling 18th century estate with views of the Pyrenees is home to a wonderfully grand stone-built house, steeped in history and with a rustic, yet freshly renovated look. Spoilt for choice, the estate also has two further residences on the grounds, its own spa, infinity pool, football field, gym, wine cellar, private cinema room and even one of Europe’s top equestrian centres… the list goes on. What’s more, with private chefs on hand to prepare nightly Spanish feasts alfresco, as well as a sommelier, butler and concierge, guests need not lift a finger. 15 bedrooms, sleeps 18 + 14 (in the main house and two further residences); for more info, www.akvillas.com / +44 (0) 1242 547705
This sleek pad with a serious brag factor offers respite on party isle. It’s spacious, minimalist yet with funky, colourful interiors, and best of all, it seamlessly brings the outside in, with an open-plan living layout and panoramic sliding glass doors overlooking the island’s unspoilt landscape and out to the sea. With the latest technology as well, it has a Sonos sound system installed throughout, ideal for bringing the party home. 6 bedrooms, sleeps 12; for more info, www.sjvillas.co.uk / +44 (0)20 7351 6384
This utterly romantic 15th century converted mill house is the former holiday retreat of famous film director Sir David Lean, who first spotted the beautiful house and said, “all I want to do is lie down in the grass under an olive tree and look up through its silver-green leaves and gaze at the blue sky”. Now available to rent, the beautifully restored stone house has dramatic interiors where elaborate murals, grand stone arches and plush fabrics meet Provençal simplicity. With a secluded pool and vast manicured gardens, this is a truly special hideaway. 5 bedrooms, sleeps 9; for more info, www.sjvillas.co.uk / +44 (0)20 7351 6384
Needless to say, the region of Puglia in Italy’s heel has won our hearts, and bellies, over the last few years, and here’s our top choice for your next pied-à-terre while you’re in this sun-bleached part of Italy. The ever so stylish Villa Trullo is one of the most impressive places to stay in the region, with its iconic cluster of fully restored ‘trulli’ (or conical dwellings), overlooking a stunning pool. It sits on a large estate dotted with olive groves, almond, lemon, pomegranate and fig trees. Time to get fruit picking! 4 bedrooms, sleeps 8; for more info, www.oliverstravels.com / +44 (0) 800 133 7999
Synonymous with understated luxury, Villa Dolce is a firm favourite with VIPs and royals who love the villa’s sophisticated Mykonian style, but most of all, for its discreet, natural setting away from any watchful eyes. With four separate guest houses for extra privacy, the 600sqm property sits on a huge gated estate surrounded by the island’s rocky hills and features a gorgeous infinity pool and open air jacuzzi carved out of the cliff’s edge. It overlooks the gold sand Agrari Beach - one of the more quiet and exclusive parts of Mykonos, known to just a lucky few… 4 bedrooms, sleeps 8; for more info, www.brightbluevillas.com / +30 6944 796 796
Sometimes you come across some work that strikes a chord with your own work or beliefs. This was one of those moments. In his TEDxNYED video Jeff talks about using the best resources that are available and simply linking to them, instead of reproducing them. It does mean reassessing what education is, what format it takes, after all if you can access some of the best lectures in the world online, for free, (as I wrote about here and here) what is the value of sitting through someone else delivering the same topic without any interaction?
I think we should be tapping into what others are providing without having to repackage the material into the ‘corporate identity’ of an institution. Doing so simple seems a waste of time and effort, and doesn’t necessarily reward (not financially speaking; more citing and recognition) the original author. If we are working towards a vast educational community approach to resources, I feel we should be finding (and passing on) the best examples of material already produced, and not necessarily recreating them.
For example, I was recently passed a link to a site where someone was creating screencasts of how to use various software. The individual had won an award for this site. Fair enough, what he’s created is a good resource now, all very uniform. But it doesn’t really align with my own philosophy. Why not just create a wiki linking to the best you can find of other people’s screencasts of how to use software? It may look more different and dirty but I’d say possibly it gets learners thinking about a few things: they see that not everything useful has to come from a recognised, uniform resource; they as learners can go out and find material and they need to evaluate its credibility; they themselves can produce material to share; they can be part of the bigger community (for example, by editing the wiki linking to all these resources).
Just picking up on what Mark said above in terms of choosing between making yet another how to screencast or collecting the best of what’s out there and spending time reading and thinking rather than creating, I agree. I like the effects he cites in terms of
“they see that not everything useful has to come from a recognised, uniform resource; they as learners can go out and find material and they need to evaluate its credibility; they themselves can produce material to share; they can be part of the bigger community (for example, by editing the wiki linking to all these resources).”
Not that it totally relates here, but a while back on my blog I posted about the need to take photos of beautiful places we visit when we can gets tons of photos of those places already on Flickr with a CC license that would let us remix and reuse them. Now I know that I want pictures of my kids while they are actually snorkling in the Barrier Reef, etc. but I wonder sometimes why some have so much trouble with using what is already out there instead of re-creating it in yet another way.
It’s Friday, and I’m tired, so I hope that made some sense. Yes, we want our students to be creators and connectors, but we also don’t want them reinventing the wheel either.
Posted in advice, digital literacy, education, exciting, idea, informal learning, knowledge, learning, learning and teaching, lecturing, oer, open educational resources, personal learning environment, presentation, ted, video	| Tagged howard rheingold, jeff jarvis, mark morley, markuos, oer, online lecture, online lectures, open education, open educational resources, opened, social media colab, squire morley, squiremorley, use the best, will richardson	| 1 Reply
I came across Matt McKeon’s interesting article ‘The Evolution of Privacy on Facebook‘ today. It has an infographic for changes in privacy policy over time.
This tied in nicely with a video on Teacher TV that I’d watched the evening before, where school children at two different schools had the issue of online privacy when using social networking sites highlighted to them.
Posted in safety, social network, video	| Tagged mark morley, markuos, privacy, privacy settings, social network, social networking, social networking site, social networking sites, squire morley, squiremorley, teacher tv	| Leave a reply
I’ve started to become interested in digital storytelling. So when I found Bubblr by Pimpampum recently I was very interested at the possibilities. Bubblr is a comic strip based services that uses the Flickr API to allow you to search for and pull in Creative Commons licensed images to tell a story. The interface is pretty intuitive; do a search via the text box, choose images you like from the returned results and drag them onto the strip. Add an additional image by simply dragging another and dropping it to the right of the last image, and so on. (You can also add them before the last image by clicking the appropriate option.)
Once your strip is in place, you can add comic strip like speech bubbles, thought bubbles and narrative bubbles. When you’re happy, you can publish your strip to the archive. You just then need to put a title to your composition and add your name. (There’s an interesting warning – your boss might see your composition so be careful.)
Writing this post, I have realised some similarities between Bubblr and Vuvox Collage. So Bubblr not only has a digital storytelling use, but could be a presentation tool as well.
Posted in creative commons, digital storytelling, essay, flickr, idea, learning and teaching, online services, photos, presentation, quick technique	| Tagged bubblr, comic strip, creative commons, digital storytelling, flickr, mark morley, markuos, photographs, photos, pimpampum, squire morley, squiremorley, storytelling, vuvox, vuvox collage	| Leave a reply