Tag: Microsoft

Categories
Business Intelligence

Day 1 Review #sqlpass #summit12

This SQL PASS Summit was my third, and it was good. Kind of crazy timing as we just had a baby 2+ weeks ago, so I am very lucky I got to go.

Day one was Wednesday Nov 7th. There is a kickoff thing the night before which is always good to see everyone again, etc. There are pre-cons two days before (5th, 6th). Myself, as with many I talked to, came out the 5th, thinking the conference started the 6th, which we were mistaken, so it was kind of a free day, but still things going on. The website said 6th-9th so we all assumed without digging into the detail. At least I wasn’t the only one.

The first day keynote was good, Ted Kummert from Microsoft which I have seen a few times now, and the same cast of characters, Amir Netz showing off more Power View and Movie data. The big things announced that made me perk up were SQL Server 2012 SP1 and Power View over OLAP (coming soon?). No big flashy giveaways like BUILD, but good keynote, then the fun starts.

I attended 4 sessions on Wednesday

1. BIA-303: What’s New in Analysis Services 2012? – Chris Webb

This was my first session of the day, and it was in 305-TCC. TCC was across the street, which maybe was like that years past, but I never had to go to any, so everyone seemed lost. We finally got there, but then Chris Webb told us that the abstract was wrong in some places and the talk would mostly be about tabular, not multidimensional. Oh well, good stuff anyways. There was one slide about OLAP stuff. The biggest thing I got out of this was xEvents for SSAS, and how to pull into PowerPivot. This is the first time I have seen Chris Webb present and it was good.

2. BIA-316-M: Enterprise Information Management: Bringing Together SSIS, DQS, and MDS

For the second session, it was two Microsoft employees. I like to try to hit many sessions by Microsoft Employees because well, they usually have worked on the products, and they get into details, and they sometimes let some juicy details slip.

Matt Masson and Matthew Roche are great presenters, funny and play off each other. They showed and telled SQL Server 2012 MDS and DQS and discussed how it could and should be used in orgs. Master Data is a huge issue in many businesses and the Microsoft solution looks really good. Using DQS along with SSIS to clean your data, or as a very smart “spell checker”, and then MDS to track changes, workflow, and send back data to source systems if you’d like. The big thing here I took out was how they see MDS fitting into businesses, and that a BI team should implement MDS/DQS to make sure their dimensional data is clean and the “golden master” they need for great BI reporting, and updating back to source systems is a secondary thing.

3. BID-212-S: Around the World with SharePoint BI Toolbelt

This was a typical Brian Knight session. Not as huge of a production as some of them I have seen. Just him and his employee/bi architect and a helper/demo person.

They showed quickly how to get SharePoint setup for Excel Services and Power View and then did some demos. Overall good stuff but seemed a bit rushed and some things didn’t work. They demo’d PerformancePoint, which who knows what future that has, but seems like the best tool for OLAP scorecards in SharePoint. Performance Point has been an enigma for us to do anything with, not sure we ever will. I always see it demo’d and see the benefits, and see what it can do, but we never get around to doing it. Maybe someday, or maybe it will just get replaced by something..

As I said he brings up a sales person from his team or someone new to show how easy it is for a non-techie to use Power View (or whatever tool they present) and go through a little demo.

4. BID-102: Mobile Business Intelligence for Everyone, Now!

Final presentation of the day was with Jen Stirrup, who also won the PASSion award on Thursday. I also chatted with her briefly Wednesday morning, which was good as I haven’t met her before this summit. The presentation was OK. It was a 100 level, but I wanted to see some Mobile BI. I have some high expectations as I saw Jen Underwood present on Mobile BI at TechEd, so was expecting more of the same. Jen Underwood was actually in the audience and answered some audience questions.

The presentation had some technical glitches, and also dug a little to deep into visualization discussion, which is good, but I wasn’t expecting it in this one, maybe a different session. Jen showed some stuff on her iPad, and talked about how she uses Azure and SSRS in Azure, and also HostedPowerPivot, which was good stuff, but nothing new that I didn’t see at TechEd.

I use MobiSSRS for SSRS reports on iOS and that works great, she didn’t mention it, but Mobile BI presentations can get into the “3rd party app here and there” instead of what you can do out of the box. With mobile BI though, the first question is, “do you run SharePoint?” and the second is, “It is Enterprise?” because that makes a big difference in what you might try to do

Wednesday was a good day, I didn’t do much in the evening besides just grab a bite to eat and hit the hay. Bummer this year was that I started getting a cold on the way out on the plane, and it ate at my voice all week. Nothing to serious but enough to not want to talk in a pub about BI much as you have to yell.

More to come about Day 2 and Day 3, and overall thoughts..

Categories
Geeky/Programming

Windows 8, WinPCap, Compatibility Mode.

I have been running Windows 8 since the 2011 BUILD conference, the dev preview, then the consumer preview, then the release preview. So RTM wasn’t much of a jump for me. I have it installed on my BUILD samsung tablet, as well as on my work laptop.

While I have seen a few things not work, that would be expected, one is WinPCap (packet capture) software , which is an integral part of Wireshark. Turns out it doesn’t really work in Windows 8, at least the installer doesn’t.

What I had to do was run the install in “Windows 7 Compatibility Mode” and it then installed and I could capture traffic.

Categories
Business Intelligence SQLServerPedia Syndication

Selling Management on SQL 2012

2012 is going to be a big year in the SQL world. No, the world isn’t going to end. SQL 2012 should get released by Microsoft, hopefully in the first half (cross your fingers for the first quarter!) of the year. Great! But many out there are now on SQL 2005, or 2008, or 2008 R2, some even on SQL 2000 (SP4 – still get support?) but you want to get to SQL 2012. What can you do to make that transition easier? You need to sell the features and benefits, just like anything else.

Clustering

If you have any kind of clustering environment, or mirroring, or are even thinking about doing clustering, then SQL 2012 is going to be what you want to do. With AlwaysOn, it makes it dead simple to create and manage clusters. If you look back over the versions of SQL, and think clustering, you might shutter. With 2012, things become much easier and management has to see this benefit, as with anything, to make your systems more available with the new AlwaysOn

Master Data Services and Data Quality Services

Microsoft came out with their first round of Master Data Services (MDS) in SQL 2008 R2, but it was lackluster. The interface is clunky, weird, and hard to use. Most “end users” of MDS aren’t going to be that technical. You need something simple, like SharePoint, or Excel. MDS is neither (even though its a weird version of SharePoint). With 2012, MDS is vastly improved and actually something viable where an Enterprise could use it for a Master Data Management (MDM) solution. Couple that with Data Quality Services (DQS) and you get tons of bang for your buck. with MDS and the excel add on, this will be just what the doctor ordered for MDM groups in businesses.

Business Intelligence

Near and dear to my heart of course, is Business Intelligence. What a huge release for BI folks in 2012. First off, a whole new analysis services type, Tabular. Columnar Vertipaq type cubes. Reverse engineer PowerPivots right into SSAS Tabular and then tweak to release out to the Enterprise.

Then the enhanced SSIS stuff, better IDE, better management of packages, and more. Of course the integration with the Visual Studio 2010 IDE is a welcome feature, especially for those of us that also need to work on C# and .NET 4.0 stuff!

But don’t forget the potential biggest thing yet out of the BI tools for 2012 – Power View (yes the space is intentional, not sure why.. but now we have PowerPoint, PowerPivot and Power View). Naming aside, Power View could be a HUGE analytics tool to get more BI out to the people in an Enterprise. First off, they plan on making it work on iOS! Power View works on tabular cubes, so you see the tie in there. The one big thing with Power View, is it just works inside of SharePoint. No stand alone editor. You better have SharePoint 2010 and a pretty good SharePoint admin along side your BI team to get all this stuff working. Some of the enhanced end user alerting in SSRS integrated mode looks nice as well. But once again, you need SharePoint! DON’T for get the SharePoint!

There is much more in SQL 2012 that will make DBA’s lives easier, and BI pros development streamlined. Too much to outline in just one post. But if you are trying to sell SQL 2012 upgrade to management, the “big three” things I outlined above are a good starting point. One thing to be aware of though is that the licensing model has changed in SQL 2012 to core based, so you would want to read up on that.

I’m excited for SQL 2012 bits to hit and I hope you are too!

Categories
Business Intelligence

#sqlpass 2011 Summit Thoughts

Want to get a quick post out before I forget everything cool I have been thinking about the 2011 SQL Pass Summit in Seattle WA.

