(Pinal Dave) Recently I published a blog about new DMV in SQL Server 2017 called dm_os_enumerate_fixed_drives. While doing that I found another new DMF (Dynamic Management Function) sys.dm_os_file_exists.

(John Miner) Today, many companies are living in a hybrid world in which data resides not only on-premises in a local data center, but in the cloud at a Microsoft Azure data center. There is an increasing need to share data with not only internal resources, but with our customers. How can we keep

(Pinal Dave) One of my clients sent email to know my quick suggestion on one of the error messages. Let us learn how to fix error related to worker thread.

(Arun Sirpal) It’s good to be proactive and one way is to setup alerts and it is no different when using Azure SQL Database. I like creating alerts for my Azure SQL Databases and I encourage you to do the same.

(Kenneth Fisher) I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance was another collation. Wow, was that a headache.

(Erin Stellato) There are numerous blog posts on this site related to wait statistics; they are one of the most important metrics you can use when troubleshooting performance issues in SQL Server. Wait statistics were made available in SQL Server 2005 and traditionally they have represented waits at

(Simon Liew) If you read my first tip on expired TDE certificates, you know that a database can still work even after the certificate used for TDE has expired. Now you might be wondering how you can generate a new certificate to replace the previous certificate and the steps if the database is in an

(Hannes du Preez) Sometimes you will have a situation where you would want a certain query, or Stored Procedure to be repeated on a daily, weekly or monthly basis (or any time increment for that matter).

(Thomas LaRock) I’ve had a busy few months of travel. This has cut into my blogging time as well as time to play with new things. One of those things was getting started on restoring a SQL Server database on Linux using SQL Operations Studio.

(Perry Skountrianos) ASP.NET session state enables you to store and retrieve values for a user as the user navigates the different ASP.NET pages that make up a Web application. Currently, ASP.NET ships with three session state providers that provide the interface between Microsoft ASP.NET’s session