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
147 reads
Tony Davis
- Interests: football, modern literature, real ale
Are Triggers a "Legacy" Feature?
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)
614 reads
DBA Hypochondria
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
128 reads
Password Insecurities
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
98 reads
Fragmentation Fear
Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?
2012-10-01
379 reads
Replace existing Database? JFDI!
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
139 reads
Data Compression Double Take
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
267,356 reads
Data Compression Double Take
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
325 reads
Stairway to Transaction Log Management in SQL Server, Level 5: Managing the Log in Full Recovery Mode
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,408 reads
Testing times
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
57 reads
Blogs
Comparing My Current Schema with a Backup with SQL Compare
By Steve Jones
A customer asked if they needed to restore a database from backup to compare...
Improving Our Conversations
By Brian Kelley
If we aren't having the same conversation, we aren't going to be heard. That's...
How Do You Pick Events in Extended Events?
A while back I wrote about using AI to explore why people are not...
Forums
create a table with data capture for next 3 years
Hello, I would like to build a table capturing data starting from 1st day...
Is GenAI Coming Faster Than You Think?
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Local Storage Options
Comments posted to this topic are about the item Local Storage Options
Question of the Day
Local Storage Options
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers