SQL Server Aggregator

Error 2738 while trying to install Adventure Works BI sample on Vista

2008-08-20T06:08:28Z

When trying to install the Adventure Works 2008 sample database on my new SQL Server 2008 instance I very quickly got a message box about the installation failing with an error of 2738. For some reason this sounded familiar and sure enough a quick search Read More......(read more)

VSTSDB GDR CTP15 and VS2008 SP1 AND SQL Server 2008 RTM

2008-08-20T05:07:19Z

I received enough questions asking if the VSTDB 2008 GDR CTP15 release is supported and working in combination with the released versions Visual Studio 2008 SP1 and SQL Server 2008? And if so what the correct order of installation is? GDR CTP15 is working Read More......(read more)

Systematic Paranoia

2008-08-20T05:00:00Z

My Management Studio wishlist for SQL Server 2011

2008-08-20T03:56:00Z

Inspired both directly and indirectly by fellow MVP Erland Sommarskog, whose programming wishlist I talked about the other day , I have decided to compile a list of my own wish list items, in the same spirit of, "it's never too early." This list is restricted Read More......(read more)

Microsoft Revamps Virtualization Licensing and Support Policies; VMware Joins SVVP

2008-08-19T01:00:00Z

There's been some interesting news about Microsoft's virtualization efforts hitting the wire lately, headlined by Microsoft's decision to revamp its support policies to help IT Pros more effectively manage virtualized IT infrastructures. Read More......(read more)

Trace Helper

2008-08-17T22:16:44Z

This is the last part of the 3 part diagnostics series. This part will introduce you to a little helper utility that I wrote to make configuring the diagnostics and tracing options a lot simpler and more accessible. As discussed in the previous two blog Read More......(read more)

Event Monitor

2008-08-17T20:49:08Z

In part 2 of diagnosing problems I want to introduce you to an other build-in diagnostics tools that we might ask you to run with tracking down problems, the "event monitor". The event monitor is one of those tools that we use during development Read More......(read more)

Diagnosing Problems

2008-08-17T19:56:45Z

How to diagnose problem inside Visual Studio Team System Database Edition is the subject for this blog post. When the product does not behave as expected we might ask you to create a trace of the activity that you are performing and send us the resulting Read More......(read more)

Want to make a difference in the next version of SQL Server?

2008-08-17T03:31:00Z

SQL Server 2008 is out, and I'm sure you are either learning about or already enjoying some of the new features. And while the dev team probably doesn't wholeheartedly agree with me at this very moment, I think that it can never be too early to start Read More......(read more)

BIDS Helper 1.3 Released (now with support for SQL 2008)

2008-08-16T11:51:45Z

I am pleased to announce that the BIDS Helper team have just released v1.3 which is our first release with support for SQL Server 2008. With these release we have also improved our international support. All of the features in BIDS Helper still only display Read More......(read more)

Dell hints at next gen Precision notebooks

2008-08-15T16:45:00Z

Quad Core, 16Gb RAM, 1TB RAID, 1Gb Graphics, run dual 30' monitors see the video: http://www.dell.com/content/topics/topic.aspx/global/products/precn/topics/en/precision_concept_jumppage?c=us&l=en&s=gen Share this post: email it! | bookmark it! Read More......(read more)

If SQL was an Olympic sport…

2008-08-15T04:47:00Z

we’d be judged by how well we nailed the disconnect. Seriously, my Olympic pet peeve is that the gymnasts do these amazing twists and defy gravity, and then the major point of their score is whether they move a foot when they land. It makes no sense to Read More......(read more)

Stupid Index Seek Tricks - using Included Columns

2008-08-15T01:44:00Z

Usually, we think of index seeks (a possible Query Execution Plan operation) as using the b-tree index to pick out a row and then quickly pass that row to the next operation. But the index seek has special powers: when the conditions are right, it can Read More......(read more)

2008 SSMS Query Editing Gem

2008-08-15T01:36:00Z

Hidden in the Edit > IntelliSense menu is QuickInfo, keyboard shortcut Ctrl-K, Ctrl-I. It pops up information (e.g. column name, data type, nullability) about the current object (table, view, DMV, column) under the cursor. Very Cool. Thank You to Buck Read More......(read more)

AutoAudit on CodePlex - vote for your features

2008-08-14T23:43:00Z

In an effort to be more "open", I've moved AutoAudit (code-gen utility that creates audit tirggers) from my swebsite to CodePlex. Soemthing I like about CodePlex is the open submission and voting on issues and feature requests. I've moved every feature Read More......(read more)