It seems hard to imagine that a presentation about a new IT application to the directors can go too well. Phil doesn't need to imagine- it happened to him. He winces at the memory.
I'm sure you all make changes to your schema over time adding columns to tables and occassionally dropping them. But were you aware that even though you drop a column from a table the space in the...
You are asked for the sa password for a SQL Server in order to perform a software upgrade. You, the DBA, don't know the password and it's not documented. Rodney Landrum provides a way out of this...
SQL Server Endpoints are database objects that define the ways and means that SQL Server 2005 communicates on the network. Any DBA working with SQL Server 2005 will soon need to become familiar with...
I love to go around junk shops and second hand bookshops looking for quirky second-hand books. It was whilst browsing through all the more dog-eared fiction (always a sign that the contents are...
András Belokosztolszki, Red Gate developer, shows how foreign key constraints can be disabled and re-enabled in order to simplify operations such as the bulk loading of data into related tables.