CPU custom module available for Inspector V2
If you need to keep track of CPU and are not fortunate enough to have a monitoring tool to keep hold of historical CPU usage then this module may...
2020-01-02
26 reads
If you need to keep track of CPU and are not fortunate enough to have a monitoring tool to keep hold of historical CPU usage then this module may...
2020-01-02
26 reads
With the New Year fast approaching and maybe already having arrived depending on where you are, we thought we’d do a quick recap of our top 5 posts from...
2019-12-31
23 reads
2019-12-24
15 reads
In our Christmas Special, David picks his top 5 features of Azure Data Studio.
2019-12-17
27 reads
The SQL Installation file can be found here.The new Powershell installer can be found here.If you are running the powershell collection you will need to grab the latest revision.The...
2019-12-03
40 reads
Memory grants, now here’s a fun thing that can pretty much take your SQL Server to its knees. The Symptoms The first thing that you’re going to notice is...
2019-12-03
277 reads
In this episode, David looks at how we can encrypt our SQL Server backup files
2019-11-26 (first published: 2019-11-18)
240 reads
Sometimes you just want to get a quick row count for a specific table – other times you may want to see a list of tables order by size...
2019-11-06 (first published: 2019-10-30)
1,041 reads
Adrian looks at how you can use Excel to visualise SQL performance data, specifically data collected by the Blitz First Responder Kit
2019-11-05
100 reads
In this episode of the podcast, Adrian looks at the scripting options available in SSMS.
2019-10-31 (first published: 2019-10-21)
432 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers