Monthly Archives: February 2013

convert json to xml

I found this stored procedure at http://sqldom.sourceforge.net I had to share   ALTER PROCEDURE [dbo].[sputilConvertJSONToXML] @JSON nvarchar(MAX), @XML xml OUTPUT AS BEGIN DECLARE @tvStack TABLE ( StackID int IDENTITY PRIMARY KEY, Tag varchar(8000), IsArrayElem bit ) DECLARE @I int DECLARE … Continue reading

Posted in SQL Server | Tagged | 1 Comment

"Rubber duck debugging" in which a programmer explains the code to an inanimate object

I’ve been using this term for about six months now, had to clue you guys into the rest of the story about ‘rubber ducking’ http://www.reddit.com/r/todayilearned/comments/190rs7/til_theres_a_thing_called_rubber_duck_debugging/?sort=confidence

Posted in SQL Server | Tagged | Comments Off on "Rubber duck debugging" in which a programmer explains the code to an inanimate object

future of Analysis Services

MDX is so good, in fact, that it has become the industry standard even among Microsoft’s own competitors. The longer I use these tools, the more I appreciate them for how good they truly are. The importance of data mining and … Continue reading

Posted in SQL Server | Tagged | Comments Off on future of Analysis Services

compress all tables and indexes on SQL 2008 Enterprise

To date I have found on SQL Server 2008 R2 with a reasonable external disk array and reasonable number of processor cores that disk compression offers a significant improvemnt in terms of performance as well as the number of records … Continue reading

Posted in SQL Server | Tagged | Comments Off on compress all tables and indexes on SQL 2008 Enterprise

virtualize TWITTER as a mySQL database

check this out, you can virtualize TWITTER as a mySQL database 🙂 http://www.rssbus.com/sql/?tabs=5

Posted in SQL Server | Tagged | Comments Off on virtualize TWITTER as a mySQL database

7 Things Developers Should Know About SQL Server | Brent Ozar Unlimited

Great article !! http://www.brentozar.com/archive/2013/02/7-things-developers-should-know-about-sql-server/

Posted in SQL Server | Tagged | Comments Off on 7 Things Developers Should Know About SQL Server | Brent Ozar Unlimited

How Microsoft could regain its footing

Opinion: How Microsoft could regain its footing (Hint: more Office, less Windows) Even after several months, I don’t know what to make of Windows 8. And Microsoft’s tablet initiative feels like it’s on the rocks. Still, when I look at … Continue reading

Posted in SQL Server | Tagged | Comments Off on How Microsoft could regain its footing

Access Services – latest ULS error dump 2/15

here’s the error dump I get from my fifth (and final) attempt to get Access Services working correctly. ————————————————————————————————————————————————– 02/15/2013 12:29:26.57 w3wp.exe (0x265C) 0x27F8 SharePoint Foundation Logging Correlation Data xmnv Medium Name=Request (POST:http://win-fdshjv8jiql:80/_vti_bin/accsvc/ServerDesignService.asmx:CreateApplication) 8f1bff9b-382b-8022-6d66-ab9bf55589bd 02/15/2013 12:29:26.58 w3wp.exe (0x265C) 0x27F8 SharePoint … Continue reading

Posted in SQL Server | Tagged | 1 Comment

Enable Fast User Switching in Windows 8

This has probably been my biggest pet-peeve with windows 8 is that there isn’t LOGOUT buttons anywhere This means I’ve been rebooting whenever I want to change users LOL Well I finally decided to ask Google how to fix this, … Continue reading

Posted in SQL Server | Tagged | Comments Off on Enable Fast User Switching in Windows 8

Should I buy Office 2013

Should I buy Office 2013? Office doesn’t support SQL Server as well as Access 2000, XP, 2003, 2007 and 2010. I literally recommend avoiding Office 2013 like the plague! Does your copy of Office 2013 die with your computer? Can you reinstall … Continue reading

Posted in SQL Server | Tagged | Comments Off on Should I buy Office 2013