KillaDBAKilla DBA will
*Perform tech related songs at your I.T. event! *Write an I.T. jingle/or song for your product or company! *Create a song for your website, commercial, presentation and more! |
|
This song is a parody of Drake's song: God's Plan. I've been migrating a lot of databases for various reasons lately... which inspired me to do this one.
0 Comments
Ok... WOW! Where have I been? With work, being a dad/husband and now school... it's been difficult to keep this blog going.... but.... I'm back! This song is about Microsoft's relation database management system named SQL Server 2017. You can now experience the benefits of running SQL Server on an open source system as well as in the cloud (Azure), Docker containers or Windows. Check it out! I think Big Data is interesting because our world is now data driven and we have the technology to hold so much data these days.... it will only get better. My lyrics talk about the Big Data concepts and what we know about it at this point in time. I took a few snippets from my visit and performances at Microsoft in Redmond, Seattle during the SQL Saturday event.: I was signed up to present at my local PASS chapter meeting (http://atlantamdf.com/) on January 8th 2018. The only problem with this is that my alma mater, The University of Georgia, was playing in the College Football National Championship game…. And I had tickets! Needless to say, I didn’t present… but I did create a video that was played at the meeting. Here is the video that was played that is a walk-through demo of me installing SQL Server 2017 on Red Hat Linux 7.4 on a virtual box VM: Double wow! I attended PASS Summit in Seattle, Washington this past fall and I had a great experience! I would suggest that anyone passionate about data should definitely attend this event. PASS Summit is the world’s largest conference in the world for SQL Server professionals. Find out more about SQL Server here: http://www.pass.org/ I met so many cool people with the same interests in data and I also got to perform in front of my fellow PASS attendees! You can check out my PASS summit recap in this video below! I only had 5 seconds to explain each picture but I believe I still did a good job in describing my experience: Big Data {Verse 1} Never in the history of humans have we ever seen a day like this when data is abundant to infinity We’ve always backed up data like on walls with hieroglyphics But now we have a thousand ways to reclaim what goes missing Computers –man- Technology, servers, in the cloud lies Millions I mean Billions perhaps trillions of these hard drives. We live in times where we can finally process, All this data is a mess - Without tools so we can use it Mass data - that can tell us what is what – Insight is what we need - and Big Data is what’s up The who, the what, the when -when we gotta know the why. Big data in the answer -because Data Doesn’t Lie, <ha ha!> We have abilities to structure, make it clean then decide how-to extract - Now I’m talking ‘bout the V’s Volume-Variety-Velocity - that’s 3 But we can’t forget Veracity or Variability – Big Data. {Verse 2} So now were living in a time – where he have a lot of data But it doesn’t mean a hoot – if we don’t know how to leverage. Our society will benefit – analysis - efficiency I am a data scientist – it’s my way of philanthropy. Money we could save, give away or just make Is but one way that Big Data could assist – so many ways Shout out Apache software – Yes I’m talking ‘bout Hadoop I’m using Polybase from Microsoft to get the scoop The news, the clues, from any storage system So never ever purge – we have clever algorithms that make it so that different platforms talk to each other The different data sets - and complex architecture. So analyze the trends - we are all made of atoms On a sub-atomic level - just like atoms we have patterns Big data is the future where the data tells the future Mass data into structure making decisions to deliver – Big Data  Here is a video that shows snippets of Killa DBA in Redmond, WA performing at a SQL Saturday event (Microsoft building 92) Wow! SQL Saturday in Redmond, WA on 4/15/2017 was a success! My wife and I really enjoyed Seattle and our tour of the Microsoft campus in Redmond. the people were great, the presenters were very informative, the food was awesome and Killa DBA had a "killer" performance! Here is a snippet of the performance: Here are a few pictures from my trip to Microsoft (Bldg 92)      I really enjoy writing songs. Especially when they come to me easily. Which isn't always the case. This song was fun to write and record because it all flowed with ease. Although the song is fictional, there are many snap shots of my experiences as an employee and DBA in an IT department. The lyrics below are preserved exactly how I write them in my word or notes document. Please see song/video below. IT Girl {Chorus} I’m in love with an IT girl (Love - Love) I’m in love with an IT girl (Love - Love) I’m in love with an IT girl (Love - Love) I’m in love with an IT – IT Girl {Verse 1} So I’m a DBA and databases are my world Until I met a girl - She is an app developer. See I knew from the start - this programmer stole my heart Used to favor VB – now I’m digging C – sharp. I love her source code, so efficient – good code. She even flipped the script – converted to Java script. My head is in the cloud, like her applications are Instead of Diamonds and Pearls, she likes Python and Perl. {Pre-Hook} In the studio – I’m talking BIDs -that is With my SSIS and her IP address - we fell in love. From QA to Test all-the-way-to-Prod. Yeah - I’m Ok with her – she’s my de-ve-lop-er. {Chorus} {Verse 2} So as her DBA – I did suggest an upgrade SQL Server 16 – not that other database She agreed – got approved -from the upper management Databases mi-grated – it was money well spent. On deployment night – RFC looked tight But to add to this story – there was not enough storage. I’m Killa DBA – and that’s good for us both ‘cause before we got started - I enabled auto growth! {Pre-Hook} In the studio – I’m talking BIDs -that is With my SSIS and her IP address - we fell in love. From QA to Test all-the-way-to-Prod. Yeah - I’m Ok with her – she’s my de-ve-lop-er. {Chorus} {Rap} <pause> Her .NET Framework –yeah- is all that From mobile –to- desktops -all the way to Web apps. I like the way she moves – in and out of code-it’s like her name was -Trinity Straight out of Matrix Reloaded. Huh – Better yet – she’s an architect. You can tell by her Data-flow analysis She bang slash user slash local bin Perl (#!/usr/local/bin/perl) I love with her brain – my IT Girl. Instead of listing interesting facts about the importance of the backup and recovery process... I have decided to list the lyrics of my song instead. Please see link below for song. Backup and Recovery (Bits & Bytes) {Chorus} I’m putting your bits where your bytes should be… {Verse 1} Ooooo back it up – easy back it up – Killa DBA-let me explain to you what’s up. The backup and restore are really crucial to survival Minimize the data loss. Protection is so vital. Corruption, disasters, disgruntled employees. I’m gonna cover some Backup and restore strategies. Never put the data file and backup on the same device. Just incase the drive fails also I/O will prevail. So let’s consider- will the database get bigger? What’s the nature of the data? Backup now? Backup later? How much space will it take? Should I schedule for tomorrow? Is this a simple, bulk-logged or a full recovery model? Make sure you test it. The data is invested So recovery tests regularly - is suggested. Maintenance plans help you really understand. Scheduled jobs in place – to reclaim more space – so Lets go! {Chorus} I’m putting your bits where your bytes should be… {Verse 2} A full backup gets the data, t-logs, everything A differential only gets extents that have changed. The file backup will allow you to pick out the data file. Filegroups are the same Backup the groups by name. Partial backups – with the groups and files you pick and choose. With Copy-only backups there are no logs to include. Mirror backups will ensure multiple copies. Transaction logs for the point in time recovery. Restore it with the GUI or with T-SQL. Restore it like a boss by cracking open PowerShell. From which media type? From the file or Device? From a tape? URL? Azure storage container? The WITH option: REPLACE, KEEP_REPLICATION, RESTRICTED USER to keep out other thread connections RECOVERY, NO-RECOVERY or STANDBY Please master this -Or you can kiss your data bye bye! {Chorus} I’m putting your bits where your bytes should be… References:
https://technet.microsoft.com/en-us/library/ms175477(v=sql.105).aspx https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql |
KillaDBAOver 19 years as a DBA. I've created solutions to many issues. Wrote a song about it. Wanna hear it? Archives
October 2018
Categories
|
RSS Feed