SQL Server Aggregator

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

Darren Gosbell [MVP] - Random Procrastination — Wed, 20 Aug 2008 06:08:28 GMT

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)

VSTSDB GDR CTP15 and VS2008 SP1 AND SQL Server 2008 RTM

Data Dude — Wed, 20 Aug 2008 05:07:19 GMT

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)

Systematic Paranoia

In a Nutshell — Wed, 20 Aug 2008 05:00:00 GMT

My Management Studio wishlist for SQL Server 2011

Aaron Bertrand — Wed, 20 Aug 2008 03:56:00 GMT

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)

Microsoft Revamps Virtualization Licensing and Support Policies; VMware Joins SVVP

In a Nutshell — Tue, 19 Aug 2008 01:00:00 GMT

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

Data Dude — Sun, 17 Aug 2008 22:16:44 GMT

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)

Event Monitor

Data Dude — Sun, 17 Aug 2008 20:49:08 GMT

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)

Diagnosing Problems

Data Dude — Sun, 17 Aug 2008 19:56:45 GMT

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)

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

Aaron Bertrand — Sun, 17 Aug 2008 03:31:00 GMT

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)

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

Darren Gosbell [MVP] - Random Procrastination — Sat, 16 Aug 2008 11:51:45 GMT

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)

Dell hints at next gen Precision notebooks

Paul Nielsen — Fri, 15 Aug 2008 16:45:00 GMT

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)

If SQL was an Olympic sport…

Paul Nielsen — Fri, 15 Aug 2008 04:47:00 GMT

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)

Stupid Index Seek Tricks - using Included Columns

Paul Nielsen — Fri, 15 Aug 2008 01:44:00 GMT

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)

2008 SSMS Query Editing Gem

Paul Nielsen — Fri, 15 Aug 2008 01:36:00 GMT

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)

AutoAudit on CodePlex - vote for your features

Paul Nielsen — Thu, 14 Aug 2008 23:43:00 GMT

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)