Dynamically Create Tables Based on an Access Table
Create and Load Sql Server Tables based on Dynamic Access Database
Testing
We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.
Exploring Query Plans in SQL
SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?
Data Lakes
An interesting new paradigm popped up in the news this week: the data lake. It examines data as a model for organizational architectures.
SQL Server PCI DSS Security Patching Checklist
PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. How do you create a patching policy for SQL Servers?
Multiple Backup Files
This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.
Backing up your SQL Server to Amazon's Cloud in Three Easy Steps
John Grover explains how to set up Amazon S3 storage, install and configure the Amazon PowerShell module, and set up a Maintenance plan using SQL native backups and PowerShell.
Two Days Off
Verizon is taking their cloud service offline for maintenance for two days. Steve Jones doesn't think that sounds good.
Archiving Hierarchical, Deleted Transaction Using XML
When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.
Test Your Situation
One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.
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 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...
Alamat kantor BCA KCP Banjaran Adiwerna Telp:0818751777
WhatsApp:0818-751-777 Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers