On Learning from Experience and Misfortune
Phil Factor on learning from mistakes. Preferably other people's.
Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.
Webinar: Redgate Database Lifecycle Management (DLM) Demo
SSC's Steve Jones will show you how Redgate's DLM solution works to improve your database development and deployment processes. You'll see how to version control your databases from SSMS to track and understand changes, include your database in your Continuous Integration process to get quick feedback, automate your database deployment process to have safe, reliable, repeatable deployments, and more.
An Introduction to the SQLCMD Mode in SSMS (SQL Spackle)
Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.
SQL Solutions Group Marks 5th Anniversary with SQL FreeCon
To mark five years in business helping companies across the United States with their SQL Server needs, SQL Solutions Group will host a day of free SQL training Tuesday, Oct. 27, in Seattle.
Where should middle tier business logic be stored?
The age old question of where should business logic be stored
Idle Connection Resiliency
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
The Poor Soul
What should those accidental DBAs do when they don't get any training, but they are responsible for database servers? Steve Jones has a few pieces of advice today.
Integration Services Logging Levels in SQL Server 2016
At the time of writing, SQL Server 2016 preview (CTP 2.3) has been released and there are some changes for the Integration Services (SSIS) Catalog logging levels.
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 KCU SUBANG Telp:Cs,0817781222
Wa:0817781222 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Alamat Kontak Resmi BCA KCU DAGO Telp:Cs,0817781222
Wa:0817781222 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
BCA KCU BEKASI Telp:Cs,0817781222
Wa:0817781222 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers