August 5, 2016 at 9:50 am
BLOB_EATER (8/5/2016)
I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of knowledge.My question is ( for you speakers out there ) when you select a topic to talk about is it something that you know absolutely 100% everything about? Or do you know "enough" to present some material and present it well ? I am just curious...
Funny thing -- when I went to my first few SQL Saturdays, I knew I wanted to contribute, but I wasn't sure how. I was a little intimidated about presenting a SQL topic at first, because I figured that a lot of attendees probably knew a lot more about SQL Server than I do.
I started presenting about stuff I knew and was fairly passionate about (lots of good comments here, BTW). It wasn't necessarily about SQL (I've been presenting mostly on the professional development track), and so far, it's worked out pretty well.
I'm also trying to put something together that would be geared toward beginner SQL people -- people who don't know much (if anything) about SQL Server, but want to learn more. I figure that's something I can handle.
Also, it's one of the reasons why I started my 'blog. I use my 'blog to supplement my presentations. Also, I figure that my 'blog could potentially spark some ideas that I can talk about.
I even wrote a 'blog article about how I became a SQL Saturday speaker[/url]! 🙂
Hope that helps!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 5, 2016 at 9:55 am
ChrisM@Work (8/5/2016)
More likely too focussed on the subject to recognise what the antagonist was up to 😀
That does sound like me! :smooooth:
August 5, 2016 at 10:42 am
BLOB_EATER (8/5/2016)
I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of knowledge.My question is ( for you speakers out there ) when you select a topic to talk about is it something that you know absolutely 100% everything about? Or do you know "enough" to present some material and present it well ? I am just curious...
No such thing as 100%. I sometimes pick topics I know well, sometimes pick other interesting things to me. I sometimes get topics given to me :w00t:
In all cases, I do a lot of research and testing. However, I always go up in front of people expecting someone will know more about at least part of the topic than I do.
August 5, 2016 at 10:44 am
jasona.work (8/5/2016)
A thought I had the other day, reading another of Steve's postings on the SQL Saturday thing. Keep in mind, I've been to one, so if this does happen at others, feel free to point and laugh...What about, when it comes to sessions, having a panel-type session? Bring in several local people to be on the panel, regardless of skill level, and turn them loose to both discuss interesting problems and how they've solved them and take questions from the attendees? Rather similar to what goes on at various other types of conventions (admittedly, I don't think you'd be able to ask a DBA what the best part of working with John Barrowman / Steve Buscemi / Mark Hamil / Margo Robbie was, but...)
By having both seasoned DBAs and newer DBAs, you'd also get a decent discussion with explanations of either why the problem was solved that way, or what a possible better method might be.
Just a random thought...
Panels are hard. They can sometimes work well, but some speakers are very opinionated, some like to talk, and most people have trouble focusing and being succinct.
Good panels need a strong moderator to manage the process, but they often do produce very interesting discussions. I suggest having a few items to talk about in case it's hard to get questions from the audience.
August 5, 2016 at 10:52 am
jasona.work (8/5/2016)
SQLRNNR (8/5/2016)
jasona.work (8/5/2016)
So, something completely different!Movie review of the new Bourne movie (kept short)
Pros: Decent enough typical action movie.
Cons: Oh god the mangling and mis-use of techie! When during a very early scene in the movie someone commented (in subtitles) "we'll corrupt their database with SQL" I had a bad feeling. Which was confirmed about 15 seconds later in the same scene as to just how well they'd done their homework on the tech side of things...
My inner cynic very quickly became my outer cynic at the point when a social-media type company (think Facebook'ish) was claiming they'd have a system where "all your information would remain private" (As a co-worker has told me, if a company is giving something to you for free, you're the product.)
Would I go see it again? Not even if it was on TV for free.
Do I regret the money spent to see it? Nah, it was a night out with the wife, and movie popcorn!
Why does movie theater popcorn seem to taste so much better than when you're at home and make popcorn (excluding actually putting oil in a pan and tossing in the popcorn kernels, I'm talking bagged microwave popcorn, which means I probably just answered my own question, didn't I?)
To be a bit pedantic the quote was "Use SQL to corrupt the database". It was overly simplified for the non-techie movie goer and did depict a penetration and hack attempt from a collective - imho. Technically the statement is correct. You can use SQL to corrupt a database. I know of more than a handful of ways to do that.
My wife and I chuckled at the "private" data for a social media company that is gathering all of your bio data, preferences, habits, travel patterns etc. That part of the story line was very much like a few books I have read.
Oops. I saw the movie opening weekend, so I'm not too surprised I mis-recalled the quote. Although, I guess whether it could be considered correct or not depends on how you define "corrupt." Scratch that. If you replace existing data with incorrect data, it would be considered "corrupt," I was thinking of data file corruption (ie, such as when you use a hex editor to play with the MDF.)
As for the private data, yeah, as people keep getting told, and keep not paying attention too, anything you put anywhere on the internet is *not* "private" in any way, shape, or form. *Someone* is profiting from your information. You really want to mess with Facebooks algorithms? Either "like" absolutely every single page that you come across that has a "like" button, no matter what it's for (accidently came across a page dedicated to "Nazi lesbian hookers in love with furniture" page? LIKE it!:w00t: {BTW, that reference is lifted from the movie "UHF" and should be "...hookers abducted by aliens and forced into weight loss programs."}) or never, ever "like" anything.
And even then, they'll figure stuff out from your posts, so don't post anything, either.
Then, they'll figure stuff out from your friends, so don't befriend anyone.
Then, they'll figure stuff out from your location and pages you visit the most, so don't go online. :hehe:
August 5, 2016 at 11:27 am
Luis Cazares (8/5/2016)
jasona.work (8/5/2016)
SQLRNNR (8/5/2016)
jasona.work (8/5/2016)
So, something completely different!Movie review of the new Bourne movie (kept short)
Pros: Decent enough typical action movie.
Cons: Oh god the mangling and mis-use of techie! When during a very early scene in the movie someone commented (in subtitles) "we'll corrupt their database with SQL" I had a bad feeling. Which was confirmed about 15 seconds later in the same scene as to just how well they'd done their homework on the tech side of things...
My inner cynic very quickly became my outer cynic at the point when a social-media type company (think Facebook'ish) was claiming they'd have a system where "all your information would remain private" (As a co-worker has told me, if a company is giving something to you for free, you're the product.)
Would I go see it again? Not even if it was on TV for free.
Do I regret the money spent to see it? Nah, it was a night out with the wife, and movie popcorn!
Why does movie theater popcorn seem to taste so much better than when you're at home and make popcorn (excluding actually putting oil in a pan and tossing in the popcorn kernels, I'm talking bagged microwave popcorn, which means I probably just answered my own question, didn't I?)
To be a bit pedantic the quote was "Use SQL to corrupt the database". It was overly simplified for the non-techie movie goer and did depict a penetration and hack attempt from a collective - imho. Technically the statement is correct. You can use SQL to corrupt a database. I know of more than a handful of ways to do that.
My wife and I chuckled at the "private" data for a social media company that is gathering all of your bio data, preferences, habits, travel patterns etc. That part of the story line was very much like a few books I have read.
Oops. I saw the movie opening weekend, so I'm not too surprised I mis-recalled the quote. Although, I guess whether it could be considered correct or not depends on how you define "corrupt." Scratch that. If you replace existing data with incorrect data, it would be considered "corrupt," I was thinking of data file corruption (ie, such as when you use a hex editor to play with the MDF.)
As for the private data, yeah, as people keep getting told, and keep not paying attention too, anything you put anywhere on the internet is *not* "private" in any way, shape, or form. *Someone* is profiting from your information. You really want to mess with Facebooks algorithms? Either "like" absolutely every single page that you come across that has a "like" button, no matter what it's for (accidently came across a page dedicated to "Nazi lesbian hookers in love with furniture" page? LIKE it!:w00t: {BTW, that reference is lifted from the movie "UHF" and should be "...hookers abducted by aliens and forced into weight loss programs."}) or never, ever "like" anything.
And even then, they'll figure stuff out from your posts, so don't post anything, either.
Then, they'll figure stuff out from your friends, so don't befriend anyone.
Then, they'll figure stuff out from your location and pages you visit the most, so don't go online. :hehe:
Anyone know what happened to Luis? He's disappeared!
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
August 5, 2016 at 12:07 pm
I'm getting frustrated. http://www.sqlservercentral.com/Forums/Topic1807080-391-1.aspx
Drew
Edited to place the bold tags outside of the url.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
August 5, 2016 at 12:14 pm
drew.allen (8/5/2016)
I'm getting frustrated. http://www.sqlservercentral.com/Forums/Topic1807080-391-1.aspxDrew
And here's that link again, for those who don't want to open up a blank screen :w00t:
http://www.sqlservercentral.com/Forums/Topic1807080-391-1.aspx
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 5, 2016 at 12:46 pm
drew.allen (8/5/2016)
I'm getting frustrated. http://www.sqlservercentral.com/Forums/Topic1807080-391-1.aspxDrew
Edited to place the bold tags outside of the url.
Interesting topic. Thanks, Drew - I weighed in with my two cents (and probably way more than the OP ever wanted to hear ...)
August 5, 2016 at 12:52 pm
Hugo Kornelis (8/5/2016)
drew.allen (8/5/2016)
I'm getting frustrated. http://www.sqlservercentral.com/Forums/Topic1807080-391-1.aspxDrew
Edited to place the bold tags outside of the url.
Interesting topic. Thanks, Drew - I weighed in with my two cents (and probably way more than the OP ever wanted to hear ...)
That's a good response, Hugo.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 5, 2016 at 2:38 pm
BLOB_EATER (8/5/2016)
HA imagine the person trying to play stump the chump with Paul Randal? Oh I can see it now....
I told him once that he what he had just said was wrong. :w00t:
I then showed him his blog post (which was right) that contradicted what he just said. So I guess he was right before he was wrong.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 5, 2016 at 3:19 pm
jasona.work (8/5/2016)
SQLRNNR (8/5/2016)
jasona.work (8/5/2016)
So, something completely different!Movie review of the new Bourne movie (kept short)
Pros: Decent enough typical action movie.
Cons: Oh god the mangling and mis-use of techie! When during a very early scene in the movie someone commented (in subtitles) "we'll corrupt their database with SQL" I had a bad feeling. Which was confirmed about 15 seconds later in the same scene as to just how well they'd done their homework on the tech side of things...
My inner cynic very quickly became my outer cynic at the point when a social-media type company (think Facebook'ish) was claiming they'd have a system where "all your information would remain private" (As a co-worker has told me, if a company is giving something to you for free, you're the product.)
Would I go see it again? Not even if it was on TV for free.
Do I regret the money spent to see it? Nah, it was a night out with the wife, and movie popcorn!
Why does movie theater popcorn seem to taste so much better than when you're at home and make popcorn (excluding actually putting oil in a pan and tossing in the popcorn kernels, I'm talking bagged microwave popcorn, which means I probably just answered my own question, didn't I?)
To be a bit pedantic the quote was "Use SQL to corrupt the database". It was overly simplified for the non-techie movie goer and did depict a penetration and hack attempt from a collective - imho. Technically the statement is correct. You can use SQL to corrupt a database. I know of more than a handful of ways to do that.
My wife and I chuckled at the "private" data for a social media company that is gathering all of your bio data, preferences, habits, travel patterns etc. That part of the story line was very much like a few books I have read.
Oops. I saw the movie opening weekend, so I'm not too surprised I mis-recalled the quote. Although, I guess whether it could be considered correct or not depends on how you define "corrupt." Scratch that. If you replace existing data with incorrect data, it would be considered "corrupt," I was thinking of data file corruption (ie, such as when you use a hex editor to play with the MDF.)
Well, there is this really cool command in tsql that can cause corrupt pages. Corrupt the boot page and the database is jacked up. 😉 I would classify corrupt pages as pretty significant (not just injected data or altered data). CheckDB will flag the pages as corrupt and give the usual corruption warnings. Practice the command enough, and you can't do anything but restore the database after you mess with it.
Well, you could do something because you know what you did. But the target would likely have to call in somebody to recover data or just go for a database restore.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 5, 2016 at 7:21 pm
Phil Parkin (8/5/2016)
Hugo Kornelis (8/5/2016)
drew.allen (8/5/2016)
I'm getting frustrated. http://www.sqlservercentral.com/Forums/Topic1807080-391-1.aspxDrew
Edited to place the bold tags outside of the url.
Interesting topic. Thanks, Drew - I weighed in with my two cents (and probably way more than the OP ever wanted to hear ...)
That's a good response, Hugo.
Perhaps not. Sometimes, there are no choices despite what we think. There is a way here but, before you can think outside the box, you must first realize... you're in a box. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2016 at 7:24 pm
drew.allen (8/5/2016)
I'm getting frustrated. http://www.sqlservercentral.com/Forums/Topic1807080-391-1.aspxDrew
Edited to place the bold tags outside of the url.
The OP isn't bagging what you're raking. It may be time to break out the ol' silver platter. 🙂 One good demonstration is worth a thousand thought processes. The OP DID post readily consumable code. Should be an easy demo for anyone that wants to.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 6, 2016 at 2:31 am
Jeff Moden (8/5/2016)
drew.allen (8/5/2016)
I'm getting frustrated. http://www.sqlservercentral.com/Forums/Topic1807080-391-1.aspxDrew
Edited to place the bold tags outside of the url.
The OP isn't bagging what you're raking. It may be time to break out the ol' silver platter. 🙂 One good demonstration is worth a thousand thought processes. The OP DID post readily consumable code. Should be an easy demo for anyone that wants to.
Not until we are sure what the actual specs are supposed to be. Otherwise we may be silver-plattering him the correct answer to the wrong question.
Viewing 15 posts - 55,246 through 55,260 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply