Using DMV to identify members roles
Some times is necessary retrieve a list of members of the roles of a database. Doing this is simple, using...
2010-08-12
2,757 reads
Blog Posts
White Paper Wednesday – Bulk Report Generation with SSIS and SSRS 2008 R2
Hey folks,
It’s white paper Wednesday and this week we’re looking at Bulk Report Generation using SSIS and SSRS 2008 R2...
2010-08-12
233 reads
White Paper Wednesday – Data-tier Applications in SQL Server 2008 R2
Hey folks,
It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger...
2010-08-12
403 reads
24 Hours of PASS: Like Bacon for Chocolate
24HOP: Like Bacon for Chocolate
24 Hours of PASS is hip, it’s new…it’s serialized.
The September 15-16 24HOP is a sneak peek...
2010-08-11
681 reads
24 Hours of PASS: Summit Preview
Registration is open for the second 24 Hours of PASS this year. This one is going to be a preview...
2010-08-11
561 reads
A Chance to Win a Free Trip to the PASS Summit
Passing along this contest from Idera and MSSQLTips. I don’t do many plugs, but it’s a chance for someone to...
2010-08-11
788 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
748 reads
Logo Selected for SQLRally
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
385 reads
Registration Open for 24 Hours of PASS
The ‘Summit Preview’ edition, this time around it features speakers from the upcoming PASS Summit with each doing a one...
2010-08-11
341 reads
Sharing a Temporary Table
One of the things that I’ve often seen people do is build temp tables to hold data for each connection...
2010-08-11
2,142 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