Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means...
2012-03-01
4 reads
Jason Brimhall
Using SSIS to Maintain the File System
Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.
2012-02-24
7,252 reads
2012-02-08
1,157 reads
Goals 2012
As I have wanted to do each year, here is my goals post for 2012. Last year I set out to do this very same thing but was very...
2012-02-08
4 reads
Freedom
Not too long ago, I blogged about a Book called Daemon. Freedom is the sequel to Daemon.
I enjoyed reading this...
2012-02-07
715 reads
Freedom
Not too long ago, I blogged about a Book called Daemon. Freedom is the sequel to Daemon. I enjoyed reading this book. The story continues from Daemon, but in...
2012-02-07
12 reads
S3OLV – Get your Merge On
We are rapidly closing in on the February meeting for S3OLV. You might remember reading about the upcoming meeting here.
We...
2012-02-07
641 reads
S3OLV – Get your Merge On
We are rapidly closing in on the February meeting for S3OLV. You might remember reading about the upcoming meeting here. We are looking to have an excellent meeting this...
2012-02-07
7 reads
Slammer, Alive…Barely
Slammer
By now you must have heard of the SQL Slammer worm. It was quite an infectious little nuisance. The harm...
2012-01-30 (first published: 2012-01-24)
2,428 reads
System Base Tables
On January 19th, I published a post about the Dedicated Administrator Connection. I spoke very briefly of the system base...
2012-01-30
1,401 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