2020-12-03
757 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
585 reads
2020-11-06
815 reads
2020-11-05
525 reads
Handling the Duplication of Records
Learn how to easily identify and remove duplicate records when you discover them.
2020-11-03
7,437 reads
2020-11-03
730 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,805 reads
2020-10-30
802 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
sqlbackups through veeam not updating msdb tables
We have veeam backups happening everyday on a server where all sql databases are...
Testing whether TRY_CONVERT is losing precision
Hello All, I am using TRY_CONVERT to parse character data into a decimal column....
need help with assigning a value to a variable
Hi I am trying to assign the value of the variable using the output...
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers