hellosqlkitty

Josephine Bush is a Data Platform MVP and has over 10 years of experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data sectors using SQL Server, MySQL, Oracle, and PostgreSQL along with Azure and AWS. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics. She presents at SQL conferences and user groups around the world. She is the leader of the Boulder SQL user group. She blogs on sqlkitty.com and you can reach her on Twitter @hellosqlkitty.

Blog Post

Drop roles in Postgres

You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles are granted to it. I had to go fishing to find all the grants to...

2025-01-28 (first published: )

19 reads

Blog Post

Data (and Humans) At Rest

We talk a lot about data in the data world – imagine that! Sometimes, we talk about data at rest, but when do we all rest? Do we even...

2024-08-12 (first published: )

175 reads

Blogs

How-To Convert Excel Date & Time to SQL

By

Hey data friends! This one comes from my personal vault (aka backlog of drafts...

SQL in 2025: Still the King of Data

By

Data's the new oil, and SQL is your refinery. It's still the go-to language...

Drop roles in Postgres

By

You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...

Read the latest Blogs

Forums

Why you should avoid Implicit Measures in your Power BI model

By Koen Verbeeck

Comments posted to this topic are about the item Why you should avoid Implicit...

Creating a Linked Server in Amazon RDS for SQL Server: A Step-by-Step Guide

By Arvind Toorpu

Comments posted to this topic are about the item Creating a Linked Server in...

Dates and Languages

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Dates and Languages

Visit the forum

Question of the Day

Dates and Languages

The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?

DECLARE @yourInputDate  NVARCHAR(32) = '28 listopad 2018';

SET LANGUAGE Polish;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish];

SET LANGUAGE Croatian;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian];

SET LANGUAGE English;

See possible answers