Blog Archives

When Database Corruption Strikes – Calgary SQL Users Group

Today I am presenting one of my favorite sessions “When Database Corruption Strikes” remotely for the PASS Calgary SQL Server Users Group. This is the same session that I presented at Pass Summit 2016, with a few minor additions, including

Posted in Corruption, PASS Chapter Tagged with: , ,

Linux commands for SQL DBA’s who don’t know Linux (yet)

With SQL Server now being available (pre-release) on Linux, I think we will see many SQL DBA’s who previously did not have Linux experience being forced into a new area. I am lucky in that I have had my share

Posted in SQL Linux 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: , , , ,

SQL Server on Linux

This week Microsoft made the v.next version of SQL Server for Linux available in the public preview. It has been a couple of years since I have worked with Linux, but I am excited and going to give it a

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: , , ,

SQL Summit 2016 Session Feedback.

I was extremely excited to get my session feedback from my SQL PASS Summit 2016 session on Database Corruption today. I have been waiting, and was very please with the feedback.  Being the last time slot of the entire conference,

Posted in Summit 2016 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: , , , , , , ,

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