Houston Area SQL Server User Group Presentation
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL...
2012-03-13
710 reads
James Serra's Blog
Data Warehouse Architecture – Kimball and Inmon methodologies
What is the best methodology to use when creating a data warehouse? Well, first off, let’s discuss some of the reasons why...
2012-03-15 (first published: 2012-03-12)
9,517 reads
SQL Server 2012 (“Denali”): Power View installation and requirements
Power View is installed when you run the SQL Server 2012 install and on the Feature Selection page choose “Reporting...
2012-03-09
3,108 reads
SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode
In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took...
2012-03-07
4,499 reads
SQL Server 2012 released!
Exciting news! Microsoft announced today that SQL Server 2012 has released to manufacturing (RTM). Customers and partners can download an...
2012-03-06
1,640 reads
SQL Server 2012 (“Denali”): Details on the next version of SSRS
SQL Server 2012 contains six new features for SSRS:
Excel Renderer for Microsoft Excel 2003, 2007 & 2010 - Excel renderer will support the Excel...
2012-03-05
1,599 reads
SQL Server 2012 (“Denali”): Database Recovery Advisor
Database Recovery Advisor is a new feature in SQL Server 2012 that introduces significant user experience enhancements to the ways DBAs...
2012-03-02
1,032 reads
SQL Server 2012 (“Denali”): Extended Events
Extended Events is a general event-handling system for performance monitoring that was introduced in SQL Server 2008. It has a highly scalable and highly configurable...
2012-02-29
2,688 reads
End-User Microsoft BI Tools – Clearing up the confusion
Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there...
2012-02-27
5,914 reads
SQL Server 2012 (“Denali”): Spatial Features
SQL Server 2012 introduces several significant enhancements to spatial types, such as support for new subtypes of circular arcs, new...
2012-02-24
2,022 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