MVDBA (Mike Vessey)


SQLServerCentral Article

The NoSQL Misdirections

Editorial Note: This is a republish, in memory of Mike who passed away too soon. You can see his memorial at sqlmemorial.org. Recently I have been working with a colleague who is doing a bit of a side projects outside of work. He's  trying to expand his skillset using a pet project at home. I encouraged […]

4.46 (13)

You rated this post out of 5. Change rating

2021-06-04 (first published: )

8,116 reads

SQLServerCentral Article

It's More Than What You Know

I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]

You rated this post out of 5. Change rating

2019-12-03

1,938 reads

SQLServerCentral Article

Parameter pain

A forum question came up a few days ago regarding an abnormally large procedural cache. In an attempt to help out, I threw together a few ideas (some wrong, some right) and started looking at the types of query that were in the cache. A lot of the queries were in the format select * […]

4.7 (10)

You rated this post out of 5. Change rating

2019-11-11

4,732 reads

SQLServerCentral Article

Oops, I deleted that data

We all have these days as a DBA,  hopefully they are few and far between for most of us. This morning I walked into the office and found a stack of emails saying that a developer had responded to a support ticket and modified the values in one of our tables and got it wrong. OK, […]

3 (5)

You rated this post out of 5. Change rating

2019-10-29

9,164 reads

SQLServerCentral Article

Memories of DR testing

With the introduction of the GDPR, a lot of our prospective clients are demanding more and more information regarding data disposal, retention and usage practices. Both our new and existing clients want to look at our internal ecosystem and understand how we manage it. This means that I finally got a budget for a disaster […]

5 (4)

You rated this post out of 5. Change rating

2019-08-19

2,178 reads

Blogs

Cloud Databases Made Simple: Creating Your First AWS RDS Instance

By

I recently started full time learning of Amazon Web Services (AWS). I found that...

First Time Speaking with a Mask at an Event

By

Over the past couple of months, I have started losing my ability to talk...

A New Word: Apolytus

By

apolytus– n. the moment you realize you are changing as a person, finally outgrowing...

Read the latest Blogs

Forums

Disk (SCSI) Controllers - Parallel Disk I/O

By lanky_doodle

Hey For SQL Server VMs I use the max number of SCSI controllers supported...

SQL Server Semantic Search (Find Text in External Files)

By Stephen Butland

Dear community, I am trying to search word documents (docx) for a particular drug...

Data Archival: 1 table (Database A) to 1 table (Database B)

By Tava

I'm currently in the process of building an archival  & reporting solution and just...

Visit the forum

Question of the Day

Read Only Replica in SQL Server Standard

Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?

See possible answers