Matt Gordan is next in the hot seat. We discuss how Matt keeps the lights on while overseeing many data related projects and how his team know the more they are plugged into projects, the better support the can offer.
2022-03-25
In our latest DevOps 101 Series live webinar Grant Fritchey discusses why the key to successful DevOps implementation is gaining buy-in, and how you can achieve this in your organization.
2022-03-23
Change manage is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change management.
2022-03-23
You spoke 📣 we listened 👂
We are dedicated to listening to what our customers want and need and implementing feedback accordingly. Learn about how SQL Monitor has evolved, and the key features we've added, since 2018.
2022-03-21
After getting a new database in place, the next step is to create tables. In this article, Robert Sheldon walks you through creating tables with SQL Workbench and with scripts.
2022-03-21
In this article, Phil Factor explains how to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch.
2022-03-18
IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN and NOT IN.
2022-03-18
Share your knowledge and insights at the world's largest gathering of data platform professionals! The PASS Data Community Summit conference is going hybrid this year, and whether you're planning to attend in-person in Seattle or online, this is your chance to reach a global audience and advance your career as a speaker. If you're an expert in a data-related topic, we want to hear from you. Speakers of all experience levels are welcome to submit a proposal and the Call for Speakers is open until March 31. Registration also opens on March 24, so don't miss your chance to register for Summit's homecoming in Seattle at early bird pricing.
2022-03-16
The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for SQL Server.
2022-03-16
DevOps is a buzzword thrown around a lot. But what does it mean for you as a DBA? And how can the whole team work together to achieve peak performance across multiple projects? Join Kathi for the discussion.
2022-03-14
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
I have an issue where I have a Bill of Material list of items...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers