I wrote a SQL Server auditing whitepaper!
I recently collaborated with Idera to produce a short whitepaper on the top 5 things to audit in SQL Server...
2016-07-27
1,038 reads
When was this database restored?
I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis....
2016-07-27
858 reads
An update on AutoAdjustBufferSize in SSIS 2016
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS,...
2016-07-27
2,968 reads
Bug fixes in SQL Server
SQL Server 2016 CU1 has been released and one thing I noticed was: –
FIX: Canceling a backup task crashes SQL...
2016-07-27
854 reads
Day1 - Assertiveness Skills: Communicating with Authority and Impact
This is the last course of my July training month. This is my second course this week. Yesterday I was...
2016-07-27
997 reads
Azure SQL IaaS – TempDB Performance on SSD vs Premium Disk
[read this post on Mr. Fox SQL blog] When it comes to deploying SQL Server onto an Azure IaaS VM, it is sometimes difficult to know the best option to deploy the SQL Server...
2016-07-26
47 reads
Azure SQL IaaS – TempDB Performance on SSD vs Premium Disk
[read this post on Mr. Fox SQL blog]
When it comes to deploying SQL Server onto an Azure IaaS VM, it is sometimes difficult...
2016-08-01 (first published: 2016-07-26)
3,232 reads
Check out the latest and greatest...Great Value It Training Offers
Here's this weeks list of courses. At £750 plus VAT... I can't see how you can fail
1902: Linux Virtualisation 4...
2016-07-26
438 reads
PowerSQL – Get SQL TraceFlag SQL Service and Config Information
Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers.
This script outputs...
2016-07-26
612 reads
Webinar Followup: New Security Features in SQL Server 2016
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can...
2016-07-26
696 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers