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
1,958 reads
Pablo Echeverria
- LinkedIn: www.linkedin.com/in/pablo-echeverria
Check Your Backup Compliance Against a Data Management Provider
As a database administrator, it's your responsibility to ensure the customer data won't get lost in case of a disaster, so you either provide your own backup strategy, use a third-party script, or hire a data management provider. With the first two options, you have full control over your environment so you can know exactly […]
2020-04-02
991 reads
Restore SQL Server database using data management provider REST API
Learn how to restore sql server database using data management provider Rubrik REST API
2020-03-19
2,180 reads
Graph multiple databases growth using SSMS only
Easily graph your storage needs based on msdb backup data recorded automatically, no matter what your backup solution is.
2020-03-17 (first published: 2020-03-10)
1,072 reads
Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
Learn how to monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services
2020-02-24
3,662 reads
Use Polybase to consume Oracle data from SQL Server on Linux 2019
Learn how to set up Polybase in containers to access an Oracle database.
2020-01-09
3,247 reads
Monitor Current Analysis Services Activity
Although not every business has SSAS (SQL Server Analysis Services) installed nor use it extensively, the ones who do also care about their database responsiveness. If it is slow, what else is running that may be causing the slowness? Are there any locks? What commands are being run, who is running them, from where? How […]
2019-12-17
2,733 reads
Blogs
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
Bash: “command not found” in IF statement
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
The First Data Saturday is Tomorrow
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
Forums
Data Privacy Grows in California
Comments posted to this topic are about the item Data Privacy Grows in California
Grant user access to view database only
Hi I need to grant a user access to a DB on the server...
Need to strip off the beginning of a field in SELECT statement
I have this table that unfortunately has spaces in the field, which I am...
Ask SSC