Prevent wiping out of SSAS partitions
There have been a few times when I have created SSAS partitions outside of BIDS using script code in an...
2012-08-01
1,025 reads
James Serra's Blog
Syncing your contacts
In the same vein as my blog post about Syncing your calendars, I wanted to post how to sync your contacts...
2012-07-30
1,981 reads
Visual Studio 2012 does not support BI
In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does not...
2012-07-25
16,080 reads
TechEd Europe 2012 videos online
Microsoft has posted ALL the session videos for TechEd Europe 2012 and they are available for free! What a great...
2012-07-23
846 reads
SSRS does not require IIS
Starting with SQL Server Reporting 2008 Reporting Services (SSRS) was the removal of the Internet Information Services (IIS) dependency, so you do...
2012-07-18
7,597 reads
How to use LinkedIn to enhance your career
LinkedIn is a great resource to improve your career. It has definitely worked for me as the last 5-6 jobs I have...
2012-07-20 (first published: 2012-07-16)
3,901 reads
Microsoft PivotViewer
Microsoft PivotViewer is a really cool Silverlight web-based control that provides a visual way to interact with massive amounts of data (download)....
2012-07-11
1,320 reads
Blueprint for consulting riches
As a business intelligence architect consultant, I have met many people out there who are as good or better than...
2012-07-09
1,529 reads
SQL Server table partition switching
If you are using partitions in SQL Server, be aware that “partition switching” is a great feature to quickly truncate partitions...
2012-07-05
7,994 reads
Comparing DirectQuery and ROLAP for real-time access
In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution...
2012-07-02
1,370 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers