The SQL Rally (#sqlrally) voting as started, and I’ve got a session up for vote this week.
The SQL PASS organization has taken a different approach to session selection for the SQL Rally than they normally do for the annual summit. Instead of a full program committee which selects sessions then announces them, they are leaving the session selection up to the community via a vote. This weeks voting is for the […]
My slide decks from #sqlsat62 in Tampa.
I gave two talks at the recent SQL Saturday 62 in Tampa, FL and I had a blast doing it. As promised I’ve posted them on Monday (it is still Monday my time, so that counts right)? Storage and Virtualization for the DBA (Pre-Con) Where should I be encrypting my data Thanks everyone for coming […]
How much cache to allocate for servers that host 500gb databases?
The short answer is as much as possible. The more exact answer is you typically can’t allocate cache to a specific LUN. You can usually carve up the total amount of cache into read and write cache. You want as much write cache as possible so that the database writes directly to the disk as […]
What are your opinions on using an iSCSI NAS for SQL Server storage?
You’ve really got two questions here. The first is if I like iSCSI for SQL, and the second is if I like NAS for SQL. NAS doesn’t support iSCSI as iSCSI is a SAN technology. iSCSI is just fine for SQL Server as long as the server and the storage are on the same subnet, […]