Click here to monitor SSC
A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
SQL Home  >  Database Administration
Phil Factor Automated Script-generation with Powershell and SMO
by Phil Factor | 03 February 2012 |  2 comments |
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 |  1 comment |
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...
Rob Garrison What's the Point of Using VARCHAR(n) Anymore?
by Rob Garrison | 30 January 2012 |  13 comments |
The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a... Read more...
Phil Factor Confessions of a DBA: My worst mistake
by Phil Factor | 23 January 2012 |  13 comments |
Over the next few months, we'll be asking various well-known DBAs to describe their worst disaster caused by a mistake they made. To kick off the series, we asked Phil Factor to confess. He came up with a classic: The mistaken belief that a backup WITH CHECKSUM... Read more...
Jonathan Kehayias Great SQL Server Debates: Buffer Cache Hit Ratio
by Jonathan Kehayias | 18 January 2012 |  12 comments |
One of the more popular counters used by DBAs to monitor the performance, the Buffer Cache Hit Ratio, is useless as a predictor of imminent performance problems. Worse, it can be misleading. Jonathan Kehayias demonstrates this convincingly with some simple tests. Read more...
Robert Young Relational Databases and Solid State Memory: An Opportunity Squandered?
by Robert Young | 17 January 2012 |  34 comments |
The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully normalized database with no performance deficit. Now, with reliable SSDs falling in price, we can reap the benefits, instead of getting distracted... Read more...
Buck Woody Buck Woody's Cloud Howlers
by Buck Woody | 17 January 2012 |  8 comments |
We asked Buck Woody to come up with his favourite 'Cloud' Howlers. After 'Howler' monkeys, we are faced with Howler letters. Buck dreams of sending Howler letters to the folks who dreamed up the marketing hype around 'cloud' services, who misunderstand services, who... Read more...
Alex Kuznetsov Close Those Loopholes: Lessons learned from Unit Testing T-SQL
by Alex Kuznetsov | 09 January 2012 |  5 comments |
Alex has done some pioneering work on the testing of stored procedures over four years, and has learned a great deal in the process. In this article, he spells out the lessons learned from a wealth of experience in Unit Testing T-SQL. Read more...
Sam Bendayan Constraints and the Test-Driven Database
by Sam Bendayan | 14 December 2011 |  29 comments |
Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a defensive approach based on constraints to any team that is developing an application in which the data has to be exactly right, and where bad data could cause... Read more...
Feodor Georgiev Administrating SQL Server Integration Services - Planning, Documenting and Troubleshooting
by Feodor Georgiev | 12 December 2011 |  3 comments |
SQL Server Integration Services is an essential component of SQL Server, and designed to perform a variety of routine and occasional tasks. It majors on ETL tasks and for administrative jobs across servers. The DBA needs also to be aware of their role in optimising... Read more...
Jonathan Kehayias Great SQL Server Debates: Lock Pages in Memory
by Jonathan Kehayias | 12 December 2011 |  24 comments |
There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default... Read more...
Grant Fritchey Grant Fritchey's SQL Server Howlers
by Grant Fritchey | 30 November 2011 |  17 comments |
We decided to ask various well-known SQL Server people to write about their favourite SQL Server Howlers. These are the common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions. Grant Fritchey opens the series with some of... Read more...
Greg Larsen SQL Server Database Growth and Autogrowth Settings
by Greg Larsen | 23 November 2011 |  18 comments |
It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future. Why? What do I do about it? Read on! Read more...
Grant Fritchey 7 Preventable Backup Errors
by Grant Fritchey | 31 October 2011 |  6 comments |
The loss of a company's data is often enough to put the company out of business; and yet backup errors are generally avoidable with the application of common sense rather than deep technical knowledge. Grant digs into memories of his long experience of giving forum... Read more...
Laerte Junior Create a Monitoring Server for SQL Server with PowerShell
by Laerte Junior | 21 October 2011 |
At some point, you are going to need a notification system for a range of events that occur in your servers, even if it is only a warning of low disk space. Laerte shows how you can even set up temporary or permanent alerts for any WMI events to give you a system... Read more...
Grant Fritchey Auditing DDL Changes in SQL Server databases
by Grant Fritchey | 12 October 2011 |  7 comments |
Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the changes being made to a database and put those into Source Control, in order to track what changed and when. You can even get an email alert when... Read more...
Brad McGehee Database Properties Health Check
by Brad McGehee | 13 September 2011 |  9 comments |
Within an instance of SQL Server, the database settings can have a direct effect on the database’s behavior, performance and availability. Sometimes, it is difficult to tie a symptom to a cause, so it is wise to routinely check and record these settings. Before you... Read more...
Fabiano Amorim Statistics on Ascending Columns
by Fabiano Amorim | 01 September 2011 |  12 comments |
It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an ascending primary key with most querying on the latest records, can throw the judgement of the Query Optimiser to the extent that perfomance nose-dives. Fabiano... Read more...
Grant Fritchey Preventing Problems in SQL Server
by Grant Fritchey | 15 August 2011 |  6 comments |
It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and... Read more...
Laerte Junior Using PowerShell and WMI Events Queries for Powerful Notifications
by Laerte Junior | 25 July 2011 |  7 comments |
With PowerShell in one hand, and WMI in the other, DBAs can do almost anything in their Window's environments, and Laerte is using his powers for good. He built a highly precise, highly configurable alerting system for his servers, and now shows us exactly how he... Read more...
Glenn Berry Configuring the Storage Subsystem
by Glenn Berry | 20 July 2011 |  2 comments |
The storage subsystem for a SQL Server can prove to be a bottleneck if the best choices of hardware aren't made, but there are ways to relieve the I/O bottlenecks if the causes are well understood. This requires benchmarking. Glenn Berry gives expert advice on... Read more...
Joe Celko Arrays in SQL that Avoid Repeated Groups
by Joe Celko | 05 July 2011 |  5 comments |
It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would be the best design. Most often, the wish for an array in SQL is a sign of a forlorn struggle against poorly-normalised data. One of the worst sins against Codd is the... Read more...
Grant Fritchey SQL Backup Pro for the Accidental DBA
by Grant Fritchey | 10 June 2011 |
If you've suddenly found yourself responsible for maintaining and backing up your company's servers, you're an 'accidental DBA'. If you've been dropped in the deep end, let Grant Fritchey show you through the backup and restore functionality of Red Gate's SQL Backup... Read more...
Grant Fritchey SQL Server Backup and Restore for the Accidental DBA
by Grant Fritchey | 24 May 2011 |  7 comments |
Not everyone who is tasked with the job of ensuring that databases are backed up, and easily restorable, consider themselves to be database administrators. If you are one of these 'Accidental DBAs' then Grant Fritchey has some good straightforward advice for you to... Read more...
Grant Fritchey It's 3AM and I'm on call
by Grant Fritchey | 27 April 2011 |  7 comments |
If you are part of a team that is required to ensure that an application stays running at all hours, then you're likely to experience that 3AM-callout feeling. Grant knows all too well what is required, and gives hard-won advice on the best way of keeping on top of... Read more...
Grant Fritchey Performing DBCC Checks Using SQL Virtual Restore
by Grant Fritchey | 07 April 2011 |  5 comments |
Ever restored a corrupted database from the backup, only to find that the backups are corrupted too - All the backups? Sure it can happen and it isn't nice when it does. To check that a database backup is internally consistent you have to use DBCC CheckDB. On a huge... Read more...
Feodor Georgiev Database Documentation - Lands of Trolls: Why and How?
by Feodor Georgiev | 07 April 2011 |  4 comments |
When database documentation is mentioned in an IT Department, everybody nods wisely, yet everyone does their best to avoid doing it. Attention to the database documentation can be the best invertment in time a development group can make. It is essential, and no... Read more...
Mike Mooney Simple Database Backups With SQL Azure
by Mike Mooney | 17 March 2011 |
SQL Azure can take away a great deal of the maintenance work from a hosted database-driven website. It isn't perfect, however, in that it doesn't support the archiving of data by the users. Mike Mooney explains how he customised the solution with SQL Compare and... Read more...
Grant Fritchey SQL Strategies for 'Versioned' Data
by Grant Fritchey | 17 March 2011 |  13 comments |
If you keep your data according to its version number, but need to work only with a particular version, what is the best SQL for the job? Which one works best? Which one do you use and when? Read more...
Hugo Shebbeare The Polyglot of Databases: How Knowledge of MySQL and Oracle Can Give SQL Server DBAs an Advantage
by Hugo Shebbeare | 14 March 2011 |  2 comments |
Although switching between different RDBMSs can be the cause of some culture shock for the Database Administrator,it can have its advantages. In fact, it can help you to broaden your perspective of relational databases, refine your problem-solving skills and give... Read more...
Brad McGehee Correlating SQL Server Profiler with Performance Monitor
by Brad McGehee | 16 February 2011 |  2 comments |
Both Performance Monitor and SQL Server Profiler provide valuable information about your server. However, if you combine the data from the two sources, then this correlated information can help find some of the subtler bugs. Brad explains how. Read more...
Timothy Ford Investigating Transactions Using Dynamic Management Objects
by Timothy Ford | 30 September 2010 |  3 comments |
There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When you hit performance problems in a database under load, and there is excessive locking and blocking, how can you determine... Read more...
Rod Colledge Policy-based Management and Central Management Servers
by Rod Colledge | 30 September 2010 |  5 comments |
Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that... Read more...
Brad McGehee Rebuilding Indexes using the SSMS Database Maintenance Wizard
by Brad McGehee | 18 August 2010 |  3 comments |
Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity... Read more...
Greg Larsen Creative Solutions by Using a Number Table
by Greg Larsen | 03 August 2010 |  12 comments |
One irritating thing for the occasional SQL Server Developer is that the experts assume that you are familiar with the use of number tables when they write about techniques. We therefore asked Greg Larsen to spell it out in a way that would help the beginner and... Read more...
Brad McGehee Automate and Improve Your Database Maintenance Using Ola Hallengren's Free Script
by Brad McGehee | 20 July 2010 |  8 comments |
If you ever feel uneasy when you set about handcrafting database maintenance jobs for SQL Server, it may be the voice of your conscience saying 'Ola, Ola!'. Follow your conscience. Ola Hallengren has already crafted a superb set of routines to do this for you. Why... Read more...
Laerte Junior Gathering Perfmon Data with Powershell
by Laerte Junior | 08 July 2010 |  23 comments |
When you have to routinely collect data from Performance Monitor Counters, it soon becomes easier and more convenient to use PowerShell. SQL Server MVP Laerte Junior was inspired to create a script, and guides us through its useful functions. Read more...
Laerte Junior I'm a SQL Server DBA, and I'm in Love with PowerShell
by Laerte Junior | 28 May 2010 |  23 comments |
To learn PowerShell, Laerte suggests that you just start using it. To encourage you to start, he provides a series of tips on using PowerShell with SQL Server to solve various everyday problems. With a little patience, a good IDE, and a bit of help and advice,... Read more...
Buck Woody Mission Critical: SQL Server General Configuration
by Buck Woody | 24 May 2010 |
You know how to set up a SQL Server instance, but it is great to have a list of all the necessary checks and procedures: even better is to have the link to in-depth explanations for every stage by the renowned SQL Server Expert Buck Woody. Read more...
Thomas LaRock Statistical Sampling for Verifying Database Backups
by Thomas LaRock | 13 May 2010 |  8 comments |
A DBA's huge workload can start to threaten best practices for data backup and recovery, but ingenuity, and an eye for a good tactic, can usually find a way. For Tom, the revelation about a solution came from eating crabs. Statistical sampling can be brought to... Read more...
Buck Woody Mission Critical: SQL Server Upgrade
by Buck Woody | 13 April 2010 |  2 comments |
You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist. Read more...
Buck Woody Mission Critical: Engine Pre-Installation
by Buck Woody | 31 March 2010 |  2 comments |
Even with a task you're entirely familiar with, it is always great to have a checklist to make sure it is all done. No? Have you never forgotten your car-keys? Read more...
Buck Woody Mission Critical: Database Design
by Buck Woody | 18 March 2010 |  4 comments |
There is nothing like a checklist to make sure you've completed all the tasks in designing a database, and there is absolutely nothing like Buck Woody's military-style Critical Task List Read more...
John Magnabosco Transparent Data Encryption
by John Magnabosco | 16 March 2010 |  4 comments |
Transparent Data Encryption is designed to protect data by encrypting the physical files of the database, rather than the data itself. Its main purpose is to prevent unauthorized access to the data by restoring the files to another server. With Transparent Data... Read more...
Rod Colledge Planning for Disaster
by Rod Colledge | 16 March 2010 |  5 comments |
There is a certain paradox in being advised to expect the unexpected, but the DBA must plan and prepare in advance to protect their organisation's data assets in the event of an unexpected crisis, and return them to normal operating conditions. To minimise downtime... Read more...
Buck Woody Mission Critical: SQL Server 2008 Engine Post-Installation
by Buck Woody | 03 March 2010 |  8 comments |
Even an experienced DBA finds it safer to double-check that all the tasks have been done, and in the right order. Buck Woody continues his series with another handy checklist, army-style. Read more...
Buck Woody Mission Critical: SQL Server 2008 General Maintenance
by Buck Woody | 15 February 2010 |  5 comments |
There is nothing that beats a simple checklist for ensuring that things don't get forgotten in the Database Maintenance process. Once again, Buck Woody imagines how the US military would have tackled DBA checklists for 'mission-critical' databases. Read more...
Laerte Junior Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation
by Laerte Junior | 11 February 2010 |  22 comments |
In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL... Read more...
Buck Woody Mission Critical: SQL Server 2008 Performance Tuning Task List
by Buck Woody | 04 February 2010 |  2 comments |
In which Buck Woody imagines how the US military would have tackled DBA checklists for 'mission-critical' databases. And having imagined it, lo, it came to be. The CTL for the DBA with short-back-and-sides. Read more...
Laerte Junior Exceptional PowerShell DBA Pt 2 - The Morning Checklist
by Laerte Junior | 21 January 2010 |  26 comments |
Laerte Junior takes us further into the world of an Exceptional PowerShell DBA, showing us how he uses PowerShell 2.0 to take all the headaches out of even more of his daily checklist. What could be better than having your morning checklist run itself? Read more...
Rodney Landrum Managing Data Growth in SQL Server
by Rodney Landrum | 21 January 2010 |  3 comments |
'Help, my database ate my disk drives!'. Many DBAs spend most of their time dealing with variations of the problem of database processes consuming too much disk space. This happens because of errors such as incorrect configurations for recovery models, data... Read more...
Brad McGehee Brad's Sure DBA Checklist
by Brad McGehee | 20 January 2010 |  33 comments |
Sometimes, all a DBA needs, to help with day-to-day work, is a checklist of best-practices and dos and don’ts. It provides a handy reminder. Brad has come up with a new update to his famous checklist Read more...
Brad McGehee Database Maintenance Plans in SSMS: An Overview
by Brad McGehee | 06 January 2010 |  4 comments |
Maintenance plans are essential. Microsoft provide two tools, the Maintenance Plan Wizard and the Maintenance Plan designer, to assist the busy DBA to get started with one, but they don't include all the likely tasks, so Custom-created T-SQL or PowerShell scripts... Read more...
Thomas LaRock Monitoring SQL Server Virtual Log File Fragmentation
by Thomas LaRock | 06 January 2010 |  11 comments |
One of the delights of PASS is to be able to pick up ideas from some of the presentations and recombine them in new and interesting ways. Tom recounts how he used two different insights to solve a problem of monitoring a large number of servers for signs of Virtual... Read more...
Robert Sheldon Working with the bcp Command-line Utility
by Robert Sheldon | 10 December 2009 |  13 comments |
Even though there are many other ways to get data into a database, nothing works quite as fast as BCP, once it is set up with the right parameters and format file. Despite its usefulness, the art of using the command-line utility has always seemed more magic than... Read more...
Laerte Junior Exceptional PowerShell DBA Pt1 - Orphaned Users
by Laerte Junior | 26 November 2009 |  30 comments |
Inspired by Brad McGehee's 'How to Become an Exceptional DBA', Laerte decided it was high time he took a proactive approach to his work. Using PowerShell, he came up with a solution that makes finding and fixing orphaned users as easy as cake, and now he's sharing... Read more...
Rodney Landrum Eating SQL Server Installations for Breakfast
by Rodney Landrum | 24 November 2009 |
Here you will find wholesome SQL Server installations on the menu, complete with Express, Continental and Deluxe breakfast choices, depending on your application’s appetite. This is the article where your new SQL Server installation is completely yours, having not... Read more...
Bob Cramblitt Exceptional DBA Josef Richberg: fighting cancer, but still sharing
by Bob Cramblitt | 10 November 2009 |
Josef Richberg is an exceptional person: The Judges of the Exceptional DBA Award were quickly proved right in their decision to choose him, when he subsequently showed extraordinary resilience and determination in the face of an unexpected diagnosis of cancer. His... Read more...
John Magnabosco Obfuscating your SQL Server Data
by John Magnabosco | 21 October 2009 |  1 comment |
If you are required to use real production data to test applications, any sensitive data should be "disguised" before loading it into the development environment. Although there are tools to generate convincing test data, it occasionally happens that the variances... Read more...
Anith Sen Five Simple Database Design Errors You Should Avoid
by Anith Sen | 16 October 2009 |  21 comments |
Anith follows up his highly successful article Facts and Fallacies about First Normal Form with a fascinating discussion of five common database design errors which persist in spite of the fact that the unfortunate consequences of their use is so widely known. It... Read more...
Rodney Landrum Finding Data Corruption
by Rodney Landrum | 29 September 2009 |  7 comments |
In this article, taken from Chapter 8 of his new book, SQL Server Tacklebox, Rodney describes how a working DBA goes about troubleshooting data corruption. He demonstrates the tools and scripts required to seek out and fix data corruption in a timely manner, and so... Read more...
John Magnabosco Honeycombing a Database
by John Magnabosco | 16 September 2009 |  5 comments |
In this article, taken from Chapter 9 of his new book, Protecting SQL Server Data, John describes how to set a "honey trap" for would-be data thieves, allowing the DBA to identify the precursors of an attack and respond quickly and also to better understand the... Read more...
Thomas LaRock SQL Server Consolidation
by Thomas LaRock | 04 September 2009 |  5 comments |
In the crusade to cut expenses, Data Centres (and IT Infrastructure) are now coming under scrutiny as a possible source of savings. Half-informed executives now rally behind the cry of "Virtualization!", but virtualization is only part of the story - The tip of the... Read more...
Brad McGehee A Code of Conduct for DBAs
by Brad McGehee | 03 September 2009 |  8 comments |
Despite the fact DBAs are protectors of an organization’s knowledge, and privy to much confidential information, there is no clearly defined set of rules and standards to help govern and guide their ethical conduct. Brad McGehee, in an article based on a chapter... Read more...
Timothy Wiseman Python for the SQL Server DBA
by Timothy Wiseman | 27 August 2009 |  11 comments |
Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find it easy to learn, powerful, and reasonably intuitive. Here Timothy Wiseman, a working DBA, explains the attraction of Python... Read more...
Rodney Landrum SQL Server Tacklebox Free eBook
by Rodney Landrum | 04 August 2009 |  2 comments |
As a DBA, how well-prepared are you to tackle issues such as backup failure due to lack of disk space, or locking and blocking that is preventing critical business processes from running, or data corruption due to a power failure in the disk subsystem? If you have... Read more...
Robert Sheldon Defragmenting Indexes in SQL Server 2005 and 2008
by Robert Sheldon | 31 July 2009 |  4 comments |
Rob Sheldon tackles the subject of Index Defragmentation in SQL Server 2005 and 2008, using the sys.dm_db_index_physical_stats system function. He shows how to analyze indexes and, if necessary, how to go about reorganizing or rebuilding indexes. He makes the point... Read more...
Rodney Landrum The DBA as Detective: Troubleshooting Locking and Blocking
by Rodney Landrum | 31 July 2009 |  17 comments |
In this article, taken from Chapter 5 of his great new book, SQL Server Tacklebox, Rodney describes in his own unique style how he, as a working DBA, goes about troubleshooting problem queries, and investigating various types of locking and blocking problems. In... Read more...
Brad McGehee Do Not Forget to Maintain Your Indexes
by Brad McGehee | 09 July 2009 |  1 comment |
Index Maintenance Plans are essential for the well-being of a database. However, there is more to the process than just the use of the wizard. Brad McGehee takes this one stage further in suggesting that, instead, you should create your own index maintenance tasks... Read more...
Brad McGehee Brad's Sure Guide to Indexes
by Brad McGehee | 11 June 2009 |  18 comments |
In order to best appreciate the reasons for, or importance of, the various administrative tasks that are needed for indexes, it is a good idea to take a look at how the various types of indexes work. Who better to help with a clear expanation for this than Brad McGehee? Read more...
Thomas LaRock SQL Server Audit: Magic without a Wizard
by Thomas LaRock | 27 April 2009 |  8 comments |
In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or the most highly-regulated of industries. SQL Server 2008 Enterprise Edition includes all of the... Read more...
Allen White Let PowerShell do an Inventory of your Servers
by Allen White | 13 February 2009 |  19 comments |
If you run a regular and comprehensive inventory of all the servers you manage, you can solve problems more quickly and answer most questions from management. If you then repeat these reports over a time period, it helps to to track trends such as disk space usage... Read more...
Alex Kozak Estimating Disk Space Requirements for Databases
by Alex Kozak | 16 January 2009 |
In the first of a series of Database Maintenance Tips and Tricks, Alex Kozak discusses some general issues surrounding disk space requirements for SQL Server databases and shows how to estimate Disk space usage and requirements. He gives tips on using DBCC CHECKDB... Read more...
Thomas LaRock Monitor your Database Backups Using Operations Manager
by Thomas LaRock | 02 December 2008 |  8 comments |
Thomas LaRock shows just how easy it is for a DBAs to monitor any aspect of the databases in their charge by using Operations Manager, just as long as they are prepared to spit on their hands and do some coding. As he says, 'The possibilities are endless'. Read more...
Rodney Landrum The DBA Script Thumb
by Rodney Landrum | 10 November 2008 |  32 comments |
Like many DBAs, Rodney has squirrelled away a large number of routines that he uses almost daily to check on his servers and databases. Of this large collection he chooses five that he wouldn't want to be without. and there is something for everyone in this DBA's... Read more...
Francis Hanlon On the Trail of the Expanding Databases
by Francis Hanlon | 11 October 2008 |  8 comments |
It is sometimes difficult for other IT people to understand the constraints that DBAs have to work under. So often the ideal or obvious solution is frustratingly out of reach because of 'political' reasons that seem baffling to the spectator. Francis Hanlon... Read more...
Ron Dameron Why This SQL Server DBA is Learning Powershell
by Ron Dameron | 30 September 2008 |  8 comments |
Ron describes how he decided to study Powershell as a single scripting system to automate all the common repetitive server tasks. He concludes that time spent learning PowerShell is time well spent, and that it can help a great deal in understanding the .NET... Read more...
Brad McGehee Policy-Based Management
by Brad McGehee | 26 August 2008 |  4 comments |
Every DBA knows the frustration of trying to manage tens of servers, each of which has a subtly different configuration. Policy-based management, now introduced in SQL Server 2008, could ease a lot of this pain. Brad McGehee explains.... Read more...
Rodney Landrum SQL Server eBook Download - SQL Server Tacklebox
by Rodney Landrum | 05 August 2008 |  8 comments |
The SQL Server Tacklebox contains a collection of practical tools and techniques to automate and standardize SQL Server installation, document and report on servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of... Read more...
Randy Volters DML Trigger Status Alerts
by Randy Volters | 04 July 2008 |  21 comments |
When databases suddenly stop working, it can be for a number of different reasons. Human error plays a large part, of course, and the DBA needs to know what these various humans are up to. DDL triggers can help alert the DBA to unauthorized tampering with a... Read more...
Alexander Karmanov Deploying Database Developments
by Alexander Karmanov | 17 June 2008 |  28 comments |
When a team is developing a database application, it is a mistake to believe that deployment is a simple task. It isn’t. It has to be planned, and scripted. Alexander Karmanov describes many of the problems you’re likely to meet, and provides an example solution... Read more...
Brad McGehee Professional Certification for DBAs
by Brad McGehee | 16 June 2008 |  33 comments |
In this article, republished from Brad McGehee's book 'How to Become an Exceptional DBA', Brad explains why there are several advantages for DBAs in continuing to take exams throughout their careers. Read more...
Shawn McGehee SQL Server Tracing: An Automated and Centralized Solution
by Shawn McGehee | 14 March 2008 |  9 comments |
When you are trying to pin down the cause of a problem with a SQL Server, there is probably going to come a time when you need to get 'trace' information. If you've ever done that, you'll know how easy it is to get overwhelmed by the detail. Here, Shawn McGehee... Read more...
Robyn Page and Phil Factor SQL Server Alerts: Soup to Nuts
by Robyn Page and Phil Factor | 19 February 2008 |  22 comments |
In which Robyn Page and Phil Factor try to get to grips with the difficult subject of SQL Server Alerting, and give you enough detail to put effective alerting systems into your database. Read more...
Rodney Landrum Doing Eighty Things at Once
by Rodney Landrum | 25 January 2008 |  3 comments |
Rodney Landrum is a SQL Server DBA for a large company, with at least eighty SQL Servers to look after. He is now a great fan of SQL Multiscript and explains why ... Read more...
William Brewer The Science of Compliance
by William Brewer | 02 October 2007 |  5 comments |
'William Brewer takes a look at what is involved with IT 'Compliance', and discusses what SOX compliance means for the DBA and IT Application developer.' Read more...
Timothy Ford Greetings from the Alpaca Mill
by Timothy Ford | 06 September 2007 |  4 comments |
Timothy Ford fails to make the leap from his cubicle to the Alpaca farm, due to the help, sympathy and advice from Simple-Talk's readers Read more...
Rodney Landrum Changing Service Credentials
by Rodney Landrum | 05 September 2007 |  5 comments |
One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution. Read more...
Simon Sabin What Specification Server Should I Buy?
by Simon Sabin | 13 August 2007 |  5 comments |
Simon Sabin explains why he is always cagey about giving advice on the sort of hardware to run SQL Server on, but admits to some general rules. Read more...
Timothy Ford Do Alpacas Dream of farming DBAs?
by Timothy Ford | 13 August 2007 |  36 comments |
When IT starts to stand for 'Implement This', even the keenest DBA begins to dream of farming Alpacas as a career-change. ...and we ask our readers how they would have solved the DBA's dilemma. Read more...
Ron Dameron Comparing Python and PowerShell DBA Scripting
by Ron Dameron | 03 August 2007 |  15 comments |
Just when it seemed that there were were no adequate scripting systems for DBAs that could access .NET, along came two. Powershell and Python. Read more...
William Brewer SQL Server Endpoints: Soup to Nuts
by William Brewer | 06 July 2007 |  8 comments |
SQL Server Endpoints are database objects that define the ways and means that SQL Server 2005 communicates on the network. Any DBA working with SQL Server 2005 will soon need to become familiar with them, particularly if using SOAP, Service Broker or Database Mirroring. Read more...
András Belokosztolszki Foreign Keys and their States
by András Belokosztolszki | 22 June 2007 |  9 comments |
András Belokosztolszki, Red Gate developer, shows how foreign key constraints can be disabled and re-enabled in order to simplify operations such as the bulk loading of data into related tables Read more...
William Brewer Database High-Availability: Soup to Nuts
by William Brewer | 31 May 2007 |
William Brewer argues that, although there are technologies around that will minimise downtime in most circumstances, they are only part of the solution. At the heart of every robust system, there is planning, documentation, scripting, testing and drill. Read more...
András Belokosztolszki Source Control and Databases
by András Belokosztolszki | 29 May 2007 |  28 comments |
András's article on Source Control shows a lot of the thinking amongst the developers at Red Gate at that time that eventually crystallized into SQL Source Control. It identified several problems that had to be overcome before the task could be done properly.... Read more...
Robyn Page and Phil Factor SQL Server Replication Crib Sheet
by Robyn Page and Phil Factor | 14 May 2007 |  14 comments |
Robyn Page and Phil Factor delve into all the things you need to know, rather than want to know, about SQL Server replication. Read more...
Nigel Rivett Partitioned Tables in SQL Server 2005
by Nigel Rivett | 16 April 2007 |  42 comments |
Nigel Rivett provides an in-depth, practical examination of how to create and manipulate partitioned tables and indexes in SQL 2005. Read more...
Doug Burns What use is a Development DBA?
by Doug Burns | 12 April 2007 |  20 comments |
"I can't help thinking that unless you have a good DBA on a development team and use him or her as a consultant on all database matters, we're all losing out. I end up having work thrown at me that I could teach a trainee to do, which is a waste of my talents, and... Read more...
Dan Sullivan PowerSMO at Work Part 2
by Dan Sullivan | 12 March 2007 |
In part 3 of Dan Sullivan's in-depth exploration of PowerSMO, the versatile command line utility for managing SQL Server databases, he describes how to control the identity that SMO uses to login to SQL Server, how to set up Server activity monitoring, and how to... Read more...
Louis Davidson Ten Common Database Design Mistakes
by Louis Davidson | 26 February 2007 |  52 comments |
Database design and implementation is the cornerstone of any data centric project (read 99.9% of business applications), and yet too often the design phase is rushed through in order to start "getting things done" as quickly as possible. Consequently proper... Read more...
Arthur Fuller Database Design: A Point in Time Architecture
by Arthur Fuller | 22 February 2007 |  43 comments |
In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller... Read more...
Robyn Page SQL Server Security Cribsheet
by Robyn Page | 20 February 2007 |  29 comments |
If you've ever had brain meltdown trying to understand SQL Server users, roles, permissions, logins etc. then Robyn Page's security cribsheet might be just be your Panacea. Read more...
Dan Sullivan PowerSMO At Work Part I: DBA Scripts and Functions
by Dan Sullivan | 19 February 2007 |  3 comments |
Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy, he provides a step-by-step guide to creating and deploying secure, signed DBA scripts. He then describes how to use PowerSMO... Read more...
Pop Rivett Pop Rivett and the Uncontrolled Release
by Pop Rivett | 15 February 2007 |  4 comments |
Pop Rivett offers a hard lesson in the dangers of an uncontrolled software release. Read more...
Dan Sullivan Managing SQL Server using PowerSMO
by Dan Sullivan | 31 January 2007 |  8 comments |
Most DBAs don't have time to perform routine processes manually. Everything has to be scripted, automated and scheduled. Here, Dan Sullivan describes how a combination of PowerShell and SMO ("PowerSMO") can provide a familiar but powerful command line tool for... Read more...
Phil Factor The Data Dialog
by Phil Factor | 30 January 2007 |  12 comments |
Most companies have long since jettisoned the role of the grizzled old data architect, whose job it was to ensure a common understanding of the meaning of all data entities in the enterprise, and the actions carried out on it. Many are just now coming to realize... Read more...
Scott W. Ambler and Pramod J. Sadalage Refactoring Databases: The Process
by Scott W. Ambler and Pramod J. Sadalage | 09 January 2007 |  1 comment |
Database refactoring can greatly improve the efficiency of your database code. However, even a seemingly simple database refactoring such as "Move Column" can be tricky to implement correctly in a production environment. In this article, Scott Ambler and Pramod... Read more...
Phil Factor Automating Common SQL Server Tasks using DMO
by Phil Factor | 27 November 2006 |  20 comments |
Phil Factor's DMO automation procedures provide a valuable additon to any DBAs toolkit. Read more...
Nigel Rivett Creating CSV Files Using BCP and Stored Procedures
by Nigel Rivett | 20 November 2006 |  62 comments |
Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing on a stored procedure approach that gives complete control of the format of the extracted data. Read more...
Pop Rivett Pop Rivett's SQL Server FAQ No.5: Pop on the Audit Trail
by Pop Rivett | 03 November 2006 |  34 comments |
Pop provides a cunning, trigger-based technique for auditing the activity on SQL Server tables Read more...
Sanchan Sahai Saxena Fine Tuning your Database Design in SQL 2005
by Sanchan Sahai Saxena | 10 October 2006 |  149 comments |
Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005. Read more...
Phil Factor More Database Administration and Development Automation using DMO
by Phil Factor | 04 October 2006 |  18 comments |
Phil Factor provides a handy DMO automation toolkit to take care of some core SQL Server administrative tasks. Read more...
Andrew Calvett SQL Server 2005 Snapshots
by Andrew Calvett | 03 April 2006 |  18 comments |
Find out about Database Snapshots, new to SQL 2005 Enterprise Edition, which provide a read-only, "virtual" copy of a database, at a given point in time. Read more...
Hilary Cotter The identity crisis in replication
by Hilary Cotter | 05 July 2005 |  14 comments |
This article discusses three common problems DBAs are likely to encounter when columns have an identity property that will auto-increment its value when data is inserted. These problems are humorously referred to as the identity crisis. Read more...
Brian Moran Tracking tempdb growth
by Brian Moran | 11 April 2005 |  1 comment |
Runaway tempdb growth can be a problem, so how do you track its growth and correlate the growth to specific commands? 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
Tony Davis To Not CI to Eye
 Many developers, including Troy Hunt, here on Simple-Talk, have argued persuasively that each database developer in...  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