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






November 18, 2017

Enable or Disable All SQL Jobs
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
MSDB..sysjobs
Read More
Tags TSQL
November 9, 2017

T-SQL - Query all SQL Server Error Log Files
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
xp_enumerrorlogs
Read More
Tags TSQL
November 8, 2017

T-SQL - Check Statistics Last Updated and Update All Statistics
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.stats, sys.stats_columns, sys.columns, sys.partitions, sys.objects
Read More
Tags TSQL
November 8, 2017

T-SQL - Find Missing Indexes - incl. Improvement Measure and Avg User Impact
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_db_missing_index_group, sys.dm_db_missing_index_group_stats, sys.dm_db_missing_index_details
Read More
Tags TSQL
September 26, 2017

T-SQL Index & Heap Space plus Rolled Up Table Space
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.tables, sys.schemas, sys.indexes, sys.partition, sys.allocation_units
Read More
Tags TSQL
September 9, 2017

SQL Replication Monitor
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Captures, Logs, Alerts & Reports for Microsoft SQL Server Transaction Replication Distribution Metrics.
Read More
Tags TSQL
August 30, 2017

Get Number of Microsoft Systems Center (SCOM) Events Per ComputerName
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
EventallView
Read More
Tags TSQL
August 25, 2017

T-SQL Get SQL Server Transaction Log Backup Size (or Database Backup Size)
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
MSDB..backupset
Read More
Tags TSQL
August 22, 2017

Transaction Log Large File Size
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
800+GB Transaction Log File
Read More
Tags TSQL
August 18, 2017

SQL Server Database Transaction Log Backups - Activity-based (vs Time-based)
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_db_log_stats
Read More
Tags TSQL
August 18, 2017

T-SQL - Get Stored Procedure Created and Modified Dates
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.objects, INFORMATION_SCHEMA.ROUTINES
Read More
Tags TSQL
August 17, 2017

Get Number of Microsoft Systems Center (SCOM) Monitor's State changes
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
StateChangeEvent, State, MonitorView, ManagedType
Read More
Tags TSQL
July 30, 2017

T-SQL - Get Logins Connect Permissions
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.server_principals, sys.server_permissions, sys.sql_logins
Read More
Tags TSQL
July 29, 2017

T-SQL - Get SQL Server Up-Time - Services, SysProcesses & TempDB
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_server_services, sysprocesses, sys.databases
Read More
Tags TSQL
July 26, 2017

T-SQL - Get list of Indexes with Fillfactor less than 90 (incl: #Pages, #Rows, % Fillfactor, % Fragmentation)
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_db_index_physical_stats, sys.indexes
Read More
Tags TSQL
July 24, 2017

T-SQL - Get Tables, Fields & Data Types
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.columns, sys.objects, sys.types
Read More
Tags TSQL
July 23, 2017

T-SQL - sp_clean_db_free_space
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Removes residual information left on database pages because of data modification routines in SQL Server.
Read More
Tags TSQL
July 21, 2017

T-SQL Get Database Backups Throughput
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
msdb.dbo.backupset, msdb.dbo.backupmediafamily
Read More
Tags TSQL
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 TSQL
July 12, 2017

SQL Space Monitor - Version 2
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 TSQL
July 8, 2017

SQL Space Monitor - Version 1
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.database, sys.master_files, sys.data_spaces, sys.dm_os_volume_stats
Read More
Tags 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 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 TSQL
June 28, 2017

Auditing SQL Server Systems - Logins
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sp_readerrorlog, sp_helptext
Read More
Tags 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 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 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 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 TSQL
June 19, 2017

sp_configure - RECONFIGURE or RECONFIGURE WITH OVERRIDE
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SQL Server Configuration options are available to manage via SQL Server Management Studio Application (SSMS) or sp_configure stored procedure...
Read More
Tags TSQL
June 14, 2017

T-SQL Get Permissions for a Role
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.database_principals, sys.database_permissions, sys.schemas, sys.objects
Read More
Tags TSQL
June 7, 2017

sp_server_diagnostics
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Captures diagnostic data and health information about SQL Server to detect potential failures. The procedure runs in repeat mode and sends results periodically.
Read More
Tags TSQL
June 7, 2017

Transactional Replication Monitoring - SQL Job Perspective - Last Run Time and Run Status
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
This query returns all Replication SQL Jobs and reports on it's Last Run Time and Run Status...
Read More
Tags TSQL
June 5, 2017

Capture Microsoft SQL Server Waits Stats
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_os_wait_stats - Returns information about all the waits encountered by threads that executed. Use this aggregated view to diagnose performance issues with SQL Server and also with specific queries and batches.
Read More
Tags TSQL
June 3, 2017

T-SQL List Database or Log Backups
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Backupset - Contains a row for each backup set. A backup set contains the backup from a single, successful backup operation. Backupmediafamily - Contains one row for each media family.
Read More
Tags TSQL
May 31, 2017

How to Monitor Log Shipping in SQL Server
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Log shipping allows you to automatically send transaction log backups from a PRI DB on a PRI Server to one or more SEC DB(s) on separate SEC Server(s)...
Read More
Tags TSQL
May 29, 2017

T-SQL Getdate as Integer
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
With Time, With Uniqueidentifier
Read More
Tags TSQL
May 12, 2017

Log Reader Agent not starting after AlwaysON Availability Groups Failover
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
During recent testing of a new Microsoft Azure Cloud setup of SQL Server 2016 Standard running Always On Availability Groups Basic...
Read More
Tags TSQL
April 11, 2017

T-SQL - Constants vs Parameters vs Local Variables - Execution Plans, Statistics, Assumptions
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Procedure Cache, Parameter Sniffing, SSMS Compare Execution Plans Tool, SSMS Live Execution Plan Tool
Read More
Tags TSQL
March 30, 2017

SQL Server - File IO - Sizes, Usage, Stats - Write(Insert) vs Read(Select)
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SSMS, Process Monitor
Read More
Tags TSQL
March 29, 2017

SQL Server Database Mail - Success, Failure, Logs, Config
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
msdb.dbo.sysmail_sentitems, msdb.dbo.sysmail_faileditems, msdb.dbo.sysmail_event_log, msdb.dbo.sysmail_configuration
Read More
Tags TSQL
March 16, 2017

Microsoft SQL Server Replication - Distribution - CmdsPerSec Delivery Rate Dropped
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Distribution.dbo.MSdistribution_history
Read More
Tags TSQL
February 2, 2017

T-SQL Transform Row Data into Columns using PIVOT
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Example - Transactional Replication Pending Commands
Read More
Tags TSQL
January 27, 2017

List all SQL Server Reporting Services Subscriptions
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SQL Server Reporting Services(SSRS) is a Microsoft solution that provides customers with the ability to create, publish and manage reports...
Read More
Tags TSQL
January 27, 2017

SQL Server Get Latest Database or Log Backup History
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
DB, Log, Diff
Read More
Tags TSQL
January 18, 2017

Calculate RTO(Recovery Time Objective) in AlwaysON Availability Groups
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.dm_hadr_availability_replica_cluster_nodes, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.dm_hadr_database_replica_states, sys.availability_replicas
Read More
Tags TSQL
January 12, 2017

T-SQL Get Maximum Value from a list of Columns Values
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
VALUES Clause...
Read More
Tags TSQL
January 3, 2017

DBCC CLONEDATABASE
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Generates a Schema and Statistics only copy...
Read More
Tags TSQL
January 1, 2017

SQL Server 2016 Compress() & Decompress()
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Built-in T-SQL functions in SQL Server 2016
Read More
Tags TSQL
December 30, 2016

JSON in SQL Server 2016
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
JSON_VALUE, JSON_QUERY, JSON_MODIFY, OPENJSON, FOR JSON
Read More
Tags TSQL
December 27, 2016

Temporal Tables in SQL Server 2016
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
A new type of user table in SQL Server 2016
Read More
Tags TSQL
December 17, 2016

T-SQL Merge
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Inserting, Updating, and Deleting Data by Using MERGE
Read More
Tags TSQL
December 17, 2016

T-SQL Pivot Data
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Pivoting the data based on a column values
Read More
Tags TSQL
December 13, 2016

Reseed Identity Column in a SQL Server Table
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
IDENTITY, DBCC CHECKIDENT
Read More
Tags TSQL
December 13, 2016

SQL Server Schema Change History
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.traces, fn_trace_gettable, fn_dblog, SSMS Report
Read More
Tags TSQL
December 9, 2016

T-SQL - Recursive CTE's
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Generate a List of Numbers, Generate a List of dates(DATEFROMPARTS, EOMONTH, MAXRECURSION), Navigate a Hierarchy
Read More
Tags TSQL
December 8, 2016

Add a new Article to an existing Publication in Transactional Replication (Push Subscription) using T-SQL
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sp_helppublication, sp_helpsubscription, sp_addarticle, sp_addsubscription
Read More
Tags TSQL
December 6, 2016

Retrieving the input buffer in SQL Server 2016 using the new Dynamic Management Function - sys.dm_exec_input_buffer
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Functionally equivalent to DBCC INPUTBUFFER
Read More
Tags TSQL
December 6, 2016

T-SQL Delete Duplicate Records
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
CTE, Row_Number(), Over(Partition by)
Read More
Tags TSQL
December 5, 2016

T-SQL Create a Distinct Comma Separated List of Postal Codes
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
COALESCE
Read More
Tags TSQL
December 5, 2016

T-SQL - Extract out the Date within File Names
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SUBSTRING Function w/ PATINDEX(Pattern Index Function) and a REGEX(Regular Expression)
Read More
Tags TSQL
November 29, 2016

Microsoft SQL Server Replication - Log Reader Agent - History, Status & Configuration
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
MSlogreader_history, MSlogreader_agents, sp_replcmds
Read More
Tags TSQL
November 4, 2016

T-SQL Get Replication Distribution History Errors
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
MSdistribution_history, MSdistribution_agents
Read More
Tags TSQL
October 15, 2016

T-SQL Analytic Functions FIRST_VALUE(), LAST_VALUE(), LEAD(), LAG()
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Analytic functions compute an aggregate value based on a group of rows. However, unlike aggregate functions, they can return multiple rows for each group.
Read More
Tags TSQL
October 15, 2016

T-SQL Ranking Functions ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE()
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Ranking functions return a ranking value for each row in a partition
Read More
Tags TSQL
October 13, 2016

T-SQL Get Total Database Size
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.databases, sys.master_files
Read More
Tags TSQL
October 7, 2016

Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object...
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
OPENQUERY
Read More
Tags TSQL
October 6, 2016

Azure SQL Database Geo-Replication Logins and Users Configuration
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Create Login, Create User, sys.sql_logins , sys.database_principals
Read More
Tags TSQL
October 3, 2016

Azure SQL Database Geo-Replication - Initiate a Failover using T-SQL
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Alter Database FAILOVER, sys.dm_geo_replication_link_status, sys.dm_operation_status
Read More
Tags TSQL
September 9, 2016

SQL Server List all Tables with no Primary Key
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
information_schema.tables, sys.tables, replication
Read More
Tags TSQL
September 2, 2016

T-SQL SET PARSEONLY ON vs SET NOEXEC ON vs SET FMTONLY ON
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Parsing T-SQL Statements
Read More
Tags TSQL
August 28, 2016

Use Extended Events to capture Deadlocks in SQL Server
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Histogram, XQuery
Read More
Tags TSQL
August 22, 2016

T-SQL Log Long Running Open Transactions
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Transaction Log Size, Number of VLF(Virtual Log Files), Connection Details
Read More
Tags TSQL
August 10, 2016

Transactional Replication - Out of Synchronization
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SkipErrors, Validate Subscriptions
Read More
Tags TSQL
July 20, 2016

SQL Server Replication Get Undistributed Commands
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Distribution.sys.sp_MSget_repl_commands
Read More
Tags TSQL
July 17, 2016

SQL Server Distribution Agent is retrying after an error
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Transactional Replication, Distribution.dbo.MSdistribution_history, Distribution Retention Period
Read More
Tags TSQL
July 14, 2016

View Microsoft SQL Server Replication Publication details
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Publication Name, Publication DB, Article Name, Distribution Name, Subscriber Name, Subscriber DB
Read More
Tags TSQL
June 30, 2016

How to prevent schema changes to tables configured for SQL Server Replication
by PC
Database-level Trigger
Read More
Tags TSQL
June 29, 2016

T-SQL Check the last X days for any SQL Agent Job steps that were retried
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
MSDN function dbo.agent_datetime for Date & Time, Filter out Replication Jobs
Read More
Tags TSQL
June 28, 2016

T-SQL Stuff() vs Replace()
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Transact-SQL Functions
Read More
Tags TSQL
June 22, 2016

Capture Slow Stored Procedure Calls in Microsoft SQL Server using Extended Events
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sqlserver.rpc_completed
Read More
Tags TSQL
June 10, 2016

TechDevOps.com shared a Session - "SQL Server Index Internals: A Deep Dive (Tim Chapman; Microsoft)"
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
PASS
Read More
Tags TSQL
May 9, 2016

T-SQL Cross Apply vs Derived Table vs Subquery
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Enter Short Description Here
Read More
Tags TSQL
April 13, 2016

Rebuild Indexes based on Fragmentation Percent
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
T-SQL, Alter Index
Read More
Tags TSQL
February 5, 2016

T-SQL Query Tuning - Statistics, Histogram, Density, Selectivity & Cardinality
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
DBCC Show_Statistics, Set Statistics Profile, Set Statistics IO, Set Statistics Time, sp_updatestats, DBCC dropcleanbuffers, DBCC freeproccache
Read More
Tags TSQL
December 23, 2015

T-SQL subtract current row value from previous row value
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
LAG (Transact-SQL)
Read More
Tags TSQL
November 23, 2015

View Microsoft SQL Server Reporting Services Report Server Logs
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Report Server Execution Log and the ExecutionLog3 View
Read More
Tags TSQL
November 8, 2015

Determine the progress of Microsoft SQL Server Backup or Restore
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Using T-SQL get the Total Elapsed Time, Percentage Completed & Estimated Completion Time...
Read More
Tags TSQL
November 7, 2015

Microsoft Azure Blob Storage Service as a backup destination
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Requires Storage Account, Container & Credential
Read More
Tags TSQL
November 2, 2015

Create an Extended Events session - Azure SQL Database
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sqlserver.sql_batch_completed, ring_buffer
Read More
Tags TSQL
November 2, 2015

Create an Extended Events session - On-Prem
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sqlserver.rpc_completed, sqlserver.sql_batch_completed, ring_buffer
Read More
Tags TSQL
November 1, 2015

Microsoft SQL Server Query Testing Tool
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
SQLQueryStress by http://www.datamanipulation.net/
Read More
Tags TSQL
October 12, 2015

List your SQL Server Replication Topology using T-SQL
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Distributor, Publisher, Publications & Subscribers
Read More
Tags TSQL
October 7, 2015

Find hidden characters in a SQL Server table data
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Using ASCII (Transact-SQL)
Read More
Tags TSQL
August 6, 2015

List information about all SQL Server Databases & Files
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
sys.master_files, sys.databases
Read More
Tags TSQL
August 5, 2015

SQL Server Connections - Schedulers, Threads, Workers, Tasks, Requests, Sessions, Connections, Users
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Along with sys.messages & other resources
Read More
Tags TSQL
August 4, 2015

Find the DateDiff between separate log records with starttime and endtime
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
T-SQL query
Read More
Tags TSQL
August 2, 2015

Find a stored procedure call within a SQL Server Job
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Using T-SQL, find a stored procedure call within a SQL Server Job step(s)
Read More
Tags TSQL
June 28, 2015

T-SQL - Find Lead Blocking SPID
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Use T-SQL to find the lead blocking SPID and it's INPUTBUFFER contents.
Read More
Tags TSQL
June 28, 2015

Hash Lookup/Static Table Contents
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
T-SQL Solution for Hashing Lookup Table records in a Microsoft SQL Server Database. Required for data level Change Detection/Control implementations.
Read More
Tags TSQL
June 28, 2015

Use T-SQL to log Active SPID Execution Duration
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Use T-SQL to capture, filter & log Active SPID Execution Duration for all active requests inside the Microsoft SQL Server Engine.
Read More
Tags TSQL
June 21, 2015

Concatenate Row Values using T-SQL
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
Concatenate Row Values in SQL Server using T-SQL's FOR XML and STUFF function.
Read More
Tags TSQL
Future Events
SQL Server LIVE! 2017
Popular Tags
SQLServer
TSQL
Azure
CloudComputing
SQLServerReplication
AzureSQLDatabase
SQLServerHealthCheck
SQLServerPerformance
Powershell
SQLServerReplicationMonitor
AzureVirtualMachine
SQLServer2016
Metrics
QueryTuning
ExtendedEvents
SQLServerManagementStudio
SQLServerAgent
ReportingServices
SQLServerTransactionLog
SQLServerAlwaysOn
SQLServer2017
IntegrationServices
WindowsServer2008
WindowsFailoverCluster
SQLServer2008
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