SQL Data Partners – Podcast with Argenis Fernandez

Download PDF

In episode 53 of the SQL Data Partners podcast Carlos Chacon and I chat with Argenis Fernandez, storage guru and PASS Director-at-Large. We talk storage options, LUNs, IOPs, and why he thinks we all need to approach storage a lot differently.  This was a fun interview, I had a chance to learn quite a bit from Argenis. This might be one of those podcast episodes that I need to listen to twice for all that great information to soak in.

Some of the things we covered with Argenis…

  • Why Argenis thinks that drive letters are outdated… and what you should use instead
  • The “Argenis definition” of a LUN, IOPS, and more…
  • The information Argenis thinks all DBAs should know
  • The difference between LUNs, mount points, and data stores
  • How to partition your data files and logs in physical storage vs. in virtualized environments
  • How IOPS fits into the SQL Server storage environment
  • What you should worry about instead of IOPs

I love the reference to spinning storage (traditional hard drives) as spinning rust compared to flash storage.

Spinning Rust

Spinning Rust

So check out this podcast and the other episodes from SQL Data Partners.

Listen now…

Related Links:

Posted in Uncategorized Tagged with: , , , ,

Speaking at PASS Summit 2016

Download PDF

This year in October, I again have the privilege to speak at PASS Summit in Seattle. One of my favorite topics, Database Corruption was the session that was selected.

Here are the details.PASS Summit 2016

When Database Corruption Strikes

You database is running fine month after month with no problems. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error”, or something even scarier. Do you know what to do now?

We will walk through three corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you can do to protect yourself when corruption strikes. Learn how to avoid making things worse, and how to protect your data if things do get worse. You will leave with a checklist of steps to use when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.

 

This is going to be a fun session to present.

If you are going to PASS Summit 2016, please check out my session.

Posted in PASS Summit Tagged with: ,

Podcast Episode 52 – The R Programming Language

Download PDF

Today we released Episode 52 on the SQL Data Partners podcast on the R Programming Language. You might remember a few weeks ago the announcement that I was joining Carlos Chacon as the co-host of the weekly podcast.

the R Programming Language R Revolution Analytics

Episode 52 on the SQL Trail with the SQL Data Partners Podcast is with Ginger Grant (@DesertIsleSQL on Twiter) and the topic is the R Programming Language and Revolution Analytics in SQL Server.

This weeks podcast was a fun one for me. I have been hearing lots about R for a while, and I wasn’t quite sure what it is or how it integrates with SQL Server. I learned a bit along the way, and want to thank Ginger for sharing her knowledge of R with us.

Listen to learn more about the R programming language

  • How R got started and why it’s built the way it is
  • How Revolution Analytics transformed R into a useful data science tool
  • How the open source version differs from the Revolution Analytics version in SQL Server
  • How to use R alongside SQL Server

If you are a regular listener I think you will enjoy this episode. If you are not a regular listener, or haven’t heard the podcast before, give it a try it is very educational, and a great way to keep on on SQL Server topics.

After listening to the podcast is is now challenging to think about R without thinking about pirate jokes.

pirate1

Related Links:

Posted in Podcast Tagged with: , ,

DBCC CloneDatabase

Download PDF

The Service Pack 2 release of SQL Server 2014 introduces a new DBCC command called DBCC CloneDatabase.

Books online states:

DBCC CLONEDATABASE should be used to create a schema and statistics only copy of a production database in order to investigate query performance issues. “

Which sounds really interesting. Get all the schema and statistics but no data.

Some immediate uses come to mind:

  • Using in a development or test environment to use production statistics to view query plans.
  • When dealing with Database Corruption, a way to spin up an empty copy of a database for troubleshooting work.
  • A great way to archive the schema without the data.
  • Spinning up multiple developer copies of a database on a test server.

 

 

To clone the database QueryTraining to a new database called AttackOfClones.


DBCC CloneDatabase (QueryTraining, AttackOfClones)

Clone1

Here is the output when you run CloneDatabase.

Database cloning for 'QueryTraining' has started with target as 'AttackOfClones'.
Database cloning for 'QueryTraining' has finished. Cloned database is 'AttackOfClones'.
Database 'AttackOfClones' is a cloned database. A cloned database should be used for diagnostic 
purposes only and is not supported for use in a production environment.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

 

Note the bit about not supported for use in a production environment.

 

Notice that after running DBCC CloneDatabase, and refreshing the object explorer that the cloned database is read only.

Clone2

 

If you want to set the database read write, and no longer be read only, you can do the following.


ALTER DATABASE [AttackOfClones] SET  READ_WRITE WITH NO_WAIT;

Clone3

 

Here is a list of tables in the cloned database compared to the original database.

clone4

 

I still have some investigation to do here, but this looks interesting.

Posted in SQL 2014 Tagged with: ,

Database Health Monitor – July 2016 Release

Download PDF

I have just released version 2.4.3 the July 2016 version of Database Health Monitor. You can download it now at the Database Health Monitor website. http://DatabaseHealth.com/download

Since the releases have been coming about monthly lately, I have decided to add the month and year to each release so that it has a bit more meaning. The next update should be sometime in August.

This update was about a month in the making, a few new features, a few bug fixes, and overall improvements.

My favorite new feature in this release is the addition of a “Go Back” feature when viewing reports. When you click from one report to another, and then another, and you realize that you want to jump back to that previous report… well you can now, just use the Backspace key on your keyboard from anywhere in database health monitor. Hit it multiple times to jump back further in your history of reports.

New Features in 2.4.3

  • Backspace button to go to the previous report viewed.
  • A new report for SSRS report servers that shows the speeds of the SSRS reports being run. You can find your slow SSRS reports with this.

