Voice of the DBA

Author: way0utwest

  • #SQLNewBlogger–Adding Local Accounts

     

    What do you do if you need a process running under Local Service to connect to your SQL Server? Most of the advice out there is to change the login account. I actually agree with that, but there are times you can’t, or don’t want to.

    There are certainly times when I’ve seen some automated process use one of these accounts:

    • NT Authority\Network Service
    • NT Authority\Local Server

    Often this is because someone doesn’t want to bother to learn how to enable other accounts for their application, which isn’t a good excuse. In my case, I had a local VSTS agent service running as part of a demo, where I had very limited rights. I couldn’t affect a change, and I needed to get a new login for SQL Server.

    I searched a bit, but most advice said to just change the account, after all, if you had a process connecting from another machine, Local Service won’t work. However I found one item on Stack Overflow that helped.

    Here’s my Login list. As you can see, I have Network Service, but not Local Service.

    2016-03-25 12_50_57-Alarms & Clock

    I the run this code:

    CREATE LOGIN [NT AUTHORITY\LOCAL SERVICE] FROM WINDOWS;

    This gives me a new login.

    2016-03-25 12_52_48-Alarms & Clock

    In my situation, I then had to add this to the dbcreator role, but I could treat this like any other login and assign the minimum privileges needed.

    SQLNewBlogger

    I had to solve this and decided to write about it. The writing took 10 minutes, the research was 15-20 minutes to find a good reference and experiment a bit.

    A good learning exercise, and all of you should know how to do this. Prove it with your own blog.

  • SnowCrash for SQL Server

    Years ago I read Snow Crash and really enjoyed the novel. In it, a virtual reality world exists, where many people connect to and roam about in a virtual world, experiencing various 3D type views of applications, systems, and data. There are numerous other novels that enjoy similar worlds, like Ready Player One and Warstrider. It’s an idea that many people look forward to as virtual reality systems grow in power and capability.

    With Microsoft’s HoloLens, there’s a project underway to bring more virtual reality to our everyday world, including the management of IT systems. There are various people at Microsoft Research looking to allow us to navigate the complexity of our IT installations, including SQL Server instances, to better understand the relationships between our servers.

    This is exciting in some sense. Can you imagine being able to “move” through space to a Production SQL Server, viewing the real time access of queries, users, and data. We would be able to grab a query and pause it, cancel it, even follow chains of blocking to find the sources of issues in a way that is likely to be more natural for many of the people that will enter the technology field in the next 20 years.

    It’s April 1, and I’m somewhat joking and somewhat not. I’m not sure if there is any project underway specifically for managing IT systems, but I could see this as a way of better visualizing and working with large amounts of data. Certainly there might be visual analysis of Big Data that makes sense, but I could see large amount of security data, logging, auditing data that is better dealt with in some sort of virtual reality interface.

    I know this might seem strange to some of us. I’ve tried the Oculus hardware and Samsung VR systems, and they have a long way to go before I’d want one, but I have dreams of being able to more easily navigate the complexity of our systems in a way that might feel more natural and intuitive than the ever growing list of folders and dialogs in Management Studio.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.8MB) podcast or subscribe to the feed at iTunes and LibSyn.

  • No Overtime

    This editorial was originally published on Dec 5, 2011. It is being re-run as Steve is out of town.

    It’s been a long time since I received overtime at any job. Most of my IT work has been with a salary, and the expectation that I would work as needed to accomplish my assignments. Early in my career I worked as a contract for an hourly rate, and while it didn’t necessarily lower the hours I worked, I did receive a little more pay on long weeks. From there I worked for a company that provided “comp time” when the hours exceeded 20 hours in a month. That seemed to help reduce hours more than anything.

    There’s a bill that’s in the US Congress that adds some new job classifications to the exemptions for overtime pay. In addition to the system administrative jobs, it now includes database and network professionals. I’m not sure how many people this affects as the overtime requirements disappear once you make more than $27.63 an hour. That equates to about an annual salary of 57,491, without the benefits. If you make less than this, you should be getting overtime.

    Does overtime pay matter to most IT workers? I don’t know. There are lots of workers who make more than US$60,000 a year, and are exempt, but I suspect there are many others who make less than this amount and work long hours without any extra compensation. This bill is aimed squarely at reducing pay for those people in the industry that make the least amount of money.

    I struggle with whether the benefits and abuses of a salary. On one hand salaries provide a level of security to workers, along with a guarantee of payment for work that cannot easily be measured in terms of output per unit of time. On the other hand, employers sometimes see a salary as a way to push workers to their limits, burn them out, and impose strict requirements on the work needed for deadlines, themselves often arbitrary.

    I like the idea of allowing businesses to pay salaries, and stabilize their cost structures, but I do think we ought to implement a few bumpers that prevent abuses. Limiting hours across a month or quarter and ensuring that employees can take their vacations would be limits that I’d like to see implemented. This bill doesn’t affect those and I’m not sure we’ll see any limits implemented, but I do think it’s up to each person to stand up to their employer and ensure they are not overworking themselves.

    Steve Jones

  • Examining SQL Server 2016

    SQL Sever 2016 is getting close to release. The updates are coming fast and furious, causing issues in some cases as many people look to test the new features in different environments. Personally, I’m struggling a bit to determine which of my environments to update and test, and which to skip. It’s also hard to keep track of those items that work in newer environments, and those I need to keep working on old systems with older code.

    We saw CTP 3.3 this year in January, with both RC0 and RC1 coming in March. I expect we will see an RTM soon, though it’s possible we have more Release Candidates before then. I know there are still some bugs in RC1, so I’m hoping we get at least one more release to show that both the core platform, as well as SSMS, are stable and working well.

    I know many of you won’t be upgrading any production systems, and maybe not even development systems, anytime soon. However are you looking to work with the platform and understand how it’s changed? I think SQL Server 2016 deserves a look, even if it’s curiosity. There are quite a few changes and it’s possible you’ll find some things in there that may make an upgrade worthwhile.

    Even if you don’t find anything valuable for your organization, it’s a neat release, with quite a few enhancements and additions. There are features you are just interesting and exciting to experiment with. Certainly there is plenty to learn as well, with the chance to see how new features, like temporal tables, work, or test the new T-SQL functions against your current code and see if you can beat them.

    Looking at a new bit of software can be invigorating to your career, as you try to grow your knowledge and build new skills. Given that most of us perform work that requires thought, just exercising your brain with the SQL Server 2016 eval might enhance your thought processs and let you enjoy your job just a bit more.

    Steve Jones

    The Voice of the DBA Podcast

    Listen to the MP3 Audio ( 2.9MB) podcast or subscribe to the feed at iTunes and LibSyn.