SQL PASS Summit 2011 Recap
This week has been an exciting and memorable week for me. The last PASS Summit I attended was in 2009...
2011-10-14
1,842 reads
PerformancePoint – Using SSAS Actions
The latest project I worked on had a heavy dose of PerformancePoint and one of the requirements was to launch...
2011-09-23
2,300 reads
SSRS – Dealing with truncating spaces
I apologize ahead of time on this post today because it will require lots of pre explanation and screenshots to...
2011-09-22
2,073 reads
PASS Pre Con - Building a Microsoft Business Intelligence Platform
PASS Summit is quickly approaching and while many of you are registering I wanted to remind you of some of...
2011-09-07
1,160 reads
SSIS - Inferred Member Insert in Fact Table Load
Recently while working on a different solution for loading inferred member solution in our fact table load I ran into...
2011-08-16
2,949 reads
PowerPivot – Commonly Used DAX Expressions
Today I will be presenting in a webinar, which by the way is recorded for later viewing, on Commonly used...
2011-08-11
1,675 reads
PowerPivot – Creating KPIs
Probably one of the most anticipated additions to the latest version of PowerPivot is the ability to create KPIs. PowerPivot...
2011-08-08
2,813 reads
PowerPivot – Perspectives
PowerPivot – Perspectives
Many times when developing larger Analysis Services cubes you may find it necessary to use Perspectives to logically split...
2011-08-05
4,420 reads
PowerPivot – Creating Hierarchies
Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies...
2011-07-31
4,840 reads
Modified Insert Unknown Row to Dimension Table
A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. ...
2011-07-29
2,912 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