AI in Industries
It is important to showcase how Artificial Intelligence is being used in various fields and industries with some facts
2018-03-13
456 reads
Articles
Changing Data Types on Large Tables: The INT to BIGINT Conundrum
Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.
2018-03-13
10,620 reads
Intervals Part 1 - Definitions and Terms
Learn the basic terms and definitions for intervals in SQL Server.
2018-03-12
2,556 reads
Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert
In this tip, Tim Smith looks at how to use bulk insert to load data into SQL Server when the column and row terminators are not what you typically see.
2018-03-12
3,402 reads
The DBA's Essential Index Monitoring and Maintenance Tasks
Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.
2018-03-09 (first published: 2016-02-15)
8,198 reads
Introduction to the Biml Language
Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages.
2018-03-09
3,767 reads
TDE with Automatic Database Seeding
Transparent Data Encryption on an Availability Group and Automatic Database Seeding
2018-03-08
3,122 reads
Azure Cosmos DB Partitioning
One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.
2018-03-08
2,357 reads
Questions About Data Breaches that You Were Too Shy to Ask
News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not immune. William Brewer answers the question about data breaches that you may be too shy to ask.
2018-03-07
3,539 reads
The Many Levels Of Concurrency
When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.
2018-03-06
3,361 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 kantor BCA KCP Ketanggungan Timur Telp:0818751777
WhatsApp:0818-751-777 Jl. P. Diponegoro No.141, Dukuhtengah, Dukuh Tengah, Kec. Ketanggungan, Kabupaten Brebes, Jawa Tengah...
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...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers