DeveloperBall
Steve Jones looks at the challenges of putting a team together of wildly different skill levels.
Declarative SQL: Using CHECK() & DEFAULT
SQL is unusual is that data is not passively stored. Instead you use declarative SQL to specify the rules that underlie the data and its integrity. When used properly, constraints can avoid having to provide a lot of logic elsewhere. CHECK() and DEFAULT can do a lot to ensure that your data is correct
Backup File Inventory
Are you using Ola Hallengren's Maintenance Solution? Here's a Python script that helps you keep track of your backup file inventory.
Crafting Your Resume
Today Steve Jones talks about how you can present yourself better within the confines of a resume.
Microsoft IT: A Case Study on “Hekaton” against RPM
I/O latch can cause session delays that impact application performance. This white paper describes the procedures and common I/O latch issues when migrating to Hekaton in SQL Server 2014. It also includes challenges that occurred during the migration and the performance analysis at different stages.
Create/write to an Excel 2007/2010 spreadsheet from an SSIS package
Excel spreadsheets are useful for distributing data generated by SQL Server. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.
The Market
This Friday Steve Jones asks about the market price for your skills. Do you know what it is?
Correct SQL Server TempDB Spills in Query Plans Caused by Outdated Statistics
Sergey Gigoyan looks at how to address the warning: Operator used tempdb to spill data during execution with spill level 1.
Design a Better SQL Server Pricing Model
Today we have a guest editorial from Andy Warren that talks about SQL Server the no one's favorite topic: licensing.
Microsoft Azure DocumentDB
Microsoft's DocumentDB is a late-entrant in the Document-oriented database field. However, it benefits from being designed from the start as a cloud service with a SQL-like language. It is intended for mobile and web applications. Its JSON document-notation is compatible with the integrated JavaScript language that drives its multi-document transaction processing via stored procedures, triggers and UDFs. Robert Sheldon investigates its SQL-like query language.
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
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...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers