PowerShell and Effective Meetings at PASS 2010
Last week, PASS announced this year’s program for the 2010 Summit in Seattle, Washington. The program session are available online....
2010-07-12
442 reads
Blog Posts
S3OLV July Recap
This month we had our first adventure in LiveMeeting presentations. We had the pleasure of listening to Jack Corbett give...
2010-07-12
441 reads
Settling or Pushing On
I read a blog recently that was titled: Time to Stop Settling. I think that the author (a friend) was...
2010-07-12
382 reads
Should DBAs Be the Protectors of Data?
Originally published in the Database Weekly newsletter.
I used to work at a large organization ($8 billion in revenues) as a...
2010-07-12
412 reads
Speaking at Greater New Orleans .Net User Group (GNO.NET)
This week I will speaking at the Greater New Orleans .Net User Group. My topic is Introduction to the SQL...
2010-07-12
685 reads
Speaking at Nashville, St Louis, and Baton Rouge in August
In August, I will be presenting at the following events:
DevLINK, August 5-7, 2010
How and When to Use Indexed ViewsIdentifying SQL...
2010-07-12
558 reads
SQL Lunch Presentation Today and Wednesday
A heavy week for SQL Lunch with two presentations!
There is another SQL Lunch presentation scheduled for today at 12:30 EDT. Join...
2010-07-12
578 reads
SQL Saturday #28 “Refer a Friend Contest”
With all the MSDN give away contests, I decided to add another. Here are the official rules for the twitter...
2010-07-12
563 reads
SQL Server DMV Starter Pack E-Book Published
Red Gate Books has published a new e-book called “SQL Server DMV Starter Pack”, which you can download for free...
2010-07-12
2,075 reads
SQLSaturday #49 – Orlando Pre-Conference with Louis Davidson
The planning team of SQLSaturday #49 – Orlando and OPASS are proud to announce that there will be a pre-conference seminar...
2010-07-12
774 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