(Sheeri K. Cabral) I was playing around with MySQL Workbench earlier in the week, and ran across the “clean up SQL” feature, which I thought was neat. Here’s a picture-based demonstration – you can click on the pictures to make them bigger, so they are more readable.
Author: SSWUG Research
Search SSIS packages for table/column references
(Nigel Rivett) A lot of companies now use TFS or some other system and keep all their packages in a single project. This means that a copy of all the packages will end up on your local disk.
Overcoming storage speed limitations with Memory-Optimized Tables for SQL Server
(Daniel Farina) Achieving mission critical performance is key for most businesses, but sometimes due to storage costs you just can’t afford it. Traditional databases were designed assuming that memory resources were expensive and were optimized for disk I/O.
ADO.NET: Manually creating and populating a DataGridView
(Ged Mead) In the posts in this series so far, I’ve used an artificially simple database for my examples. It contained only a single table and, to be honest, that data could have been more easily stored using a VB collection class. So in this post, I’m going to use a database that contains several
Virtual Reality in the .NET Framework, Part 1
(Eric Vogel) The promise of Virtual Reality (VR) for all has been made since the 90s. Back then VR was all the rage, and it appeared we’d all be hooked into virtual worlds in no time.
SQL Server: Quickly get row counts for tables, heaps, indexes, and partitions
(Ian Stirk) How do you quickly get a count of the number of rows in a table? This small utility will enable you to quickly get row counts for tables, heaps, indexes and partitions. It works with SQL Server 2005 and higher.
Intervals and Counts, Part 4
(Itzik Ben-Gan) This article is the fourth in a series about intervals and counts. The series focuses on temporal intervals representing entities such as sessions, phone calls, and chats; it describes how to handle tasks related to such intervals.
Oracle RAC on the Cloud, Part 2
(Marc Fielding) In part 1 of this series, we talked about some of the challenges of setting up Oracle RAC on a public cloud provider, and went on to order some VMs from provider Gandi, and finally configuring an NFS server for shared storage. In this post, we move on to configuring the RAC servers t
Dropping all your ODM model
(Brendan Tierney) This post is main a note to myself of a script to drop all my Oracle Data Miner models.
Same plan hash value different partition range
(Bobby Durrett) Today I saw two different plans with the same plan hash value but different numbers of partitions. So, the partition numbers must not factor into the plan hash value. So, you can’t count on the plan hash value to fully indicate whether two plans are the same.