TechDevOps.com
Explore Tools
An IT resource site featuring Microsoft Technologies + Cloud Computing + Enterprise Data



LATEST...

July 19, 2017
T-SQL Display Operating System Version Information
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_os_windows_info vs sys.dm_os_host_info
Read More
Tags SQLServer, SQLServer2017, TSQL

July 12, 2017
T-SQL Get Database Data and Log File Space plus Disk Space - v2 (includes: Database Mail plus HTML Report with records markers)
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.database, sys.master_files, sys.data_spaces, sys.dm_os_volume_stats, sp_send_dbmail
Read More
Tags SQLServer, SQLServerHealthCheck, TSQL

July 8, 2017
T-SQL Get Database Data and Log File Space plus Disk Space
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.database, sys.master_files, sys.data_spaces, sys.dm_os_volume_stats
Read More
Tags SQLServer, SQLServerHealthCheck, TSQL

July 5, 2017
Agent is retrying after an error. 65 retries attempted. See agent job history in the Jobs folder for more details.
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
msdb.dbo.sysjobhistory
Read More
Tags SQLServer, SQLServerReplication, SQLServerReplicationMonitor, TSQL

June 30, 2017
SQL Server Buffer Pool Usage per Database and per Objects
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.objects, sys.partitions, sys.allocation_units, sys.indexes, sys.dm_os_buffer_descriptors
Read More
Tags SQLServer, SQLServerArchitecture, SQLServerCPU, SQLServerHealthCheck, SQLServerMemory, TSQL

June 28, 2017
Auditing SQL Server Systems - Logins
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sp_readerrorlog, sp_helptext
Read More
Tags SQLServer, TSQL

June 25, 2017
SQL Server 2017 - sys.dm_db_log_info
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
A New DMF used to examine the structure of Transaction Log files and it is a replacement for DBCC LOGINFO. It returns VLF information of the Transaction Log Files.
Read More
Tags SQLServer, SQLServer2017, TSQL

June 24, 2017
SQL Server 2017 - sys.dm_os_enumerate_fixed_drives
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
A New DMV to identify free disk space. It is a replacement for XP_FIXEDDRIVES.
Read More
Tags DMVs, SQLServer, SQLServer2017, TSQL

June 23, 2017
SQL Server 2017 - sys.dm_os_file_exists
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
A New inline TVF to check if a file exists or not. It is a replacement for XP_FILEEXIST.
Read More
Tags SQLServer, SQLServer2017, TSQL

June 20, 2017
SQL Server 2017 - sys.query_store_wait_stats
by BF(Senior MSSQL Operations - Enterprise, Cloud, Strategy)
New in SQL Server 2017, it contains information about the Wait Stats for Queries in the Query Store. Query Store is a great feature to help with performances issues related to Plan changes.
Read More
Tags SQLServer, SQLServer2017, SQLServerQueryStore, TSQL

Future Events
Microsoft Ignite 2017
IT/Dev Connections 2017
SQL Server LIVE! 2017
Popular Tags 
SQLServer141
TSQL83
Azure35
CloudComputing34
SQLServerReplication32
AzureSQLDatabase19
Powershell17
SQLServerPerformance16
SQLServerReplicationMonitor15
SQLServer201611
AzureVirtualMachine10
SQLServerHealthCheck10
QueryTuning7
ExtendedEvents7
ReportingServices6
SQLServerAlwaysOn6
SQLServerAgent5
SQLServerManagementStudio5
SQLServer20175
SQLServer20084
WindowsServer20084
WindowsFailoverCluster4
IntegrationServices4
DMVs4
ProcedureCache4
Pinned Posts
T-SQL - Constants vs Parameters vs Local Variables - Execution Plans, Statistics, Assumptions
SQL Server - File IO - Sizes, Usage, Stats - Write(Insert) vs Read(Select)
Azure Virtual Machines running SQL Server 2016 STD AlwaysON Availability Groups w/ Transactional Replication
T-SQL Transform Row Data into Columns using PIVOT
List all SQL Server Reporting Services Subscriptions
Calculate RTO(Recovery Time Objective) in AlwaysON Availability Groups
T-SQL Get Maximum Value from a list of Columns Values
SQL Server 2016 Compress() & Decompress()
JSON in SQL Server 2016
Temporal Tables in SQL Server 2016
T-SQL Merge
T-SQL Pivot Data
T-SQL - Recursive CTE's
T-SQL - Extract out the Date within File Names
Find out when an AlwaysOn Availability Group Failover occurred


©2015 www.TechDevOps.com; Contact us: info@techdevops.com


Website Disclaimer: TechDevOps.com(website, owners, authors, affiliates) is not responsible for, and expressly disclaims all liability for, damages of any kind arising out of use, reference to, or reliance on any information, products, services, graphics, videos or any content contained within the website. TechDevOps.com is not responsible for the accuracy of content provided as it is informational purposes only with no warranties and confers no rights. Any reliance you place on such content is therefore strictly at your own risk. TechDevOps.com contains links to other websites which it is not responsible for the information or privacy policies of those sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them.