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

SQLFlipFlopsDBA

Jim is a Cloud Solutions Architect for RDX Technologies in Warrendale, PA, a suburb just outside of Pittsburgh. He enjoys retro video game collecting and watching the Pittsburgh Penguins.

Veterans At PASS Summit ’18

Hello all!

This year at PASS Summit, I will be distributing the below ribbons once again to ANY and ALL Service Members(past or present).  I started this last year at PASS Summit and handed out quite a few ribbons.  I hope to hand out more this year!

 

 

I… Read more

2 comments, 122 reads

Posted in SQLFlipFlopsDBA on 10 October 2018

Azure Runbook Configuration

Hello everybody! Greetings from the very warm state of Texas!  One of the most popular questions I get when talking about Azure SQL Database is how to configure Index and Statistics maintenance without a SQL Agent to execute jobs.  I normally recommend using Azure Automation and the creation of a… Read more

2 comments, 1,527 reads

Posted in SQLFlipFlopsDBA on 2 August 2018

Webinars, and Azure, and SQL… OH MY!

Hello everybody!  Thank you once again for stopping by and reading.  April has been pretty busy with presentations, and I wanted to make sure I listed them here just in case folks wanted to catch them anywhere!

Earlier this month, I did a webinar for RDX involving Migrating SQL Server… Read more

0 comments, 48 reads

Posted in SQLFlipFlopsDBA on 25 April 2018

Getting the Azure DTU Calculator to work on a 2008R2 OS w/ a 2008R2 SQL Server Instance

Hello everyone!  I recently had to do an analysis of a client’s database workload using the Azure DTU Calculator(DTU Calculator) and thought it might be interesting to share just how I did that.  I have run this tool numerous times on other clients via the PowerShell method and… Read more

4 comments, 155 reads

Posted in SQLFlipFlopsDBA on 24 April 2018

Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 2

Hello everybody!  Thanks for stopping by again.  In Part 1 of this series, I gave the background of the project, and the initial steps taken and I left off discussing some code review.  I am going to pick up on this blog starting from there.

 

Identifying Incompatabilities

 

I… Read more

0 comments, 40 reads

Posted in SQLFlipFlopsDBA on 2 April 2018

Migrating to Azure DBaaS – A Client’s Steps Taken to the Cloud – Part 1

Hello everybody!

I have been working with one of my favorite clients lately on migrating their SQL databases to a DBaaS (Database as a Service) solution in Microsoft Azure. This has been such a fun project that I thought I would share with you the steps taken to hopefully help… Read more

1 comments, 56 reads

Posted in SQLFlipFlopsDBA on 10 February 2018

Upcoming SQLSaturdays

I have the priveledge of speaking at two SQLSaturday events coming up in the near future.  This is the first time I’ve spoken at either of these two great events and I am looking forward to seeing everybody there!

 

SQLSaturday #698 Nashville – 1/13/18

Session Name:  Getting started with… Read more

0 comments, 55 reads

Posted in SQLFlipFlopsDBA on 2 January 2018

Creating and Using Failover Groups in Azure DBaaS – Part 2

Connecting to Failover Group

So in Part 1 of this series, we created and configured our Failover Group. Well, now that the easy stuff is out of the way, let’s talk about how you connect to these groups via SSMS.  This is where some of the confusion happens.  When I… Read more

0 comments, 47 reads

Posted in SQLFlipFlopsDBA on 26 December 2017

Creating and Using Failover Groups in Azure DBaaS – Part 1

Introduction

Hello everybody! Welcome back! One of my favorite features in Azure SQL DBaaS is Failover Groups.  I have been working with these since they were in preview and I cannot stress the value of this feature enough!  In my former company, we had 22 web applications that all had… Read more

0 comments, 69 reads

Posted in SQLFlipFlopsDBA on 22 December 2017

TSQL Tuesday #96 – Difference Makers!

 

This month’s T-SQL Tuesday is about recognizing the people whom have inspired you or have made a meaningful contribution to your life.  Reading alot of the post’s today made me realize once again how AWESOME #SQLFamily is! Thank you to Eweld Cress(b/t) for hosting this… Read more

0 comments, 47 reads

Posted in SQLFlipFlopsDBA on 14 November 2017

PASS Summit 2017

Hello all!

 

This past week was PASS Summit 2017, a super crazy/awesome week!  So many great things happened this week and I finally have the chance to sit down and blog about them.

 

First, it is always one of the best week’s of my year when I get… Read more

2 comments, 48 reads

Posted in SQLFlipFlopsDBA on 7 November 2017

Veterans at PASS Summit 2017

Hello all!

 

This year at PASS Summit, I wanted to do something different.  In the past Summit’s that I have attended, one of the things that I have noticed is the custom ribbons folks bring. Usually by the end of the week, I have a long trail of ribbons… Read more

1 comments, 89 reads

Posted in SQLFlipFlopsDBA on 28 October 2017