Home > Topics > Databases > SQL Server
SQL Server
Articles
Cloud 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
Synchronization 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
Transact-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
Blogs
InformIT's 17 Days of GiveawaysGet 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
Careful with those NULLsMany 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
The true value of conferencesI 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
Finding Big DataI 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
We currently do not have any SQL Server related podcasts. Please check back later.