Posts Categorized: SQL Server

Log Buffer #283, A Carnival of the Vanities for DBAs

Besides of voices of Lata Mangeshkar, Rahat Fateh Ali Khan and Celine Dion, the thing which ticks my heart to no bound is the blogs written by various bloggers covering Oracle, SQL Server, and MySQL related technologies. This Log Buffer Edition is brimming with those chords in Log Buffer #283. Enjoy !!!

Log Buffer #282, A Carnival of the Vanities for DBAs

Blogging is the way to express an idea in an informal way by a person, who has either worked with it, or planning to work with it, or has seen it at work. In databases, ideas are the foundations of everything, and these Log Buffer Edition is presenting ideas from bloggers in Log Buffer #282.

SQL 2012: Path to easier data cleanup with Try_Convert

One new feature in SQL 2012 that I am very excited about is TRY_CONVERT which makes data conversion much easier. When you pair TRY_CONVERT with some Case statements you can easily pipe the inconvertible data to other columns which can then be reviewed and (hopefully) fixed prior to cutting over your data. I’ve mocked up a quick demo so you can see how powerful this new feature is.

SQL Server: High Availabilty & Disaster Recovery à la carte!

For the business world , a good RDMS is one that can provide high availability (HA) options with minimal downtime and cheapest licenses. Vendors, usually if not always, provide a set of HA features to satisfy different needs. Usually some of these features are reserved for higher-end editions: Enterprise, Datacenter, cluster or whatever named; of course, those editions are more expensive than their “inferior” counterparts. Most important factors on choosing an edition are:

Log Buffer #279, A Carnival of the Vanities for DBAs

In a typical organization, all work together to bring out a common good for the outside world. It’s interesting to see how all of these entities blog about technology, and there is more and more interest shown by managerial technologists about the database. This Log Buffer Edition appeases their appetites along with the others in Log Buffer #279.

Log Buffer #278, A Carnival of the Vanities for DBAs

Some parts of the world has winter in swing, while the others are savoring or suffering through summers. This variation in weathers is so in-sync with the variety of blog posts sprouting all over the web especially regarding the database technology. This mixed flavor of the database blogs has been captured by this Log Buffer Edition in its Log Buffer #278.

Page 5 of 36« First...34567...102030...Last »