PASS Summit Live Keynote – Release 5
Julie Koesmarno, Senior Project Manager at Microsoft, takes the stage to talk about business analytics utilizing War and Peace.
Tracing emotions...
2016-10-26
589 reads
The SQL Professor
PASS Summit Live Keynote – Release 4
Document DB: Blazing fast planet-scale NoSQL:
Guaranteed Low LatencyElastically Scaling StorageElastically Scaling ThroughputNo Impedance MismatchChoice of ConsistencyEnterprise Level SLAAzure + DocumentDB with...
2016-10-26
457 reads
PASS Summit Live Keynote – Release 3
Justin Silver, Scientist Pros, takes the stage……
Taking data science out of the lab settings and placing it into real world...
2016-10-26
471 reads
PASS Summit Live Keynote -Release 2
Rohan Kumar, General Manager of Microsoft, takes the stage hyping up SQL Server 2016. We keep hearing the word “Sharing”...
2016-10-26
478 reads
PASS Summit Live Keynote – Release 1
Joseph Sirosh taking the stage by first telling us a story with over 400 million children in India. Only 50%...
2016-10-26
554 reads
PASS Summit 2016 – Live Keynote
Good morning from PASS Summit 2016!
Today will be the first keynote session at 8:15 a.m. with Joseph Sirosh. I’ve found...
2016-10-26
443 reads
T-SQL Tuesday #83: We’re still dealing with the same problems
It’s about time I got back into participating in the T-SQL Tuesday block parties that are hosted by community members...
2016-10-11
381 reads
PASS Summit Advice For First Timers
As I scrolled through the twitter feeds I ran across one from Tom LaRock (b|t) on PASS Summit being three...
2016-10-11
407 reads
Is ROI for Vendors Worth the SQL Saturday Investment?
Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from...
2016-09-27
328 reads
SQL Sentry Does It Again–Plan Explorer 3.0
Being in a shop that utilizes Plan Explorer it was awesome to hear of the news release from SQL Sentry...
2016-09-08
427 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 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...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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