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… Read More »TempDB – Do This and Don’t Do That
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 enhancements and bug fixes.
So far since we started tracking downloads there have been 11,100 downloads of Database Health Monitor worldwide.
As part of our goal of improving Database Health Monitor, and expanding it to meet the needs of more and more DBA’s, we have created a survey to solicit input on how people are using it, and what we can do better to improve the product. The survey is located here: https://www.surveymonkey.com/r/TJLJDXH
Here is the list of changes in the latest release.
Read More »Database Health Monitor – January 2017 Version Released
Zero to SQL in 20 Lessons
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… Read More »Zero to SQL in 20 Lessons
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… Read More »When Database Corruption Strikes – Calgary SQL Users Group
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… Read More »Linux commands for SQL DBA’s who don’t know Linux (yet)
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… Read More »Allow Port 1433 Ubuntu Linux for SQL Server
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… Read More »Getting Started with SQL Server on Linux
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… Read More »SQL Summit 2016 Session Feedback.
SQL Server 2016 Compatibility Level
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… Read More »SQL Server 2016 Compatibility Level
Temporary Stored Procedures #sproc
CREATE PROCEDURE #MyProcedureName
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: