My good friend and business partner Carlos L. Chacon has just completed an introduction to SQL book, that he has just published on Amazon. He is offering the Kindle edition for free for 2 days, December 14th and December 15th, …
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 …
When Database Corruption Strikes – Calgary SQL Users Group Read more »
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 …
Linux commands for SQL DBA’s who don’t know Linux (yet) Read more »
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 …
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 …
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, …
With SQL Server 2016, there was a new compatibility level introduced, level 130 the new SQL Server 2016 Compatibility Level. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you …
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 …
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 …
DBCC CheckDB and CheckTable doesn’t check In-Memory OLTP. Read more »
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 …
Bellingham SQL Server Users Group November Meeting Read more »