PowerShell is becoming a great tool for managing SQL Server tasks, but like most tasks that are coded there is always the need for error handling to deal with the unknown. PowerShell has several options for handling and capturing error details and in this tip we will explain these options using PowerShell for SQL Server examples.
Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.
The things that are important to Microsoft might not be the same ones that are important to you as a customer. However Steve Jones thinks that the potential changes in the release strategy may be good for data professionals.
A deceptively simple solution to a business re-engineering problem can beguile companies into selecting a compromise that doesn't actually meet all their needs. Simple is great, but not at the expense of functionality. Some IT solutions are complex because the problem is complex, but they can be made conceptually clearer.
Some tips on what to do when you inherit a database that you've never worked on before
Not everything in SQL Server is documented and Steve Jones doesn't think that everything should be. However some features are used often and should have additional documentation.
This article will show some common integer data-type conversions using T-SQL.
In PowerShell, Phil Factor believes we have a true novelty: a Windows Scripting language that outsmarts Perl and Python and Ruby and one that will continue to cause radical changes to Windows server applications, and the tools we use to administer them.
There's no shortage of technology workers, especially good ones. Today Steve Jones reminds us that we might wish to encourage others to try technology and then help prepare them for a career in this field if they enjoy it.
In a perfect world everyone has the right backups to be able to recover within the downtime and data-loss service level agreements when accidental data loss or corruption occurs. Unfortunately we don’t live in a perfect world and so many people find that they don’t have the backups they need to recover when faced with corruption.
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Comments posted to this topic are about the item Let's Talk Community Events!
Hi as shown below a replication target requires a primary key. if we want...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers