Making a Difference in Uncertain Times
For some people, it’s not enough to take care of their own households and those of their families and neighbors. They’ve decided it’s important to make a difference in their communities and beyond.
2020-05-11
Additional Articles
SQL Change Automation enables a new flexible approach to DevOps
In the latest version of SQL Change Automation, we enable you to be more flexible in your approach to Database DevOps and combine elements of both state- and migrations- based approaches. Learn more about the new workflow.
2020-05-11
Set Statistics Time Examples for Tuning SQL Server Queries
The SQL Server set statistics time statement displays the number of milliseconds to parse, compile, and execute a T-SQL query statement. This set statement is widely used to assess times to implement a query statement. The set statistics time statement reports the CPU time and elapsed time for performance tuning.
2020-05-08
How to Attach a SQL Server Database without a Transaction Log and with Open Transactions
You want to attach a SQL Server database that does not have the transaction log files and get the following error: "The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure." In this tip I will help you to successfully attach the transaction log to the problematic SQL Server database.
2020-05-07
How to Add a Filter to an Existing SQL Change Automation Project
Kendra Little demonstrates how to create a SQL Compare filter file and save it to a SQL Change Automation project folder, so that it will be used automatically during development.
2020-05-05
Technology Makes a Difference
As the world deals with the Covid-19 pandemic, technology is making some things better for those of us in isolation. We are also better equipped today to fight the disease. Researchers are using artificial intelligence to quickly develop vaccines and treatments.
2020-05-05
SQL Server Database Deployment: What Could Go Wrong?
Phil Factor tackles the questions you were too shy to ask about SQL Server database builds, migrations and deployments.
2020-05-04
Storage 101: Data Center Storage Configurations
In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.
2020-05-04
Export SQL Server Tables to Excel
Sometimes there is a need to export data for a lot of different SQL Server tables into an Excel file. In this tip we look at how we can quickly export several tables into one Excel workbook where each table is stored in a different worksheet.
2020-05-01
Free Training Week: How I Use the First Responder Kit – sp_Blitz
When you’re first approaching a SQL Server, start with sp_Blitz. We’ll cover my favorite parameters and what I look for in the results, and then start building our notes in Markdown for our eventual health check recommendations for the rest of our team.
2020-04-30
798 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