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 hour) Allow port 22 through the firewall to be able to connect to the server with Putty. (1 min) Follow …
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, I wasn’t quite sure what to expect. Here is the overall evaluation. Then on to the actual feedback, which I …
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 set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server …
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 double ## you will get a global temporary stored procedure. For instance:
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 OLTP tables are perhaps one of the most amazing performance improvements to SQL OLTP in a long time. The way …
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 learn how to back up and restore a full database backup using Azure Blob Storage, even if your version of …
Bellingham SQL Server Users Group November Meeting Read more »
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 output to give you a better idea of what the different statuses mean. You now get 3 statuses shown, “In …
Today I had the pleasure presenting my session “When Database Corruption Strikes” as PASS Summit 2016. I want to thank PASS and the program committee for this great opportunity to present on a topic that I enjoy so much… Database Corruption and how to fix it. Here is a shot from my point of view about 10 minutes before …
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 deal with database corruption, please come and see this presentation. Here is the session abstract: Your database is running fine …
When Database Corruption Strikes – PASS Summit 2016 Read more »
Last night I arrived in Seattle for PASS Summit 2016. This is my 4th consecutive PASS Summit, and my second time to be here as a speaker, and I am certainly looking forward to the week. Before I had even checked in I ran into a few friends and ended up talking for a while and catching up on things. …