While working on updating the PSBlitz script that retrieves statistics info for a SQL Server database, I’ve decided I should also make it available in a blog post and add …
Tag:
SQL Server
-
-
Brent Ozar’s latest blog post contained a question that piqued my interest about a potential method to calculate the checksum for an entire row in SQL Server. The original question: …
-
This post contains a script I’ve put together to query database sizes in SQL Server along with some additional info like file counts per file types and their sizes in …
-
This is just a brief post containing a script to get table sizes in SQL Server, along with some other information like table type, number of records, partition count, compression …
-
In this post I’ll cover ways of speeding up SELECT COUNT in SQL Server as well as some myths about best practices when it comes to SELECT COUNT. SELECT COUNT …
-
In this post I’ll cover a quick way to get access to SQL Server when you don’t have a login and don’t know the password for the SA account. I’ve …
- SQL ServerWorkarounds
Fix “certificate chain was issued by an authority that is not trusted” in dbatools
by Vlad DrumeaThis is a brief post about fixing the “certificate chain was issued by an authority that is not trusted” when using dbatools in PowerShell. Example of the full error message: …
-
In this post I’ll be covering the risks brought on by not securing SQL Server’s service account and setting it to run as a high privileged user. SQL Server’s wealth …
-
In this post I’ll address improper linked server configurations and their potential impact, as well as recommendations for securing SQL Server linked servers. Linked servers are one of SQL Server’s …
-
In this post I cover two ways of properly securing xp_cmdshell in SQL Server to avoid unrestricted access to the underlying Windows OS. What’s xp_cmdshell? xp_cmdshell is an extended system …