Is Self-service BI Threatening IT Professionals’ Livelihoods?
(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is...
2012-12-09
827 reads
pturley
Debugging Parameter Dependencies in Reporting Services
Creating a report with two datasets that reference the same pair of parameters, I’m seeing the following error: The Value...
2012-12-07
3,845 reads
Power View and Reporting Services
There has been an active discussion thread on Chris Webb’s blog about the similarities & differences between various Microsoft BI & reporting...
2012-12-03
733 reads
Is PowerPivot the Next Access?
I’m impressed with the current generation of semantic modeling technology from Microsoft. I’ve had the opportunity to use both PowerPivot...
2012-10-31 (first published: 2012-10-28)
4,369 reads
Office 2013 BI and Mobility
I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about...
2012-10-15
852 reads
The State of Microsoft Self-Service Reporting
(article published on the MVP Award Program Blog) I really enjoy this topic. One of the reasons, I suppose, it’s...
2012-09-27 (first published: 2012-09-25)
2,743 reads
2012 Fall & Winter Conference Sessions
Fall is a busy time for speaking engagements which include user groups, SQL Saturdays and the PASS Global Summit. I'm...
2012-09-22
708 reads
SQL Server BI & SharePoint eBooks, Guides and Resources
There are many free eBooks & resources available from Microsoft and members of the MVP community. This is a collection of...
2012-08-10
1,346 reads
PASS 2012 Summit: November 6-9
I just received an email message from the PASS Global Summit 2012 organizers after submitting session abstracts a few weeks...
2012-06-10
1,197 reads
SSRS Performance in SharePoint Integrated Mode
I’m working with a client to help them move all reports in their company from native mode (Reporting Services not...
2012-05-29 (first published: 2012-05-24)
4,902 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Update particular record in a table
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Internationalisation
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Size of DB on physical disk doesn't match Disk Usage by Table report
Hi everyone I am looking at the size of my db on disk (ie...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers