Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
SQLSaturday #32 - Tampa, FL
If you are in the area, come to this great one day training event in Tampa, FL.
Caution with EXCEPT
The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.
Moving PASS
The PASS Summit has been held in Seattle for a number of years, but recently people have asked to move it somewhere else. Steve Jones talks a little about the issue.
The End of Support
It can be nerve-wracking for a DBA when support for their server ends. This week support for SQL Server 2005 Service Pack 2 ended and Steve Jones talks about your options.
Implement a stack in SQL Server using stored procedures
In this article I will show you how to implement a stack. In programming, stacks are a great way to...
Improving Data Compression Fidelity Without Sacrificing Speed
Making it easier to handle huge data sets
Local Temporary Tables and Table Variables
Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.
The Price of SQL Server
SQL Server is an expensive product to license. Or is it? Steve Jones asks today if you feel it's expensive, and what price might you want to pay.
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