How to Increase SQL Server Query Performance When You Have No Control Over the Query — A Unique Approach

Last week, at my local PASS chapter (Rochester), I gave a presentation titled “Magical Query Tuning.” In the presentation, I described a query-tuning technique that can be used when you think you’re out of options. I first learned of this method from Kendra Little at LittleKendra.com and I think it’s an incredibly interesting and not widely-known method, which is why I chose to share it with everyone.

Continue reading “How to Increase SQL Server Query Performance When You Have No Control Over the Query — A Unique Approach”

Why Do Projects Fail? Part 1 (Risks)

Why do projects fail? This is a question that has many answers. I intend for this post to be part of a series of posts that address issues that lead to project failure and what you can do to increase your project’s success rate.

Continue reading “Why Do Projects Fail? Part 1 (Risks)”

Function Friday

I’m a huge proponent of SQL Server. I think it’s a great database engine and I find that I’m always looking for ways to expand my knowledge about the product and help others expand theirs. In that vein, starting in October of this year I’ve begun tweeting one SQL Server function and a link to its page on microsoft.com, each Friday. I call it Function Friday.

Continue reading “Function Friday”

Staff Innovation Award

The first time I heard about Nazareth College was in the year 2000 when I was a sophomore in high school and my sister, Nicole, had applied to the institution. I believe she was accepted into multiple programs at several colleges, but she chose to attend Nazareth. This was great for both of us–she was able to pursue a major she was interested in at a highly-regarded instution of higher education, and I had a place to visit two hours away from where I was living.

Continue reading “Staff Innovation Award”

Welcome to My New Blog!

Hi, and welcome to my blog!

I’m Mike Scalise. I’ve been interested in starting a blog for a long time and I’ve finally carved out the time to set one up. My plan is to post fairly regularly about various topics of interest, including but not limited to: SQL Server, databases, computer languages, project management, and weightlifting.

My goal for this blog is not only to have a platform to voice my thoughts and ideas, but also to provide you with resources that will make your life easier and help further advance each of the aforementioned areas.

Thanks for looking and stay tuned!

In the meantime, you can find me on social media via the links listed at the bottom of this page.

Mike