Monthly Archives: June 2011

Miss SQLBits 8? No problem, all videos are online

Posted on June 30, 2011 by

OK, since this conference in is England, it’s a little harder to get to compared to TechEd.  No matter, all the videos for this conference are online (65 of them).  Take a look at the recorded sessions at http://sqlbits.com/content/Event8.  All … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication, SSAS, Videos | 1 Comment

Can you query a SSAS cube while it is processing?

Posted on June 29, 2011 by

I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the entire time the cube is processing, or just for a few minutes?  Or would the query bomb out?  Surprisingly, I … Continue reading →

Posted in SQLServerPedia Syndication, SSAS | 3 Comments

SQL Server 2012 (“Denali”): Details on the next version of SSAS

Posted on June 27, 2011 by

At the recent TechEd North America 2011 conference, details on the next version of SQL Server 2012 (codename “Denali”) were released.  Part of those details were an update on the SQL Server Analysis Services (SSAS) roadmap.  The main new feature in … Continue reading →

Posted in BISM, SQL Server, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular | 17 Comments

Configuration Manager for Sqldiag

Posted on June 24, 2011 by

SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor your servers over time or troubleshoot specific problems with your servers.  SQLdiag can collect data from: Windows performance logs, Windows event … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication | 2 Comments

SQL Server 2012 (“Denali”)

Posted on June 23, 2011 by

SQL Server 2012 (codename “Denali”) is the name for the next version of SQL Server.  The CTP1 of Denali was released on Nov 8, 2010, and you can download it here.  The next CTP will be available this summer, and you can signup to be … Continue reading →

Posted in SQL Server 2012, SQLServerPedia Syndication | 4 Comments

Three must-have tools you should use everyday

Posted on June 22, 2011 by

There are three tools I use every day without exception.  They all save me valuable time in surfing the net: Delicious – This is a free bookmarking tool that works so much better than the built-in bookmarking in IE.  You … Continue reading →

Posted in SQLServerPedia Syndication, Tools | Leave a comment

Miss TechEd 2011? No problem, all videos are online

Posted on June 20, 2011 by

While nothing beats going to a conference, the next best thing is to watch the recorded sessions.  Fortunately, Microsoft has posted ALL the session videos for Tech·Ed North America 2011 and they are available for free!  Here is the list … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

SSMS Add-in for Analysis Services

Posted on June 17, 2011 by

A nice new little add-in available for SSMS on Codeplex.  It helps with repetitive tasks involved with SSAS such as processing and deployment.  As the site says, the goal for the Analysis Services Helper is to fill in gaps in the toolset inside … Continue reading →

Posted in SQLServerPedia Syndication, SSAS, SSMS | Leave a comment

Data Mining and Analytics hot career

Posted on June 16, 2011 by

Researchers at the University of California, San Diego have published a list of job-market hotspots, and in the top ten is Data Mining and Analytics.  The study is based on enrollment figures, national employment statistics and interviews with San Diego business … Continue reading →

Posted in Career, SQLServerPedia Syndication | Leave a comment

New Microsoft SSIS transform

Posted on June 15, 2011 by

Microsoft has just released a new SSIS transform, called the SSIS Balanced Data Distributor (BDD).  You can download it here. UPDATE: The BDD has been released for SQL Server 2012 (download).  See Balanced Data Distributor (BDD) for SQL Server 2012 … Continue reading →

Posted in SQLServerPedia Syndication, SSIS | Leave a comment