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. …
At PASS Summit next week, I will be available most of the day on Monday and Tuesday to meet with anyone to discuss Database Health Monitor, or consulting work. Just send me an email or contact me via twitter @SqlEmt. I am also available to meet up during the summit, for lunch, dinner, drinks whatever works best. Related Links: Database Health …
Interested in some personal training on Database Health Monitor? Read more »
Next week I will be presenting on Database Corruption on Friday afternoon at Pass Summit. The session is called “When Database Corruption Strikes.” This session is on Friday afternoon, if you are interested in how to deal with database corruption, please come and see this presentation. The session is the last session of the week at 3:30 on Friday afternoon …