Let’s say you have some obscure list of career goals for the year and one of those is to be a champion of innovation. I’m sure many of you reading this have probably run across goals like this before. I see a lot of people struggle with larger companies and syncing with what the management has implemented as employee goals.Read More »
I last posted about changing a table without changing a view that represents the table and how this may affect the view.
In today’s quick post I’d like to show another issue brought about by not maintaining your views.
I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created a “history” table. This was before temporal tables came out in SQL.
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.
For those that don’t know, I live in Texas. Been here all my life. There are two main things north Texans worry about from mother nature: Tornados & Hail.
My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification. At first I thought it was spam and then I did a double take.
SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know. I plan to do a few blogs on this topic and today marks the first.
Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases for a while, I’m sure you’ve had to parse a string and while you’d think these are the same they work a little different and I think Oracle may surprise you a bit.
It’s been a while since I’ve done a SQL Saturday and I’m happy to be joining the folks in Orlando again this year. I spoke there a couple years ago and had a great time so I’m sure this will not disappoint.
If you happen to be headed to the Orlando, FL area in October, you’ll want to check out this totally FREE SQL Server training event. There are a lot of great speakers and plenty of awesome topics!
For more details check out my session here:
A DBA’s guide to whole stack performance troubleshooting
and the SQL Saturday Orlando schedule here:
I hope to see you there!