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 12»»

Is Microsoft neglecting SMO? Expand / Collapse
Author
Message
Posted Saturday, March 5, 2011 12:07 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 12, 2014 11:01 AM
Points: 594, Visits: 2,580
Comments posted to this topic are about the item Is Microsoft neglecting SMO?


Best wishes,

Phil Factor
Simple Talk
Post #1073755
Posted Saturday, March 5, 2011 5:25 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 35,770, Visits: 32,435
What I wish is that Microsoft would stop ignoring T-SQL.

--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 #1073784
Posted Sunday, March 6, 2011 6:20 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 12, 2014 11:01 AM
Points: 594, Visits: 2,580
Maybe we should turn it around and list all the things that they spend way too much time and effort on, Jeff.


Best wishes,

Phil Factor
Simple Talk
Post #1073836
Posted Sunday, March 6, 2011 1:16 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 35,770, Visits: 32,435
Phil Factor (3/6/2011)
Maybe we should turn it around and list all the things that they spend way too much time and effort on, Jeff.


Good idea, Phil, except that list would be too long for a single thread. I'll just stick with they're not spending enough time on T-SQL...

We still have to use the Quirky Update to do certain previous row calculations. We still have to make a trip to DOS or some other trickery to export. We still have to resort to Tally Table logic to do splits and use FOR XML PATH to concatenate. We still have to use recursive CTE's or While Loop logic to build a simply hierarchical path. And we still can't skip header rows that are different than the body for BULK INSERT without some data loss. We still have to shift to another type of window to select more than one table for deletion. They went backwards on the Query Designer... you can get back to your original SSMS window without closing the designer. AND, there's still no straight forward method to print Query Designer diagrams. There's still no supported method for listing files in a directory never mind finding out their creation date, modification date, or size and there's still nothing to rename them or move them once they've been processed. Heh... and none of that even starts on SMO.

I could go on for an hour or two but that's a start.


--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 #1073900
Posted Sunday, March 6, 2011 4:08 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 24, 2014 2:02 PM
Points: 259, Visits: 716
I think you already know my answer--Yes PowerShell has been neglected in SQL Server 2008 R2 with almost no changes and we can only hope we see changes in Denali. In Denali we've seen a hint of several new cmdlets for managing HADRON. I think six HADRON related cmdlets were mentioned by various bloggers, but still nothing that covers basic-level day-to-day DBA tasks.

As for SMO, I don't have many gripes. Having spent considerable time working with SMO and other object models I feel that SMO is a wonderful object model. Yes, there are pieces of SMOs that are slow and yes there are a few pieces missing (easily remedied by adding synthetic properties using PowerShell), but this is nothing compared to other SQL Server related technologies (AMO, RMO, SSIS, SSRS). These areas have zero PowerShell coverage and some of their object models are difficult to use. The one that gave me the most pain was SSIS. The SSIS object model is clearly ported from a COM interface (several methods that do similar things differing in parameter types). In trying to use the SSIS object model there are things not exposed outside of SSMS which I find very annoying. Manageability seems restricted to the core database engine and very few DBAs solely work with just the core database engine.

One of the promises PowerShell makes is that as an administrator you'll have a consistent way of managing systems, but this only works if they build coverage.















Post #1073911
Posted Sunday, March 6, 2011 8:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, April 10, 2011 6:51 AM
Points: 1, Visits: 8
Why do I need Powershell, when I can do all the stuff in GUI using SSIS? Powershell is another geek tool.
Post #1073928
Posted Monday, March 7, 2011 2:17 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 12, 2014 11:01 AM
Points: 594, Visits: 2,580
Why do I need Powershell, when I can do all the stuff in GUI using SSIS? Powershell is another geek tool.

Well, it certainly is a geek tool in the sense that it makes few compromises for non-programmers, but there is a great deal to be learned from Powershell, particularly in the discipline with which Cmdlets are named in order to give you a good clue as to what they do. It is a great naming convention that has many good ideas. Powershell is also quite a good way of exploring .NET assemblies and the functionality they expose.
I just had a look at the projects I'm using Powershell for and there is nothing there that SSIS can be made to do. Obviously, if there is an easier way that you can get the functionality you need 'out of the box' in SSIS, then you'd use it. I use Powershell when there is no other obvious easy way to automate processes. That seems to happen to me quite often.



Best wishes,

Phil Factor
Simple Talk
Post #1073993
Posted Monday, March 7, 2011 6:20 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 35,770, Visits: 32,435
Saravanan Durairajan (3/6/2011)
Why do I need Powershell, when I can do all the stuff in GUI using SSIS? Powershell is another geek tool.


Heh... because some of us are heavy-duty batch programmers that don't go anywhere near a GUI. I'd rather see the power added to T-SQL, though.


--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 #1074099
Posted Monday, March 7, 2011 6:21 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 35,770, Visits: 32,435
Phil Factor (3/7/2011)
I just had a look at the projects I'm using Powershell for and there is nothing there that SSIS can be made to do.


Now THAT's an interesting thought. I'd love to know what some of those are.


--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 #1074100
Posted Monday, March 7, 2011 7:06 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 12:04 PM
Points: 705, Visits: 1,779
Why do I need Powershell, when I can do all the stuff in GUI using SSIS? Powershell is another geek tool.


Because at some point in your career, you will find tasks that can't be done effectively except through scripting. Or you may want to automate certain aspects of your job. Feel free to click away till then...
Post #1074137
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse