SQLEspresso

What is Azure SQL Database Serverless?

• by Monica Rathbun

• SQLEspresso

What is Azure SQL Database Serverless? When I hear the term serverless my mind gets confused. How can a database exist without a server? Azure is a cloud platform,...

2020-07-01

205 reads

Open Letter to PASS

• by Monica Rathbun

• SQLEspresso

As you know, I spoke to 12 Chapter Leaders and 4 Regional Mentors yesterday. All are very upset with PASS right now and feel slighted, which as a volunteer...

2020-07-03 (first published: 2020-06-19)

230 reads

What is Batch Mode on Rowstore in SQL Server?

• by Monica Rathbun

• SQLEspresso

Under compatibility level 150, in both SQL Server 2019 and Azure SQL Database, you now can use batch mode for CPU-bound analytic type workloads without requiring columnstore indexes. There...

2020-06-29 (first published: 2020-06-16)

542 reads

My Thoughts on PASS Virtual Summit – An Editorial

• by Monica Rathbun

• SQLEspresso

On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server...

2020-06-26 (first published: 2020-06-11)

276 reads

The New Public Speaking

• by Monica Rathbun

• SQLEspresso

The need to transition to virtual speaking engagements is not easy for me. As someone who loves public speaking and delivering in person training, not being able to do...

2020-04-29

6 reads

Coding Standards Gone Bad in SQL Server

• by Monica Rathbun

• SQLEspresso

Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I...

2020-05-01 (first published: 2020-04-21)

894 reads

Moving Your SQL Workload to the Cloud   

• by Monica Rathbun

• SQLEspresso

Every day, more IT organizations decide to move their SQL Server databases to Azure. In fact, over a million on-premises SQL Server databases have been moved to Azure. There’s...

2020-03-31 (first published: 2020-03-25)

359 reads

Being a Woman in the SQL Community

• by Monica Rathbun

• SQLEspresso

In celebration of Women’s History Month starting next week, I was asked to write this blog about my experiences as a woman in the SQL Community, and it really...

2020-02-28 (first published: 2020-02-26)

480 reads

Upcoming International Speaking Engagements

• by Monica Rathbun

• SQLEspresso

I am very excited and fortunate to be chosen to speak at both SQLBits and DataGrillen this year. These two conferences are incredible community run events and if you...

2020-02-19

8 reads

String Split Function in SQL Server

• by Monica Rathbun

• SQLEspresso

Did you know that a native STRING_SPLIT function built into SQL Server was added into SQL Server 2016? As a consultant I see so much code that call out...

2020-02-21 (first published: 2020-02-12)

858 reads