Home > Topics > Data > SQL Server

SQL Server

Articles

Buck Woody

Buck Woody, Senior Technical Specialist on Windows Azure at Microsoft, describes how to create a centralized, off-premises (cloud-based) data store that provides flexibility, security, consistency, and guards against vendor lock-in.

This chapter focuses on the use and most effective configuration of storage components within a Database Engine instance of SQL Server 2012.

Baya Dewald

Database administration expert Baya Dewald shows how built-in synchronization works and how it compares to other approaches for distributing the querying load across multiple hosts.

Baya Dewald

Baya Dewald concludes this two-part series on Transact-SQL by discussing functions for grouping and table-valued parameters for passing multiple data rows to a stored procedure.

See More SQL Server Articles

Blogs

John  Traenkenschuh

Whether using a Fitbit or Jawbone UP, many are recording their fitness information and sending the changes to the Cloud.  


John  Traenkenschuh

Is your information ready for the next 20 years?  Traenk gives more information on what you must understand when creating a Data Migration Strategy, something all organizations, businesses, and people must create.

Rachel Bayless

Get ready for a month full of giveaways. From July 9 through the end of the month, InformIT will be having 17 days of giveaways. Each week has a theme to make sure that there’s something YOU will be excited to win!

Buck Woody

Many folks (including me) use NULL values in their databases. There's actually a bit of controversy on even having them - but I don't fall on the side of never using the. But you do need to exercise some care...

See More SQL Server Blogs