When You're Out of the Office
What would you recommend for the holidays next week when the office is closed.
SQL Server 2005 Express Edition - Part 12 - ClickOnce Deployment and Updates
Part 11 of this series presented the publishing options of ClickOnce-capable applications that involve User Instance-based databases. This article takes a closer look at the deployment process, demonstrating the impact of your selections on its characteristics.
Becoming A DBA, Part 1
Buck Woody examines examines some of the decisions you'll need to make when embarking on your DBA career, and some the character traits and skills that will help you succeed and progress.
What's a Good Manager
What makes a good manager? In response to a recent thread, Janet Wong takes us through some of the good and bad managers she's had during her career and talks about the problems today with technical managers.
Optimise SQL Server queries with these advanced tuning techniques
Now that you know how to speed up your SQL Server database queries, you can start delving into some of the more advanced tuning options.
SQL Server Training at TCU
If you are near Texas Christian University, you might want to check out this training from a SQL Server MVP.
Obfuscation
Test data is critical to being sure your application works, but is production data ok to use in test environments?
SQLServerCentral Rules of Conduct
Being a part of the community means that there are certain standards that we'd like you to adhere to. Steve Jones brings you a few reminders of how to behave when posting in the community.
XML Workshop XIII - XSD And Variable Content Containers
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
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