Users: 30k; Pages Per Session: 2.5pg; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}



LATEST...

April 21, 2018

Monitor real-time query progress using sys.dm_exec_query_profiles DMV
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Use this DMV to determine which part of the query is running slow.
Read More
Tags DMVs, QueryTuning, SQLServer, SQLServerPerformance, TSQL
April 17, 2018

Disk Performance on Azure Virtual Machine - storflt driver
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Virtual machines (VMs) that are running Windows Server 2012 R2
Read More
Tags AzureStorage, AzureVirtualMachine, CloudComputing
April 16, 2018

Find the Authentication scheme(SQL Server or Windows Authentication) used with all connections.
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_exec_connections
Read More
Tags SQLServer
April 13, 2018

Automate XCOPY of Database Data & Log Files
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Useful for SQL Server Database Migrations that use DETACH & ATTACH process
Read More
Tags SQLServer, TSQL
April 10, 2018

The term 'New-AzureStorageContext' is not recognized as the name of a cmdlet, function, script file, or operable program.
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SQLPS.exe, New-AzureStorageContext, Get-AzureStorageBlob, Remove-AzureStorageBlob
Read More
Tags Azure, AzureStorage, CloudComputing, Powershell, SQLServer, SQLServerAgent
March 23, 2018

Using Microsoft Data Migration Assistant and Extended Events to capture any Deprecated Features
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sqlserver.deprecation_announcement, sqlserver.deprecation_final_support
Read More
Tags AzureSQLDatabase, AzureVirtualMachine, CloudComputing, ExtendedEvents, SQLServer, TSQL
March 22, 2018

Using Extended Events to capture failed logins
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Enter Short Description Here
Read More
Tags ExtendedEvents, SQLServer, TSQL
March 10, 2018

Using Extended Events to capture Stored Procedure calls, Log & Extract Duration Buckets of % and/or #
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
CREATE EVENT SESSION, ADD EVENT, ADD TARGET
Read More
Tags ExtendedEvents, SQLServer, SQLServerHealthCheck, SQLServerPerformance, TSQL
March 7, 2018

Find out which Connections are using the highest network bandwidth from SQL Server
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
DMVs
Read More
Tags SQLServer, SQLServerHealthCheck
March 3, 2018

Automated Report for any Database Restores occurring on an SQL Server Instance
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
HTML Report, Database Mail
Read More
Tags SQLServer
Future Events
DevIntersection 2018
Microsoft Ignite 2018
IT/Dev Connections 2018
Popular Tags
SQLServer
TSQL
CloudComputing
Azure
SQLServerReplication
SQLServerHealthCheck
SQLServerPerformance
AzureSQLDatabase
Powershell
AzureVirtualMachine
SQLServerReplicationMonitor
SQLServer2016
Metrics
SQLServerAlwaysOn
QueryTuning
ExtendedEvents
SQLServerTransactionLog
SQLServerAgent
ReportingServices
SQLServerManagementStudio
DMVs
AzureStorage
SQLServer2017
WindowsFailoverCluster
IntegrationServices
Pinned Posts
Create a Microsoft SQL Server Audit Report using Powershell
SQL Space Monitor - Version 2
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



©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.