The conference started out great with a first timer reception (this was my second year), and I knew a few first timers so that would great.

The first day keynote was good, and then the sessions I hit were on a full range of things, new semantic search stuff with file table, and more.

I missed a couple of sessions on day 1 because I was in a Microsoft led focus group on “BI in the cloud” some very cool ideas thrown out and excited to see what is coming up in the future.

More good keynote on day two, a deeper dive into the stuff in SQL Server 2012 (formerly Denali). Went to some good sessions on Data Quality Services (DQS) and Vertipaq vs OLAP, and Power View (remember the space!) SharePoint and Power View integration, etc. Some very cool stuff coming soon with the 2012 release.

Tabular cubes vs Multidimensional cubes. OLAP vs Vertipaq, etc. Big debates and questions here, when to put things in Tabular vs MDX, etc. DAX solves some hard problems we run into with MDX.

Another thing I went to a couple sessions on was StreamInsight. This is some very cool technology for complex event processing, using .NET and LINQ. The StreamInsight guys are crazy smart. Also integrating StreamInsight with Azure, and doing some crazy processing and analysis of tons of data in near real time. I see this technology making a difference somewhere down the road.

Power View was another big winner from the summit. This integrates with SharePoint 2010 as a Silverlight (SL still isn’t dead?) report builder and viewer. Not even sure they are called “reports” anymore, but “views”. You create views and you can interact/edit them in real time. Export to PowerPoint too. These views work off “tabular” vertipaq BISM (BI semantic model) cubes. This technology is going to change how we deliver information to the business.

Being able to take a PowerPivot (no space!) and reverse engineer it into SQL Server Data Tools (formerly BIDS – in VS2010 shell) to create a BISM tabular cube and publish to SSAS Tabular instance looks great. Solving problems like crazy snapshotting and many to many and time analysis using DAX looks very useful.

Of course, GameWorks appreciation night was fun, and I found a Mcmenamins (Six Arms) up the road from the convention center, so I got get a taste of Ruby again. Good conversation and times at the Taphouse and around the Sheraton and Convention center was good too. Seattle is a nice city and the weather was pretty good I thought. Another great summit.

Categories
Geeky/Programming

Office 365 and Windows Live Messenger Not Working? Here's The Fix:

Earlier this summer, I moved from Google Apps to Office 365. I really don’t use Windows Live Messenger for personal IM, but log in every once in a while, also Xbox 360 can login. I noticed on live.com when I hit it, the web messenger continually tried to login. Also my Xbox and WLM on my PC wouldn’t login (error code 8100037b). What gives?

Well, I figured it might have had something to do with Office 365 and Lync Online, and I was right. I had to go into Office 365, Admin, under Lync, General Settings, and disable external communication settings. After 12+ hours I could then log into Windows Live Messenger. Kind of a mess if your org might be using Windows Live for IM and then moving to Office 365. Of course your Lync could federate out to WLM, but still, not being able to log in could be a pain

Categories
Geeky/Programming

VS 11 Experience

Today I decided to give it a go and install VS 11 Developer Preview (off the USB key I got from BUILD) onto my production machine. Whoa, Steve, that could be risky!!

Yeah, it could, but sometimes you need to live life on the edge. As much as a geek can.

There aren’t a ton of options when installing. The installer looks.. “beautiful” compare to other Visual Studio installers. It installed a few things, then reboot, then some more, then it was done. Easy. But of course, it installed SQL Express (Denali CTP3) which I really didn’t want to install since I already have 2008 R2 developer on my machine. Maybe in the advanced install I could have disabled it, but I didn’t dig through it all. Anyways, I just turned the service off and set it to manual start.

VS 11 is nice. Seems faster. Cleaner. Crisper. I LOVE the code clone feature. Found some good info there. I like the new TFS design (the work items, etc look nicer – almost a fat client version of the new TFS server and TFS azure experience).

The big app we work on compiled and ran, which was good. I didn’t try .NET 4.5 yet, that might be for another day. One thing that does stink about the dev preview is that you lose all your add ons. The VS productivity tools are baked in (at least some? I didnt try them all). But things like Resharper, etc aren’t there so you might be “missing” some things you are used to.

The solution file of the project changed on me, since I opened up a VS 2010 sln file. It added some comments and rearranged some things, but after I closed VS 11 and saved everything, I opened in VS 2010 and it still worked. Checked into source control and other devs with just VS 2010 opened it and it worked, etc. So MSFT wasn’t lying.. backward compatible!

Excited to dig into it more and for the future versions.

Categories
Geeky/Programming

Windows 7: All My Fonts Are Italic!

Last week, I uninstalled some software on my Windows machine, a Dell “reader” app. I reboot. Right away I notice something is wrong, all my fonts that were usually just normal Times New Roman or Arial were italic. WTF?

I figured that removing the app somehow also removed or reset my default font’s on the machine. I had someone export out some reg settings and I added them back to mine and things returned back to normal. Attached is the reg file. YMMV. I’m not responsible for your machine getting hosed, or anything related to this fix. Backup your registry, yada yada. win7fontfix

Some apps are just downright destructive when uninstalling. I think back to DLL hell and some of the wacky things that could happen there. System DLL’s removed when uninstalling an app. Just horrible. It seems even with Microsoft’s latest OS, things can still get jacked by a bad app install/uninstall.

I could have also probably went back to a snapshot, but figured I would give it the 10 minute try to fix it approach first. Seems to have worked.

Categories
Geeky/Programming Product Reviews

Moving to Office 365 from Google Apps: Follow Up

Earlier I blogged about Moving to Office 365 from Google Apps, and some of my woes.

In the time since, things have been straightened out. First off, what happened to me sucked, but was resolved. I think Microsoft knows they have some initial bugs and they will work it out. What does stand out is that the customer service is top notch. Their forum moderators replied. Their twitter account @Office365 replied. They actually CALLED me and walked through fixing the issue. This was great. They made sure it was working before leaving me hanging.

After I got the issues resolved, I switched my GoDaddy DNS to MSFT DNS name servers and away we go. I reset up my iPhone, iPad syncing with my new Office365 stuff, worked great, found the server url, etc. Android I had to type it in (to find it, log into web mail and go to about off the help icon). I set it up with Outlook 2010 and it works great. Also Mail.app on Mac, works great there too.

I haven’t done much more than just use it. Some things I miss or want? First, in Gmail, you can archive mail right from iOS. Exchange doesn’t have this, but in Outlook you can set up quick steps to do it, so I did that. The OWA interface doesn’t have quick steps, which would be nice. I haven’t used Lync yet as I don’t have anyone to talk to on it, I will dork around with that later. Haven’t used the SharePoint or Office Web Apps yet, it has been more Mail, Contacts, Calendar to start.

I would like to point my mail.domain.com to the Office365 portal for easy access, haven’t looked into it yet.

One other thing I noticed, is that some mail still comes to my old Google Apps account. Facebook mail alerts for sure. They might have a slow DNS change time as most all other mail comes to Office365. More to come as I get into things though.

Categories
Geeky/Programming Reviews

Moving from Google Apps to Office 365

I have been using Google Apps premier since 2007. Almost 4 years. Before that I used hotmail and tried to use the Microsoft ecosystem as I had a Windows Mobile phone, many of them actually. Before Windows Mobile was “cool”. The thing with Google Apps is that it only offered the “core” apps for a loooong time. (Mail, Calendar, Docs, Chat). Recently they allowed you to “transition” to more Google services (apps), such as Reader, Voice, etc, etc.

Now, this sounds great right? Yeah, except in the last 4 years I had to create a regular gmail account to use most of the Google services (YouTube, voice, Reader), and now I have 4 years of content and what not built up with that account. Google wants me to “start fresh” with my Google Apps account? Doesn’t sound like much fun. Also Google+ just came out, and it doesn’t work with Google Apps accounts, another great way for Google to alienate paying customers, and rewarding free ones. You can’t be signed into both a Google Apps and Google Account at the same time (at least without problems) So I end up having to run one browser with Google account and one with Google Apps? No thanks again.

What I decided to do is try something new. There aren’t many options.

1. Hotmail
2. Yahoo
3. Hosted Exchange (Rackspace, etc)
4. Office 365
5. Other

With Hotmail.. It works, I actually changed it over in a hour or so.. but, there is no 1st class citizen mail client on Mac. Mail, other 3rd party, even Outlook, only connect with POP, not with IMAP. iOS at least uses Activesync. This is somewhat of a deal breaker for me, as I like to use a client on the desktop, or at least try them out.

Yahoo is just out, well, because it is Yahoo. Hosted Exchange looks promising, but too much $$ for not the same features I currently get. Office 365 seems like the logical choice.

I was in the beta for Office 365 and dorked around with it a little bit. I decided to take the plunge.

It is a little more expensive than Google Apps a year, but really no other choices. My first concern was with my Google Talk with my Google Apps. Probably not going to work. Why? Well, with Office 365, if you are on the small business plan, you have to delegate your DNS to Office 365. You can create CNAME and A records, but not TXT or SRV records, etc. Google Apps GTalk needs SRV records in your DNS.

Also, when you sign up for Office 365, you get a weird account, not a Windows Live ID, but Online Services ID, like blah@domain.onmicrosoft.com .. and then you have to set up your custom domain inside the Office 365 web app.

Currently, this is where I am at, and I hope to have a follow up to this..

I made all the DNS changes for Office 365. I created another account in my system, and assigned it a license. I made the account admin, so I had 2 admin accounts. Everything was working.

I decided to cleanup the onmicrosoft.com account, by removing the mailbox and account. It had the same “Full Name” as my regular account, Steve Novoselac. I went to delete and it said “Do you want to remove Steve Novoselac”, I was weary but figured it was keyed on email address of the account record, not name.

Boom, it deleted both the records on my account. Currently I can’t even login to my account. Even better with the small business account you don’t get 24/7 support. Just “service tickets” and the community forum. I did put in a service request and a forum post, and I am working through the issue, but it seems ridiculous. Why?

First off, you shouldn’t be able to remove the “last admin” from an account. Second, it should delete by email address and not full name. We will see how and when I get this resolved, but currently I just switched my DNS back to Google Apps so I can continue to receive email.

Another unknown is the Lync online. It is federated with WLM, but I am curious to see how that is all going to work. Giving support a few days and hopefully will have it all sorted out. More to come..

Categories
Geeky/Programming

What is an Operating System?

This is a core question. Might sound stupid or you might even ask yourself why I would blog this. But seriously, we need to take a look at the Operating System our code is running on. Windows? Mac OS? iOS? Linux, etc. But beyond that, what is core and what is “cruft” in the OS?

I think Microsoft got a hard lesson some years ago from the DoJ on what can or can’t be included in the OS from a monopolistic perspective. But even then, Apple adds things to their OS and bundles them, etc. So what am I getting at?

If you develop native apps (more so for OS X or Windows, not the Mobile OS’s) then you are going to run into compatibility problems. Hardware, software, OS level stuff. DLL Hell, the whole bit.

As a developer or even “product” you can only do so much, you have to mostly code for the “happy path” – and give some documentation and direction to your users. ex:

– This software only works with .NET 4.0
– This software only works on Windows XP SP3 and Windows 7
– You must have a sound card to make use of the features of this software
– You must have an internet connection to make use of this software
– This software only runs on versions SQL Server 2008 R2
– Running an anti-virus package or malware detector on the files the program reads and writes to constantly is going to slow performance.
– Port xxxxx must be open for external devices to connect

You get the idea. You can code some checks into your setup/installer or program on start up of the exe, but beyond that, you have to leave some things to the user. You can’t ever think of every scenario.

If some other program (albeit even an add on you can download after installing your OS from the vendor of the OS) is going to conflict with your program, then the user has to decide which program they want to use or come up with some compromise.

From a Microsoft Windows point of view, the OS is what you get from Microsoft. Not what you get from Dell or HP or whatever. No, Adobe Flash isn’t part of the OS. Either is Windows Live Messenger or Windows Live Photo Gallery or any add on you download later. Hell even .NET wasn’t part of the OS until Vista/7.

When developing your applications, focus on what is going to give your users more functional and business value rather than coding for things you have no control over. Leave it to support and documentation to handle the infinite unknown scenarios.

Code for a fresh Operating System, and supported patches as they come out. You might have a few RARE scenarios you code around but I would suggest against it. The user’s and other programs that might screw up your users OS’s, you can’t do anything about either.

After all that, it is more clear why Apple’s iOS is appealing, sandboxed applications make more sense. You worry about your stuff and I worry about mine type of deal. Less room for support nightmares because of misconfigured operating systems. I wonder if Microsoft will ever “get there”, but I don’t see it anytime soon.