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

cjsommer.com

Chris started in computing and I.T. in the mid to late 1990's. After the dust had settled from Y2K, he found himself a bit more focused and working with database servers on the Unix platform. His first exposure to SQL Server was in 2007 and he has been working on that platform ever since. Chris is currently a Sr. SQL Server DBA in more of a DevOps role with a main focus on operational reliability, stability and performance. His specialty is automation. He truly enjoys the days he gets to spend building tools with PowerShell to help his fellow DBA's manage their ever growing SQL Server environment.

T-SQL Tuesday 94 - Do you wanna get PoSh?

This month’s topic: Let’s get all Posh – What are you going to automate today?

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild… Read more

0 comments, 123 reads

Posted in cjsommer.com on 11 September 2017

What I Learned Today - Configuring tempdb in RDS

Today I learned that you can configure tempdb in RDS!

One of the things we DBA’s do is configure tempdb to have multiple data files (if needed). Not going to go into the depths of why in this post, but adding multiple data files can help alleviate contention in tempdb.… Read more

0 comments, 219 reads

Posted in cjsommer.com on 28 August 2017

Beware the automated backup window when running native SQL Server backups in RDS

Beware the automated backup window when running native SQL Server backups in RDS

If you’ve ever fired up an RDS instance you know you can set an automated backup window for your instance. During this window Amazon will kick off an automated snapshot of your RDS instance each day. Set… Read more

0 comments, 333 reads

Posted in cjsommer.com on 4 August 2017

SQL Saturday 622. Join me July 29, 2017 in Albany, NY and learn to Paint with PowerShell!

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation… Read more

0 comments, 180 reads

Posted in cjsommer.com on 13 June 2017

T-SQL Tuesday 90 - Shipping Database Changes

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic blog | twitter.

This month’s tsql2sday is being hosted by James… Read more

0 comments, 1,424 reads

Posted in cjsommer.com on 9 May 2017

T-SQL Tuesday 89 - The times they are a changing!

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic blog | twitter.

This month’s tsql2sday is being hosted by Koen… Read more

0 comments, 223 reads

Posted in cjsommer.com on 11 April 2017

SQL Saturday 619. Join me April 29, 2017 in Rochester, NY and learn to Paint with PowerShell!

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation… Read more

0 comments, 169 reads

Posted in cjsommer.com on 27 March 2017

SQL Browser, what is it good for? Absolutely something!

Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some help troubleshooting a SQL connection issue. He had an application server that could not connect to one of our SQL Servers.

We have a fairly complex and secure network environment.… Read more

0 comments, 255 reads

Posted in cjsommer.com on 8 March 2017

So I have a new home! Welcome to cjsommer.com part deux!

Just wanted to put a quick post out there for the people who follow me. I very recently made a switch from Wordpress to Jekyll blogging platform and I am certain it will come with a few hiccups. At the moment I don’t have comments enabled, although I hope to… Read more

0 comments, 234 reads

Posted in cjsommer.com on 3 March 2017

This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter. Here is a link to the YouTube Video of the presentation. Check at the bottom of this blog post for a zip file containing the PPT as well as all...…

Read more

0 comments, 0 reads

Posted in cjsommer.com on 3 March 2017

SQL Browser, what is it good for? Absolutely something!

Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some help troubleshooting a SQL connection issue. He had an application server that could not connect to one of our SQL Servers.

We have a fairly complex and secure network environment.… Read more

0 comments, 2,115 reads

Posted in cjsommer.com on 1 March 2017

How the SQL Agent Job schedule_uid broke my heart, and my jobs!

This is something that has caused me some grief in my life as a DBA. I hesitate to call it a bug, but this little gottcha resurfaced in a change that was submitted by a teammate just today. So I wanted to share while it was fresh in my mind. Read more

10 comments, 1,937 reads

Posted in cjsommer.com on 3 February 2017

How the SQL Agent Job schedule_uid broke my heart, and my jobs!

This is something that has caused me some grief in my life as a DBA. I hesitate to call it a bug, but this little gottcha resurfaced in a change that was submitted by a teammate just today. So I wanted to share while it was fresh in my mind. Read more

0 comments, 83 reads

Posted in cjsommer.com on 3 February 2017

T-SQL Tuesday #85 – Backup & Recovery

Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here is a snippet from the invite:

Backups are one of the most common things DBAs discuss, and they are at once one of the simplest and… Read more

0 comments, 251 reads

Posted in cjsommer.com on 13 December 2016

T-SQL Tuesday 85 - Backup & Recovery

Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here is a snippet from the invite:

Backups are one of the most common things DBAs discuss, and they are at once one of the simplest and… Read more

0 comments, 91 reads

Posted in cjsommer.com on 13 December 2016

T-SQL Tuesday #84: Growing New Speakers

This month's #tsql2sday is being hosted by Andy Yun (b|t) and is about helping new speakers.

I have only been speaking a couple years so I still consider myself a new speaker. I have given a number of presentations for my Toastmasters club. I've spoken at… Read more

0 comments, 251 reads

Posted in cjsommer.com on 8 November 2016

T-SQL Tuesday 84 - Growing New Speakers

This month's #tsql2sday is being hosted by Andy Yun (b|t) and is about helping new speakers.

I have only been speaking a couple years so I still consider myself a new speaker. I have given a number of presentations for my Toastmasters club. I've spoken at… Read more

0 comments, 84 reads

Posted in cjsommer.com on 8 November 2016

Ponderings of PASS Summit 2016


Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new ideas and so much good information on so many fronts, I don’t know where to begin! So lets go back to the PASS Summit 2013.

Summit 2013 in Charlotte, NC… Read more

0 comments, 299 reads

Posted in cjsommer.com on 3 November 2016

Ponderings of PASS Summit 2016

Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new ideas and so much good information on so many fronts, I don’t know where to begin! So lets go back to the PASS Summit 2013.

Summit 2013 in Charlotte, NC… Read more

0 comments, 90 reads

Posted in cjsommer.com on 3 November 2016

Convert User Friendly Retention to DateTime value with PowerShell

I think the title is fairly descriptive so let me put a little context around it for you. In my SQL Server environment we backup our databases to local disk. Unfortunately we don’t have unlimited storage for backups, which means we have to delete the old backups on a regular… Read more

0 comments, 543 reads

Posted in cjsommer.com on 25 October 2016

Older posts