SQL Server 2008 R2 – Release Date
This is a very short post
I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release...
2010-04-15
514 reads
Blog Posts
SQL Server 2008 R2 Release Date: May 21 2010
R2 is ready to roll!
As expected, Brent “Master” Ozar (Blog | Twitter) already scooped the story, but it never hurts to...
2010-04-15
480 reads
Third Party Backup Tools – Redgate SQL Backup
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,905 reads
A DMV a Day – Day 14
The DMV for Day 14 is sys.dm_os_wait_stats, which is described by BOL as:
Returns information about all the waits encountered by...
2010-04-14
788 reads
A Quick Queue Process
As SQLServerCentral grew, we evolved through a few email sending solutions to meet the demand. We started with a manual...
2010-04-14
783 reads
How Do I Kill All Sessions from a Windows Group?
Introduction
The stored procedure I am posting today will kill all sessions for users that are members of a given domain...
2010-04-14
515 reads
How to Avoid Some Common Developer and DBA Mistakes
In March, I ran a Question of the Month that asked, “What is the biggest mistake/problem you ever found on...
2010-04-14
2,815 reads
Microsoft Changing Their Lifecycle Support Policy
Microsoft’s Bob Ward has a new post up on the CSS SQL Server Engineers blog about a change in their...
2010-04-14
1,726 reads
Notes from the April 13, 2010 oPASS Meeting
Decided to scrap the pizza this month after one too many late deliveries from Pizza Hut, went with sandwich platters...
2010-04-14
489 reads
OPASS April Meeting Recap
Well, we had our April meeting on Tuesday the 13th. Let's just say it wasn't our most successful meeting, and...
2010-04-14
473 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