Tag: syndicated

  • Looking to Windows 9

    I haven’t played with Windows 8 yet, and only a little with Windows Phone 7, but I am a little concerned. This set of videos that show an older man, a CPA, a lifelong Windows user messing with Windows 8 and OSX are a bit telling to me.

    The whole start menu/tile thing is a problem to me. It’s no that big a deal in that once you learn it, you understand how it works, but it does seem to be an issue of design. The more I look at the tile/menu design, the more I’m bothered. It’s not a question of ergonomic design. The whole iOS design is something that just works. It was new, different, and it changed the way so many people view computers. For the first time, the majority of stuff you wanted to do just made sense. Not necessarily for us techies/power users, but for most of the world.

    I read through a dozen or so of the design considerations from Microsoft, and I appreciate it’s an impossible task. Or at least a Herculean task. However what it seems like it happening is that they’re still bound by viewing the world the old way. As much as they worry about moving the tile/start menu around to be more intuitive, they’re still stuck with stuff in the corners. If they want to be revolutionary, then think about the fact that our mice are often in the screen, somewhere near the application (a cell in Excel, a portion of a Word doc, or a scrollbar). Make the menu work from that point in time, or without the idea that I’m starting from the lower left.

    I watched this video from cNet with a hands on, and it definitely feels a little cherry-picking on features and ergonomics was shown, but I am looking forward to messing with it at some point. There are things I like about the direction they’re going, though I’m not sure they are going to work in the 1.0 implementation. However I thought I’d look forward to Windows 9 and talk about what I’d like to see.

    For the record. I use a Windows 7 desktop, with 3 monitors, but I travel with a Macbook Air that I love. It’s much better than the last 4 laptops I’ve had, smaller, and OSX Lion is a dream for me. I have an iPhone, which I use constantly. I also have an iPad that I use regularly, but not as much as my kids. I’ve been a Windows user primarily for two decades at work, and I don’t want to see Windows disappear. However I do think there are things Microsoft could do better.

    One Device

    More and more convergence seems to be on the mind of people. When PDAs first came out, I thought we might get there, but a decade of crappy devices that worked in a half-assed way, from the Palm to PocketPCs to Windows 6 smarthphones had me rethinking that. However with my Android G-1 and then my iPhone, I think to a large extent, I can converge. Not to one device, but two.

    I saw this device recently, the ASUS PadPhone, and thought it was pretty cool. It’s a phone, that slides into a tablet, which can attach a keyboard. The idea of getting my phone screen larger at times, would be very handy. Adding a keyboard is a natural step, since the virtual keyboards work OK, but aren’t always great.

    ht_asus_padfone_jp_120227_wblog

    The iPad changed the world and made us think of tablets. I think my iPad is very handy, but it’s not convenient. It doesn’t allow me to do technical work for presentations, which is an issue. It just lacks horsepower. I know for more people that’s potentially not an issue (my Mom loves hers), but it is for some of us. The iPad isn’t what I want.

    For most of us, however, the idea of a phone/tablet makes some sense. We want to use the form factors differently, and much of what I’ve seen in Windows 8 makes sense there, but I’m not sure about the desktop.

    Hot Hardware

    To me, the biggest thing that Windows 9 should have is hot hardware. Not cool, not flashy, but the core hardware ought to change without the OS freaking out.

    Ideally what I’d like is a core OS running on my phone, that I can then plug into another device (docking station, tablet, whatever) and have that docking station add CPUs, Memory, displays, etc. without the OS missing a beat. It might take a minute to sync up, but if I have a dual socket quad core CPUs on my desk, I’d like my OS session to take advantage of them. I want things to speed up. If I have 128GB of RAM on my desk, pick that up and start using it for Powerpivot, editing movies, or anything else.

    Undocking is definitely the harder part. When I lose RAM, what happens? Well, I’d expect that applications using that memory would have to suspect themselves, perhaps even in the other hardware. Or maybe they’d suspend, rebuild their state, and have to reload things from disk (on the phone). Threads on CPUs would be tricky, but there are a few scenarios on how to recover applications, including letting them die, but it could work.

    Potentially we’d start most CPU work as transactional as we do in databases, and only commit the state at known points, so that a drop in hardware would result in a “rollback”. I suppose we could also do something like spawn off threads that are either always on the phone/small device or always on the remote hardware, but there are some smart people in the world that I suspect could come up with a solution.

    I’d expect things might freeze state when I dock/undock, but I’d want them to keep working at some point, even if they went into some background/sleeping state.

    Virtualization

    I’d like to see more virtualization, but at a core application level. Let me essentially sandbox an application into a VM, which thinks it’s on it’s own OS installation, but limit it to very basic interactions, like the clipboard. Can you imagine if Windows did this, and opened up a few VMs from Linux, or even allowed people to get a $29 OSX install running for a few pieces of software? I don’t know the legalities, but it would be a game changer in many ways.

    Think Different

    The best thing Microsoft could do is really think different. Don’t evolve Windows, but really grow it into something that is handy, ergonomic, efficient, and effective. Don’t worry about matching up with older software. iOS showed many people will port their stuff over if you make it popular, so give up on making things backward compatible.

    Break things if you must, but just make it better.

  • Ownership Chains in SQL Server

    Someone asked the question recently about allowing a user to run a process,but not execute the individual pieces of the process. I replied that ownership chains allow this, and then explained things. Here’s a short example of that.

    Let’s suppose I have a process that removes data from a table and then reloads it. Perhaps it’s a report, perhaps it’s a static look at inventory, it doesn’t matter. Can I allow a normal user to execute the entire process, but not the clear or load pieces?

    I can, and here’s how.

    Suppose I have a clear procedure:

    CREATE PROCEDURE dbo.spClear
    AS
    BEGIN
       select 'Clear'
    END
    go

    For the sake of this example, I don’t have any work here, but the "SELECT ‘Clear"’” could be replaced by a TRUNCATE TABLE or other statement.

    By default in SQL Server, I don’t have rights to execute procedures that I haven’t created. In this case, assume a db_owner created this procedure, so a normal user, Joe, would not be able to execute it. In fact, if I log in as Joe and run this, I get:

    SETUSER 'Joe' 
    go
    -- Fails
    EXEC spClear
    go
    

    Msg 229, Level 14, State 5, Procedure spClear, Line 1

    The EXECUTE permission was denied on the object ‘spClear’, database ‘db1’, schema ‘dbo’.

     

    That’s expected, and it’s good.

    Let’s also create a load procedure, as the db_owner.

    CREATE PROCEDURE dbo.spLoad
    as
    BEGIN
       select 'Load'
    END
    go

    Now to manage the process, let’s create a wrapper stored procedure that calls these. For the sake of tracking what’s happening, I have a few statements in there.

    CREATE PROCEDURE dbo.spRefresh
    AS
    BEGIN
       select 'Refresh start'
       EXEC spClear
       EXEC spLoad
       SELECT 'Refresh End'
    END
    go

    If I were to call this process, this is what I’d expect from the call stack:

    • a call spRefresh
    • a result set returning “Refresh Start’”
    • a call to spClear
    • a result set returning “Clear”
    • return to spRefresh
    • a call to spLoad
    • a result set returning “Load”
    • a return to spRefresh
    • a result set returning “Refresh End”
    • end of spRefresh

    Obviously I could have actual delete or truncates in the clear procedure and then some insert in the load procedure. If I attempt to run this as Joe, I get:

    Msg 229, Level 14, State 5, Procedure spRefresh, Line 1

    The EXECUTE permission was denied on the object ‘spRefresh’, database ‘db1’, schema ‘dbo’.

    Expected, because I haven’t granted Joe rights. Let’s do that and execute the procedure:

    GRANT EXECUTE ON dbo.spRefresh TO Joe
    go
    SETUSER 'Joe' 
    GO
    EXEC spRefresh

    I get what I expected for results:

    ownership_a

    I have rights to execute spRefresh. Since the same owner exists for all three objects, dbo in this case, I have a chain that permissions are not checked for spLoad and spClear. I can execute them in the context of spRefresh.

    What about separately?

    EXEC spLoad

    gets me:

    Msg 229, Level 14, State 5, Procedure spLoad, Line 1

    The EXECUTE permission was denied on the object ‘spLoad’, database ‘db1’, schema ‘dbo’.

    and

    EXEC spClear

    gets me

    Msg 229, Level 14, State 5, Procedure spClear, Line 1

    The EXECUTE permission was denied on the object ‘spClear’, database ‘db1’, schema ‘dbo’.

    A nice way to allow someone to execute a group of processes without allowing them to execute any individual one.

  • T-SQL Tuesday #28 – Jack of all Trades, Master of None

    tsqltuesdayIt’s that time of the month again, T-SQL Tuesday Tuesday. This month Argenis Fernandez, MCM, and big round SQL teddy-bear is hosting. His topic is Jack of All Trades, Master of None.

    The second Tuesday of every month is when the blog party takes off. If you want to participate, read Argenis’ post and write your own entry. If you want to host, contact Adam Machanic.

    Jack of All Trades, Master of None

    After my third year of college, I went to work at a new hotel in Virginia Beach. I hadn’t had much experience in the restaurant industry, other than cooking one semester at college, so they hired me to be a busboy and room service waiter. I opened the hotel working in the café, but the slow start caused some people to quit. When a waiter didn’t show up one day, I volunteered, got a chance, and moved up in the world. When a bartender didn’t show up one afternoon, I volunteered, and had a new gig for the rest of the summer.

    It’s been a mantra for me for the most part in my career. I like challenges, I like new things, and I’m not afraid to tackle much. The same way I moved up in the restaurant business to new (and better paying) jobs worked in technology. However the “jack of all trades” philosophy hasn’t been just about getting new jobs, but also being better at my main job.

    At more than a few companies, I’ve been happy to fill in for the network person, the sysadmin, the Exchange manager, the developer, doing my best to fix something or improve it. As I’ve been a DBA, I’ve worked on PHP, ASP, HTML, XML, Cisco IOS, configured T-1 lines, changed batteries in UPSes, and more. Those skills have helped me to understand how things are put together, and enabled me to solve more than a few complex problems, in complex architectures, because I could truly see the forest. Even if I didn’t understand how everything worked, I knew how lots of parts were supposed to work, and how they were plugged together.

    Even today in SQL Server, I write about all sorts of topics, and review pieces on all aspects of the SQL Server platform. I don’t know how to configure them all as an expert, but I know a lot about how most of the platform works, even if I don’t know all the details. Sometimes that’s enough to get me by.

    It’s not all perfect, and I don’t think being Jack is better than being a master. There are more jobs for the “Jacks” of the world, but the pay tends to be lower. Masters make more, but have fewer opportunities, and fewer places they might get to live/work at any point in time. There’s a (I think) higher level of satisfaction from being a master in some area of your field, and I can appreciate that. I’ll also say that most of the “masters” I know that are fairly specialized have this innate motivation to learn more about their topic, which bleeds off into other sections of their field, making them knowledgeable in a “Jack” way on other parts of their industry.

    In the end, I think it’s fine to be a Jack or a master, just be true to yourself. Do the things that you enjoy, and if that’s one or the other, you should have a great career.

  • Traveling More Than Expected

    For a guy that was looking to not travel much, it seems that I’ve got way more on my plate than I expected. Right now I have these trips scheduled. At most of them, I’m scheduled to deliver some type of talk.

    That’s quite a bit of travel for me. Add to that these personal trips:

    • Boy Scout camping in April
    • Summer Camp for Boy Scouts in June
    • Summer Camp for Girl Scouts (weekend) in July
    • Two horse race trips with my wife
    • Summer Camping with the family in August

    So much for an off year.