Miss TechEd Australia 2011? No problem, all videos are online
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the...
2011-10-26
852 reads
James Serra's Blog
What is Microsoft TAP and RDP?
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product...
2011-10-24
2,233 reads
SSIS – Can’t Enable/Disable within Data Flow Tab
This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from...
2011-10-21
3,027 reads
Microsoft and HP’s Database Consolidation Appliance
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). ...
2011-10-19
1,772 reads
Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,134 reads
Formula engine and storage engine in SSAS
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. ...
2011-10-14
1,214 reads
SQL Server 2012 and other PASS annoucements
Some announcements and notes from SQL PASS Summit 2011, going on this week:
It was announced that the official name of the...
2011-10-13
1,636 reads
SQL Server 2012 and other PASS announcements
Some announcements and notes from SQL PASS Summit 2011, going on this week:
It was announced that the official name of the...
2011-10-13
980 reads
Error configuration in SSAS
In SSAS, there is an Error Configuration object that is central to the management of data integrity errors.
The following picture...
2011-10-12
2,434 reads
Sometimes temp tables can be your best friend
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
880 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers