MSSQL

This category contains 263 posts

Hartford SQL Server User Group Meeting Tomorrow

Sorry for the late post on this, but better late than never, right?
Tomorrow at noon (ET) will be the second meeting for the Hartford SQL Server User Group (HSSUG). That’s right, we meet during the day because we prefer to be home at night instead of, well, at a user group meeting. Weird, I know. [...]

Who Is Responsible For What?

In my previous life I was a production DBA which meant my primary responsibility was recovery. I also took my job role to be that of a general SQL Server expert. I stayed general because no one person can possible be an expert in every facet under the SQL Umbrella. A few years ago I [...]

When 24 Hours Is Not Enough

Many of you have some awareness regarding the 24 Hours of PASS events that I have helped to promote previously. When I was asked to help arrange for the upcoming event I targeted the list of current Summit speakers. This made logical sense to me since we want to make it a Summit preview. So [...]

SQL Saturday #51 Nashville Recap

I returned from Nashville yesterday, having been there for four days to take part in SQL Saturday as well as the most recent in-face PASS Board meetings. This was my first ever trip to Nashville and I had really just one goal in mind as a tourist: to find some good music. I managed to [...]

How To Find Duplicate Indexes

I’ve had this script in my toolbox for a few years now. I didn’t create it initially, and I have no idea who did. This script helps you to identify duplicate indexes. Why is that important? I’m glad you asked, mostly because I’m tired of answering my own questions and it’s good to have someone [...]

Is It A Problem?

Last week I used some local user group meetings as tune-ups for my talk that I am giving this Saturday in Nashville.
[Sorry that you had to find out this way Seacoast and SNESSUG. It's not easy finding out you were being used, but you were. And thanks for the bacon pizza, I can let myself [...]

24 Hours of PASS v3.2

Just about one year ago PASS launched a brand new concept in training: 24 consecutive one hour presentations done live by remote presenters around the globe. I still remember the PASS board meeting when Rick Heiges (blog | twitter) suggested the format. Some were skeptical but overall we mostly said “Do you think that can [...]

Index Tuning Advisors

One of the benefits I have working for Confio is that I get some exposure to multiple database platforms (Oracle, DB2, SAP Sybase, and MS SQL). And along with those multiple platforms I also get to look at a handful of tools that are commonly used for each. I have a long way to go [...]

SQL Server Management Through Monitoring

How do you manage your SQL Server instances? No, not connect to an instance to push buttons and pull levers. That’s not what I am asking about here. What I want to know is, how do you effectively administer and manage your entire environment? Are you in a reactive mode, where you wait for someone [...]

SQLRockstar 2010 Tour Dates

Want to take part in the SQLRockstar 2010 “What Are You Waiting For” Tour? Check out my upcoming tour schedule and see if I am coming to a location near you.
2010 US (and Tennessee) Tour Dates
8/10 Seacoast SQL Server User Group, Portsmouth, NH
8/11 Southern New England SQL Server User Group, Warwick, RI
8/12 Town Hall and [...]