Latest Blog Posts
Enjoy this article re-publication from my original work at SQL Solutions Group.
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor for a specific thing to happen. But sometimes you don’t… Read more
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.This inventory can take any number of forms but, ideally, will allow some aggregation of information. When server hardware or software changes are taking place, it’s easy… Read more
As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.
A few weeks ago I needed to do a demo with ReadyRoll for Redgate Software. I built a new project, and wanted to perform a build in Visual Studio Team Services… Read more
The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month with many returning participants along with some newcomers.
We had a wide range of topics with many great insights from everyone, but don’t take my word for it. Check out… Read more
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the web. I pointed them to the Features Supported by the Editions of SQL Server web page and thought I was done. He stated that this site was good, but did… Read more
Have you ever tried to query the contents of the default trace and then spent more time trying to figure out the name of the oldest file than the actually analyzing the data?
A while back I wrote a query to quickly get the oldest file name in the default… Read more
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.
Here is a glimpse of my presentation… Read more
Performance tuning is a tricky part. We need to analysis all points of view. Sometimes it is an easy fix and can be solved in a minute and sometimes it take a day or more to find and fix.
I received many emails for performance tuning help. It has… Read more
In this module you will learn how to use the Dot Plot Power BI Custom Visual. The Dot Plot is often used when visualizing a distribution of values or a count of an occurrence across different categorical data you may have. Watch this module to learn more!
Module 08 –…
One of the things that you need with a Continuous Integration server is that ability to build your software on some computer system and verify things work. With Visual Studio Team Services, using Visual Studio online, this seems to be a challenge.
The VSTS team has thought of this… Read more
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Louisville on Friday, August 5 called ‘The Complete Primer to SQL Server Infrastructure‘.
The focus of the course is to help those new to the enterprise server… Read more
The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that can be easily reused over and over within another query. The CTE also provides a mechanism for recursion which, though a little dangerous and overused, is extremely handy for… Read more
Really late linking to it, Should I Stay or Go is about being more assertive about making the decision to change jobs or projects. It’s easy to decide to leave when things are terrible, much harder when it less than optimum – because most jobs are!
If you’re in Louisiana or Texas this is one SQL Saturday you won’t want to miss. This annual event is one of the largest SQL Saturday events each year with over 600 actual attendees.
My session is titled “Everything you ever wanted to know about query tuning in SQL… Read more
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options but they still have their limits). Performance is important so you’ve tuned every query, you’ve tested and adjusted each of the server settings. The cloud gives you limited control over… Read more
Whoisactive stored procedure is a powerful script to capture the SQL server queries with tons of information. It’s written by Adam Machanic. It makes DBAs job easier.
It’s a great script with lots of parameter and I am going to show, which are all more important.
Run the stored… Read more