SSRS Subscriptions failure - should we always listen to our DBA's?
During the configuration of one of the SSRS instances I have stumbled upon a problem with SSRS Subscription. Subscriptions were...
2010-08-04
1,013 reads
Blog Posts
SSWUG Fall VConference – Coming Soon
SSWUG, or the SQL Server Worldwide Users’ Group, is one of the largest and most respected SQL Server communities on...
2010-08-04
309 reads
SSWUG Fall VConference – Get Registered
Hey There Gang!
For those of you who are not familiar with SSWUG I don’t know what to say. SSWUG or...
2010-08-04
196 reads
Testing Native Backup Compression in Combination with SQL Server 2008 R2 Data Compression
SQL Server 2008 introduced native backup compression and data compression as features that were only available in the Enterprise Edition...
2010-08-04
3,831 reads
Upcoming SQL
Hey folks, we have some very exciting SQL Lunch speakers on the docket coming up. Check out Devin Knight(Blog)|(Twitter) and...
2010-08-04
190 reads
Vote For The PASS SQLRally Logo
We received over 100 submissions for our 99designs contest to design the SQLRally logo. The SQLRally planning team, with help...
2010-08-04
797 reads
Getting Started With PerformancePoint 2010
PerformancePoint is a great tool for monitoring and analyzing the performance of your business at a high level but also...
2010-08-03
1,252 reads
Notes on SQLSaturday #40
Had a reasonably uneventful four drive to Miramar Friday, arriving in time to check in at the hotel and then...
2010-08-03
526 reads
Quickly Script Out Replication Redux
Dave Levy (Blog|Twitter) posted a script in a blog post in which he uses a bit of SQL PowerShell Extensions (SQLPSX)...
2010-08-03
1,409 reads
Registration Open for SW Fla Code Camp on September 25, 2010
John Dunagan and team are once again leading their annual Code Camp on September 25, 2010 in Estero, FL (think...
2010-08-03
275 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
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
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,...
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