Skip to content
Thomas LaRock
  • About
  • Work With Me
    • Author
    • Speaker
    • Data Expert
  • Blog
  • Contact Me
  • Resources
    • Portfolio
    • SQL Server Upgrades
    • SQL Server Books
    • Someday…
    • Blogger Disclosure

SQL

Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time

May 9, 2018 by Thomas LaRock

For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database.

Categories MSSQL, SQL MVP, SQL Server 2016, SQL Server 2017 Tags policy based management, SQL, sql server 2 Comments

SQL Vulnerability Assessment Available in SSMS

December 7, 2017 by Thomas LaRock
SQL Vulnerability Assessment Scan Results

The SQL Vulnerability Assessment (VA) feature in now available in SSMS (SQL Server Management Studio)!

Categories Data Security and Privacy, MSSQL, SQL MVP, SQL Server Performance Tags data security, SQL, sql server, SSMS, vulnerability assessment 6 Comments

Audit SQL Server Jobs

October 12, 2017 by Thomas LaRock
SQL Server Audit Log File

In this post I will show you how to audit SQL Server jobs. If anyone adds, deletes, or modifies a job you can track who did what, and when.

Categories Data Security and Privacy, MSSQL, SQL Azure, SQL MVP Tags data privacy, data security, database audit specification, SQL, sql audit, sql server, sql server audit 6 Comments

View BACPAC Files Using This One Weird Trick

May 8, 2017April 24, 2017 by Thomas LaRock
change BACPAC to ZIP file

I did not think it was possible to view the contents of a BACPAC file. However, last month while at SQL Bits I was reminded about this one weird trick to view the contents of a BACPAC file.

Categories Database Design, MSSQL, SQL Azure, SQL MVP, SQL Server Performance Tags BACPAC, DACPAC, SQL, Things I Write While High on Bacon, ZIP 1 Comment

KPIs For DBAs to Show Their CIOs

March 8, 2017 by Thomas LaRock
KPIs for DBAs to show to their CIOs

It is perfectly valid for a DBA (or their manager) to assign KPIs to the servers and databases they administer. KPIs are unique for every shop, and for every role.

Categories MSSQL, SQL MVP Tags KPI, Professional Development, SQL 3 Comments

Join Me at SQL Konferenz 2017

January 24, 2017 by Thomas LaRock

I will be presenting at SQL Konferenz in Darmstadt, Germany next month. If you are in, or near, Darmstadt in February I hope you take the time to join us at SQL Konferenz!

Categories MSSQL, PASS, Professional Development, SQL MVP, Travel Tags event, Germany, SQL, training Leave a comment
Older posts
Page1 Page2 … Page12 Next →
+ More
Pro SQL Server 2022 Wait Statistics
Next Page »