An examination of bulk-logged recovery model
This article looks at the bulk-logged recovery model in depth and examines how it affects disaster recovery and logging.
Mobile Password Protection
Security is becoming more of an issue for mobile devices as we store and access more information on them all the time.
Responsibility for Security
Steve Jones talks about security, and the developer's role in ensuring secure code.
Big Data is Just a Fad
The Term 'Big Data' is nothing more than a fad, and we'll soon be cringing with embarrassment at the thought that we ever used it. However, the data, and the challenges to processing it that it presents, will stay with us. If jargon like 'Big Data' helps us focus on the problems, then let’s use it: temporarily, perhaps.
Red Gate releases SQL Backup Pro 7
Red Gate Software has released SQL Backup Pro 7 with pioneering new features focused on SQL Server backup verification. SQL Backup Pro 7’s step-by-step scheduling wizards aim to simplify the process of restoring and verifying backups.
The Best Way to Learn
This Friday Steve Jones is looking to see how you might like to improve your educational materials. With the success of our Stairway Series, we are looking to find better ways to teach people about SQL Server.
Implementing Lookup Logic in SQL Server Integration Services
With SSIS, you can perform a lookup on data in the course of a task, using referenced data from any OLE DB source. It is a useful feature that enables you to check on the validity of data, or interpret it before proceeding. Robert Sheldon explains.
Learn XML
Steve Jones talks about XML and how it will be more and more important for DBAs to understand this in the future.
Red Gate launches Exceptional DBA Awards 2012 - bringing DBAs the recognition they deserve
The 2012 Exceptional DBA awards are back. Learn how you can enter and win a trip to the 2012 PASS Summit.
Selecting from hierarchies like Managers and Employees
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers