October 27, 2010 at 11:05 am
Jack Corbett (10/27/2010)
Grant Fritchey (10/27/2010)
To the Threadizens/Threadites/Threadoids/Threadopians:Please, make sure, if you're going to the Summit, you track me down and introduce yourself in person. Some of you I know already, Dixie,Jeff,etc., but some of you I've never met. I'm going to be all over the place, but I really want to meet you people for the first time, or again. If nothing else, I'll be working as a Amabassador for the keynote on Tuesday. Look for the tall bald guy in a red vest.
You mean we won't all be meeting at the SSC party on Monday Night?:-D
I'll be there, I just don't know who else will be. Shame that the volunteer/speaker party is at exactly the same time, but I know where I'm going.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2010 at 11:07 am
I'll drop some topics out here for you. Here's a couple that I have saved up:
- Finding/changing the default backup location
- scheduling a trace
- duplicating the default trace, but larger in size.
- read db files, get logical name, automate restore
- How distinct works in a query with multiple columns
- Ordering months by number (1, 2, 3), but displaying name in a query (Jan, Feb, etc.)
- Find top xx results for each group of a result set. So perhaps top 3 finishers in a race for each class, where the data is in one table and there are multiple classes
First come, first server
October 27, 2010 at 11:08 am
Grant Fritchey (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Excellent. If you want to write on something, might post a note here so we don't have collisions. Good to get a 1-2 pager on common stuff that can be used to answer questions.But is someone going to point out the topics that need it? Like you bringing back the auditing topic we'd need a mechanism (the Thread, clearly) to bring this stuff up so that the thicker headed amongst us (me) know what to do.
In addition to a list of topics that need it, a way to claim those topics would also be good since, as Steve says, we don't want everyone to write the same article.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 27, 2010 at 11:09 am
Steve Jones - SSC Editor (10/27/2010)
BTW, speaking of technical stuff....I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on. Like our joyous person today that thinks there is some magical tool to audit the last time a table was accessed.
If you see something like that, and don't have an SSC reference, I'd love a 1 pager that solves the problem for future reference.
I see that we already finished this up in early 2011.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 27, 2010 at 11:11 am
Steve Jones - SSC Editor (10/27/2010)
Whew, for a second I thought I was going to learn something on The Thread.
OMG, someone grab the paramedics. Steve's going into shock because he almost learned something on The Thread!
October 27, 2010 at 11:13 am
Steve Jones - SSC Editor (10/27/2010)
I'll drop some topics out here for you. Here's a couple that I have saved up:- Finding/changing the default backup location
- scheduling a trace
- duplicating the default trace, but larger in size.
- read db files, get logical name, automate restore
- How distinct works in a query with multiple columns
- Ordering months by number (1, 2, 3), but displaying name in a query (Jan, Feb, etc.)
- Find top xx results for each group of a result set. So perhaps top 3 finishers in a race for each class, where the data is in one table and there are multiple classes
First come, first server
I just did something basic for work on the default backup locations... so I'll volunteer to tackle this one.
Questions about this in general:
1. How do we "submit" these "articles"?
2. How many versions of sql should it cover?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 27, 2010 at 11:13 am
Steve Jones - SSC Editor (10/27/2010)
I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on.
FYI: I'm "working up" a series of SSIS articles that address dynamic functionality or non-script functionality. I'll start sending them in as soon as I get them done. I've got paid spec work due on several other non-SQL projects, though, so I don't know when I'll have them for you.
October 27, 2010 at 11:16 am
WayneS (10/27/2010)
Questions about this in general:1. How do we "submit" these "articles"?
Look in the upper left hand sidebar. "Write For Us" has all the details. You'll have to click through a few links to get everything, though..
October 27, 2010 at 11:17 am
Steve Jones - SSC Editor (10/27/2010)
I'll drop some topics out here for you. Here's a couple that I have saved up:- Finding/changing the default backup location
- scheduling a trace
- duplicating the default trace, but larger in size.
- read db files, get logical name, automate restore
- How distinct works in a query with multiple columns
- Ordering months by number (1, 2, 3), but displaying name in a query (Jan, Feb, etc.)
- Find top xx results for each group of a result set. So perhaps top 3 finishers in a race for each class, where the data is in one table and there are multiple classes
First come, first server
I'll take "Scheduling a Trace" Quick & easy one to get started. I'll take the order by Months thing too. Actually never done that (not that it seems all that hard), so it could be fun.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2010 at 11:32 am
Brandie Tarvin (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on.FYI: I'm "working up" a series of SSIS articles that address dynamic functionality or non-script functionality. I'll start sending them in as soon as I get them done. I've got paid spec work due on several other non-SQL projects, though, so I don't know when I'll have them for you.
The first SSIS item I had in mind was about how to send more than 65000 rows to older versions of Excel by using the Conditional Split in the data flow. This was going to include other uses for the same methodology.
Am I going to be stepping on your toes?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 27, 2010 at 11:37 am
Brandie Tarvin (10/27/2010)
WayneS (10/27/2010)
Questions about this in general:1. How do we "submit" these "articles"?
Look in the upper left hand sidebar. "Write For Us" has all the details. You'll have to click through a few links to get everything, though..
I guess I was reading into this that this would be a collaborative thing, with Steve coordinating / compiling it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 27, 2010 at 11:41 am
WayneS (10/27/2010)
Brandie Tarvin (10/27/2010)
WayneS (10/27/2010)
Questions about this in general:1. How do we "submit" these "articles"?
Look in the upper left hand sidebar. "Write For Us" has all the details. You'll have to click through a few links to get everything, though..
I guess I was reading into this that this would be a collaborative thing, with Steve coordinating / compiling it.
I'm sure that any group that wants to do a collaborative effort can. What matters is the output.
Edit: I'm guessing Steve is expecting the coordinating / compiling it to be done before he gets it.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 27, 2010 at 12:10 pm
Grant Fritchey (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Excellent. If you want to write on something, might post a note here so we don't have collisions. Good to get a 1-2 pager on common stuff that can be used to answer questions.But is someone going to point out the topics that need it? Like you bringing back the auditing topic we'd need a mechanism (the Thread, clearly) to bring this stuff up so that the thicker headed amongst us (me) know what to do.
Count me in for writing something as well if I know that topic... 😀
-Roy
October 27, 2010 at 12:31 pm
I'm in for Duplicating the Default Trace only Bigger. Run Grant's on Scheduling first and then I can link to it in mine:-D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 27, 2010 at 12:32 pm
Grant Fritchey (10/27/2010)
Jack Corbett (10/27/2010)
Grant Fritchey (10/27/2010)
To the Threadizens/Threadites/Threadoids/Threadopians:Please, make sure, if you're going to the Summit, you track me down and introduce yourself in person. Some of you I know already, Dixie,Jeff,etc., but some of you I've never met. I'm going to be all over the place, but I really want to meet you people for the first time, or again. If nothing else, I'll be working as a Amabassador for the keynote on Tuesday. Look for the tall bald guy in a red vest.
You mean we won't all be meeting at the SSC party on Monday Night?:-D
I'll be there, I just don't know who else will be. Shame that the volunteer/speaker party is at exactly the same time, but I know where I'm going.
Me too! I'm a bit disappointed that they are the same time. I know there are people at both I want to get together with.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 15 posts - 20,881 through 20,895 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply