Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Critique - Common SQL Server Mistakes Expand / Collapse
Author
Message
Posted Monday, January 24, 2011 7:56 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:23 AM
Points: 13,923, Visits: 28,315
Based on most of the comments, I'm alone on this one, but what the heck, I'll stick my neck out.

I'm not crazy about it. I don't like the laundry list approach. I see that you identify the common issues, but I don't get a sense that you're going to tell me enough about them to get me to go to the session. I'd rather have a bit more traditional discussion style abstract.

There. Let the rock throwing begin.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1052826
Posted Tuesday, January 25, 2011 12:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 6,735, Visits: 8,495
Grant Fritchey (1/24/2011)
Based on most of the comments, I'm alone on this one, but what the heck, I'll stick my neck out.

I'm not crazy about it. I don't like the laundry list approach. I see that you identify the common issues, but I don't get a sense that you're going to tell me enough about them to get me to go to the session. I'd rather have a bit more traditional discussion style abstract.

There. Let the rock throwing begin.


rock pile -1 ( this should add some credit )

This might actually work in a formula like the chalk talk sessions at SQLPASS.
(especially because they were brought by respected members of the community)

5 minute topics highlighting hot spots that need your attention, with a change of subject and speaker every 5 minutes.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- 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
Post #1052890
Posted Tuesday, January 25, 2011 8:12 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:12 AM
Points: 31,210, Visits: 15,651
Grant Fritchey (1/24/2011)
Based on most of the comments, I'm alone on this one, but what the heck, I'll stick my neck out.

I'm not crazy about it. I don't like the laundry list approach. I see that you identify the common issues, but I don't get a sense that you're going to tell me enough about them to get me to go to the session. I'd rather have a bit more traditional discussion style abstract.

There. Let the rock throwing begin.


Fair point. I was hitting a number of misc items that get you into trouble, but that might not be a great approach.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1053180
Posted Tuesday, January 25, 2011 8:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:23 AM
Points: 13,923, Visits: 28,315
Maybe use the rule of three's like you suggested for mine? I thought it was a good idea.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1053243
Posted Wednesday, January 26, 2011 7:28 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:02 PM
Points: 35,397, Visits: 31,955
Grant Fritchey (1/25/2011)
Maybe use the rule of three's like you suggested for mine? I thought it was a good idea.


I'll certainly Google for it but what is the "Rule of Three's"?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1054348
Posted Wednesday, January 26, 2011 7:36 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:23 AM
Points: 13,923, Visits: 28,315
Jeff Moden (1/26/2011)
Grant Fritchey (1/25/2011)
Maybe use the rule of three's like you suggested for mine? I thought it was a good idea.


I'll certainly Google for it but what is the "Rule of Three's"?


Steve suggested that I use the "rule of three," basically list three things, "The top three sql server mistakes are...", "Three things people always drop the ball on are..." Not sure if you'll find it in Google.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1054349
Posted Friday, January 28, 2011 1:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 19, 2013 2:00 PM
Points: 183, Visits: 479
Steve Jones - SSC Editor (1/20/2011)
Good feedback on this, however I'm more wondering if you think the abstract is well written. Does it make you want to go, or not go, to the session?


I can't figure out who your audience is.

DBAs?

Developers?

Seems to be a hodgepodge mix from the topics.
Post #1055573
Posted Friday, January 28, 2011 2:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 6,735, Visits: 8,495
This could well be an appetizer kind of session.

Just get an overload of hotspot topics to pick a detailed session on the issues that got your interest.

Might even work very well for newbe and a refresh minded audience.

However, you might not be remembered due to the lack of details because of time constraints.


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- 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
Post #1055639
Posted Friday, January 28, 2011 6:04 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:12 AM
Points: 31,210, Visits: 15,651
More good feedback. I somewhat aimed this at accidental DBAs, but I think I've moved into development a bit and probably need to split this off to two sessions.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1055693
Posted Friday, January 28, 2011 8:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:06 AM
Points: 18, Visits: 216
Many accidental DBA's are developers and may be doing both roles.

Technically i'm a Stealth DBA (I do dba things cause we, as a company, need it...even though its not in my job description, and noone else is doing it).
Topics that bridge both worlds are VERY beneficial for me.

Plus, it can be a more holistic view of Sql Server. ie. Here is how developers and DBAs can coordinate to avoid the worst problems.

At the end of the day its all about the server running as fast and smoothly as it can while being as flexible to end users.


Post #1055699
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse