-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

There Is a Magic Button, a Rant

OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest of you. We know something that you don’t. I don’t think we should hide this secret from the world any more.

Illuminati? Incompetents. Free Masons? I am one, so I… Read more

10 comments, 298 reads

Posted in The Scary DBA on 1 August 2017

Being a Positive Influencer

I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to arrive at a better, more productive, more useful individual. I suck at it.

Positive

If you read a lot of these books and articles about how to go about getting… Read more

2 comments, 1,535 reads

Posted in The Scary DBA on 31 July 2017

Being a Positive Influencer

I read a lot of self-help and improvement information. I’m always trying to hack my brain or my attitude to arrive at a better, more productive, more useful individual. I suck at it.

Positive

If you read a lot of these books and articles about how to go about getting… Read more

2 comments, 65 reads

Posted in The Scary DBA on 31 July 2017

Database Fundamentals #6: Create a Table with the SSMS GUI

The whole idea behind databases is to store information, data, in order to look at it later. The place where that data is going to be kept is referred to as a table. A table consists of columns and each column can be defined to store a variety of specific… Read more

1 comments, 299 reads

Posted in The Scary DBA on 24 July 2017

SQL Cruise: Alaska 2017

We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more. There you’ll also find testimonials and suggestions on how to sell SQL Cruise to your boss. I’m going to leave selling it to your boss to you. I want… Read more

4 comments, 1,507 reads

Posted in The Scary DBA on 19 July 2017

Thoughts on the State of Data Management

I was given the opportunity to do a little online interview. It’s primarily about promotion, but I thought I’d share it with you. If you’re wondering what I think of the current state of the industry, go here to check it out.

The post Thoughts on the State of Data… Read more

2 comments, 189 reads

Posted in The Scary DBA on 18 July 2017

Database Fundamentals #5: Database Properties

Don’t let the ease of creating databases lull you into a false sense of security. They actually can be very complicated. You can modify and individualize their behavior within your server so that different databases behave in radically different ways. The best way to see all the different manipulations you… Read more

1 comments, 1,981 reads

Posted in The Scary DBA on 17 July 2017

The Choices We Make

If you keep your head up and look around you’ll see the choices people make all the time. I saw a recent example online in this story about two experiences, shopping at Home Depot vs. Lowes (very minor NSFW warning due to language).

I don’t want to get into a… Read more

4 comments, 1,614 reads

Posted in The Scary DBA on 10 July 2017

Gratitude

I want to take a moment to thank a few people for being amazing.

First up, Thomas LaRock is wrapping up his tenure on the PASS Board this year. He has one more in-person meeting at Summit 2017 and then he’s basically done. I followed Tom to karaoke during my… Read more

0 comments, 199 reads

Posted in The Scary DBA on 6 July 2017

I Love Entity Framework

I love Entity Framework. I also like (not love) nHibernate. That’s right, as a DBA and data professional, I’m telling you I love Object/Relational Mapping tools (ORM). I think this is a technology set that the DBA needs to more tightly embrace. Let me tell you why.

Most of…

Read more

10 comments, 2,410 reads

Posted in The Scary DBA on 5 July 2017

Database Fundamentals #4: Create a Database

SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works and have as many different mechanisms as possible for getting work done, you’ll use the GUI and TSQL to learn how to create and drop databases. You can then use… Read more

2 comments, 1,742 reads

Posted in The Scary DBA on 26 June 2017

Database Fundamentals #3: What’s In a Database?

It’s worth noting that a lot of people will never need to create their own database. You may never create your own tables or other data structures either. You may only ever run backups and restores and manipulate the security on the system and let application installs create databases for… Read more

2 comments, 298 reads

Posted in The Scary DBA on 20 June 2017

The Three T’s of Backups

I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume, extreme volume), and evidently I have to say it again. Simply creating a backup file is not enough to ensure the protection of your information. In… Read more

7 comments, 1,626 reads

Posted in The Scary DBA on 19 June 2017

T-SQL Tuesday #091 – Round-Up

Thank you to everyone who participated in T-SQL Tuesday #091 which was on databases and DevOps. As I anticipated, this brought out quite a bit of variety on the posts. This is because DevOps is still… not quite cooked…(?) in many peoples minds. I think with the range of posts… Read more

5 comments, 1,383 reads

Posted in The Scary DBA on 15 June 2017

DevOps and Visual Studio

The hardest part about implementing DevOps is not the tools you choose, but the processes you use to make DevOps work. That said, you do need to think about the tools you’re going to use to automate those processes. Frequently the emphasis is on third party tools, but it doesn’t… Read more

3 comments, 719 reads

Posted in The Scary DBA on 13 June 2017

Database Fundamentals #2: SQL Server Management Studio

The best way to learn any software is to start using it. There are a bunch of software tools in the SQL Server toolbox, but the biggest and most important is SQL Server Management Studio (SSMS). SSMS is where you’ll spend most of your time when you start to work… Read more

2 comments, 655 reads

Posted in The Scary DBA on 12 June 2017

T-SQL Tuesday #091 – Databases and DevOps

Implementing DevOps with databases presents a unique set of challenges. However, just because something might be hard doesn’t mean that it shouldn’t be done.

I had the opportunity to work with a team of developers, database developers and DBAs under a management team that all agreed on the common goal… Read more

10 comments, 282 reads

Posted in The Scary DBA on 6 June 2017

Database Fundamentals #1: Install SQL Server

To get started with SQL Server, you need to install it. However, I’m not going to teach you how to do a SQL Server install. Instead, I want to point you towards a couple of sources of information, and, give you some alternatives to installing SQL Server.

Install SQL Server

Read more

3 comments, 366 reads

Posted in The Scary DBA on 5 June 2017

Database Fundamentals

One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to forget about the fundamentals. More importantly, in our pursuit of the latest and greatest things, it’s very easy for those of us who teach to forget to reach back and… Read more

7 comments, 2,408 reads

Posted in The Scary DBA on 31 May 2017

Technology Gender Gap By State

This is my first ever guest blog post. Take it away Hazel Garcia.


Though the gender gap narrows by the year, there remains a noticeable lack of balance in the professional workplace. This gap reflects in everything from gender-based pay scale discrepancies to the ratio of women to men… Read more

8 comments, 1,258 reads

Posted in The Scary DBA on 22 May 2017

Newer posts

Older posts