How to setup a task to delete the old backup files or log files from the server ?
Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...
2012-02-27
1,428 reads
Blog Posts
I’m Going to SQL RALLY!
Hello Dear Reader, I’ve just received great news I’M HEADED TO SQL RALLY 2012! But I didn’t get here on...
2012-02-27
763 reads
I’m speaking at SQL Rally 2012
I’ve learned that my session entitled “Introduction to Data Quality Services” has been selected as one of the community choice...
2012-02-27
681 reads
Learn Mirroring with me at SQLRally
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an...
2012-02-27
666 reads
New Article: Exploiting SQL Server via CONTROL SERVER permissions
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,737 reads
Passing BIGINT data to SSRS Sub Report
Few days back one of my team mate complained to me that one particular sub report is failing randomly with
Error:...
2012-02-27
1,453 reads
Presenting Two Sessions at SQLRally
I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....
2012-02-27
980 reads
RYO Maintenance Plan – Update Statistics
Another key component of any good maintenance plan is updating statistics. Statistics are what help the SQL Server optimizer choose...
2012-02-27 (first published: 2012-02-21)
2,552 reads
SSRS 2008 Error – The report definition is not valid
Recently I downloaded a file from one of our production server, did some changes and reviewed it in BIDS and...
2012-02-27
4,706 reads
The Armor of Transparency
Yesterday I blogged about hosting a daily status meetings and some of the tricks I use to make it work....
2012-02-27
648 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
BCA KCP Permata Ujung Menteng Tlp:0817839777
WhatsApp: 0817839777 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
Alamat Kantor BCA KCU RAWAMANGUN Tlp:0817839777
WhatsApp: 0817839777 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
Alamat Kantor BCA KCP Buaran Raya Tlp:0817839777
WhatsApp: 0817839777 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers