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

Anthony Nocentino's Blog

Anthony Nocentino is the founder of Centino Systems. As an Enterprise Architect he works with clients to find right technology for their business, designing and deploying it, providing expertise on system performance and architecture. Creating well-designed, maintainable SQL Server and Linux based systems that enable clients to collect meaningful data that they can act upon. Anthony has a Bachelors and Masters in Computer Science and is working towards a Ph.D focusing on high performance/low latency data access algorithms on solid state disks. Anthony has a unique blend of academic and professional experience leveraged to help customers solve their hardest IT problems.

Top 5 Reasons Why I think SQL Server on Linux is Legit

Here are my top 5 reasons why I thing SQL Server on Linux is Legit!

  1. SQL Server on Linux is Fast – Earlier this year SQL Server on Linux posted the fasted 1TB TPC-H benchmark in the world and at the end of October posted the a 10TB result! Check…

Read more

0 comments, 514 reads

Posted in Anthony Nocentino's Blog on 12 November 2017

Launching SQL Server on Linux in Single User Mode

There was a question this morning on the SQL Server Community Slack channel from SvenLowry about how to launch SQL Server on Linux in Single User Mode. Well you’ve heard everyone say, it’s just SQL Server…and that’s certainly true and this is another example of that idea.

The command… Read more

0 comments, 718 reads

Posted in Anthony Nocentino's Blog on 9 November 2017

SQL Server on Linux Online Training with Brent Ozar Unlimited!

I’m proud to announce to you that I’m partnering with the folks over a Brent Ozar Unlimited to provide live, instructor-led training directly to you online!

Course – SQL Server on Linux: Install, Configure, and Manage

Description

You’ve been managing SQL Server configuration, backups, and troubleshooting for a couple of… Read more

0 comments, 114 reads

Posted in Anthony Nocentino's Blog on 1 November 2017

New Pluralsight Course – SQL Server on Linux Administration Fundamentals

New Pluralsight Course – SQL Server on Linux Administration Fundamentals

My new course “SQL Server on Linux Administration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right in check it out…

Read more

0 comments, 251 reads

Posted in Anthony Nocentino's Blog on 1 November 2017

Exit Codes, systemd and SQL Server on Linux

In this blog post we’re going to cover systemd, process exit codes and highlight how systemd reacts in certain exit conditions from SQL Server on Linux. My friend and SQL Server guru Argenis Fernandez – @dbargenis asked about this behavior on Twitter and I’ve been meaning to write this post,… Read more

2 comments, 371 reads

Posted in Anthony Nocentino's Blog on 28 October 2017

SQL Server on Linux Content at PASS Summit

PASS Summit is right around the corner and I’ll be there speaking on Monitoring Linux Performance for the SQL Server Admin!

There’s a fantastic amount of SQL Server on Linux content available at Summit. I encourage you to attend one of these sessions. You’ll likely find me at all… Read more

0 comments, 248 reads

Posted in Anthony Nocentino's Blog on 20 October 2017

SQL Server on Linux – External Memory Pressure

In this blog post we’re going to explore how SQL Server on Linux responds to external memory pressure. On Windows based SQL Server systems we’ve become accustomed to the OS signaling to SQL Server that there’s a memory shortage. When signaled, SQL Server will kindly start shrinking it’s memory caches,… Read more

0 comments, 1,526 reads

Posted in Anthony Nocentino's Blog on 20 October 2017

Speaking at IT/Dev Connections 2017 – San Francisco!

I’m proud to announce that I will be delivering two sessions at IT/Dev Connections in San Francisco! This is my second year at IT/Dev Connections, real content for IT pros!

Networking Internals for the SQL Server Professional

Tuesday, 10/24/2017: 1:15 pm – 2:30 pm

Room: Contiental 7

Abstract

Once data… Read more

0 comments, 175 reads

Posted in Anthony Nocentino's Blog on 16 October 2017

New Pluralsight Course – LFCE: Linux Service Management – HTTP Services

My new course “LFCE: Linux Service Management – HTTP Services” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right in check it out here!

This course targets IT professionals that design… Read more

0 comments, 265 reads

Posted in Anthony Nocentino's Blog on 1 October 2017

Instant File Initialization in SQL Server on Linux

Earlier this week Ned Otter (@NedOtter) brought up a question about Instant File Initialization on SQL Server on Linux, check out the thread here. I was up way too early in the morning, as I normally am, so I decided to poke around and see how it… Read more

0 comments, 282 reads

Posted in Anthony Nocentino's Blog on 23 September 2017

Warning Handling in dbatools Automation Tasks

So I’ve been using dbatools for automated restore tasks and came across a SQL Server Agent job that I wrote that was reporting success but the job was actually failing.

What I found was the function I used, Restore-DbaDatabase, was not able to access the path that I was… Read more

1 comments, 164 reads

Posted in Anthony Nocentino's Blog on 12 September 2017

There will be no Doctor No, for now!

A few weeks back several SQL Server bloggers discussed their academic pasts…well here I’m going to let you in on a little secret of mine too. I failed out of college too. I was a Management Information Systems major and limped along with a 1.82 GPA before I got tossed… Read more

0 comments, 176 reads

Posted in Anthony Nocentino's Blog on 11 September 2017

TechMentor Dine Around

Next week I’ll be speaking at TechMentor in Redmond, I’m doing a 1/2 day workshop on Linux OS Fundamentals for the Windows Admin be sure to come see me!

If you’re there on Monday night (August 7th) and let’s get together for dinner! We’ll talk tech and hopefully make a… Read more

0 comments, 261 reads

Posted in Anthony Nocentino's Blog on 1 August 2017

Speaking at TechMentor – Redmond

I’ll be speaking at TechMentor, August 7-11 at Microsoft HQ in Redmond. Surrounded by your fellow IT professionals, TechMentor provides you with in-depth, immediately usable training that will keep you relevant in the workforce. 

I’ll be presenting the following session: Workshop: Linux OS Fundamentals for the Windows Admin – this… Read more

0 comments, 167 reads

Posted in Anthony Nocentino's Blog on 26 July 2017

Speaking at PASS Summit 2017

I’m very pleased to announce that I will be speaking at PASS Summit 2017!  This is my first time speaking at PASS Summit and I’m very excited to be doing so! What’s more, is I get to help blaze new ground on a emerging technology SQL Server on Linux Read more

0 comments, 194 reads

Posted in Anthony Nocentino's Blog on 19 July 2017

Reflecting on the Last Year of Microsoft’s OpenSource Technologies

This past year has certainly been interesting in the world of Linux. Microsoft has taken a new strategy and is embracing the open source model. It’s releasing it’s key software products with versions for Linux. It’s truly a remarkable time. In this post I want to highlight some of the… Read more

0 comments, 1,402 reads

Posted in Anthony Nocentino's Blog on 24 June 2017

Speaking at SQLSaturday Sacramento – 650!

Speaking at SQLSaturday Sacramento!

I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 15th 2017! And wow, 650 SQLSaturdays! This one won’t let you down. Check out the amazing schedule!

If you don’t know what SQLSaturday is, it’s a whole day of free…

Read more

0 comments, 242 reads

Posted in Anthony Nocentino's Blog on 23 June 2017

dbfs – command line access to SQL Server DMVs

With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users. People that aren’t used to Windows and it’s tools. In the Linux world we have a set of tools that work with our system performance data and present that to… Read more

0 comments, 1,351 reads

Posted in Anthony Nocentino's Blog on 19 June 2017

PowerShell Remoting in Multi-Platform Environments – Use Cases

In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In this post, we’re going to leverage that configuration and look at some common remoting use cases. This is one of the core things I use everyday when I work with… Read more

2 comments, 285 reads

Posted in Anthony Nocentino's Blog on 12 June 2017

Speaking at SQL Saturday Pensacola!

I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule!

If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

If you haven’t been to… Read more

1 comments, 224 reads

Posted in Anthony Nocentino's Blog on 26 May 2017

Older posts