Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.
2008-03-25 (first published: 2007-04-12)
9,940 reads
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
40 reads
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
31 reads
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
38 reads
With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.
2008-03-25
2,032 reads
ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.
2008-03-25
3,820 reads
Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.
2008-03-24 (first published: 2007-04-03)
10,151 reads
Entity-Attribute-Value model (EAV) is used interchangeably with name for name value pair. This article will try to address advantages and disadvantages of EAV modelling
2008-03-24
7,232 reads
Cracking open the default management packs in SCOM unlock a vast code library for custom automation and monitoring of SQL Server instances.
2008-03-24
7,175 reads
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
2008-03-24
32 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Thanks in advance for any clues on this. I am trying to write a...
Comments posted to this topic are about the item Backup to Immutable Storage
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers