Tag: SQL Server

Latest Podcast Episodes

Here is a quick update on the last 3 podcast episodes that we have published, ending up 2016, and starting out 2017 with some great information from Paul Turley, Jimmy May and Argenis Fernandez. Episode 77: New Reporting Options with

Posted in Podcast Tagged with: , , , ,

TempDB – Do This and Don’t Do That

Today I had the opportunity to present on TempDB to the Spokane SQL Server users group (PASS Chapter). The session was titled TempDB – Do This and Don’t Do That”, and it covers a bunch of tips and best practices around

Posted in Uncategorized Tagged with: , , , , ,

Database Health Monitor – January 2017 Version Released

Today we released the Database Health Monitor January 2017 version. You can download it for free at http://DatabaseHealth.com/Download. This update includes  some new branding with new logos, new icons, and a new splash screen, as well as the usual feature

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

Allow Port 1433 Ubuntu Linux for SQL Server

If you have just installed SQL Server on Ubuntu Linux and you are trying to connect remotely you may have some difficulty connecting if port 1433 is not available. Here is how you do it, using the UFW, or Uncomplicated Firewall

Posted in SQL Linux Tagged with: , , , ,

Getting Started with SQL Server on Linux

With the recent public availability of the SQL Server Linux release, I figured I should give it a try, and it went well. Here is all that it took. Download and install to a VM Ubuntu Linux Server 16.04.  (1

Posted in SQL Linux Tagged with: , , ,

Temporary Stored Procedures #sproc

Yes, you can create temporary stored procedures by prefixing the name of the sproc with a #. The temporary stored procedure is sort of a “leave no trace” stored procedure that is only good for your session. If you use

Posted in TSQL Tagged with: , , , , , , ,

DBCC CheckDB and CheckTable doesn’t check In-Memory OLTP.

Special thanks to my friend Theresa Iserman for introducing me to Jos de Bruijn the Senior Program Manager for the In Memory OLTP (Hekaton) project to help get my questions answered at PASS Summit. So, the Hekaton – In Memory

Posted in Corruption, Hekaton Tagged with: , , , , ,

Bellingham SQL Server Users Group November Meeting

Bellingham SQL Server Users Group (Pass Chapter) – November 30th at 6:00pm. Features Presentation by Randolph West: “Back up and Restore your Database with Azure Blob Storage”. Making use of good disaster recovery fundamentals and modern off-site storage, you will

Posted in PASS Chapter Tagged with: , , , , , , ,

Visualizing VLF’s – Updated

A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script. Here is an updated script that has adds another column called “TextStatus” to the

Posted in Uncategorized Tagged with: , , , , , , ,

When Database Corruption Strikes – PASS Summit 2016

It has been a great week at PASS Summit 2016. Tomorrow I will be presenting on Database Corruption.  The session is called “When Database Corruption Strikes.”   This session is at 3:30pm in Room 2AB, if you are interested in how to

Posted in Corruption, Summit 2016 Tagged with: ,