Home > Topics > Data > SQL Server

SQL Server


Buck WoodyCloud Computing Reference Architecture: Data Ingress and Storage Access
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.
Continue reading...
By Buck WoodyOct 24, 2012
Administering Storage, I/O, and Partitioning in Microsoft SQL Server 2012
This chapter focuses on the use and most effective configuration of storage components within a Database Engine instance of SQL Server 2012.
Continue reading...
By Ross MistrySep 27, 2012
Baya DewaldSynchronization with Microsoft SQL Server Analysis Services
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.
Continue reading...
By Baya DewaldFeb 21, 2012
Baya DewaldTransact-SQL Improvements with SQL Server 2008, Part 2
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.
Continue reading...
By Baya DewaldOct 4, 2011

See More SQL Server Articles


John  TraenkenschuhShould You Share Your Fitness Information?

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

Continue reading...
By John TraenkenschuhCommentsJanuary 26, 2014
Topics: Access,General Security and Privacy,BusinessObjects/Crystal Reports,SQL Server,DB2,Web Services,Storage,Networking,FileMaker,Information Management,Virtualization,Data,Security,Data Analytics and Visualization,Cloud Computing
John  TraenkenschuhIt was 20 years ago today: Data Migration Strategy II
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.

Continue reading...
By John TraenkenschuhCommentsDecember 26, 2013
Topics: Human Resources,MySQL,Software Security,Access,General Security and Privacy,SAP,Sales & Marketing,BusinessObjects/Crystal Reports,SQL Server,DB2,Information Management,Network Security,FileMaker,Information Management,Management & Strategy,Finance & Investing,Data,SQL,Global Business,General Business,Security,Data Analytics and Visualization,Personal Development,Business Applications,Oracle,Business & Management
Rachel BaylessInformIT's 17 Days of Giveaways

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!

Continue reading...
By Rachel BaylessCommentsJuly 3, 2012
Topics: Microsoft Certification,Other Applications,Graphic Programming,Six Sigma and Process Improvement,Upgrading & Repairing,Home & Office Computing,General Engineering & Hardware,Cisco Networking Academy,Software Security,Microsoft Servers,Access,Information Technology,Software Development & Management,SOA,Microsoft Windows 7,User Interface (UI),Programming,Dreamweaver & Flash,SQL Server,Java,Open Source,Web Services,Graphics & Web Design,Storage,Networking,Windows Programming,Eclipse,Network Security,Wireless/High Speed/Optical,Engineering,Cisco Certification,Microsoft Windows Vista & Home Server,C/C++,Other IT,Web Development,Routing & Switching,Certification,Web Services/ XML/ SOA/ WebSphere/ WCF,Data,Security,Hardware,Linux/UNIX/Open Source,Communications Engineering,Other Networking,CompTIA,Semiconductor Technologies,Microsoft Applications,Other Non-Technical,MAC OS X/Other,Operating Systems, Server,Process Improvement,Voice/IP Communications,Business & Management
Buck WoodyCareful with those NULLs

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

Continue reading...
By Buck WoodyCommentsOctober 13, 2010
Topics: SQL Server,Data

See More SQL Server Blogs