I admit it, I still use SQL Profiler. I always have, and I will for the foreseeable future. My reasons are pretty simple.
- When it comes to troubleshooting I can spin up a Profiler session must faster than an Extended Events session.
- Usually, I’m troubleshooting something as a one-off. so having my session isn’t really something I care about.
- I usually can’t bring scripts into my client’s servers to setup Extended Events, so I have to go create everything manually. (See #1)
- Done correctly with filtering, there’s no risk of a production outage using Profiler.
- If I could bring in scripts to set up an Extended Events session (see #3) I’d have to modify the session which I can do faster in profiler than in Extended Events.
Should you be using Extended Events? Probably. Odds are you got a full-time job somewhere, so extended events sessions are going to make more sense for you as you can run them against your servers and easily jump on and see what the server is doing.
What would it take get me to use Extended Event sessions instead of Profiler? Speed. Whatever GUI Microsoft creates for Extended Events needs to be just as responsive as the Profiler GUI, and the data that is returned needs to be returned by Extended Events just as quickly as data is returned from Profiler.
The post Why Profiler For Life? appeared first on SQL Server with Mr. Denny.
The Cloud is a fun and exciting place to be. Exciting as it may be, even in the cloud, protection of databases and the data they contain has to be forefront in your mind. If it isn’t, that is just calling for a disaster to happen.
Recently, I had the distinct pleasure of sitting down with my good friends Mike Fal (B|T) and David Klee (B|T) to discuss database protection in the cloud era for a podcast. Sponsor and hosted by Mike’s employer, Rubrik, this podcast is about 45 minutes long and was an excellent discussion on the topic of database protection when in the cloud. Mike did a great job hosting and I look forward to participating in future podcasts.
Take a listen to the podcast here: https://soundcloud.com/buzzword-bingo/databases-protection-in-the-cloud-era/
Have concerns about protecting your data in the cloud?
Looking to move your data to the cloud but don’t know where to start?
Let’s discuss! Drop me an email at john at dcac.co. We can help!
© 2018, John Morehouse. All rights reserved.
If you’ve been thinking about submitting for the PASS Summit 2018 Speaker Idol, but you aren’t sure that it’s for you, we can solve that problem. On
August 30th, 2018 at 1600 UTC (4 pm) join myself, Karen Lopez, and Joey D’Antoni at the PASS Professional Development Virtual Chapter as we talk about Speaker Idol at the PASS summit. You can register for the session on the PASS Professional Development VC website. We look forward to seeing everyone at the webcast.
The post Get some behind the scenes information on PASS Summit Speaker Idol appeared first on SQL Server with Mr. Denny.
OCEANSIDE, Calif., Aug 2, 2018 /PRNewswire/ – Denny Cherry & Associates Consulting announced today the company has been named one of the “10 Best Performing Azure Service Providers 2018” by Insights Success Magazine.
A Microsoft Managed Gold Partner with a team of veteran Microsoft MVPs, Denny Cherry and Associates Consulting are renowned for their depth of knowledge in, and dexterity with, Azure solutions.
Principal and CEO Denny Cherry commented, “We’re really proud to be named to this list and thank Insights Success for nominating us. Azure consulting has become almost 50% of our business in the past 18 months and it’s great to be recognized for the work.
Every week brings us a new Azure challenge right now. We’ve just wrapped up a 50 Terabyte migration for a business that was going from a CoLo to Azure. Simultaneously, on behalf of a non-profit customer, we’re assisting with medical reporting for medical clinics in Africa using PowerBI. We’ve designed the system to include Azure Virtual Machines to load and scrub the data before moving the data into PowerBI for users around the world.”
About Denny Cherry & Associates Consulting
The vetted and certified experts at Denny Cherry and Associates Consulting assist companies with reliably attaining IT goals such as HA, scalability, SQL Server virtualization, Azure migration and acceleration, while finding ways to save on costs. With clients ranging from Fortune 50 corporations to small businesses, their commitment to each is the same: to provide a deft, high-speed IT environment that leverages every aspect of their platform: from architecture, to infrastructure, to network. http://www.dcac.co/
About Insights Success
Insights Success is The Best Business Magazine in the world for enterprises. Being a platform, it focuses distinctively on emerging as well as leading fastest growing companies, their innovative style of doing businesses and the way of delivering effective and collaborative solutions to strengthen market share. Here, we talk about the leader’s viewpoints & ideas, latest products/services, etc. Insights Success magazine reaches out to all the ‘C’ Level Professionals, VPs, Consultants, VCs, Managers, and HRs of various industries. For more info, visit: www.insightssuccess.com
SOURCE Denny Cherry & Associates Consulting