Deployment of Microsoft SQL database with Azure DevOps
Hello, data folks! I have published several articles about databases and their maintenance in SSDT project on the blog. One of the posts explained step by step how to...
2019-12-12
40 reads
Kamil
- Website: https://sqlplayer.net
Last Week Reading (2019-11-10)
Hello all! An extraordinary week has just passed. Two big conferences took place in the USA, PASS Summit and Ignite, where Microsoft announced plenty of new products or updates....
2019-11-10
13 reads
Last Week Reading (2019-11-03)
This week I’m offering you many posts about Cosmos DB, Azure Data Factory and how to design reliable Azure applications. Have a great week also for those of you...
2019-11-03
17 reads
Script and deploy the data for database from SSDT project
This post is a part of the series about SSDT and database project leveraging Visual Studio. We already know that SSDT can cover all objects but only on a...
2019-10-30
40 reads
Last Week Reading (2019-10-27)
Hello and good morning! We have Tuesday morning, which means I experienced a delay in this post. But finally, it is out and have a look at how much...
2019-10-29
22 reads
Last Week Reading (2019-10-20)
Hello folks! 2 weeks passed but eventually, I have some news for you. Press Support for Azure Databricks Instance pool for operationalizing Databricks workloads in Data Factory Public Preview...
2019-10-20
13 reads
T-SQL Tuesday #119 – What changes my mind
T-SQL Tuesday series (the monthly blog party) has been started by Adam Machanic and co-ordinated by Steve Jones. This month’s topic is hosted by my friend Alex Yates. He...
2019-10-08
16 reads
Last Week Reading (2019-10-06)
Hello Azure/Power/BI/Data fella! Another two weeks passed very quickly and the new edition of Community conference in the UK is about to begin. Check whether you can attend one...
2019-10-06
20 reads
ASF 025: Rob Farley interview
Introduction Rob Farley is a Microsoft Certified Master, Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server since 2006. Rob provides consulting and...
2019-09-26
24 reads
Last Week Reading (2019-09-22)
Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to admit but I missed last week’s post due to my visit to Sweden (SQLSaturday) and...
2019-09-22
11 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
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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