We record tutorials and fun snippets for the Microsoft SQL Server community of database administrators and data professionals. Featuring Sean McCown and Jen McCown of the banners MidnightDBA, MidnightSQL, and MinionWare.
►WHAT WE DO: We help CTOs and CIOs Speed Up SQL Server audits by 95% using Minion Enterprise.
►HEALTH CHECKS, AUDITS & BENCHMARKS: Use a single query to perform standard benchmarks and run internal audits for all instances in your environment.
►WHERE YOU'VE SEEN ME: I’m a regular speaker at the Professional Association for SQL Server, SQL Saturdays, SQL Bits and other training events worldwide.
►MY STORY: I’ve been interested in computers since Ms. Pac-Man came out in 1982. I took two years of programming in high school, continued in college, and I’ve worked with computers ever since. I’ve been a full time DBA, a consultant, an internet personality - kind of - and now an entrepreneur and CEO.
I wonder if this still works in 2024? I need to access a system that has been abandoned by the installer and manufacture only refers me back to the installer.
Don't we all! I talked to an expert in the field, and it really boils down to "nobody knows, because the systems have gotten so incredibly complex, and the vendors have gotten extremely tight-lipped."
It looks yellow but the instructions are very helpful as I did not know that about using the fish to "swim" on the pan bottom as the oil keeps getting hotter!
Very interesting, useful and easy to follow course, I followed part 1, wrote all code as you did and it works like a charm. However, when I started watching this one, Part2, I see a huge difference between the dispalyed code and the code when you ended partI, is it possible or is the code source available for download? Thanks in advance
Many thanks Sean.... been watching you guys for since I started 10 years ago.... I learned at the open university to make smart friends :) Cocked up first one but thought your advice at the end of part one was great... but your right... they love clusters... mind you they also believe the earth is flat :) ... great thing about your stuff is you can rinse - repeat until I get it right.... I also think plural are wrong... I've done loads of online stuff and yours (along with Brents) is right up there.... like having someone sat next to you explaining what's what .. all the best
The explanation from the 8:00-9:30 time might be a little better explained as: First, the `\b` matches a word boundary (which occurs in several places in the text), but then expects to find the 4 letters `s-a-n-d` (which only occurs in 3 places in the text). The "regex cursor" is now to the right of the 'd' in "sand", so when the lookbehind "peeks to the left" of its current location to search for `\w+` characters, it finds "sand".
You guys are amazing! Your canal is very underrated it should have soo much more views. I 've laughed/cried so hard after I found out that "Pan-seared Tilapia" is the most viewed video of Your's
Awesome I must say again! Please what if one just wants to select unique Customer IDs and then give a count of each alone ...i.e to have a table of just unique values of customer IDs with their respective count or sum, without including any other information?