Windows Firewall and antivirus software configurations for SQL Server.

One of the more important duties of a DBA is to make sure that their databases and the data is secure. In this post we’ll be looking at two utilities to increase the security of your server, the Windows Firewall and an antivirus software. Like with about everything else related to servers, you can’t just switch these on (well, you could, but…) and forget about them to get the best possible experience. They need to be properly configured for servers running Microsoft SQL Server. If you’re a DBA you might not be doing the configuration yourself, but you still need to tell your Windows administrators what they need to do.

(more…)

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 options (like that stupid AUTO_CLOSE one) you need to replace, you’re going to want to use scripts for it.

(more…)

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 there. The evening itself was hosted by Marko Hotti, one of the Senior Product Managers at Microsoft who moved to Seattle a while back and is now working on the SQL Server 2016 release. And while there was some (or a lot) talk about SQL Server and the PASS community, we did also get to relax bit after a long week.

(more…)

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 are connected to Internet was high, I wasn’t aware that it had also surpassed the number of people living on Earth back in 2008. And the estimated number for devices for year 2020 was something along the lines of 50 billion! That is a lot of devices.

(more…)

PASS Summit 2015: Conference day 1

The first day of the actual conference was exciting. The Day 1 Keynote by Joseph Siroshi (Microsoft Corporate Vice President, Data Group) was something that I found especially interesting as the examples of data strategy were derived from the healthcare industry, which happens to be the same industry I’m involved with. The funny thing was that we were discussing how technology will shape the future of healthcare industry during the breakfast. And then, less than hour later we’re shown how analytics provided by the Microsoft Data Platform can analyze decoded human genome to provide list of possible health problems. How crazy is that?

(more…)

PASS Summit 2015: Pre-con sessions and welcoming party

First two days of PASS Summit 2015 are now almost over. I just got back to the hotel from the welcoming party and decided to write a quick summary of these days. The pre-con sessions I attended to were “The Complete Primer to SQL Server Virtualization” by David Klee, Argenis Fernandez and Jimmy May on day one and “The Enterprise Scripting Workshop” by Sean and Jennifer McCown on day two.

(more…)

Attending PASS Summit 2015

PASS_2015_200x200

It has been awhile since my last post, not that I’ve run out of ideas or stopped blogging (in fact I got a bunch of drafts waiting to be finished) but I’ve had trouble finding time and energy to write outside working hours as of late. Part of the reason is that I’ve done plenty of writing at the office, turning our standard procedures and such into actual documents, so writing some more at home hasn’t felt all that tempting.

(more…)