Table of contents



 .NET

  1. .NET - Extend ListControl with GetSelectedItems and GetSelectedValues

 ASP.NET

  1. .NET - Extend ListControl with GetSelectedItems and GetSelectedValues

 Azure

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!

 BINARY

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string

 BLOB

  1. MSSQL: How to read an UTF-8 file (XML or JSON)? - New!

 BULK

  1. MSSQL: How to read an UTF-8 file (XML or JSON)? - New!

 C#

  1. .NET - Extend ListControl with GetSelectedItems and GetSelectedValues

 CHANGE TRACKING

  1. MSSQL - CHANGE TRACKING - How can I get DateTime of changes?

 CSV

  1. MSSQL - Convert list to table #1 (array of numbers in string form)
  2. MSSQL - Convert list to table #2 (array of string items)

 CTE

  1. MSSQL - Function to generate empty rows - New!
  2. MSSQL - How to generate range of Dates - New!

 Chrome

  1. Google Chrome - Managed by your organization - how to remove? - New!
  2. VMware and Chrome - damaged or washed out colors or transparent backgrounds - New!

 DATETIME

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string

 DBCC

  1. MSSQL - How to clear all caches? - New!

 DMV

  1. MSSQL - CHANGE TRACKING - How can I get DateTime of changes?
  2. MSSQL - Very fast method to get statistic (rows and bytes) for all database tables

 DevOps

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!

 EnableRetryOnFailure

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!

 Extensions

  1. .NET - Extend ListControl with GetSelectedItems and GetSelectedValues

 GROUP_CONCAT

  1. MSSQL - Simple GROUP_CONCAT

 GUID

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string
  2. MSSQL - How to get rows in random sort order
  3. MSSQL - The random number generator with a random initialization (random seed)

 HTML

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string

 JavaScript

  1. JavaScript - String Extensions #1 [ isEmpty(), left(), right(), contains(), repeat() ]
  2. JavaScript - String Extensions #2 [ replaceAll() ]
  3. jQuery.log

 ListControl

  1. .NET - Extend ListControl with GetSelectedItems and GetSelectedValues

 LocalDB

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!

 MONEY

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string

 MSSQL

  2. MSSQL - CHANGE TRACKING - How can I get DateTime of changes?
  3. MSSQL - Convert list to table #1 (array of numbers in string form)
  4. MSSQL - Convert list to table #2 (array of string items)
  5. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string
  6. MSSQL - Function to format detailed error message
  7. MSSQL - Function to generate empty rows - New!
  8. MSSQL - How to clear all caches? - New!
  9. MSSQL - How to generate range of Dates - New!
  10. MSSQL - How to get rows in random sort order
  11. MSSQL - How to replicate to readonly database? - New!
  12. MSSQL - Immediately PRINT big messages - more then 8000 bytes (4000 unicode characters)
  13. MSSQL - Kill all my processes (except current)
  14. MSSQL - Performance tuning of Scalar-Value User Defined Functions (UDFs)
  15. MSSQL - Query Templates
  16. MSSQL - Query Templates - GROUP_CONCAT
  17. MSSQL - Query Templates - usage of system tables
  18. MSSQL - Simple GROUP_CONCAT
  19. MSSQL - Stored procedure to replace placeholders in texts (dynamic SQL)
  20. MSSQL - T-SQL equivalent of VBA VAL() function - New!
  21. MSSQL - The random number generator with a random initialization (random seed)
  22. MSSQL - Very fast method to get statistic (rows and bytes) for all database tables
  23. MSSQL: How to read an UTF-8 file (XML or JSON)? - New!
  24. Reduce SSMS startup time - New!

 MSSQLLocalDB

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!

 NEWID

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string
  2. MSSQL - How to get rows in random sort order
  3. MSSQL - The random number generator with a random initialization (random seed)

 OPENROWSET

  1. MSSQL: How to read an UTF-8 file (XML or JSON)? - New!

 Pipeline

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!

 Policy

  1. Google Chrome - Managed by your organization - how to remove? - New!

 RAND

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string
  2. MSSQL - How to get rows in random sort order
  3. MSSQL - The random number generator with a random initialization (random seed)

 RANK

  1. MSSQL - Convert list to table #2 (array of string items)

 ROW_NUMBER

  1. MSSQL - Function to generate empty rows - New!
  2. MSSQL - How to generate range of Dates - New!

 Random

  1. MSSQL - How to get rows in random sort order
  2. MSSQL - The random number generator with a random initialization (random seed)

 SQL

  2. How to add the last version of LocalDB to Azure Devops Pipeline - New!
  3. MSSQL - CHANGE TRACKING - How can I get DateTime of changes?
  4. MSSQL - Convert list to table #1 (array of numbers in string form)
  5. MSSQL - Convert list to table #2 (array of string items)
  6. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string
  7. MSSQL - Function to format detailed error message
  8. MSSQL - Function to generate empty rows - New!
  9. MSSQL - How to clear all caches? - New!
  10. MSSQL - How to generate range of Dates - New!
  11. MSSQL - How to get rows in random sort order
  12. MSSQL - How to replicate to readonly database? - New!
  13. MSSQL - Immediately PRINT big messages - more then 8000 bytes (4000 unicode characters)
  14. MSSQL - Kill all my processes (except current)
  15. MSSQL - Performance tuning of Scalar-Value User Defined Functions (UDFs)
  16. MSSQL - Query Templates
  17. MSSQL - Query Templates - GROUP_CONCAT
  18. MSSQL - Simple GROUP_CONCAT
  19. MSSQL - Stored procedure to replace placeholders in texts (dynamic SQL)
  20. MSSQL - T-SQL equivalent of VBA VAL() function - New!
  21. MSSQL - The random number generator with a random initialization (random seed)
  22. MSSQL - Very fast method to get statistic (rows and bytes) for all database tables

 SQL Server

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!
  2. MSSQL - CHANGE TRACKING - How can I get DateTime of changes?
  3. MSSQL - Convert list to table #1 (array of numbers in string form)
  4. MSSQL - Convert list to table #2 (array of string items)
  5. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string
  6. MSSQL - Function to format detailed error message
  7. MSSQL - Function to generate empty rows - New!
  8. MSSQL - How to clear all caches? - New!
  9. MSSQL - How to generate range of Dates - New!
  10. MSSQL - How to get rows in random sort order
  11. MSSQL - How to replicate to readonly database? - New!
  12. MSSQL - Immediately PRINT big messages - more then 8000 bytes (4000 unicode characters)
  13. MSSQL - Kill all my processes (except current)
  14. MSSQL - Performance tuning of Scalar-Value User Defined Functions (UDFs)
  15. MSSQL - Query Templates
  16. MSSQL - Query Templates - GROUP_CONCAT
  17. MSSQL - Query Templates - usage of system tables
  18. MSSQL - Simple GROUP_CONCAT
  19. MSSQL - Stored procedure to replace placeholders in texts (dynamic SQL)
  20. MSSQL - T-SQL equivalent of VBA VAL() function - New!
  21. MSSQL - The random number generator with a random initialization (random seed)
  22. MSSQL - Very fast method to get statistic (rows and bytes) for all database tables

 SQLLocalDB

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!

 SSMS

  2. MSSQL - How to replicate to readonly database? - New!
  3. MSSQL - Kill all my processes (except current)
  4. MSSQL - Query Templates
  5. MSSQL - Query Templates - GROUP_CONCAT
  6. MSSQL - Query Templates - usage of system tables
  7. MSSQL - Very fast method to get statistic (rows and bytes) for all database tables
  8. Reduce SSMS startup time - New!

 Stored Procedure

  1. MSSQL - How to replicate to readonly database? - New!
  2. MSSQL - Immediately PRINT big messages - more then 8000 bytes (4000 unicode characters)
  3. MSSQL - Stored procedure to replace placeholders in texts (dynamic SQL)

 System Tables

  2. MSSQL - CHANGE TRACKING - How can I get DateTime of changes?
  3. MSSQL - How to replicate to readonly database? - New!
  4. MSSQL - Kill all my processes (except current)
  5. MSSQL - Query Templates - GROUP_CONCAT
  6. MSSQL - Query Templates - usage of system tables
  7. MSSQL - Very fast method to get statistic (rows and bytes) for all database tables

 T-SQL

  2. MSSQL - CHANGE TRACKING - How can I get DateTime of changes?
  3. MSSQL - Convert list to table #1 (array of numbers in string form)
  4. MSSQL - Convert list to table #2 (array of string items)
  5. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string
  6. MSSQL - Function to format detailed error message
  7. MSSQL - How to clear all caches? - New!
  8. MSSQL - How to replicate to readonly database? - New!
  9. MSSQL - Immediately PRINT big messages - more then 8000 bytes (4000 unicode characters)
  10. MSSQL - Kill all my processes (except current)
  11. MSSQL - Performance tuning of Scalar-Value User Defined Functions (UDFs)
  12. MSSQL - Query Templates
  13. MSSQL - Query Templates - GROUP_CONCAT
  14. MSSQL - Simple GROUP_CONCAT
  15. MSSQL - Stored procedure to replace placeholders in texts (dynamic SQL)
  16. MSSQL - The random number generator with a random initialization (random seed)
  17. MSSQL - Very fast method to get statistic (rows and bytes) for all database tables
  18. MSSQL: How to read an UTF-8 file (XML or JSON)? - New!

 TIMESTAMP

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string

 Table Sample

  1. MSSQL - How to get rows in random sort order

 Template

  2. MSSQL - Query Templates
  3. MSSQL - Query Templates - GROUP_CONCAT
  4. MSSQL - Query Templates - usage of system tables

 Trigger

  1. MSSQL - How to replicate to readonly database? - New!

 Type Extensions

  1. .NET - Extend ListControl with GetSelectedItems and GetSelectedValues
  2. JavaScript - String Extensions #2 [ replaceAll() ]

 UDF

  1. MSSQL - Convert list to table #1 (array of numbers in string form)
  2. MSSQL - Convert list to table #2 (array of string items)
  3. MSSQL - Function to format detailed error message
  4. MSSQL - Function to generate empty rows - New!
  5. MSSQL - How to generate range of Dates - New!
  6. MSSQL - Performance tuning of Scalar-Value User Defined Functions (UDFs)
  7. MSSQL - T-SQL equivalent of VBA VAL() function - New!

 UDT

  1. MSSQL - Stored procedure to replace placeholders in texts (dynamic SQL)

 UNIQUEIDENTIFIER

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string

 UTF-8

  1. MSSQL: How to read an UTF-8 file (XML or JSON)? - New!

 UseSqlServer

  1. How to add the last version of LocalDB to Azure Devops Pipeline - New!

 User Defined Function

  1. MSSQL - Convert list to table #1 (array of numbers in string form)
  2. MSSQL - Convert list to table #2 (array of string items)
  3. MSSQL - Function to format detailed error message
  4. MSSQL - Performance tuning of Scalar-Value User Defined Functions (UDFs)

 User Defined Type

  1. MSSQL - Stored procedure to replace placeholders in texts (dynamic SQL)

 VALUES TABLE

  1. MSSQL - Function to generate empty rows - New!

 VALUES_TABLE

  1. MSSQL - How to generate range of Dates - New!

 VARBINARY

  1. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string

 VMware

  1. VMware and Chrome - damaged or washed out colors or transparent backgrounds - New!

 XML

  1. MSSQL - Convert list to table #1 (array of numbers in string form)
  2. MSSQL - Convert list to table #2 (array of string items)
  3. MSSQL - Convert speсial types to strings or HTML:MONEY to string, DATETIME to string, GUID or UNIQUEIDENTIFIER to string, VARBINARY or BINARY to string, XML to string, TIMESTAMP to string
  4. MSSQL - Query Templates - GROUP_CONCAT
  5. MSSQL - Simple GROUP_CONCAT

 XQUERY

  1. MSSQL - Convert list to table #1 (array of numbers in string form)
  2. MSSQL - Convert list to table #2 (array of string items)

 jQuery

  1. JavaScript - String Extensions #1 [ isEmpty(), left(), right(), contains(), repeat() ]
  2. JavaScript - String Extensions #2 [ replaceAll() ]
  3. jQuery.log

Get This Widget
Subscribe to: Posts (Atom)