Cam-Graph
A new project from Microsoft Research has Steve Jones interested. It deals with large data sets to perform graphical modeling. The storage mechanism has Steve Jones interested.
How to Setup Report Parameters to Default Based On User Credentials
This article explains how to setup Reporting Services (SSRS) parameters default values using user credentials.
Life is Short
Life is short, and Steve Jones reminds us to live for today, even as we invest in ourselves for the future.
Backup and Restore of an Analysis Services Database
One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.
SQL Server 2008 R2 Service Pack 1 Customer Technology Preview Available
You can help test the first service pack for SQL Server 2008 R2 and ensure the highest quality possible for its release.
Happy Easter 2011
It's Good Friday and the Easter holiday weekend with a number of countries having a bank holiday. Steve Jones is on vacation and providing us with a blooper reel for today.
ShowPlan Operator of the Week - Split, Sort, Collapse
'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano Amorim after his epic series of articles about the ShowPlan operators. With renewed stamina, Fabiano continues his mission to describe all the major operators by explaining the Trivial Plan and the power of unique indices.
Saying Thank You
After a bad experience traveling, Steve Jones stops to recognize that despite a possible computer bug, he still recognizes that the programmers building web sites aren't making mistakes on purpose and deserve a thank you for their work.
SQL Server Webinar Series #9: Streamlining SharePoint Recovery
Metalogix Selective Restore Manager streamlines the process of finding and recovering individual documents and lists directly from a SharePoint content database backup file without the need for a recovery farm. When used in conjunction with Red Gate’s SQL Virtual Restore, Selective Restore Manager can recover documents and lists without physically restoring the backup file—saving time and much needed disk space. Together, Metalogix Selective Restore Manager and Red Gate SQL Virtual Restore open up new possibilities for your SharePoint backup and recovery strategy. Apr 21, 2011, 11am EST.
When does a Tumbling Window Start in StreamInsight
Whilst getting some courseware ready I was playing around writing some code and I decided to very simply show when a window starts and ends based on you asking for a TumblingWindow of n time units in StreamInsight. I thought this was going to be a two second thing but what I found was something I haven’t yet found documented anywhere until now.
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers