AdventureworksCI Step 3 Handling data with SSDT
This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server...
2015-07-07
2 reads
Ed Elliott's Sql Developer Blog
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...
2015-07-07
28 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...
2015-07-07
35 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official support to Windows. While this is great news it...
2015-07-07
12 reads
Run SQL Server In A Container Today July 2015
Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...
2015-07-03
809 reads
Download SSMS, SSDT or SSDT-BI
It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or...
2015-06-30
1,378 reads
Download SSMS, SSDT or SSDT-BI
It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or...
2015-06-30
244 reads
Download SSMS, SSDT or SSDT-BI
It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or...
2015-06-30
215 reads
Download SSMS, SSDT or SSDT-BI
It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or you download the wrong thing.
This is an example of...
2015-06-30
16 reads
Why does sqlpackage.exe not compare after the pre deployment script has run?
It isn't a Pre compare script
When you use SSDT to deploy your dacpac, a pre deployment script lets you run...
2015-06-24
857 reads
Blogs
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...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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