October 27, 2010 at 12:40 pm
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.
Typically repeated posts like that trigger blog posts for me. I'll have to consider in future whether something is blog post or article material
For the record, my article writing plans for next year are:
Rewrite of the managing transaction log article
Help, my database is suspect
Principals of troubleshooting (this is gonna be hard)
Probably something on parameter sniffing (my blog posts on it are old and lacking detail)
That should keep me busy...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2010 at 1:17 pm
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
Steve,
I wonder if there would be a way to do something like this on the Write for us page... something like topics we'd like to see (but warn the people that if they want to write on something on this list, to check to make sure someone else isn't already working on it).
One of the problems I run into is coming up with ideas for articles. Seeing something that the site is interested in would be helpful for me.
About the top xx results one... I'd solve that with the dense_rank() and/or row_number() function that I covered in my Windowing Functions article.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 27, 2010 at 1:31 pm
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
To maybe add one to that (don't know if there's existing articles), there seem to have been a fair few datetime manipulation questions recently (last saturday of the month, 1st sunday of the month, etc)
Probably not much fun to write though.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2010 at 2:08 pm
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
Not sure, but would reading the original threads help us with any of the above? If so, do you have the links handy? The last one is one I could probably do.
October 27, 2010 at 2:12 pm
Ahhhhhhhhhh, overwhelmed already.
I'll try to look through here and do a short post in a bit capping off who might have what.
October 27, 2010 at 2:17 pm
Don't forget folks, NO plagiarism!!! 😀
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 2:31 pm
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
How about a forum subject for "article requests". That way, they won't get lost in the noise here.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 27, 2010 at 2:35 pm
how about :
- Anger management 101
- HowTo handle people "who don't know what, but want it now"
- Comforting for beginners
- HowTo tell you boss (s)he's a dumb a$$ without getting sacked.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 27, 2010 at 2:43 pm
ALZDBA (10/27/2010)
how about :- Anger management 101
The 100 classes haven't been helping... I think I need the 200 classes now. :w00t:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 27, 2010 at 3:03 pm
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'm planning to write about:
- Autonomous Transactions (I know that Paul White was planning on this and already had that convered on his blog. If he's willing to make an article of it, I'll pass on)
- Tracking changes on database objects
- Auditing stored procedures calls (I need Autonomous Transactions for this one)
-- Gianluca Sartori
October 27, 2010 at 4:26 pm
Steve Jones - SSC Editor (10/27/2010)
Ahhhhhhhhhh, overwhelmed already.I'll try to look through here and do a short post in a bit capping off who might have what.
In an effort to help our beloved overwhelmed editor, I've added who has mentioned what they'll be doing:
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 - Wayne
- scheduling a trace - Grant
- duplicating the default trace, but larger in size. - Jack
- 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.) - Grant
- 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
- SSIS: Send > 65000 rows to Excel - Alvin
First come, first server
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 27, 2010 at 4:31 pm
WayneS (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
Ahhhhhhhhhh, overwhelmed already.I'll try to look through here and do a short post in a bit capping off who might have what.
In an effort to help our beloved overwhelmed editor, I've added who has mentioned what they'll be doing:
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 - Wayne
- scheduling a trace - Grant
- duplicating the default trace, but larger in size. - Jack
- 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.) - Grant
- 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
- SSIS: Send > 65000 rows to Excel - Alvin
First come, first server
Wayne, are you volunteering to be editor? 😀
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 5:07 pm
Here's an idea that poped up in my head after reading Steve's request for suggested articles and thinking about Stefan Krzywicki's recent thread with Celko:
How about 2 editorial Articles:
1) ISO Standards and why they are important. (Maybe Celko could write it)
2) Why Proprietary features exists and the case for using them. (Maybe one the "Thread" regulars could write it)
Have the articles post on the same day.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
October 27, 2010 at 5:34 pm
Steve, I did a search (honestly, a brief one) about basic troubleshooting/optimizations for queries that I think would save a lot of headaches if I could just link some folks to it.
However, the only articles I seemed to find in the search were #932 and #938... and I'm getting Errors.
I assume there would be a need for an article of that nature? I know Paul White and a number of others have gotten very in depth with deep optimization about a specific thing, but I can't find a generic "Start here, check this, then that, then that" type of thing that a lot of newbie/volunteered DBA's could use.
I'll think about the list you've already posted and see if there's something in there I can tackle intelligently.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 27, 2010 at 5:55 pm
GSquared (10/27/2010)
How about a forum subject for "article requests". That way, they won't get lost in the noise here.
Good idea. I'll set one up
Viewing 15 posts - 20,896 through 20,910 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply