SQLBits is back online and in-person from March 8-12 and this year they’re taking us all to the Arcade! Register to get access to our exclusive pre-con and conference sessions run by Grant Fritchey, Kathi Kellenberger, and Steve Jones, as they talk database. And get a 10% discount code when you register using REDGATE274.
2022-03-02
Continuous Compliance Automation aims strike a balance between baking compliance requirements into daily operations, and business demands for speed and agility. Redgate's Security Lead, will be joined by a panel of peers to discuss this mindset change and the impact it can have on your organization.
2022-02-28
In this article learn about how to use the new diagram view along with a schema view in Power BI to make Power Query online editing easier on report designers.
2022-02-28
Find out how 2500+ of your database professional peers are meeting current and upcoming challenges in our free reports. We cover the Cloud, Security, Growing Environments and the value of monitoring for the entire organization.
2022-02-25
Python is a modern general-purpose programming language that's very useful for analytics. Sanil Mhatre demonstrates sentiment analysis with Python.
2022-02-25
The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon explains how to install it on Windows and create the first database and table.
2022-02-23
This article describes a route to adopting Flyway in order to bring management and control to a chaotic database development process. It is based on use of Flyway migrations to update a database from version to version, while maintaining object-level source scripts for tracking changes between versions.
2022-02-23
In this article we look at how to create SQL Server triggers using Common Runtime Language (CLR) along with examples and a step-by-step guide.
2022-02-21
More and more organizations are turning to DevOps to improve the efficiency and quality of software delivery, and increase value to their business. But what exactly is DevOps and what does it mean for you and your organization?
2022-02-21
In case you missed it: IDC’s recent Global DataSphere Forecast, 2021-2025, predicts that global data creation and replication will experience a compound annual growth rate (CAGR) of 23% over the forecast period. But what’s causing the growth? Where will all of that extra data be stored? And how should we, as data professionals, prepare for it?
2022-02-18
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Kontak Cs: 0817839777 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik,...
Kontak Cs: 0817839777 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
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