Storage - A meeting of minds
Even if you are not an infrastructure guy a good grasp of storage basics will stand you in good stead
2012-07-16
5,295 reads
ssd
Relational Databases and Solid State Memory: An Opportunity Squandered?
The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully normalized database with no performance deficit. Now, with reliable SSDs falling in price, we can reap the benefits, instead of getting distracted by NOSQL with its doubtful compromise of 'eventual consistency'.
2012-02-10
3,356 reads
Solid State Disks and SQL Server
An interesting result from a recent test of SSDs in SQL Server by Wes Brown. A surprising discovery is important for anyone thinking about using SSDs to know.
2012-03-09 (first published: 2010-04-08)
35,717 reads
Flash
Flash. Flash Gordon. There have been a few "Flash"es in Steve Jones career, and the newest one looks interesting.
2009-05-06
117 reads
Flash
Flash. Flash Gordon. There have been a few "Flash"es in Steve Jones career, and the newest one looks interesting.
2009-05-05
911 reads
Flash
Flash. Flash Gordon. There have been a few "Flash"es in Steve Jones career, and the newest one looks interesting.
2009-05-05
839 reads
Flash
Flash. Flash Gordon. There have been a few "Flash"es in Steve Jones career, and the newest one looks interesting.
2009-05-05
867 reads
SSD, The Game Changer
I’ve often described SQL Server to people new to databases as a data pump. Just like a water pump, you have limited capacity to move water in or out of a system usually measured in gallons per hour. If you want to upgrade your pumping systems it can be...
2009-04-21
6,824 reads
RE: Query Analyzer - Licensing
Unlike SQL Server 7, SQL 2000 does not offer per-server licensing. SQL Server (2000) has 3 licensing modes. - Per Processor: Any number of clients/devices can connect WITHOUT the need for each client to have a CAL. Each CPU on the server would need to be licensed. - Server plus device CAL - Requires a […]
2003-12-13
1 reads
RE: DTS output from stored procedure to Excel
You're correct you will need to use dynamic sql to provide the column name. One other thing to consider, instead of outputting to an XLS file, output the data to a comma seperated file with a CSV extension. CSV files open up in Excel by default. Hope this helps Phill Carter -------------------- Colt 45 - […]
2003-11-20
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers