A Novel Workaround for an Infamous SSAS Connection Error
For months I’ve been itching to get the latest version of SQL Server, thanks to the addition of new functionality...
2012-08-28
1,937 reads
Blog Posts
Lookup transformation in SSIS: Performance Improvements
There are 2 suggestions I hear about when performance tuning the Lookup transformation on a large dimension table when getting...
2012-08-28
9,152 reads
Minnesota SQL Saturday (#SQLSat149)
It’s close to that time of year again. It’s time for a SQL Saturday in Minnesota and this… it isn’t...
2012-08-28
945 reads
Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused
There is a way to view the size of a particular PDW database using the DBCC_pdw_showspaceused command via the NEXUS...
2012-08-28
3,402 reads
Please, Call Me Richard
I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good....
2012-08-28
1,285 reads
Say Seminar, Not Pre-Con for SQLSaturday
I read a note posted on the OPASS LinkedIn site today about our upcoming SQLSaturday and the two pre-cons by...
2012-08-28
1,035 reads
Suppressing namespace attributes in nested select statements when using FOR XML workaround
I was helping out on the forums the other day with a user who had stumbled across the quirk of...
2012-08-28
6,899 reads
The INSTALLSHAREDWOWDIR command line value is not valid.
I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly...
2012-08-28
1,599 reads
These People Are Exceptional
I should know. I was one of the judges of this year’s Exceptional DBA of the Year award. I had...
2012-08-28
1,011 reads
Upcoming Speaking Events
I will be the inaugural speaker for the Northern Colorado Database Professionals on September 17, in Loveland, CO. I will...
2012-08-28
2,039 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers