Click here to monitor SSC
A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
SQL Home
Phil Factor Automated Script-generation with Powershell and SMO
by Phil Factor | 03 February 2012 | Not rated yet
In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases, Phil Factor demonstrates how one can generate TSQL scripts for databases, selected database objects, or table contents from PowerShell and SMO. Read more...
Robert Sheldon Converting String Data to XML and XML to String Data
by Robert Sheldon | 01 February 2012 | Not rated yet
We all appreciate that, in general, XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, auch as... Read more...
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...
TITLE PUBLISHED RATING VOTES
 What's the Point of Using VARCHAR(n) Anymore? 30 January 2012 4 votes
 Confessions of a DBA: My worst mistake 23 January 2012 25 votes
 SQL Cop Review 19 January 2012 11 votes
 Great SQL Server Debates: Buffer Cache Hit Ratio 18 January 2012 46 votes
 Relational Databases and Solid State Memory: An Opportunity Squandered? 17 January 2012 32 votes
 Buck Woody's Cloud Howlers 17 January 2012 20 votes
 Close Those Loopholes: Lessons learned from Unit Testing T-SQL 09 January 2012 8 votes
 Tom LaRock's SQL Server Howlers 05 January 2012 59 votes
 Window Functions in SQL Server: Part 3: Questions of Performance 04 January 2012 25 votes
 Incorporating XML into your Database Objects 04 January 2012 17 votes
 Constraints and the Test-Driven Database 14 December 2011 25 votes
 Centralized management: Tips for Managing Backups on Multiple Servers 13 December 2011 5 votes
 SQL Test: Seeing Red Change to Green 13 December 2011 8 votes
 Administrating SQL Server Integration Services - Planning, Documenting and Troubleshooting 12 December 2011 49 votes
 Great SQL Server Debates: Lock Pages in Memory 12 December 2011 45 votes
 The XML Methods in SQL Server 08 December 2011 17 votes
 Backup Verification: Tips for Database Backup Testing 06 December 2011 16 votes
 Faster Restores: Best Practices to Increase Speed 02 December 2011 15 votes
 Grant Fritchey's SQL Server Howlers 30 November 2011 45 votes
 Window Functions in SQL Server: Part 2-The Frame 24 November 2011 39 votes
  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 (71 articles)
  SSIS (19 articles)

  Reporting Services (20 articles)

Insider Insights
 Read more...
  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 (71 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
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