Skip to main content

SQL Server and Metadata

Read an interesting article this morning by Alex Fleming called Microsoft SQL Server Metadata For Developers - I was interested in this article because I'm been using SQL Server for over 18 years now but didn't really know much about Metadata.

First, I didn't realize that SQL Server 2016 had recently taken the lead in RDMSs. And that SQL Server 2017 supports programming languages R and Python!

Alex talks about 3 essential SQL Server skills all developers should have.

1) Knowing SQL or T-SQL, it's very valuable scripting language in SQL Server and is something I know quite well.

2) Powershell - another powerful scripting language allowing users to automate tasks, which usually involve SSRS (SQL Server Reporting Services).  I have this on my list of To Learns!

3) Use of Metadata - basically how a developer applies knowledge of metadata in T-SQL, Alex talks about how metadata is overlooked but should be an important part of a developer's skill.  My understanding of Metadata is it's the information of the data itself;  for example if you have several tables in your database and the Field BusinessID is used in several of them, you can use T-SQL to find where the BusinessID's reside

Alex also provided links to more information on Metadata, which I plan on reading more on this week.

Comments

Post a Comment

Popular posts from this blog

Alexa Is Listening, Recording, and Sending!

Check out this story where a couple in Oregon was having a private conversation and Alexa recorded and sent the conversation to one of their contacts!  They were not aware until the contact contacted them about what had happened.  The couple contacted Amazon and they verified the series of events.  But what's even more bizarre is the couple wanted to return their Amazon home devices but Amazon has not agreed to return the costs for the devices! Check out the article here  by Bruce Brown on  Digital Trends
Post a Comment
Read more

Cybersecurity

I went to a Cybersecurity conference last week hosted by  Data Connectors and I want to give kudos for the job well done in running the conference.  First of all they held the conference in a very nice Westin downtown, so the facility was great!  The Vendors were very informative and the presentations were very good as well!  There was a good mix of breaks so we could talk with the Vendors and learn more about their products.  The lunch and snacks were good too!  Always a plus! But back to the subject of Cybersecurity.  It's truly amazing all the cyber attacks made against companies, websites, home owners, smart phones, etc.  I don't remember the exact numbers, but at the time they presented them, I was amazed how high it is, and how high it's going to be.  Everything on the web is exposed and most people don't realize the bad exposure that's out there.  Yes, bigger companies are spending lots of money to protect their data but the ...
1 comment
Read more

My Twitter Followers Have Gone Down!

If you're a Twitter user you might have heard or seen on your account the number of followers go down.  For some of us, those numbers might be minimal.  I have a Twitter account @NKYSports which I use in connection with one of my High School sports website NKYSports.com.  Last week I had about 6,070 followers.  That number today is down about 100.  But I have heard users who have followers over 50K, 100K, etc. losing thousands and thousands of "so-called" followers. So what happened?  Twitter has started cleaning accounts due to fake news scandals and data privacy.  That equates to about 1 million accounts the past quarter (2nd Q of 2018).  Twitter CEO Jack Dorsey says improving the health of the platform is critical for future growth. Twitter has been a great tool for my website, but I also like getting updates sent directly to my phone to get the latest news, sports, weather, etc.  I know what to believe and not to believe as well!...
Post a Comment
Read more