|
|
Front Page News
-
|
Not too many posts yet a little too much marketing for my state but since the BI area needs support the new blog is welcomed: http://blogs.msdn.com/bi/default.aspx...
|
-
|
How time flies. It's seems like yesterday when this XML thing came and conquered the world. Happy anniversary! Check out the post of the Data Programmability Program Manager - Irinel Crivat: Happy 10th anniversary, XML!...
|
-
|
How just vote here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=327537...
|
-
|
If you search at this point for the recording of this webcast you will discover that is pretty hard to locate it. To make things easier for you here's the link: MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications The source of the link...
|
-
|
It may surprise you but this is the official announcement "Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release candidate (RC) in Q2 calendar year 2008, with final Release to manufacturing (RTM)...
|
-
|
New Year - new passion - R/C Helicopters - such as Silverlit Picoo Z . Luckily for beginners like me YouTube has plenty of movies. But how to save them? You may say: just copy all files starting with the get_video from C:\Documents and Settings\UserName\Local...
|
-
|
Paul A. Mestemaker II, Program Manager for SQLCAT, starts the year by bringing gifts - an updated version of SQL Server 2005 Best Practices Analyzer. You can find in the box more than 60 new rules, rules for Analysis Services, BPA UI and command-line...
|
-
|
SQL Server 2008 - Resource Governor Questions Bob Dorr answers some of the most common questions regarding Resource Governor: What is the difference between priority and importance? How (an when) can I throttle an active query that is taking too much...
|
-
|
Since SQL Server 2005 in all the demos (even in Microsoft demos) involving sys.dm_exec_sessions DMV I saw this usage for retrieving user sessions: SELECT * FROM sys.dm_exec_sessions WHERE SPID > 50 This comes from SQL Server 2000 where you could select...
|
-
|
When you have just become comfortable with the idea that you have to certify yourself on SQL Server 2005 - guess what - new certifications are coming. My advice - if you have the time - take the SQL Server 2005 certifications as SQL Server 2008 builds...
|
-
|
In a discussion with Remus Rusanu , he reminded me that if you use a SqlString to pass a varchar(max) to a client application, the whole value is copied into the memory (think big - a varchar(max) can have up to 2GB). The alternative is to use streaming...
|
-
|
To answer a question on a previous blog post - YES, there is a PowerShell Add-In for Visual Studio - the VSCmdShell . It works with Visual Studio 2005 and Visual Studio 2008 (I tested with 2008 version) and you can also get the code for it from the project...
|
-
|
One of the perks of being MVP is that you can use lots of commercial applications for free. Two of them come from Shell Tools : PowerShell Analyzer and PowerShell Plus. If you are into PowerShell then I recommend you to at least download the free version...
|
-
|
A few days ago I wrote how can one talk to Analysis Services. Though I have no PowerShell skills (I opened a PowerShell console 2-3 times) and I come from the Database Engine world - I thought that it would be interesting to try the powerSSAS provider...
|
-
|
or should I say Forever Young? If you try to troubleshoot AS connections like I had to, you will choose the second characterization for the Troubleshooting Analysis Services 2005 connectivity problems article....
|
-
|
The answer depends on who you asked the question. If you ask an Analysis Services member team he/she might answer XML DDL, MDX ( Multidimensional Expressions ). DMX (as in Data Minining Extensions and not DMX the rapper ), XMLA ( XML for Analysis ), PMML...
|
-
|
At least it would not be supported though the API can be somewhere in the code. What is the execution plan? It was a feature of Analysis that resembles the actual execution plan from the Database Engine though it is not the same thing. What makes them...
|
-
|
There's a small link on the top right corner of the site to the Heroes Happen Here :: SQL Server 2008 Test Drive If you didn't check it then you should. Why? You can play with an online installation of SQL Server 2008 without having to install your own,...
|
-
|
An Introduction to New Data Warehouse Scalability Features in SQL Server 2008 [quote from="Table of Contents"] SQL Server Relational DBMS DW Improvements Star Join Partitioned Table Parallelism Partition-Aligned Indexed Views GROUPING SETS MERGE Change...
|
-
|
I guess you'll have another year to keep hearing the phrase at ROSQL meetings "Cristian Lefter, SQL Server MVP" :) Good news for Romania, we have a "fresh" MVP - Andrei Iacob with the Client Application Development competency. You can read more about...
|
-
-
|
Well, it's not really a screencast, it's a "replay" of the presentation from the last user group meeting. Thanks Narcis for the hardware. Windows Media Video archive: Download Format: wmv Duration: 00:12:47...
|
-
|
It started with this question: Let's suppose that I want override the QUERY_GOVERNOR_COST_LIMIT value for an user that connects to the server. How can I do that? I want to customize the value per user so I won't use sp_cofigure and query governor cost...
|
-
|
After 7 months of confusion between DMF (Dynamic Management Functions) and DMF (Declarative Management Framework), a new name makes the new feature of SQL Server 2008 very clear as purpose: Microsoft ® SQL Server ® 2008 Policy-Based Management Read more...
|
-
|
An image is worth a thousand words so this posts contains exactly 1014 words:...
|
|
|
|