The April Energy Update
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
2008-04-22
484 reads
Editorial - WMV
Table Level Access
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
2008-04-21
27 reads
The Inmates in Charge
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
2008-04-20
28 reads
Sun Invests, IBM Invests, MS ??
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
2008-04-15
42 reads
2008-04-14
32 reads
Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
2008-04-13
39 reads
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
2008-04-12
39 reads
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
2008-04-10
38 reads
The Social Mesh
Steve Jones talks about some research from Dr. Cross, a professor from his alma mater, into social networks and how work gets done in a company.
2008-04-09
41 reads
The Feature Debate
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
2008-04-08
38 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
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