Leveling the Field
Today Steve Jones talks about the ability of cloud services to level the field when it comes to software, especially for small companies.
Process to truncate transaction log of replicated database
This article demonstrated the steps which you must follow to gracefully truncate the publisher database transaction log file by resetting replication.
Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor
Wednesday July 25 2012, 6:00pm BST: Learn how you can use SQL Monitor to gather information and alert on extra performance data for your servers and applications, making this tool vital for keeping an eye on your business. In this free webinar David Bick, Product Manager at Red Gate, will give you an overview of SQL Monitor including the new custom metric functionality in v3.
Implementing SQL Server's Change Data Capture
When SQL Server 2008 was released the Microsoft product group came out with a new feature called "Change Data Capture" that allows you to track the changes that occur to a table. Greg Larsen gives you a primer of how to implement change data capture and how to review the captured information to produce an audit trail of the changes to a database table.
SQL Saturday #159 - Kansas City
BBQ and SQL Server. Come to a free day of training in Kansas City on Aug 4.
Introduction to Indexes: Part 3 – The nonclustered index
Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.
Security is Improving
Today Steve Jones notes that security is improving at many web sites. It's not great, but it's improving. That's a good sign, or is it?
What to look for in an employer
A Job interview for a database Developer is, or should be, a two-way process. They are sussing you out, and you are sussing them out.
Developing Low-Maintenance Databases
Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.
SQL Saturday #150 - Baton Rouge
Baton Rouge, LA. LSU. Free Training. Come visit, learn a few things, and enjoy meeting other SQL Server pros.
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 Bumiayu Telp:0817866887
WhatsApp:0817-866-887 Jl. Kalierang No.Ruko 3-5, Dukuhturi, Kec. Bumiayu, Kabupaten Brebes, Jawa Tengah 52273 (@bcakcpbumiayu)
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...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers