The Real World: Implementing AWE
Describes the gains experienced in my environment by implementing AWE.
What is Big Data?
The definition of Big Data is rather murky, despite all the press and attention given to it. Steve Jones talks about what Big Data means for relational databases.
How to Create an Indicator and Gauge Report in SSRS - SQL Server 2008 R2 - Part 1
Arshad Ali discusses the details of creating reports with indicators and gauges in SQL Server 2008 and walks you through designing a one tablix report with two levels of grouping.
Self Service SQL
Self service in IT is something Steve Jones likes, but it doesn't solve all problems, and might end up creating more issues.
Partial Backup and Restore
Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.
PASS Data Architecture VC presents Mike Fal on Eating the Elephant: SQL Server Table Partitioning
On Thursday May 17th 12PM noon Central, Mike Fal will discuss "SQL Server's table partitioning gives the DBA tools to manage this beast and support very large tables in a way where index management and data retrieval..."
A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
Amazon RDs and the PaaS formerly known as Azure
Phil Factor welcomes SQL Server support by Amazon RDS, as an alternative to having Microsoft as service provider as well as software provider, via the PaaS formerly known as Azure.
Is Software Engineering Dead?
Software engineering is seen as a dead end career choice, at least by some people. Steve Jones disagrees.
Snapshot Isolation Level in SQL Server - What, Why and How - Part 1
Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.
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