2023-07-10
379 reads
Administration
2023-06-23
356 reads
Actively Choosing Compatibility
Do you actively choose which compatibility level makes sense for your SQL Server databases? Or do you just take the defaults? Steve has a few thoughts today on actively managing your system.
2023-06-14
892 reads
T-SQL Scripts to generate the HTML-formatted database storage report
This article will show how to generate an HTML formatted report of your disk space.
2023-06-12
6,177 reads
Validating Password Expiration
Steve notes that password expiration is important for SQL Logins, but he knows this isn't always configured when logins are created, or checked later to see if it is still enabled.
2023-05-27
451 reads
Using Azure Data Studio to Deploy a SQL Server VM on Azure
This article looks at deploying SQL Server on an Azure VM from Azure Data Studio.
2023-05-24
1,480 reads
How to Find the SQL Server Instance Startup Time
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
7,345 reads
2023-05-05
155 reads
2023-05-03
488 reads
2023-04-12
444 reads
Blogs
Advice I Like: Experience and Aptitude
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
Plan Time for Self-Development
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
BK’s Bookshelf: Never Split the Difference
By Brian Kelley
I picked up Never Split the Difference: Negotiating As If Your Life Depended On...
Forums
Insiders Selling Data
Comments posted to this topic are about the item Insiders Selling Data
Join 2 tables
Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N...
Impact of Not Including Foreign Keys in an SQL Archive Database
Hello everyone, I am about to start a data archiving project that will affect...