Category: SQL Server
-
Customizable PerfMon Counter for SQL Server
As the summer vacation season is pretty much over, it’s time for me to get back to working and blogging again. I had originally planned to write up a few posts during the summer, but as I spend most of my days writing my bachelor’s thesis, I simply didn’t have…
-
SQL Server tool improvements
While there’s plenty of new and exciting features coming with SQL Server 2016, Microsoft has also worked hard on improving the delivery of their SQL Server tools. Previously figuring out the correct tools or what version to install could be more than little confusing, but no more!
-
Distributed Replay
Distributed Replay is a feature that was first introduced with SQL Server 2012. It allows you to play a set of recorded transactions against a SQL Server database. This can be extremely useful if you’re doing hardware or SQL Server version upgrades and want to test the performance impacts of…
-
Few thoughts from the Data Driven SQL event
Just finished watching the Data Driven event that was broadcasted live from New York earlier today. As expected there was a lot of information about SQL Server 2016 and quite a few visitors telling how their companies used Microsoft SQL Server in their daily business. And these were some big…
-
How to change options for multiple databases the easy way.
Changing options for multiple databases can be time-consuming when done one database at the time. With just few databases you might be fine using the Management Studio and doing changes through the GUI but when you have dozens, or hundreds, of databases and only some of them are having wrong…
-
PASS Summit 2015: Conference Day 3
This post comes a bit late as our last day in Seattle went on bit longer than expected, but for very positive reasons. We had an ad hoc gathering of Finnish PASS Summit attendees and despite the fact that it was very last minute setup, we got pretty much everyone…
-
PASS Summit 2015: Conference day 2
Today started with a keynote held together by boths David DeWitt and Rimma Nehme from the Microsoft Jim Gray Labs they’re both excellent speakers and fun to listen to. The topic of the keynote is the Internet of Things (IoT). While I was aware that the number of systems that…
-
Mentored by Paul Randal, my experiences from the first months.
It’s a last day of my combined summer vacation and paternal leave and for the last week my thoughts have, now and then, drifted momentarily to work related things like trying to remember my laptop password. This is, at least for me, a common occurrence. With the end of the…
-
Review: Diagnostic Scripts by Glenn Berry
I’m finally getting back to the “Tools of the Trade” series with a third post on some of my favorite (and free) SQL Server tools. This time on the spotlight is the Diagnostic Scripts by Glenn Berry. The scripts can be found from his blog, here. The whole package is…
-
SQL Server 2016 and Ignite On Demand
Microsoft Ignite is currently happening in Chicago, IL and there’s already been a some rather interesting news coming in. For us who work with the SQL Server the datasheet for SQL Server 2016 release is now available online. I spotted some rather delicious improvements listed there, especially when it comes…