Click here to monitor SSC
A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
SQL Home  >  SQL Training
Brad McGehee How to Document and Configure SQL Server Instance Settings
by Brad McGehee | 30 January 2012 |
Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why? Most likely, it is down to different configuration settings. There are around seventy of these settings and the DBA needs... Read more...
Benjamin Nevarez The SQL Server Query Optimizer
by Benjamin Nevarez | 03 August 2011 |  5 comments |
To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez explains the essentials, in a broad sweep through a complex subject, in an article taken from his new book 'Inside the... Read more...
Fabiano Amorim Questions about SQL Server Distribution Statistics
by Fabiano Amorim | 23 June 2011 |  6 comments |
Fabiano was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into... Read more...
Robert Sheldon Table Value Constructors in SQL Server 2008
by Robert Sheldon | 22 June 2011 |  8 comments |
Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. This has all sorts of uses. Users who are stuck with previous versions of SQL Server can play along, since Rob demonstrates that there have, for... Read more...
Alex Kuznetsov Yet Another SQL Strategy for Versioned Data
by Alex Kuznetsov | 22 June 2011 |  14 comments |
There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is never deleted, but merely superseded by a later version. Whilst this is conceptually simple, it has always made for complicated SQL for reporting... Read more...
Andrew Clarke SSMS: The Query Window Keyboard Shortcuts
by Andrew Clarke | 10 June 2011 |  16 comments |
Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations within SQL Server Management Studio that unlock the hidden magic that is available for editing and executing queries. Read more...
Robert Sheldon Subqueries in SQL Server
by Robert Sheldon | 26 May 2011 |  4 comments |
Subqueries and derived tables can add great versatility to SQL statements, cut down complexity, but can occasionally be a curse when their effect on performance is poorly understood. Surely everyone understands the various types of subqueries and how they are used?... Read more...
Troy Hunt The 10 Commandments of Good Source Control Management
by Troy Hunt | 23 May 2011 |  7 comments |
Simple-Talk generally doesn't re-publish anything from another site, but Troy's popular blog post on the Ten Commandments of Source Control was too good to miss. Here is Troy's updated version in the light of the readers' comments made when it was first published. Read more...
Phil Factor RegEx-Based Finding and Replacing of Text in SSMS
by Phil Factor | 14 January 2011 |  3 comments |
So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that would be much quicker and easier by using the built-in Regular-Expression-based Find/Replace functionality. It is understandable, since the syntax is odd and... Read more...
  Learn SQL Server (80 articles)
  SQL Training (9 articles)

  Database Administration (115 articles)
  T-SQL Programming (130 articles)

  Performance (34 articles)
  Backup and Recovery (25 articles)

  SQL Tools (72 articles)
  SSIS (19 articles)

  Reporting Services (20 articles)

  SQL Home

  Learn SQL Server (80 articles)

  SQL Training (9 articles)

  Database Administration (115 articles)

  T-SQL Programming (130 articles)

  Performance (34 articles)

  Backup and Recovery (25 articles)

  SQL Tools (72 articles)

  SSIS (19 articles)

  Reporting Services (20 articles)

Phil Factor
Automated Script-generation with Powershell and SMO
 In the first of a series of articles on automating the process of building, modifying and copying SQL Server... Read more...



 View the blog
Phil Factor Using XML to pass lists as parameters in SQL Server
 (Updated 14th Jan 2012, and again 26th Jan 2012)Every so often, the question comes up on forums of how to pass a...  Read more...


 View the blog
Beginning SQL Server 2005 Reporting Services Part 1
 Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide... Read more...

Ten Common Database Design Mistakes
 Database design and implementation is the cornerstone of any data centric project (read 99.9% of... Read more...

Reading and Writing Files in SQL Server using T-SQL
 SQL Server provides several "standard" techniques by which to read and write to files but, just... Read more...

Beginning SQL Server 2005 Reporting Services Part 2
 Continuing his in-depth tour of SQL Server 2005 Reporting Services, Steve Joubert demonstrates the most... Read more...

Creating CSV Files Using BCP and Stored Procedures
 Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing... Read more...

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk


Privacy policy | Terms and conditions | ©2005-2012 Red Gate Software
About | Site map | Become an author | Newsletters | Contact us