(Jason Brimhall) Quite some time ago, I shared a few articles that peeled back the top layer of how to use PowerShell (PoSh) with Extended Events (XEvents). Among those articles, I showed how to retrieve the metadata, predicates and actions, and targets (to mention a few).

(Daniel Farina) You are facing a problem with one of your SQL Server instances. Something happened to one of the disks and the result is a damaged model database, so SQL Server won’t start up. In this tip I will show how you can fix this issue.

(Jack Vamvas) Question: I’m trying to understand for educational purposes , what are the exact steps the SQL Server Backup is taking to progress through a SQL Server backup.

(Pinal Dave) If you have read release notes of SQL Server 2019, you might have been aware of the fact that Microsoft has finally made an enhancement to error 8152 – String or binary data would be truncated.

(Denny Cherry) I was doing a POC of SQL Server 2019 Big Data Cluster (BDC) recently. We did the POC in Azure as they didn’t have a Kubernetes environment on-prem that we could work with.

(Esat Erkec) The sp_executesql is a built-in stored procedure in SQL Server that enables to execute of the dynamically constructed SQL statements or batches.

(Greg Robidoux) One challenge that just about everyone is faced with, is ever changing database schemas. From the onset of a project the database schema might be perfect on day one, but as the application evolves and the business needs change database table structures have to change.

(Kenneth Fisher) I don’t know how many of you are working with Windows Core these days but personally I think it’s a pretty cool concept. You aren’t supposed to be logging into your servers all that often so why have the extra overhead of Windows?

(Manoj) In SQL Server to get top-n rows from a table or dataset you just have to use “SELECT TOP” clause by specifying the number of rows you want to return, like in the below query.

(Pinal Dave) Few of my clients are still running older versions of SQL Server and they have their own reasons to not to move to the new SQL version. In this blog, I would share my findings of how I identified the cause of failure “Disk full: There is not enough disk space on the volume.”