Training and tips to get certified with Microsoft (Part 1)
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions...
2017-08-02
156 reads
SQL Homework – August 2017 – Create a table
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month...
2017-08-02
424 reads
SELECT…INTO in SQL Server 2017
One of the new options available in SQL Server 2017 is the ability to specify a filegroup when using SELECT..INTO...
2017-08-22 (first published: 2017-08-02)
3,283 reads
TechMentor Dine Around
Next week I’ll be speaking at TechMentor in Redmond, I’m doing a 1/2 day workshop on Linux OS Fundamentals for the Windows Admin be sure to come see me!
If you’re...
2017-08-01
11 reads
TechMentor Dine Around
Next week I’ll be speaking at TechMentor in Redmond, I’m doing a 1/2 day workshop on Linux OS Fundamentals for...
2017-08-01
433 reads
SSoL: Adding disk space with a repartition
I don’t think most of us need to know Linux, but if you end up managing a system, it’s good...
2017-08-01
627 reads
Are your indexes being thwarted by mismatched datatypes?
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...
2017-08-01
16 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...
2017-08-01
22 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...
2017-08-01
219 reads
Manually updating Statistics
Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...
2017-08-01
2,443 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Alamat Kantor BCA KCU Sidoarjo Tlp:(08218200203)
Hub Via Wa:628218200203 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo,...
Alamat Kantor BCA KCU Diponegoro Tlp:(08218200233)
Hub Via Wa:628218200233 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Alamat Kantor BCA KCU Indrapura Tlp:08218200174
Hub Via Wa:628218200174 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers