Tag: Microsoft SQL Server

SQL 2012: Let’s Make a Date with DATEFROMPARTS and TRY_PARSE!

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.

Read More >

SQL 2012: Path to Easier Data Cleanup with Try_Convert

A 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.

Read More >

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

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

Read More >

Microsoft Assessment and Planning Toolkit

This post is to discuss the Microsoft Planning and Assessment (MAP) toolkit, which is a nice little tool with a few extremely useful features.

Read More >

SQL Server: High Availability and Disaster Recovery à la Carte!

n the business world, a good RDMS is one that can provide high availability (HA) options with minimal downtime and the 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. The most important factors to consider when choosing an edition are…

Read More >

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 databases. This Log Buffer Edition appeases their appetites. Enjoy!

Read More >

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

Some parts of the world are going through winter in swing while others are savoring summer (or suffering through it!). This variation in weather is beautifully in-sync with the variety of blog posts sprouting all over the web, especially regarding database technology. This mixed flavor of database blogs is captured once again by this Log Buffer Edition.

Read More >

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

Database bloggers are blowing their trumpets at full throttle, warming up the hearts of readers across the globe with cool tips, nifty tricks, and glimmering gems. This Log Buffer Edition picks those gems and offers them to you.

Read More >

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

Sharing knowledge not only is beneficial to others, but also enhances one’s own knowledge and broadens the spectrum. Blogging is all about sharing and this Log Buffer Edition brings together some great blog posts from around the database arena.

Read More >

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

With the rapid advancement in the database technologies, the legacy systems are either being upgraded or replaced. Or, in some cases, technologists are finding ways to support them in new ways, showing us the flexible nature of databases and the belief of professionals that the sky is the limit. For this Log Buffer Edition, we go even beyond.

Read More >
Page 18 of 51« First Page...10...1617181920...30...Last Page »