SQL Server Disaster Recovery Expo Coming this Friday, June 17th. Register for the Expo and gain access to the insights and experience of Eight renowned experts in SQL Server Disaster Recovery including, Kevin Kline, Sarah Barela, Alan Berry and others. There is a free track for all members. Additional content is available in a premium track for those wishing to […]

SelecTViews With Stephen Wynkoop Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] How to Remove Index Fragmentation Index fragmentation occurs when the contents of an index are not contiguous as it is stored […]

New SelecTViews Show Meredith Ryan Smith on the show today, plus the latest news for the database world. Also, what do fingers have to do with injection and SQL Server? Find out on the show… [Watch the Show] Also: Watch last week’s show here Index Defragmentation Indexes are one of the key components impacting the performance of a relational database. […]

Index Maintenance Yesterday I talked about SQL Server Indexes and how important it is to keep them from becoming fragmented in your database. Defragmenting clustered indexes cause all the data to be grouped contiguously on the disk. Defragmenting non-clustered indexes cause those indexes to also be located contiguously on the disk. So, in order to defragment both the data and […]

Filtered Indexes As you may or may not know there are two basic types of indexes available in SQL Server. Clustered and Non-Clustered. A table (or view) having a clustered index stores the data within the clustered index leaf nodes. A Non-Clustered index stores pointers to the location of the data within the clustered index, if one exists, or the […]

SelecTViews With Stephen Wynkoop Find out the latest news involving Red Gate, IBM’s Watson supercomputer, Office 365 and more. Stephen Wynkoop discusses the benefits of "big data". An interview with MaximumASP’s Sarah Barela delves into database forensics and best practices for tracking users. [Watch the Show] Lightswitch wrap up I received some interesting Email regarding Lightswitch. I think I can […]

Lightswitch – Where Does It Belong Some like it…some like it not. David C says: I have been using Lightswitch for over a month now and it is a great RAD tool. We are using it for an in-house admin tool to allow the BAs to edit metadata for our own code generation tool. It works great until you have […]

SelecTViews With Stephen Wynkoop and Sam Brace Find out the latest news involving NewsGator’s Social Sites 2010 software, HTML5 development and more. In the "In My Humble Opinion (IMHO)" section, MVP Stephen Wynkoop answers questions about server consolidation. And Sam Brace, community manager for SSWUG.ORG, has an extensive interview with MVP Kevin Kline about cutting costs in the cloud, particularly […]

How Will Mobile OS Change the Way We Do Business? Decades ago there was a dream of once again centralizing systems with clients running on hardware not much more intelligent than old Mainframe terminals. IT would have better control of applications because they would be executed from a central location such as Citrix or Unix. There was the dream of […]

Compensating for Bad Schema – Views Views are another tool used to compensate for a bad schema. I have been using the term Bad Schema for a couple days now…and want to qualify the statement. The same schema may be bad in one situation and not bad in a different one. In a reporting database you consistently find a highly […]