| February 3, 2024 |
|
|
|
| November 4, 2023 |
|
|
|
| October 24, 2023 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.tables, sys.indexes, sys.index_columns, sys.columns
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| October 5, 2023 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sysdatabases, backupset, backupmediaset, backupmediafamily
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| October 1, 2023 |
|
|
|
| July 23, 2023 |
|
|
|
| April 23, 2023 |
|
|
|
| January 10, 2023 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.query_store_plan, sys.query_store_query, sys.query_store_query_text, sys.query_store_runtime_stats
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerQueryStore, TSQL
|
|
|
| December 4, 2022 |
|
|
|
| November 13, 2022 |
|
|
|
| October 8, 2022 |
|
|
|
| September 12, 2022 |
|
|
|
| July 6, 2022 |
|
|
|
| June 20, 2022 |
|
|
|
| May 20, 2022 |
|
|
|
| May 10, 2022 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.tables, sys.columns, sys.types, sys.partitions
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| May 8, 2022 |
|
|
|
| March 10, 2022 |
|
|
|
| February 16, 2022 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Column Statistics and Index Statistics
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| February 8, 2022 |
|
|
|
| January 3, 2022 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.indexes, sys.dm_db_index_usage_stats, sys.dm_db_partition_stats
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| October 11, 2021 |
|
|
|
| September 5, 2021 |
|
|
|
| July 17, 2021 |
|
|
|
| April 4, 2021 |
|
|
|
| January 23, 2021 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
availability_replicas, dm_hadr_database_replica_cluster_states, dm_hadr_database_replica_states, dm_hadr_availability_replica_states
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerAlwaysOn
|
|
|
| November 28, 2020 |
|
|
|
| October 31, 2020 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.availability_groups_cluster, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.availability_group_listeners, sysjobs
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerAlwaysOn, TSQL
|
|
|
| September 1, 2020 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.dm_io_pending_io_requests
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| June 20, 2020 |
|
|
|
| May 12, 2020 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.availability_groups_cluster, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.availability_group_listeners
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
JDE E1, SQLServer, SQLServerAlwaysOn, TSQL
|
|
|
| January 10, 2020 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
A game changer in terms of features + price from the other tools in the marketplace.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| December 28, 2019 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Automated refresh with Transaction Log backups and deliver current Production Databases for D.R. requirements.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| October 7, 2019 |
|
|
|
| August 26, 2019 |
|
|
|
| July 14, 2019 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
msdb.dbo.sysjobservers, msdb.dbo.sysjobs
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| May 24, 2019 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
SQL Server VAS (Virtual Address Space)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| May 3, 2019 |
|
|
|
| April 16, 2019 |
|
|
|
| April 2, 2019 |
|
|
|
| February 28, 2019 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
ALTER TRIGGER [DropDatabaseNotifier] ON ALL SERVER FOR DROP_DATABASE
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, Trigger
|
|
|
| February 15, 2019 |
|
|
|
| January 30, 2019 |
|
|
|
| January 21, 2019 |
|
|
|
| January 15, 2019 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Bitwise operators perform bit manipulations between two expressions of any of the data types of the integer data type category...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| January 10, 2019 |
|
|
|
| December 18, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
DBCC DBINFO
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| December 6, 2018 |
|
|
|
| December 4, 2018 |
|
|
|
| December 3, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Alter Database tempdb Modify File
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| December 3, 2018 |
|
|
|
| November 23, 2018 |
|
|
|
| November 23, 2018 |
|
|
|
| November 23, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.objects, sys.database_permissions, sys.database_principals
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| November 22, 2018 |
|
|
|
| November 20, 2018 |
|
|
|
| November 18, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
MSdistribution_agents, MSdistribution_status, MSARTICLES, SYS.Servers, MSagent_profiles
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerReplication
|
|
|
| November 18, 2018 |
|
|
|
| November 2, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
msdb.dbo.restorehistory, msdb.dbo.backupset, msdb.dbo.backupmediaset, msdb.dbo.backupmediafamily
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerLogShipping
|
|
|
| November 1, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Alter Database Remove File
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| October 31, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
msdb.dbo.backupset, msdb.dbo.backupmediaset, msdb.dbo.backupmediafamily
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| October 27, 2018 |
|
|
|
| October 19, 2018 |
|
|
|
| October 17, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sp_cycle_errorlog, sp_cycle_agent_errorlog
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| October 12, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.dm_db_index_usage_stats
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| October 6, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Enter Short Description Here
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| September 26, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
msdb.dbo.sysjobs, msdb.dbo.sysjobactivity
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| September 15, 2018 |
|
|
|
| September 4, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
SQL_Handle, Plan_Handle, Query_Hash, Query_Plan_Hash, Query Cache Statistics, Plan Attributes
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| August 22, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
dbo.sp_validate_redirected_publisher, dbo.sp_Validate_Replica_Hosts_As_Publishers, dbo.MSRedirected_Publishers
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerAlwaysOn, TSQL
|
|
|
| August 14, 2018 |
|
|
|
| July 5, 2018 |
|
|
|
| June 21, 2018 |
|
|
|
| June 19, 2018 |
|
|
|
| June 17, 2018 |
|
|
|
| June 13, 2018 |
|
|
|
| June 6, 2018 |
|
|
|
| June 5, 2018 |
|
|
|
| June 4, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
EXEC ReportServer.dbo.AddEvent @EventType='TimedSubscription',@EventData=''
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
ReportingServices, SQLServer
|
|
|
| May 22, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
[MASTER].sys.Servers, [MASTER].sys.linked_logins, [MASTER].sys.server_principals
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
DataMigration, SQLServer, TSQL
|
|
|
| May 20, 2018 |
|
|
|
| May 18, 2018 |
|
|
|
| May 18, 2018 |
|
|
|
| May 14, 2018 |
|
|
|
| May 6, 2018 |
|
|
|
| April 29, 2018 |
|
|
|
| April 28, 2018 |
|
|
|
| April 28, 2018 |
|
|
|
| April 28, 2018 |
|
|
|
| April 21, 2018 |
|
|
|
| April 17, 2018 |
|
|
|
| April 16, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.dm_exec_connections
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| April 13, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Useful for SQL Server Database Migrations that use DETACH & ATTACH process
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
DataMigration, SQLServer, TSQL
|
|
|
| April 10, 2018 |
|
|
|
| March 23, 2018 |
|
|
|
| March 22, 2018 |
|
|
|
| March 10, 2018 |
|
|
|
| March 7, 2018 |
|
|
|
| March 3, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
HTML Report, Database Mail
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| February 24, 2018 |
|
|
|
| February 13, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Find the Head / Lead Blockers to eliminate/lower your rate of Blocking
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| February 11, 2018 |
|
|
|
| February 2, 2018 |
|
|
|
| January 28, 2018 |
|
|
|
| January 23, 2018 |
|
|
|
| January 22, 2018 |
|
|
|
| January 19, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Check if SQL Server Native Client can support TLS 1.2, Check if Microsoft ODBC Driver for SQL Server can support TLS 1.2
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Powershell, SQLServer
|
|
|
| January 9, 2018 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Captures, Logs, Alerts & Reports for Microsoft SQL Server Always On Availability Groups Metrics.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerAlwaysOn
|
|
|
| December 18, 2017 |
|
|
|
| December 12, 2017 |
|
|
|
| December 12, 2017 |
|
|
|
| December 12, 2017 |
|
|
|
| December 11, 2017 |
|
|
|
| December 9, 2017 |
|
|
|
| December 3, 2017 |
|
|
|
| December 2, 2017 |
|
|
|
| November 30, 2017 |
|
|
|
| November 29, 2017 |
|
|
|
| November 29, 2017 |
|
|
|
| November 24, 2017 |
|
|
|
| November 23, 2017 |
|
|
|
| November 18, 2017 |
|
|
|
| November 17, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.dm_operation_status - Returns information about operations performed on databases in a Azure SQL Database server.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Azure, AzureSQLDatabase, SQLServer
|
|
|
| November 9, 2017 |
|
|
|
| November 8, 2017 |
|
|
|
| November 8, 2017 |
|
|
|
| October 4, 2017 |
|
|
|
| September 26, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.tables, sys.schemas, sys.indexes, sys.partition, sys.allocation_units
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| September 9, 2017 |
|
|
|
| August 30, 2017 |
|
|
|
| August 29, 2017 |
|
|
|
| August 28, 2017 |
|
|
|
| August 25, 2017 |
|
|
|
| August 24, 2017 |
|
|
|
| August 22, 2017 |
|
|
|
| August 18, 2017 |
|
|
|
| August 18, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.objects, INFORMATION_SCHEMA.ROUTINES
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| August 17, 2017 |
|
|
|
| July 31, 2017 |
|
|
|
| July 30, 2017 |
|
|
|
| July 29, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.dm_server_services, sysprocesses, sys.databases
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| July 26, 2017 |
|
|
|
| July 24, 2017 |
|
|
|
| July 23, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Removes residual information left on database pages because of data modification routines in SQL Server.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| July 21, 2017 |
|
|
|
| July 19, 2017 |
|
|
|
| July 12, 2017 |
|
|
|
| July 8, 2017 |
|
|
|
| July 5, 2017 |
|
|
|
| June 30, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.objects, sys.partitions, sys.allocation_units, sys.indexes, sys.dm_os_buffer_descriptors
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Metrics, SQLServer, SQLServerArchitecture, SQLServerHealthCheck, SQLServerMemory, SQLServerPerformance, TSQL
|
|
|
| June 28, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sp_readerrorlog, sp_helptext
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| June 25, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
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 |
|
|
|
| June 23, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
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 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
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
|
|
|
| June 19, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
SQL Server Configuration options are available to manage via SQL Server Management Studio Application (SSMS) or sp_configure stored procedure...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| June 18, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
A facet is a collection of properties that describe some functionality of SQL Server related to an area of Management. For example, some common facets are Database, Login & Server Security.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServer2016, SQLServerManagementStudio
|
|
|
| June 18, 2017 |
|
|
|
| June 14, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.database_principals, sys.database_permissions, sys.schemas, sys.objects
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| June 7, 2017 |
|
|
|
| June 7, 2017 |
|
|
|
| June 5, 2017 |
|
|
|
| June 3, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
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
SQLServer, SQLServerAgent, SQLServerLogShipping, TSQL
|
|
|
| June 2, 2017 |
|
|
|
| May 31, 2017 |
|
|
|
| May 29, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
With Time, With Uniqueidentifier
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| May 16, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
During a Migration Project for SQL Server Reporting Services 2014 to 2016 we ran into some errors with bringing online...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
ReportingServices, SQLServer2016
|
|
|
| May 12, 2017 |
|
|
|
| April 11, 2017 |
|
|
|
| March 30, 2017 |
|
|
|
| March 29, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
msdb.dbo.sysmail_sentitems, msdb.dbo.sysmail_faileditems, msdb.dbo.sysmail_event_log, msdb.dbo.sysmail_configuration
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerDatabaseMail, TSQL
|
|
|
| March 26, 2017 |
|
|
|
| March 16, 2017 |
|
|
|
| February 27, 2017 |
|
|
|
| February 21, 2017 |
|
|
|
| February 17, 2017 |
|
|
|
| February 7, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
The template deployment is not valid according to the validation procedure. Deploying template using PowerShell script failed.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Azure, CloudComputing, JSON
|
|
|
| February 2, 2017 |
|
|
|
| January 27, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
SQL Server Reporting Services(SSRS) is a Microsoft solution that provides customers with the ability to create, publish and manage reports...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
ReportingServices, SQLServer, TSQL
|
|
|
| January 27, 2017 |
|
|
|
| January 18, 2017 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
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
SQLServer, SQLServerAlwaysOn, TSQL
|
|
|
| January 15, 2017 |
|
|
|
| January 12, 2017 |
|
|
|
| January 3, 2017 |
|
|
|
| January 1, 2017 |
|
|
|
| December 30, 2016 |
|
|
|
| December 27, 2016 |
|
|
|
| December 17, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Inserting, Updating, and Deleting Data by Using MERGE
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| December 17, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Pivoting the data based on a column values
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| December 15, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
SQL Server Service Pack(s), Registry Key
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| December 13, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
IDENTITY, DBCC CHECKIDENT
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| December 13, 2016 |
|
|
|
| December 10, 2016 |
|
|
|
| December 9, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Generate a List of Numbers, Generate a List of dates(DATEFROMPARTS, EOMONTH, MAXRECURSION), Navigate a Hierarchy
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| December 8, 2016 |
|
|
|
| December 6, 2016 |
|
|
|
| December 6, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
CTE, Row_Number(), Over(Partition by)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| December 5, 2016 |
|
|
|
| December 5, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
SUBSTRING Function w/ PATINDEX(Pattern Index Function) and a REGEX(Regular Expression)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| December 1, 2016 |
|
|
|
| November 29, 2016 |
|
|
|
| November 19, 2016 |
|
|
|
| November 10, 2016 |
|
|
|
| November 4, 2016 |
|
|
|
| October 15, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
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
SQLServer, TSQL
|
|
|
| October 15, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Ranking functions return a ranking value for each row in a partition
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| October 13, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.databases, sys.master_files
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| October 7, 2016 |
|
|
|
| October 6, 2016 |
|
|
|
| October 3, 2016 |
|
|
|
| October 3, 2016 |
|
|
|
| September 29, 2016 |
|
|
|
| September 26, 2016 |
|
|
|
| September 19, 2016 |
|
|
|
| September 18, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Use Javascript statements and Console commands while a page is live in the browser
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
DOM, HTML, HTML5
|
|
|
| September 17, 2016 |
|
|
|
| September 9, 2016 |
|
|
|
| September 7, 2016 |
|
|
|
| September 6, 2016 |
|
|
|
| September 3, 2016 |
|
|
|
| September 2, 2016 |
|
|
|
| August 28, 2016 |
|
|
|
| August 24, 2016 |
|
|
|
| August 22, 2016 |
|
|
|
| August 10, 2016 |
|
|
|
| July 27, 2016 |
|
|
|
| July 20, 2016 |
|
|
|
| July 17, 2016 |
|
|
|
| July 14, 2016 |
|
|
|
| July 11, 2016 |
|
|
|
| July 3, 2016 |
|
|
|
| June 29, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
MSDN function dbo.agent_datetime for Date & Time, Filter out Replication Jobs
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerAgent, TSQL
|
|
|
| June 28, 2016 |
|
|
|
| June 22, 2016 |
|
|
|
| June 20, 2016 |
|
|
|
| June 15, 2016 |
|
|
|
| June 15, 2016 |
|
|
|
| June 10, 2016 |
|
|
|
| June 1, 2016 |
|
|
|
| May 31, 2016 |
|
|
|
| May 19, 2016 |
|
|
|
| May 16, 2016 |
|
|
|
| May 15, 2016 |
|
|
|
| May 9, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Enter Short Description Here
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| May 6, 2016 |
|
|
|
| May 3, 2016 |
|
|
|
| April 29, 2016 |
|
|
|
| April 27, 2016 |
|
|
|
| April 26, 2016 |
|
|
|
| April 13, 2016 |
|
|
|
| April 6, 2016 |
|
|
|
| April 5, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
New-PSSession, Invoke-Command, Get-Process, Remove-PSSession
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Powershell
|
|
|
| April 5, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
help about_remote -ShowWindow
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Powershell
|
|
|
| April 1, 2016 |
|
|
|
| March 31, 2016 |
|
|
|
| March 18, 2016 |
|
|
|
| March 18, 2016 |
|
|
|
| March 18, 2016 |
|
|
|
| March 16, 2016 |
|
|
|
| March 6, 2016 |
|
|
|
| February 8, 2016 |
|
|
|
| February 7, 2016 |
|
|
|
| February 6, 2016 |
|
|
|
| February 5, 2016 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
DBCC Show_Statistics, Set Statistics Profile, Set Statistics IO, Set Statistics Time, sp_updatestats, DBCC dropcleanbuffers, DBCC freeproccache
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
QueryTuning, SQLServer, SQLServerPerformance, TSQL
|
|
|
| January 27, 2016 |
|
|
|
| January 26, 2016 |
|
|
|
| January 20, 2016 |
|
|
|
| January 19, 2016 |
|
|
|
| January 4, 2016 |
|
|
|
| December 23, 2015 |
|
|
|
| December 14, 2015 |
|
|
|
| December 10, 2015 |
|
|
|
| November 26, 2015 |
|
|
|
| November 23, 2015 |
|
|
|
| November 8, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Using T-SQL get the Total Elapsed Time, Percentage Completed & Estimated Completion Time...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| November 7, 2015 |
|
|
|
| November 7, 2015 |
|
|
|
| November 3, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
"During my presentation at Pass Summit 2015, I announced that you can now configure Azure SQL DB as a subscriber of SQL Server Transactional Replication..."
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
AzureSQLDatabase, SQLServer, SQLServerReplication
|
|
|
| November 2, 2015 |
|
|
|
| November 2, 2015 |
|
|
|
| November 1, 2015 |
|
|
|
| November 1, 2015 |
|
|
|
| October 15, 2015 |
|
|
|
| October 12, 2015 |
|
|
|
| October 7, 2015 |
|
|
|
| October 5, 2015 |
|
|
|
| September 27, 2015 |
|
|
|
| September 27, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Includes Code Extractor & Viewer
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|
| September 8, 2015 |
|
|
|
| September 7, 2015 |
|
|
|
| September 6, 2015 |
|
|
|
| August 30, 2015 |
|
|
|
| August 30, 2015 |
|
|
|
| August 24, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Plugin Performance Profiler (P3)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
WordPress
|
|
|
| August 22, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
mysqladmin, processlist
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
MySQL
|
|
|
| August 18, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Ingest and Prepare, Transform and Analyze, Publish and Consume, Monitor and Manage
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Azure, CloudComputing
|
|
|
| August 18, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Message type as text or image
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
ASP.NET
|
|
|
| August 14, 2015 |
|
|
|
| August 12, 2015 |
|
|
|
| August 11, 2015 |
|
|
|
| August 7, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
"Today, we are happy to announce the availability of the Visual Studio Team Foundation Server 2015 RTM (Release to Manufacturing). This is the newest version..."
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TeamFoundationServer, VisualStudio
|
|
|
| August 6, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
sys.master_files, sys.databases
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| August 6, 2015 |
|
|
|
| August 6, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Core Updates, Plugin Updates, Theme Updates, Translation File updates
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
WordPress
|
|
|
| August 7, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Source: www.librato.com - Choosing Metrics that Matter (Beyond CPU/Disk/Network) ... "Imagine for a moment that you have suddenly been promoted from regular old developer to senior architect, and tasked with overseeing the telemetry efforts for all of the engineering teams..."
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Metrics
|
|
|
| August 6, 2015 |
|
|
|
| August 5, 2015 |
|
|
|
| August 5, 2015 |
|
|
|
| August 4, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Adventure Works 2014 sample databases are an upgrade from the 2012 version
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer2014
|
|
|
| August 4, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
T-SQL query
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 3, 2015 |
|
|
|
| August 2, 2015 |
|
|
|
| August 2, 2015 |
|
|
|
| August 2, 2015 |
|
|
|
| August 1, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Using TSQL RESTORE HEADERONLY to obtain the database version & compatability level of the file...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Hosting, SQLServer
|
|
|
| July 3, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
As the biggest leap forward in Microsoft’s data platform history, SQL Server 2016 delivers...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer2016
|
|
|
| July 2, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
MSDN - A Data Collector Set is the building block of performance monitoring and reporting in Windows Performance Monitor....
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, WindowsServer2008
|
|
|
| June 30, 2015 |
|
|
|
| June 28, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Using Linux Commands and MySQL Commands to Automate DB Backups
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Linux, MySQL
|
|
|
| June 28, 2015 |
|
|
|
| June 28, 2015 |
|
|
|
| June 28, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
MSDN: "The HTMLEncode method applies HTML encoding to a specified string. This is useful as a quick method of encoding form data and other client request data before using it in your Web application."
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
VB.NET
|
|
|
| June 28, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
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 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
How to implement a complete solution for SQL Server Replication Publication(s) Validation, Error Logging & Notification
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, SQLServerReplication
|
|
|
| June 28, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Parse a comma-separated string in a VB.BET DataTable, originating from a Microsoft SQL Server table, add HyperLink & re-build the string for insertion back in the DataTable.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
VB.NET
|
|
|
| June 28, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Line breaks may not display when pulled from a SQL Server table to an ASP:DATALIST control. The table record itself contains the line breaks. However, the rendered page does not display them.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
ASP.NET
|
|
|
| June 28, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Use T-SQL to capture, filter & log Active SPID Execution Duration for all active requests inside the Microsoft SQL Server Engine.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer, TSQL
|
|
|
| June 21, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Use Powershell to capture SQL Server Resources - Test Connection, CPU Usage, MEM Usage & Disk Usage.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
Powershell, SQLServer
|
|
|
| June 21, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Concatenate Row Values in SQL Server using T-SQL's FOR XML and STUFF function.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 21, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
Error: Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
ASP.NET, IIS, Website
|
|
|
| June 21, 2015 |
|
|
|
|
by BF (Principal Consultant; Architecture; Engineering)
|
| | | |
|
|
A few years ago I decided to create a Custom Performance Monitoring, Alerting and Diagnostics Web Application Tool for SQL Server product. At the time I was a Senior Microsoft SQL Server DBA managing a large farm installation of Microsoft SQL Server...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
SQLServer
|
|
|