SQL is a stout language and SQL Server has so many features that it’s impossible to be an expert in everything. I see a lot of people gravitate towards performance; but, that’s not the best place to focus. If you don’t know the fundamentals of the language then you will never be the best performance tuner.Read More »
I decided to poke fun at ORM tools again this week. Hope you enjoy.
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more than just a database; but, products that ingest data for analysis still need to get the data from a source, such as an OLTP SQL database.Read More »
Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and there are a lot of great speakers to check out. If you’re in LA or the surrounding area on June 9th be sure to check it out. The event is a LMU and it’s sure to be packed with knowledge and prizes.
The event is totally free and all are welcome. Register here to start the fun: https://www.sqlsaturday.com/773/registernow.aspx
I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took me to Oracle and then translated nicely to SQL Server where I’ve spent the bulk of my time.
Along the way different projects had different requirements and challenges. To take these on and be a better DBA, I learned VB 6 and then VB.NET. A C++/C# developer asked why I was wasting my time relearning VB when I could learn a real language (C#). Years later I got tired of TechNet samples being only C# and I learned it and primarily use C# as my dev language of choice today.
It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to getting yard work done and browsing through the whoisactive SQL Ops Studio extension code.
Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look how many people are listening to the perf tuning session vs the 3 people attending the security session.
Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the hip new thing as opposed to quality of life. I’ve even recently heard people complain to Microsoft that they only focus on new features instead of making existing ones better.