TEMPDB Enhancements in SQL Server 2016
TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.
Data Encryption Using Always Encrypted in SQL Server
The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.
Great Developers Use Source Control
The title says it all. The great developers will use source control. This habit might not make you great, but it will help you improve.
SharePoint Disaster Recovery Plan
Hot standby disaster recovery process where SharePoint farm will become available in minutes
SQL Server Machine Learning Services – Part 6: Merging Data Frames in Python
In the final article in this series, Robert Sheldon demonstrates combining data sources with multiple formats into one Python data frame.
Stairway to U-SQL Level 20: Querying External Data with U-SQL
Did you know you can query SQL Server data with U-SQL? It's true! Find out how in this latest stairway step.
SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea
By default, when you run a query in SQL Server, your delete/update/insert (DUI) is finished as soon as your query finishes. That’s because the default behavior of SQL Server is IMPLICIT_TRANSACTIONS OFF – meaning, SQL Server doesn’t hold your queries open waiting for a COMMIT or ROLLBACK.
AI in Industries
It is important to showcase how Artificial Intelligence is being used in various fields and industries with some facts
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.
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 Brebes Telp:0818751777
WhatsApp:0818-751-777 Jl. Pangeran Diponegoro No.296, Brebes, Kec. Brebes, Kabupaten Brebes, Jawa Tengah 52212 (@bcakcpbrebes)
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers