Monthly Archives: December 2012

Access Services sure LOOKS promising.

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on Access Services sure LOOKS promising.

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on virtual machines can host MDF/LDF files on a different server.

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’)

Posted in SQL Server | Tagged | Comments Off on find all columns in THREE different tables

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on SSRS – can't use User!UserID in data driven subscriptions

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on sqlclr

Lightswitch is the new Access, not Excel!

Is PowerPivot the Next Access? https://sqlserverbiblog.wordpress.com/2012/10/28/is-powerpivot-the-next-access/

Posted in SQL Server | Tagged | Comments Off on Lightswitch is the new Access, not Excel!

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

Posted in SQL Server | Tagged | Comments Off on seamicro sm15000 with piledriver

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 … Continue reading

Posted in Internet Explorer, SQL Server | Tagged | Comments Off on Microsoft to IE haters: You're sad

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

Posted in SQL Server | Tagged | Comments Off on Microsoft Declares the Future of ASP.NET is Web API – Shaun Walker's blog