Posts Categorized: SQL Server
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 !!!
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.
The Log Buffer Edition is one-stop joint to know about the latest blog entries regarding the database technologies like Oracle, MySQL, and SQL Server. Enjoy this Log Buffer #281.
Continuing on from my last post, I felt like cleaning up some more data and using more SQL Server 2012 features. I happened on DATEFROMPARTS on MSDN and felt like playing with it.
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.
This Log Buffer Edition is sparkling with fresh and budding blogs. This Log Buffer #280 is is encompassing Oracle, SQL Server and MySQL blogs. Please give your feedback in the comments. Enjoy
This post is to discuss the Microsoft Planning and Assessment (MAP) toolkit, which is nice little tool with a few extremely useful features.
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:
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.
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.