SQL Server 2012 Released Microsoft announced the release of SQL Server 2012.What’s in it? How to I get up to speed with this Release? Check out the link for more information. Microsoft Says, Customers can download the latest version of SQL Server 2012 here . Also, for a deep dive on all things SQL Server 2012, check out the SQL […]

Feedback – Getting Index Definitions Today I share two comments regarding the issue of finding included columns in an index, not readily displayed using system tools such as sp_helpIndex. Chris provides some fixes to the code I sent as a sample on Friday. James demonstrates getting include columns using SQL Server Management Studio. Chris: I don’t know if you pasted […]

Get Index Definition with Include Column List One of my favorite features added to SQL server was the ability to create indexes and have additional columns included in the index, not participating in the key values. This capability increases the capability of creating useful covering indexes. Because you can include columns not participating in the key of the index, you […]

JavaScript Coding Standards Today David writes in with his typical amount of detail. He responds to our recent topic of Naming standards with a focus on JavaScript that I find quite useful. Even if you don’t agree with everything here, I’m sure you can see some thought placed around David’s constraints far beyond personal preference. Each technique has a benefit. […]

$$SWYNK$$ Featured Article(s) Troubleshooting problems with SQL Server 2008 R2 alerts In this article, Alexander Chigrik explains some problems you can have with SQL Server 2008 R2 alerts. He also tells how you can resolve these problems. Featured White Paper(s) Demystify Tempdb Performance and Management In this white paper, Robert L Davis demystifies the best practices that work some of […]

Featured White Paper(s) Encryption & Key Management for Microsoft SQL Server 2008 Written by Townsend Security Simplify encryption and key management on … (read more) Featured Script convert_ident_to_guid.sql Script to find all ident columns in db, find out if they are in an index, (if so)drop the index, recreate the ident as guid, … (read more) Modern Documentation We had […]

Modern Modeling Strategies One current software development trend is to allow code to model as much as possible. Agile shops are the best examples of this strategy. As a result, many times a team can go to the complete extreme of not producing any models such as Class Diagrams or Database Diagrams. IMHO, these two concepts are not mutually exclusive. […]

Reader Comments Today I’m including more comments from our readers. Maurice shares his thoughts on Database Naming Conventions. William shares a new topic about the Activity Monitor interface inside Management Studio. Feel free to share your thoughts on these or other topics by sending an email to btaylor@sswug.org. Database Naming Conventions Maurice: What is the gain in adding a prefix […]