Access Services sure LOOKS promising.. everything is stored in SQL (instead of in sharepoint lists) I’ve always had big performance concerns with using SharePoint lists with larger datasets. Like 1,000 is a lot of records in a sharepoint list… makes me sad to think that we had two machines each with 256 gb ram and […]
Monthly Archives: December 2012
virtual machines can host MDF/LDF files on a different server.
I need to play with this. I think that SQL 2008 / 2012 (I’m not positive which versions).. we have the ability to host SQL Server databases across a network. Hyper-V now supports SMB (Server Message Block) for file-level storage http://www.infoworld.com/d/microsoft-windows/7-ways-windows-server-2012-pays-itself-205092?page=0,1
find all columns in THREE different tables
SELECT name + ‘,’ FROM syscolumns sc WHERE sc.id = OBJECT_ID(‘DOCUMENT’)INTERSECTSELECT name + ‘,’ FROM syscolumns sc WHERE sc.id = OBJECT_ID(‘FILE‘)INTERSECTSELECT name + ‘,’ FROM syscolumns sc WHERE sc.id = OBJECT_ID(‘OBJECT’)
SSRS – can't use User!UserID in data driven subscriptions
I’ve been stumped for a few months on why I wasn’t able to use Data Driven Subscriptions – by far my favorite flavor of SQL Server– Finally found an article that claimed it was because of User!UserID http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/94ad2583-4591-4d28-add3-629b9565c27d So I removed that expression, and now it’s working like a charm.
sqlclr
I’ve been meaning to spend more time with SQLCLR, it’s really an incredible technology. Does anyone other than me use it? I just love the flexibility it provides. Here’s a great article I found about dynamic pivot w/SQLCLR. It’s behind a freewall, so register to SqlServerCentral.. I met Steve a few weeks back.. great site! […]
Lightswitch is the new Access, not Excel!
Is PowerPivot the Next Access? https://sqlserverbiblog.wordpress.com/2012/10/28/is-powerpivot-the-next-access/
seamicro sm15000 with piledriver
10u 4tb ram 64 sockets 512 cores I’ll take one!!?!?!?! http://www.anandtech.com/show/6257/amd-introduces-seamicro-sm15000-with-piledriver-and-ivy-bridge-compute-cards
Microsoft to IE haters: You're sad
If you despise Internet Explorer, you are a twerp. You are a sad, lonely doofus who sits alone, night after night, posting stupid, negative comments about a browser that is simply above your station. You are so truly, irredeemably pathetic that your greatest achievement is to have won a karaoke competition at your local bar […]
Microsoft Declares the Future of ASP.NET is Web API – Shaun Walker's blog
ROFL Seems like just yesterday mvc was the future!?!?! http://weblogs.asp.net/sbwalker/archive/2012/06/17/microsoft-declares-the-future-of-asp-net-is-web-api.aspx