Going to Seattle for More SQLSkills!
Last April I experienced the most amazing training event I have participated in so far in my life (yet).
I actually...
2012-08-10
660 reads
Blog Posts
Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server
The PASS Data Architecture Virtual Chapter hosts none other than Dr. SQL Louis Davidson as he helps application and database...
2012-08-10
1,043 reads
Speaking for PASS Professional Development Virtual Chapter
This coming Wednesday I will be speaking for the PASS Professional Development virtual chapter. My talk will be on my...
2012-08-10
2,119 reads
SQL Server BI & SharePoint eBooks, Guides and Resources
There are many free eBooks & resources available from Microsoft and members of the MVP community. This is a collection of...
2012-08-10
1,351 reads
Standing Desk – Flooring
My standing desk experiment has worked out well. I have gotten used to standing there and I’ve slowly found places...
2012-08-10
1,205 reads
Tampa Code Camp Announced
The next Tampa Code Camp will be held October 13 at University of South Florida, 4202 East Fowler Avenue,Tampa, FL...
2012-08-10
496 reads
August 2012 – Monthly SQL Server Checklist
Summer is beginning to wrap up for those of us in the northern hemisphere and were finally to August. Maybe...
2012-08-09
1,153 reads
Don't Use Passwords That Can Be Social-Engineered
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current...
2012-08-09
1,948 reads
Excluding Schemas in SQL Compare
I saw this question posted the other day and thought it was a great idea.
I haven’t been a big...
2012-08-09
2,432 reads
Forcing network protocol to connect SQL server
Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different...
2012-08-09
1,243 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
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