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,882 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,108 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
941 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,396 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,280 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,023 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,766 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,545 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,008 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,019 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers