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
1,383 reads
Learn a number of methods to view or programmatically get the SQL Server instance startup time.
2023-05-12
1,383 reads
This SQL cheat sheet contains a series of scripts to help address common situations that might be brought to a Microsoft SQL Server DBA. Each has a proper explanation as to what it does and how it works.
2023-05-05
A stored procedure to search database objects (triggers, scalar functions, table valued functions, views and stored procedures) for a user defined string.
2022-04-04 (first published: 2022-03-28)
832 reads
This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.
2022-03-23
1,345 reads
This article looks at the way in which you can convert unmanaged devices to the ASM filter drive in an Oracle system.
2022-03-04
1,717 reads
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
3,655 reads
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
4,780 reads
SQLFacts is a FREE suite of 26 (and counting) tools for SQL Server database development, database administration, and performance tuning. The toolkit is all T-SQL code and it includes the functionality of hundreds of short scripts.
2021-11-19
8,970 reads
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
I know you can't do this in MSSQL, but hoping DW has progressed more....
Hi Folks trying the below but having zero luck and was wondering if anybody...
I have a varchar(max) column which has sensitive data and want to encrypt it....