Perform Data Filtering in Oracle Link to SQL Server
Learn how to perform data filtering in Oracle Linux using a database link to SQL Server
2020-04-13
2,421 reads
Articles
Getting Started with SQL Data Masker: I Need to Mask some Columns
Grant Fritchey explains the core rules and features of Data Masker, and how you go about using them to mask columns, so that when the data is used outside the production system it could not identify an individual or reveal sensitive information.
2020-04-13
Reduce CPU of Large Analytic Queries Without Changing Code
Microsoft introduced several features called Intelligent Query Processing for SQL Server in 2017 and 2019 that can improve performance without making changes to code. In this article, Greg Larsen demonstrates the feature Batch Mode on Rowstore.
2020-04-13
Why QUOTENAME is important
Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.
2020-04-10 (first published: 2018-08-13)
12,860 reads
Help us define the State of Database Monitoring in 2020
The State of SQL Server Monitoring was launched in 2018. This year we are interested in gathering insight across database platforms, not just SQL Server. Have your say and take the survey to be first to receive the report and enter your chance to win a $500 Amazon voucher.
Take the survey.
2020-04-10
The First Time I Had to Restore a Database
Do you remember the very first time you had to do a database restore to fix something you messed up?
2020-04-10
Implementing Reporting Application Enhancements with No Downtime
The purpose of this article is to detail steps that would help implement an enhancement to reporting application that uses SQL Server Database (or any other database) in backend without causing downtime to reporting application.
2020-04-09
69,036 reads
SQL Server Disaster Recovery Options
This presentation is to get you thinking about the disaster recovery options for SQL Server, things like backups, log shipping, Availability Groups, clustering and more while putting them in the context of the enterprise.
2020-04-09
Working with SQL Cursors
In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. This article quickly explores the concept behind and show how to declare cursors, open, retrieve data from them, and then close them
2020-04-08
Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
8,629 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers