Posted by
Jason Massie 
on Wednesday, June 11, 2008 at 7:15 PM to
SQL Server 2008, Boohoo
214 Views |
3 Comments |
I just read a post from the other side of the fence by powershell admin. Here is an excerpt:
"
I wish I were kidding. The SQL team is clearly not only talking to other teams which have done a great job of working with PowerShell - System Center, Exchange, etc - they don’t even seem to know that these other teams exist within Microsoft. Right on campus. Just down the road. Go eat lunch with them for heaven’s sake. Order a side of clues.
"
My understanding, and I would consider myself a ps-n00b, is that the SQL team created a provider so you could access the SQL structure as a file system. The add-pssnapin functionality is a valid point but you can work around that my loading the SQL powershell provider into the normal powershell. The case sensitivity point has been fixed in rc0 as far as I can tell. Also new in RC0 is the Invoke-PolicyEvaluation cmdlet. I have not had a chance with it yet though.
You can read the entire article here and join in on the conversation if you wish. My post on SQL 2008 powershell is here.
Posted by
Jason Massie on Friday, February 29, 2008 at 12:12 PM to
SQL Server 2008, SQL Shorts, Windows Server 2008, Heroes Happen Here, Boohoo, Data collection
378 Views |
0 Comments |
The big news of the week was the HH{H} launch. A lot of marketing fluff. Not just from MS but from vendors trying to ride the wave. That said, I think the rest of the year is going to be really exciting technology wise.
There are some good webcasts at the virtual event site through the slick but slightly buggy silver light interface. Check it out.
The MS SQL site got a facelift. I suspect it will replace the original site soon. Props to ThePremiers for breaking it.
Dan reports the return of the tsql debugger, object search and the new activity monitor. He demo'd these features and the other manageability features at the launch event.
SQL Server 2008 is setting records. Most impressively in loading 1TB+ in 30 minutes with SSIS. Read it on the SQLPerf site here and here, the SQLCAT site, Erin's blog, and Denis's blog.
Peter has the scoop about issues with SQL Server 2008 and leap year. Whoops :) Good thing they didn't launch today.
Linchi comments on the intel hexacore procs that should hit Q3-4.
Derek C drops knowledge on the SQL Server 2008 performance data collector.
This might be HAWTALTA to some but I consistently here people complaining about the speed of SQLWB. Jeff posts links to resources.
Bonnie posts the 2008 version of samples on codeplex. Direct dl here. Details here.
Check out this very detailed post on SNAC for the horse's mouth.
Andy has a no nonsense post on sparse columns.
I should have mentioned this last week. Simon did a great job in detailing full text in SQL Server 2008 in a series of posts. Start here.
Have a great weekend!
read more
Posted by
Jason Massie on Sunday, December 31, 2006 at 5:32 AM to
SQL Server 2005, Boohoo
221 Views |
0 Comments |
I have two complaints about the documentation. Incomplete BOL and little info on the myriad of trace flags that is growing with every other QFE. From my understanding, the documentation for SQL 2005 was locked down in April of 2005 and the product went RTM in November of 2005. They obviously had more important things....
read more