My First Board Meeting
Parents, you know that feeling you get after you’ve brought home that brand new baby (or in my case, babies) where...
2015-01-30 (first published: 2015-01-26)
6,358 reads
RIGHT() function in SQL Server
Right():- This function returns the specified number of characters from the Right part of the given character string.Syntax:- Select RIGHT ( character_expression , integer_expression ) For example, the below query will...
2015-01-26
15 reads
Impact Player Series – Part 1
I wanted to start this series in regards to impact players that go above and beyond in the SQL Community....
2015-01-26
584 reads
Entity Framework 6 Entity/Property To Table/Column Names
I was recently working on some code where I needed to be able to go from an EntitySet name to...
2015-01-26
226 reads
SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-29 (first published: 2015-01-26)
6,310 reads
SSRS Farm to Scale-Out Performance
SSRS Farm Overview
Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and...
2015-01-26
1,375 reads
Availability Group Read-only Routing
This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly. Quickly I was able to determine the issue was...
2015-01-25
24 reads
Availability Group Read-only Routing
This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly....
2015-01-25
3,456 reads
SQL Script to find the missing indexes
Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the...
2015-01-25
16,265 reads
new LinkedIn article
Hi everyone,
I just published a new LinkedIn article entitled “Let It Go”. Please check it out!
https://www.linkedin.com/pulse/let-go-chuck-boyce
2015-01-25
433 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
Alamat BCA KCP Thamrin Nine Telp:0821°7555°651
Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...
Alamat BCA KCP Samanhudi Telp:08218200203
Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCP AM Sangaji Telp:08218200233
Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers