However, on its own, raw data doesn't have the proper context or meaning to provide meaningful insights to analysts, data scientists, or business decision makers.īig data requires a service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. In the world of big data, raw, unorganized data is often stored in relational, non-relational, and other storage systems. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. In Randy’s words, “We've assembled a great team of SQL Server Consultants at SQL Solutions Group, and we have the talent to tackle anything.Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. In addition to getting elbow-deep in data, Randy enjoys taking part in and presenting at SQL Server events nationwide, including SQLSaturday, User Groups, SQL PASS Rally and SQL PASS Summit. Prior to founding SSG, he spent many years as a Database Administrator in a variety of industries, including financial services, telecommunications, and with well-known dot com properties.Īs a data professional, Randy says he has done lots of fun stuff, encountering the most interesting data during his time as database architect for (and no, he didn’t meet his wife while working there). In addition, he has numerous Novell, Microsoft, and Cisco legacy certifications. In 2020 he completed certification for Azure Fundamentals. Randy is a Microsoft Certified Solutions Master in SQL Server 2008. His prowess with SQL Server earned him the label “database whisperer” from one satisfied customer. Randy has a passion for solving what can seem to others to be insurmountable problems. Randy Knight, a Microsoft Certified Master, founded SQL Solutions Group in October 2010, after more than 20 years in the technology industry. Watch for a blog from Scott in the next day or two for background on this battle of the apps.įasten your seat belts! This is going to be a blast. Then, on March 17th, Scott will host a Webinar on SSMS vs. In the spirit of skilling up, my co-worker Scott Klein and I were discussing this a couple of weeks ago and we hatched a plan: For the next 30 days, we are both going to force ourselves to use ADS for everything we do. Like many others, I have not been super fast to adopt and start using it. ADS is a fork of Visual Studio Code, so if you’ve used that at all it will be very familiar. In 2018, Microsoft released Azure Data Studio (ADS). We have seen massive changes to the Microsoft Data Platform over the last 5-10 years - PowerShell, Azure, other cloud platforms, and the advent of technologies such as NoSQL databases and Big Data to name a few. What does this have to do with being a DBA in 2021? Everything. In fact, in the spirit of full disclosure, I did not really focus on using DMVs and upgrading those skills until 2008 or so when I attended a pre-conference workshop on DMVs given by Kevin Kline (Twitter). To this day I still find myself querying old system tables such as sysfiles or sysprocesses when I’m not thinking about it. For those of us who had been using the product for quite some time, getting rid of Enterprise Manager and Query Analyzer was big deal and a steep learning curve.ĭMVs were even worse. This was a massive change to SQL Server with the introduction of SQL Server Management Studio (SSMS), Dynamic Management Objects (i.e. Even more importantly, there may be a MUCH easier way to do something with newer tools or techniques.Ī great example of this is going back to when SQL 2005 was released. One of the things I have found over the years is that it is easy to get into a rut and do things “the way I’ve always done them.” While this is perfectly natural, it also leads to a degradation of skills over time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |