Postponing SQL Lunch Presentation Until Next Week
I woke up this morning about 3 AM with clogged sinuses and a fever. Great. The changing weather patterns that...
2010-10-27
640 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Why CONTROL SERVER Doesn't Cut It
With the new securables since SQL Server 2005, Microsoft has advised that we start moving away from the fixed server...
2010-10-26
4,544 reads
Vote for Me for a PASS SQLRally Precon on SQL Server Security
Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...
2010-10-25
2,059 reads
Free SQL Server Training for the Week of October 25, 2010
Monday
PASS Data Warehousing/BI Virtual Chapter - Applied MDX - Kevin Geoff
Tuesday
PASS Application Development Virtual Chapter - Refactoring SQL Applications - Jeremiah Peschka
Pragmatic Works - Pro...
2010-10-22
870 reads
Speaking for SQL Lunch on Wednesday
This coming Wednesday I'll be speaking for SQL Lunch on the topic of Auditing Database Permissions in SQL Server. The abstract for...
2010-10-22
517 reads
Give Back and Get Free Tools to Do So
SQL Server MVP Arnie Rowland (blog | twitter) has been running a project, Project Phoenix, to benefit unemployed/underemployed developers who are striving to do...
2010-10-17
570 reads
Free SQL Server Training for the Week of October 18, 2010
Tuesday
PASS - 24 Hours of PASS - LATAM: All Sessions in Spanish or Portuguese
Pragmatic Works - SQL Statement Tuning with Indexing Strategies - Kevin...
2010-10-15
788 reads
Active Directory Users and Computers (ADUC) - A Handy Tool for DBAs
Active Directory Users and Computers (ADUC) is a very common tool over on the Active Directory side. As the name...
2010-10-14
8,557 reads
Tools I Use to Scan for SQL Servers
I was having a Twitter conversation on this yesterday and naturally Aaron Nelson (blog | twitter) popped in with "PowerShell!" I like PowerShell,...
2010-10-13
15,644 reads
Slides and Demo from Midlands PASS Presentation - October 12, 2010
Here are the slides and demo script from the presentation on Understanding SQL Server Query Processing.
2010-10-12
550 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