Deploying Databases to the Azure Cloud: an extended plea
Is there a sound technical reason why SQL Azure can't support extended properties?
2013-02-25
145 reads
Is there a sound technical reason why SQL Azure can't support extended properties?
2013-02-25
145 reads
It is late evening. Something is wrong with a database. You narrow down the possibilities, getting more frustrated and puzzled. Stay calm. Check the inputs systematically. No! The data going into that table is right, but when you then read it in the table, it's wrong. Why did I stop believing in the supernatural? Then it hits you. Every time it comes as a surprise. They're using triggers. (This editorial was originally published on Nov 10, 2008)
2013-02-19 (first published: 2008-11-10)
610 reads
It is easy to become overwhelmed by server symptoms (aka metrics), in the forlorn hope that the more we collect, the clearer a picture we'll assemble of what ails the server. We should, of course, be looking at the whole patient.
2013-02-04
125 reads
Tony Davis argues that the Standards and best practices exist to avoid being hacked, but implementing them requires time and investment and often there simply doesn't seem to be the will to do it.
2012-11-26
92 reads
Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?
2012-10-01
358 reads
Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…
2012-04-02
132 reads
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-05
265,042 reads
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-01
317 reads
In FULL recovery mode it is possible to do a point-in-time restore of a database. It is thankfully a rare event. Tony explains what's involved
2012-01-27
10,233 reads
Databases are unique in IT that they are singularly resistant to 'best practice' advice. Any such advice can never be anything other than a starting position for tests in your own environment.
2012-01-23
50 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers