Need to create a time dimension down to the millisecond?
Ok, I know that creating a time dimension down to the millisecond is extremely rare. After all, we are talking...
2012-02-01
1,262 reads
James Serra's Blog
Complex reporting off a SSAS cube
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice....
2012-01-30
2,342 reads
SSAS fact table dilemma
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if...
2012-01-27
1,278 reads
Improving cube processing time
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,350 reads
Want to recruit me? Please follow these rules
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
906 reads
PASS Summit session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
893 reads
SQLInspire NYC 2011 Videos available
There are some FANTASTIC videos of the sessions from SQLInspire New York 2011. I highly recommend that you check out...
2012-01-18
534 reads
SQL Server 2012 (“Denali”): SSIS Logging
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what...
2012-01-16
1,225 reads
HP DL980…now this is a server!
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
953 reads
Video/Voice conferencing and Microsoft Lync
Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right...
2012-01-11
1,011 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
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers