New HP Envy 15 Laptop
After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This...
2009-11-12
1,955 reads
Glenn Berry
Windows Virtual PC and Windows XP Mode on Windows 7
One feature of Windows 7 that you may not have heard of is Windows XP Mode on Windows Virtual PC....
2009-11-12
1,403 reads
SQL Server 2005 Diagnostic Information Queries
Here is an updated version of my diagnostic information queries for SQL Server 2005. You can get the SQL Server...
2009-11-09
2,291 reads
Temporary Post Used For Theme Detection (3d1489bf-65cc-47a0-b394-b28676998db9 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e29f86d1-0b33-4a68-adcd-77248245d9b5 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2009-11-09
566 reads
SQL Server Wait Type Repository
Microsoft’s Bob Ward has a good post up on the CSS SQL Server Engineers blog about an upcoming web page...
2009-11-08
1,341 reads
Worldwide Operating System Market Share for October 2009
Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already...
2009-11-07
1,455 reads
New Pricing and Editions For SQL Server 2008 R2
Mary-Jo Foley recently posted about some announcements about SQL Server 2008 R2 out of the PASS Summit. There will be...
2009-11-05
1,028 reads
SQL Server 2008 R2 Running on “Big Iron”
During the opening keynote on Tuesday at the PASS Summit in Seattle, Microsoft’s Bob Muglia showed a demonstration of a...
2009-11-05
1,169 reads
Day 1 At SQL PASS in Seattle
Today was my big, somewhat stressful day at the PASS summit in Seattle. I gave two, 75-minute Community session presentations,...
2009-11-04
1,441 reads
SQL Server 2008 Diagnostic Information Queries
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
2009-11-04
1,650 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