Red Gate Software announces DBA in Space competition winner
Find out who has been announced as the winner of Red Gate Software's DBA in Space competition.
Your Boss Is Your Customer
Today we have a guest editorial from Andy Warren. Andy talks about the relationship with your boss, and how you ought to view them as your customer.
Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot
Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot feature. I was however surprised at the next question “Can we update the database snapshot?”
Managing Data Dictionaries in DW and DSS Database Applications
Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.
Pride and Security
When an employee has pride in their company, they tend to do a better job, and Steve Jones says that extends to security.
SQL Server does not reclaim space used when inserts fail
SQL Server has an issue when an INSERT fails that includes LOB data, SQL Server allocates space for the insert but does not reclaim the space on the failure therefore taking up more space than necessary. This tip walks you through an example of this issue and ways to resolve it.
Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
The Connections Launch Event
SQLServerCentral will be hosting a track at the 2012 spring SQL Server Connections conference and we hope to see you there.
Virtualization and the existential angst of the DBA
Tony Davis reflects on the existential angst felt by the DBA separated from his or her hardware.
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