Home
August 21, 2008
tblMashedUp


SELECT feed FROM fGetRSS()


pBlogCategories


::fn_BlogRoll()


tblTagCloud

Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless



Articles from RC0

The Gauge Report Type in SSRS 2008(or The TPS Report has a Fever.)

Posted by Jason Massie Click to IM Jason Massie on Monday, June 23, 2008 at 10:04 PM to SQL Server 2008, SSRS, RC0
252 Views | 0 Comments |

Microsoft licensed the Dundas guage control for SQL Server 2008. I believe they did the same the chart control. I have been playing around with the gauge control for a new project I am working on tonight and I thought I would show few pics because they are pretty cool.

Here is it displaying real time perfmon data:

Gauge

Here are several more but not all of the other other gauge types. Click to expand.

Gauge2

How cool is that? Ok, ok, it is a JeeYouEye but your boss will think you have been taking king fu lessons.

email it! |  |   |   |   |   | 

Attn DFW SQL'ers

Posted by Jason Massie Click to IM Jason Massie on Wednesday, June 18, 2008 at 2:58 PM to SQL Server 2008, SQL performance tuning, Indexes, PASS, Data collection, RC0
162 Views | 0 Comments |

Reminder: You can catch me at the North Texas SQL Server User's Group tomorrow night. The Data Collection presentation that I put together may be short so I have a few backup slides and demo's on filtered indexes, queries hashes and the 2 second SQL Server 2008 upgrade. Directions and details can be found at http://northtexas.sqlpass.org

Hope to see you there.

email it! |  |   |   |   |   | 

Quest PowerGUI Review

Posted by Jason Massie Click to IM Jason Massie on Friday, June 13, 2008 at 10:37 AM to SQL Server 2008, RC0
198 Views | 0 Comments |

I found this in google reader this morning. PowerGUI wins "Breakthrough Product of TechEd 2008". I have looked it before. I believe Brent O pointed me to it. Well, I missed the script editor before. This baby is nice. You can run commands directly from the editor. It has intellisense and a debugger! Oh yah, it is free and open source.

powergui

Read more and download here: http://powergui.org

To load the SQL 2008 RC0 snapin and format files, you have to run these commands.

Add-PSSnapin SqlServerProviderSnapin100
Add-PSSnapin SqlServerCmdletSnapin100

Update-TypeData -PrependPath "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLProvider.Types.ps1xml"
Update-FormatData -PrependPath "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLProvider.Format.ps1xml"

 

P.S. Be wary of the "cult of posh"

email it! |  |   |   |   |   | 

In case you have not had a chance to install RC0 yet...

Posted by Jason Massie Click to IM Jason Massie on Thursday, June 12, 2008 at 3:08 PM to SQL Server 2008, RC0
140 Views | 0 Comments |

The new SSMS splash screen....

sql2008splash

email it! |  |   |   |   |   | 

Query Hashes in SQL 2008 RC0

Posted by Jason