2020-12-03
8 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
534 reads
2020-11-06
728 reads
2020-11-05
484 reads
Handling the Duplication of Records
Learn how to easily identify and remove duplicate records when you discover them.
2020-11-03
3,776 reads
2020-11-03
641 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,107 reads
2020-10-30
737 reads
Blogs
Requesting Comments on the SQLOrlando Operations Manual
By Andy Warren
For the past couple weeks I’ve been trying to capture a lot of ideas...
Ignoring Comments in SQL Compare
By Steve Jones
Recently I had a client that wanted to know how they could use SQL...
PASS SQLSaturday’s I will be speaking at
By James-Serra
I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that...
Forums
Ordering with NULL
Comments posted to this topic are about the item Ordering with NULL
Catching Minor Issues
Comments posted to this topic are about the item Catching Minor Issues
Ask SSC