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! |
Types of indexes (Types of Indices) see Video below! DBAs are constantly facing challenges with making queries run faster. One of the top tuning procedures is to add an index to the table or tables in order to increase the optimizer's accessibility to the requested data. *Note - The first three definitions are excerpts from lyrics in my index song. The remaining definitions come from the referenced link below. Again, my intentions are to inspire listeners to learn through my songs. For example - The different types of indexes in SQL Server 2016 are now ingrained in my memory!
ONLINE REFERENCE: https://msdn.microsoft.com/en-us/library/ms175049.aspx
1 Comment
Security in the world of data has become very important. Computer viruses, Identity theft, hacked websites and more have put “data security” at the forefront of this new era of "having lots of data and storage." This is the first time in known human history that we have been able to store as much data as we have! Even at this very moment that you are reading this, data storage technology is improving at radical speeds. Not only are we able to store more data than we could yesterday, but we are now able to retain, save and archive this data with better safety precautions. Increased Disaster recovery plans over time have given us the abilities to have more insight so that data will tell us what we have done wrong in the past as well as how we can improve our future. Companies are now realizing that data is what acquires new customers, retains customers, generates money, etc… Bottom line - data doesn’t lie! I can go on and on about the importance of protecting data. Here are a few security items mentioned in my new song:
https://www.mssqltips.com/sqlservertip/3159/sql-server-security-checklist/ http://searchsqlserver.techtarget.com/tip/Microsoft-SQL-Server-security-best-practices-checklist/ Wow! I really do appreciate all of the positive responses I have received regarding my SQL Server 2016 song! This only confirms my belief that I should continue with my journey. One of my goals is to complete enough songs so that I can create an album. My hope - is that these songs help others as much as they have helped me with my studies and retaining knowledge about SQL Server. If you have any suggestions, comments or criticisms ... please don't hesitate to let me know! Thanks again everyone! I'll keep it going... next song... "Data Protection" Peace, KillaDBA As a DBA I always have to read up on new features with SQL Server. Even though I read about and mostly use these new features, I rarely remember which feature is new to a particular SQL Server version. At times it can be difficult for me to retain information that I have not experienced firsthand. My first song is about SQL Server 2016 features. I realized that if I created a song about the new features, it would help me to speed up my aspirations to become a subject matter expert and also to remember these new features as time goes on! I cover most of the popular new features in my lyrics. I created the music, lyrics and also the melody (which is my personal favorite) So... without further delay... I present to you "SQL Server 2016" |
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
|