How To Get a Count of SQL Connections BY IP Address
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...
2009-12-28
5,161 reads
Glenn Berry
Should You Get a Netbook Computer?
On Monday, Intel officially announced the next generation Atom processors (aka Pineview) that are part of the new Pine Trail...
2009-12-23
570 reads
Cumulative Update 17 For SQL Server 2005 SP2
Microsoft has announced the release of CU17 for SQL Server 2005 SP2, which is Build 3356. The link to request...
2009-12-21
592 reads
Cumulative Update 7 For SQL Server 2005 SP3
Microsoft has announced the release of CU7 for SQL Server 2005 SP3, which is Build 4273. The link to request...
2009-12-21
481 reads
Great Resource On SQL Server Wait Types
Microsoft's Bob Ward has updated his blog post about documenting SQL Server wait types, that came out of his work...
2009-12-21
924 reads
Two Tools For Discovering Hardware Information About Your Servers
One thing that I think is very important for a successful DBA to be aware of is their hardware environment. ...
2009-12-21
1,297 reads
Webcast: SQL Server 2008 R2 Support for Up to 256 Logical Processors
If you are a low-level, bare-metal type of SQL Server geek, you will probably enjoy watching this 60 minute webcast...
2009-12-21
653 reads
How to Copy Query Results From SQL Server 2005/2008 into Excel
I often work with DBAs who need to copy the results of a T-SQL query from SQL Server Management Studio...
2009-12-17
5,064 reads
Updated SQL Server 2008 Diagnostic Queries
Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able...
2009-12-16
981 reads
More Information about Intel Desktop CPU Roadmap
Endgadget has a post up about an upcoming 32nm Westmere family CPU called the Core i7-980X, which will have six...
2009-12-15
763 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