2020-12-03
774 reads
T-SQL
Check Windows Services Status with T-SQL
In this article we look at creating a SQL Server stored procedure that displays a list of all Windows services based on running or stopped state.
2020-11-24
Using Triggers to Replace Scalar UDFs on Computed Columns
Using Triggers to Replace Scalar UDFs with Brent Ozar.
2020-11-16
2020-11-09
594 reads
2020-11-06
845 reads
2020-11-05
539 reads
Handling the Duplication of Records
Learn how to easily identify and remove duplicate records when you discover them.
2020-11-03
7,537 reads
2020-11-03
746 reads
NoSqlOnSql
Introduction NoSqlOnSql is a strict syntactical superset of SQL; it adds NoSQL document-oriented capabilities to the SQL language. For this, it uses uses JSON-like documents, integrating them into the normal flow of SQL statements. NoSqlOnSql is based on augmenting a SQL database to support NoSQL features without any kernel changes. In this sense it is […]
2020-11-02
4,954 reads
2020-10-30
818 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers