Comparing Two Recordsets Using Powershell
How can you quickly and easily compare recordsets from different instances? This article will show you a quick way to do this with PowerShell.
2012-07-13
4,392 reads
Articles
SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery
The aim of the new Database Recovery Advisor in SQL Server 2012 is to simplify the task of piecing together a recovery sequence from multiple backup files, comprising full, differential, and log backups. In this article, I'll demonstrate how the tool makes it easier to plan for, and perform, a point in time recovery from a series of backups, in order to recover data that may have been lost due to an application bug, or user error.
2012-07-13
2,633 reads
File Watcher Task
The task will detect changes to existing files as well as new files, both actions will cause the file to be found when available. A file is available when the task can open it exclusively. This is important for files that take a long time to be written, such as large files, or those that are just written slowly or delivered via a slow network link.
2012-07-13
3,590 reads
SQL Triggers in a Security Context
This article will show you how to use user-defined triggers to supplement your security policies, preventing unauthorised data manipulation and blocking unfriendly logins.
2012-07-12
6,502 reads
Do you work with data to support organizational decisions?
Are you a database or BI expert supporting decisions in your company with reports or models using Microsoft tools? We want to hear how you do this and what you think of the trend towards 'self-service' analysis for business users. Share your experiences in a short survey.
2012-07-12
2,576 reads
The PoSh DBA - The Attributes of Advanced Functions
Once you pass that point of just hurriedly writing PowerShell scripts for immediate use and start to write PowerShell functions for reuse, then you'll want a robust set of parameters that allow functions to work just like cmdlets.
2012-07-12
2,902 reads
Is it time to move from SQL Azure to Amazon RDS SQL Server?
Amazon RDS SQL Server is the new kid on the block. Is it better than SQL Azure?
2012-07-11
10,432 reads
SQL Server Report Server 2008 R2 Execution Log Reports
As you design and deploy more and more reports to your Report Server, how do you review which reports are being run, how often, and how long the reports take to render?
2012-07-11
4,110 reads
SQL Server Central Webinar Series #20: Using SQL Storage Compress in the Real World
Join us on July 10 at 4:00pm GMT/11:00am EDT for an in-depth look at SQL Storage Compress and learn how you can shrink the storage needs for your databases.
2012-07-10 (first published: 2012-06-26)
1,957 reads
Troubleshooting SQL Server with PowerShell - Virtual Chapter Meeting
Come join Laerte Junior on Wednesday ,July 18th 12 noon EDT (GMT -4), for a virtual meeting on Powershell and
2012-07-10
835 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?