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

Nonclustered Index in SQL Server

So, I've run into an issue with one of my queries because it takes about 40 seconds to run and according to the Recent Expensive Queries section of the Activity Monitor in SQL Server, there is a section of code taking up about 51% of the query.  First, let me say that I've been writing Transact SQL for quite awhile but have never ventured into the Clustered and NonClustered areas of forming Indexes.  I do use indexes on all my tables but that's just the regular Primary Unique key.  We've been using this query for awhile and it does work but when the result set is about 5K records it takes a little while to run.  So here's the actual query itself SELECT PartNo , SerialNo , HeciCode , ScanDate , OrderType , PoNo , po . IssueDate , SoNo FROM ScanHistory sh WITH ( NOLOCK ) LEFT OUTER JOIN trkRWPOHeader po WITH ( NOLOCK ) ON sh . PoNo = po . PONum WHERE len ( PoNo ) > 2 AND ScanDate >
Post a Comment
Read more

Would I Be A Good Programming Teacher?

One of the things I've always asked myself is, "would I be good at teaching/coaching programming"?  I guess after 20 years of programming you'd like to think you could teach but do you have to know everything?  How will I come across to the person(s) I'm teaching?  Would I enjoy it? I'm starting to realize that you don't have to know everything about what your teaching or coaching.  This has been evident from my own experience and from the books/articles I've read (including the one below).  You just have to ask questions! Recently, I've been coaching/teaching our network guy at my work learn how to code.  And it's amazing how much knowledge comes out when you start to explain things not to yourself, but to another individual.  Plus I've been reading some books that show that teaching what you learn helps you retain that information even better. I've been learning some new languages and while learning these I'm thinking to mysel
Post a Comment
Read more