Fixes in 2.4.3

  • With multiple historic monitoring instances, the CPU load by hour report was only showing the CPU load for the server doing the monitoring, not for the server being monitored.
  • Fixed a bug causing the database overview panel to crash for database instances that with a name that started with a space, or ended with a space. Example: [ DatabaseName ]  Note the spaces inside of the brackets.  It works now.

Download now at http://DatabaseHealth.com/download

Star_of_life

Posted in Database Health Tagged with: , , , , ,

SQL Server 2016 Developer Edition

Download PDF

SqlDeveloper2016

With previous versions of SQL Server to get the developer edition, it was usually available for around $50 USD at Amazon.com. With the introduction of SQL Server 2016 Microsoft has made the SQL Server 2016 Developer Edition a free download. It does however require registration with Visual Studio Online.

To get the SQL Server 2016 Developer Edition, follow these steps.

  1. Visit the Visual Studio online page, and sign up for the Visual Studio Dev Essentials free program.
  2. Once you join, you will get an email confirming your membership.
  3. Login and click on the downloads link. Find the SQL Server 2016 Developer Edition and download it.

Its that easy.  Here is the link to the visual studio online page:

https://www.visualstudio.com

 

The SQL Server 2016 Developer Edition has the same features as the full Enterprise edition of SQL Server, the licensing however prohibits you from using it in a production environment. It’s great for developers and DBAs to use on their individual workstations or laptops.

There are many new features available in the SQL Server 2016 and with the Developer Edition, you can explore all of these.

This free download is a bit challenging to find on the Microsoft Visual Studio site, but once you find it at the link above you will be set.

Posted in SQL Server Tagged with: , , , ,

SQL Data Partners – SQL Server Podcast

Download PDF

I am excited to announce that I have joined Carlos Chacon to become the co-host of the SQL Data Partners – SQL Server podcast. The weekly show has just reached 50 episodes, and Carlos has asked me to join him as co-host on the podcast.

SQL Data Partners Podcast

In episode 50 Carlos introduces me as the co-host, the Corruption Compañero or the West Coast Compañero. I think I like the Corruption Compañero best. If you are a listener of the podcast you will recognize the word Compañero as companion, as in SQL Compañero or SQL companion. It’s a catchy term, and I am excited to be the Corruption Compañero on the podcast.

Read more ›

Posted in SQL Server Podcast, Uncategorized Tagged with: ,

Database Health Monitor Version 2.4.2 Released Today

Download PDF

Today I released the latest update to Database Health Monitor.  Version 2.4.2. It has been about a two weeks since version 2.4.1 release and version 2.4.2 has a few new features, and a couple bug fixes.

Here is a preview of the new logins report. First the logins panel on the Server overview report.

LoginsPanel

When you click the overview panel, you then drilldown into the logins report. The logins report is filtered by clicking the type of login show at the top of the page.

LoginsReport

 

New Features in 2.4.2

  • New report available on SSRS Report Server databases showing the distribution of reports run over the last 24 hours, along with a detailed drilldown with a list of all reports run in the last 24 hours.
  • Updated the Stored Procedures by Logical Writes to use Seconds rather than Microseconds in the durations. Makes much more sense, and is clearly labeled now.
  • Added a Logins by Instance report.
  • Added 3 new report panels for SSRS reporting databases.
    • Recent SSRS report usage.
    • Reports Run over the last 24 hours with chart.
    • Report Users over the last 7 days with chart.
  • Quick Scan Report
    • Added an option to the QuickScan report to right click to turn off AUTO_CLOSE for all databases on the instance.

Fixes in 2.4.2

  • Fixed a problem that has been there for a while with connecting to a monitoring database on another server than the current instance. This was introduced about 8 months ago, where you could only use the current instance for monitoring. The problem has been fixed. Thanks for the customer feedback that lead me to finding and fixing this problem.
  • Improved startup performance. Caching some values that were previously querying the database multiple times.
  • Fix a problem with the tab order on the Connect to Database dialog. The username and password were not in the correct sequence. More of an annoyance than anything, but this has finally be fixed.

Star_of_life

Posted in Database Health Tagged with: , , , , , , ,

Database Health Monitor Version 2.4.1 Released

Download PDF

Just one day after releasing Database Health Monitor version 2.4, today I released version 2.4.1.

Version 2.4.1 includes a bug fix and 2 new feature that were added after the release of version 2.4.

  • Feature: Support for SQL Server 2016. Since SQL Server 2016 officially released yesterday, Database Health Monitor now supports SQL Server 2016.
  • Bug: The check for the latest version of SQL Server 2014 CU6 was updated. Microsoft released a patch to their original CU6 release. The check now accounts for this.
  • The QuickScan report now has an option to ignore specific check items. This was a customer request that I received today. To ignore, or un-ignore items right click on the quick scan report.
  • Star_of_life

Download Database Health Monitor Today!

Posted in Database Health Tagged with: , ,

Database Health Monitor Version 2.4 Released

Download PDF

If you haven’t tried Database Health Monitor Version 2.4 might be a good time to try it out. Five and a half years of my development time has gone into Database Health monitor, and hopefully the features will show it.

Star_of_life

Here is what people have to say about Database Health Monitor.

Excellent – It’s the first tool I open every morning to see what is going on in my production environment! Thanks for the great work!

I personally used Database Health Monitor to manage over 100 instances of SQL Server, and it speeds up many of the daily maintenance checks.

Version 2.4 Release Notes

Over the last several months I have added several new features, and many bug fixes. Here are some of the features and fixes included in this update.

Read more ›

Posted in Database Health Tagged with: , , , , , ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Archives