Tag: SQL Server

Pre-con at SQL Saturday Richmond in March – Emergency Preparation for Database Disasters

On March 18th I will be attending SQL Saturday 610 in Richmond Virginia and the day before I will be presenting a pre conference session covering half a day on Database Corruption and half a day on Disaster Recovery Planning.

Tagged with: , , , ,

Podcast Episode – The Long Awaited Index Episode

For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure to announce that the Indexing episode (episode 81) was released today, well at lease half

Tagged with: , , , , , ,

Bellingham SQL Server Users Group – January 25th

On Wednesday January 25th at 6:00pm we will be hosting the monthly meeting of the Bellingham SQL Server Users Group. January SQL Server Users Group In-Person @ 709 West Orchard Drive #4 Bellingham, Washington 18:00 – 20:00 (UTC-08:00) Pacific Time

Tagged with: , , , , ,

The On Call DBA For Corruption

  One of those services that I offer is on call help for DBA’s who encounter database corruption. Call me anytime 24/7 and as long as you are an existing customer, or we can work out a billing arrangement to

Tagged with: ,

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

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

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

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

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

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

Tagged with: , , , , , , ,
Top