Database Deployments in Uncontrolled Environments
The ideal is to make a change and see that change deployed to production, in a perfect world we would...
2016-09-29 (first published: 2016-09-20)
1,311 reads
Ed Elliott's Sql Developer Blog
Database Deployments in Uncontrolled Environments
The ideal is to make a change and see that change deployed to production, in a perfect world we would...
2016-09-20
36 reads
Database Deployments in Uncontrolled Environments
The ideal is to make a change and see that change deployed to production, in a perfect world we would...
2016-09-20
42 reads
Database Deployments in Uncontrolled Environments
The ideal is to make a change and see that change deployed to production, in a perfect world we would be told to work on something, write the code...
2016-09-20
6 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
777 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
56 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
68 reads
Controlling a dacpac deployment
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to deploy dacpac's. In particular I am talking about how...
2016-08-21
15 reads
tSQLt Visual Studio Test Adapter
tSQLt Visual Studio Test Adapter
What is this?
This lets you use Visual Studio to run tSQLt tests easily. Visual Studio has...
2016-08-24 (first published: 2016-08-17)
2,273 reads
tSQLt Visual Studio Test Adapter
tSQLt Visual Studio Test Adapter What is this? This lets you use Visual Studio to run tSQLt tests easily. Visual...
2016-08-17
50 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Alamat Kantor BCA KCU GRESIK Telp/Wa (0817)839777)
Kontak Cs: 0817839777 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik,...
Alamat Kantor BCA KCU VETERAN ??/Wa (0817)839777
Kontak Cs: 0817839777 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Alamat BCA KCU Mojokerto ??/Wa (0817)839777
Kontak Cs: 0817839777 Jl. HOS. Cokro Aminoto No.5, Mergelo, Jagalan, Kec. Magersari, Kota Mojokerto,...
Question of the Day
Detecting Characters
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