What’s the one thing you must do to win the trust of customers?
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit...
2019-01-23
203 reads
Blog Posts
Availability Groups: When Your Synchronous Secondary isn’t Synchronous
During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit...
2019-01-22 (first published: 2019-01-14)
2,057 reads
Critiquing Grant Fritchey: Circa 2008
For several years, I ran a regular feature on this blog, Speaker of the Month. I attend a lot of...
2019-01-22
163 reads
Leveling Up Your TSQL
I thought I’d use this post to round up some of my other posts into a list of often overlooked/unknown...
2019-01-22
257 reads
Optimizing for Ad Hoc Workloads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
9 reads
Optimizing for Ad Hoc Workloads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
7 reads
SQL Power Doc to Discover, Diagnose and Document SQL Server
This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server, including pre-requisites, purpose,...
2019-01-22
338 reads
SQL Power Doc to Discover, Diagnose and Document SQL Server
This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server, including pre-requisites, purpose, installation, processing and output. Automation seems to be an increasing...
2019-01-22
111 reads
SQL Server Monitoring: What to start measuring
So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare...
2019-01-22 (first published: 2019-01-14)
2,668 reads
MSSQLTips.com Rookie of the year 2018
You need a lot of hard work for success!2018 was a good year for me in a lot of areas...
2019-01-21
251 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat kantor BCA KCP Ketanggungan Timur Telp:0818751777
WhatsApp:0818-751-777 Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah...
Alamat kantor BCA KCP Slawi Telp:0818751777
WhatsApp:0818-751-777 Jl. Jend Sudirman No.46, Curah, Slawi Wetan, Kec. Slawi, Kabupaten Tegal, Jawa Tengah...
Alamat kantor BCA KCP Ketapang Telp:0818751777
WhatsApp:0818-751-777 Jl. M.T. Haryono No.68, Tengah, Kec. Delta Pawan, Kabupaten Ketapang, Kalimantan Barat 78812...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers