Articles

Collect SQL Server Index Usage Information for all Instances with PowerShell

• by Additional Articles

• MSSQLTips.com

• Indexes

In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.

2019-06-26

Data breach notifications don’t need to be scary

• by Additional Articles

• Redgate

• Compliance

Ever since the GDPR was introduced, the subject of data breach notifications has worried a lot of people. How do you write one? What do you need to include? What will the ramifications be? Will it make your customers run for the hills? Will it get you fired?

2019-06-26

Free eBook: SQL Server Transaction Log Management

• by Press Release

• Redgate

• Transaction Log

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.

2019-06-26 (first published: 2013-08-14)

104,952 reads

All flash vs adaptive flash storage - which is right for my organisation?

• by checkmarkIT

• SQLServerCentral

• Storage

Many data professionals might not worry about hardware, but someone needs to watch for changes and improvements in technology. Learn about how flash storage technology has changed and how this might be useful if you still need to build a fast database server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2019-06-25

1,507 reads

• Discuss

Displaying the Object Explorer Details Pane in SQL Server Management Studio

• by Additional Articles

• Database Journal

• Management Studio (SSMS)

You are probably familiar with the Object Explorer pane in SQL Server Management Studio (SSMS), and how to bring it up. But, are you familiar with the Object Explorer Details pane and how to display it? If not, then read on...

2019-06-25

SQL Clone on your Laptop

• by Additional Articles

• Redgate

• Cloning

Phil Factor provides a PowerShell script to disconnect your laptop without risking error 21, if you're working with SQL Clone and need to go offline. The same script will then bring the clone database back online smoothly, once you're reconnected.

2019-06-25

Exporting Stored Procedure Results to a Table

• by Pamela Mooney

• SQLServerCentral

• Stored Procedures

A quick trick from Pamela Mooney for getting results from a proc into a table.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.67 (3)

Log in or register to rate

2019-06-24

5,396 reads

• Discuss

Database provisioning and containers – can you help?

• by Additional Articles

• Redgate

If you work with SQL Server, Redgate would love to talk to you about how you’re using (or thinking of using) containers, how you see databases fitting into your workflows involving them, and any challenges you’ve hit so far.

2019-06-24

Free Webinar: The State of SQL Server Monitoring 2019

• by Press Release

• Redgate

• Conferences, Classes, Events, and Webinars

With a line up like this, it's a webinar not to be missed! Join Grant Fritchey, Chris Yates, Annette Allen, and Tony Maddonna on Tuesday June 25th as they discuss the key findings of Redgate’s 2019 State of SQL Server Monitoring survey.

2019-06-24

The BI Journey: The Journey Begins

• by Additional Articles

• SimpleTalk

• BI

Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after the initial success, plans are made to sustain and grow the project.

2019-06-24