TSQL Tuesday Misconceptions in SQL Server
I haven’t written a post for a TSQL Tuesday for a little while and I know that I’m late getting...
2010-10-12
1,073 reads
Gethyn Ellis
Instant File Initialization – Is it Turned On?
I have posted a short note on instant file initialization previously, that post can be found here. The crux of...
2010-09-21
1,728 reads
Policy Based Management - Disable Autoclose
I posted recently about my run-in with autoclose and my online friend Jorge Segarra (Blog|@SQLCHICKEN) left a great comment on...
2010-09-15
1,626 reads
Mastering PowerShell – Free EBook
Someone who I follow on twitter posted a tweet recently with a link to a free eBook on PowerShell. I...
2010-09-10
2,590 reads
SQL Server - Dedicated Administrator Connection (DAC)
This a short post looking at the Dedicated Administrator Connection or DAC for short. In extreme circumstances, when there is...
2010-09-09
8,236 reads
Auto Close – SQL Server
I ran into an issue recently where I had a third party supplied database set to auto close. I couldn't...
2010-09-07
2,997 reads
Incremental Load - TSQL
For my first technical post in a short while I thought I would look at something I have worked on...
2010-08-23
11,039 reads
Summer Update
I haven’t posted on my SQL Server blog for a few weeks, I missed the August T-SQL Tuesday which I’m...
2010-08-14
525 reads
The week that was Friday 23 July 2010
Its been a busy week this week. From troubleshooting several production issues to writing some incremental load SSIS scripts, the...
2010-07-23
519 reads
Raining Tuesday – Cricket Cancelled – Replication Stinks - SQL BITS VOTE NOW!
Well this was going to be replication post, but I have read it, re-written it, read it, re-written and it...
2010-07-20
667 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 BCA KCU BEKASI Hub:Cs,0817781222
Wa:0817781222 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Alamat Kontak BCA KCU RAWAMANGUN Hub:Cs,0817781222
Wa:0817781222 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Alamat Kontak BCA KCU THAMRIN Hub:Cs,0817781222
Wa:0817781222 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers