Home > Topics > Databases > SQL Server

SQL Server

Articles

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

Blogs

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,Databases,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,Databases
Buck WoodyThe true value of conferences

I recently returned from the "SQLBits" conference in York, England. I met a lot of folks that I've seen before at other conferences, but I also met a fair amount that had not been to a SQL Server conference before.

Continue reading...
By Buck WoodyCommentsOctober 5, 2010
Topics: SQL Server,Databases
Buck WoodyFinding Big Data

I get asked from time to time about locating "Big Data" - or large sets of data for an application.

Continue reading...
By Buck WoodyCommentsSeptember 16, 2010
Topics: SQL Server,Databases

See More SQL Server Blogs

We currently do not have any SQL Server related podcasts. Please check back later.