Contents tagged with sql server
-
Automatically Running Stored Procedures at SQL Server Startup
https://www.mssqltips.com/sqlservertip/1574/automatically-running-stored-procedures-at-sql-server-startup/ more
-
How to Linux for SQL Server DBAs
https://www.red-gate.com/simple-talk/sql/sql-linux/how-to-linux-for-sql-server-dbas-part-1/
-
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
https://jasonbrimhall.info/2019/06/13/get-the-source-of-preemptive_os_pipeops-waits/ more
-
SQL and NULL Mistakes
https://www.red-gate.com/hub/product-learning/sql-prompt/the-null-mistake-and-other-sql-null-heresies more
-
Simple script to backup all SQL Server databases
https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/ more
-
Identity function tutorial in SQL Server
https://www.sqlshack.com/overview-of-identity-functions-in-sql/ more
-
Querying Temporal Tables
https://www.sqlservercentral.com/articles/querying-temporal-tables more
-
SQL SERVER CONTAINERS
https://www.scarydba.com/2019/06/17/sql-server-containers-are-boring/ more
-
Does the case expression short circuit
https://sqlstudies.com/2019/06/13/does-the-case-statement-short-circuit/ more
-
SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted
https://blog.sqlauthority.com/2019/06/03/sql-server-fix-msg-15274-access-to-the-remote-server-is-denied-because-the-current-security-context-is-not-trusted/ more
-
DBATools PowerShell Module for SQL Server
https://www.sqlshack.com/dbatools-powershell-module-for-sql-server/ more
-
TSQLT, The Open Source Database Unit Testing Framework For Sql Server
https://tsqlt.org/ more
-
SQL Server Get Row Count of All Tables
Get all the tables with a count of their records with the following query:
CREATE TABLE #Temp
(
TableName VARCHAR(MAX),
Rows INT
);
EXEC sp_MSForEachTable @command1 = 'INSERT INTO # … more
-
Audit Users logging in using "sa" or service accounts
source: https://www.sqlservercentral.com/scripts/audit-users-logging-in-using-sa-or-service-accountsIF OBJECT_ID ('AuditSqlLogins') IS NOT NULL DROP TABLE AuditSqlLogins
GO
CREATE TABLE … more
-
SQL Server Get Product Version and CPU Cores
SELECT @@SERVERNAME AS SQLServerName, CASE SUBSTRING(CONVERT(NVARCHAR(20),SERVERPROPERTY('ProductVersion')),1,4) WHEN '15.0' THEN 'SQL Server 2019' WHEN '14.0' THEN 'SQL Server 2017' WHEN '13.0' … more
-
Ten SQL Commands You Should Be Using
https://www.databasejournal.com/features/mssql/ten-sql-commands-you-should-be-using.html
-
SQL Server Introduction to Statistics
-
sp_BlitzWho and SQL Server First Responder Kit
https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/dev/sp_BlitzWho.sql
-
SQL Server: Get Operating System Information with TSQL
SELECT windows_release, windows_service_pack_level, windows_sku, os_language_version FROM sys.dm_os_windows_info
exec master..xp_cmdshell 'systeminfo'
SELECT @@version
exec xp_msver more
-
SQL Server Performance Tools
https://blog.sqlauthority.com/2019/05/08/sql-server-how-do-i-evaluate-monitoring-tools/ more