Author: way0utwest

  • SQL Deep Dives at Intersection in April

    SQL_SP14_300x250_v2

    SQL Intersection is coming to Orlando in April, along with the rest of the Dev Intersection events the week of the 13-16th. I’ll be there speaking, along with an amazing lineup of other SQL Server experts. The SQLskills crew is headline and organizing the event and I’m looking forward to going.

    This is a smaller conference, and it’s located at an amazing facility in Orlando. It will be warm, relaxing, and a great environment to learn a ton about SQL Server.

    If you’re looking to jumpstart your SQL Server skills and get excited about the platform, consider joining me in Florida this April.

  • Zombie Data

    Most of us that work with data are concerned about losing any of the bits or bytes we are responsible for. Many of us practice restores when we can, we complain about the low disaster recovery budgets we’re allowed, and we regularly check our systems for corruption. Even those of us that aren’t extremely diligent in our daily data protection are often worried about losing our jobs if a disaster causes data loss. Many of us don’t even trust our users, preferring to implement logical deletes in applications rather than physically running a DELETE statement.

    However there are times that we do want to remove data from our systems. We may find data quality is poor and want to erase the results of an ETL load. We may find ourselves bound by regulations that require the removal of data from our systems. We may upgrade old software and end up with copies of obsolete databases whose contents have been copied and reformatted by a new version of an application.

    This article talks about the data-pocolypse, and in somewhat of a jesting way, but it has a few good points that we may want to consider when we do need to remove data permanently. We should understand that deletes are not always deletes, and if a permanent solution is needed, we should use a utility to wipe the drive or physically destroy the hardware. However there are other places we should worry about old copies of data. Backups should be deleted from remote storage that might not have cleanup jobs running anymore if the servers are decommissioned. We should be wary about taking databases offline, or detaching them without physically removing the files. Development machines, laptops, etc. should have data removed if we are sure we don’t need it again.

    We should be especially careful about security access to servers that we are not using. Users might easily have links or pointers to old servers, and mistakenly connect. Make sure you remove access when you decommission the instance. Be careful about keeping old file exports, such as reports or feeds that were generated in the past. It might not be practical to wipe backup tapes, but be sure you’ve changed documentation and surfaced the information to all administrators that copes of databases restored from tapes after xxx date are not useable in DR situations.

    Of course the first thing you should do is make sure you have a good backup of the most current version of your data before you start deleting older copies. Delete this last, after you’re absolutely sure that users are no longer going to request a restore. I wouldn’t even ask users about this, however, because they may not be sure themselves. Instead I’d set a reminder a few months in the future to go back and delete this one, last, most current backup.

    Steve Jones

    The Voice of the DBA Podcast

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

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

  • Powershell in a Month Day 15 – Jobs

    This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month of Lunches book by Don Jones.

    Jobs are important, mostly because running stuff interactively, and manually, is a pain. The real power of PoSh administration, in my mind, is that not only can I run things across lots of servers, but I can also have some jobs run automatically. The Windows Scheduler isn’t always a part of this, though I’m not sure the PoSh system is better after reading this chapter.

    It’s a short one, but one that I did like. I’ve always liked scheduling jobs and having them do work for me. I can see this being handy, but the processing of results is something that will be important. That means saving this stuff off and practicing formatting.

    It’s an interesting approach here. The chapter has you create some jobs and then it explains how they work. Getting results, stopping jobs, checking them, etc. all occur as you have jobs running. All good admin things. I have the feeling I’ll refer back here as I build jobs.

    The scheduling comes after there’s an explanation of jobs themselves. We learn briefly how to schedule, but not in detail. To be fair, there isn’t a lot to worry about here.

    The lab was fairly easy. Most of the items were things I know how to do from the past, or I learned here. The recursing into subdirectories was a little tricky since I’ve used “/s” forever, but I needed to understand in PoSH that -recurse and -filter were needed here.

    I’ll be looking to play with some scheduled jobs that might clear out old files on my machine, especially backups. This would be some good practice for a job. I certainly should create a job to trim out IIS log files since that’s something I’ve seen needed on every web server I’ve encountered.

  • Big Data Comes to Hiring

    I remember first seeing kiosks a few years back in some stores such as Best Buy, Target, Barnes and Nobles, etc. The devices had banners above them that invited people to apply for a job using the computerized system. This was just before my oldest son started applying for jobs, and shortly thereafter I found a few articles that stated quite a few of these large corporations were using the same company to manage the kiosks and pre-screen candidates. Not only were they considering the applications, but they were examining employment records, noting which candidates might have been terminated or left another job quickly. They were trying to use analytics to decide which applicants to interview.

    That entire process reminded me of the “black mark” on your record that I heard about as a kid. It was a reminder to not make too many mistakes, at least not serious ones, that might follow you forever. It appears now that it’s not just entry level jobs that are starting to use data and analysis for hiring decisions. It seems as though some companies are starting to evaluate candidates with different types of algorithms and applications for a wide range of positions. This piece from the Atlantic talks about the history of hiring and a few ways in which data is being gathered about workers and used to analyze their performance. Even more interesting the section about halfway down that talks about how they analyze developer’s work from afar.

    It’s expensive, time consuming, and stressful to hire people. We’ve proven in technology over and over that many of the hiring decisions made, aren’t made that well. We find talented people being underpaid and quick to leave, while other employees are overpaid and are happy to toil away in their positions for years. Neither situation is good for the employer, and often not good for the employee either. It’s less than motivating for any of us when we don’t find some challenge and enjoyment in our jobs.

    Ultimately I know more “people analytics” will be used in the hiring process by some companies, but I find that even with the data, there’s one thing that seems to matter more: personal referrals. Networking matters, and there is no shortage of companies that are placing lots of value on their employees’ networks. Some of them are even looking to conduct the majority of their hires through networking. So make sure you’re networking with others in technology. You never know when it will be the way you get your next job.

    Steve Jones

    The Voice of the DBA Podcast

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

    The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.