Madeira Data Solutions
  • Home

  • About Us

    • Our Team
    • Customers
    • Join Us
  • Managed Services

  • Professional Services

  • Training Services

  • Content Hub

    • Blog
    • Webinars
    • Podcast- SQL SERVER RADIO
  • More

    Use tab to navigate through the menu items.

    Contact Us

    • All Posts
    • SQL Server
    • Podcasts
    • PASS
    • SQL Server 2012
    • Big Data
    • Cloud
    • Scripts
    • Blog
    • DMV's
    • Learning
    • Performance
    • SQL Server 2012
    • Conferences
    • Cursors
    • Plan Cache
    • SQL Agent
    • SQL Azure
    • High Availability
    • Productivity
    • Downloads
    • SQL Server 2014
    • SQL Server 2016
    • Webcasts
    • Videos
    • Troubleshooting
    • SQL Server 2017
    • Tools
    • SQLServerPedia Syndication
    • Storage
    • TempDB
    Search
    The Best Solution for SQL Server Partitioning Sliding Window
    Eitan Blumin
    • May 3
    • 7 min

    The Best Solution for SQL Server Partitioning Sliding Window

    Turns out there's a shortage of solutions online for easily managing partitioned tables in SQL Server. Well... That's where I come in!
    0
    Send e-mails from Azure Data Factory with Azure Logic App
    Eric Rouach
    • Apr 27
    • 4 min

    Send e-mails from Azure Data Factory with Azure Logic App

    (Part 3/3 of “Getting started with Azure Data Factory”) Author: Eric Rouach, DBA at Madeira Data Solutions Date: April 2022 In this demo,...
    0
    Which Tables are Referenced by a View?
    Guy Glantser
    • Apr 26
    • 1 min

    Which Tables are Referenced by a View?

    I published a very simple script to query for all the objects referenced by a specific object in the local database (e.g. a view)...
    0
    Modernizing Your SQL Server
    Guy Glantser
    • Apr 24
    • 5 min

    Modernizing Your SQL Server

    So you have an old SQL Server. It's time to make a change, but where do you start?
    0
    Monitoring Heartbeats in SQL Sentry
    Eitan Blumin
    • Apr 18
    • 5 min

    Monitoring Heartbeats in SQL Sentry

    SQL Sentry uses a service to monitor targets. But what if this monitoring service is down? Who will alert about the alerter not alerting?
    0
    How to Configure Auto-Scaling in Azure Data Explorer
    Guy Glantser
    • Apr 18
    • 3 min

    How to Configure Auto-Scaling in Azure Data Explorer

    You can configure auto-scaling in two ways. The first is called Optimized Auto-Scale, and the second is called Custom Auto-Scale...
    0
    When and How to Shrink Your Database
    Guy Glantser
    • Apr 10
    • 4 min

    When and How to Shrink Your Database

    Shrinking a database is a bad thing, but if you have to do it, then here is how to do it right...
    0
    How To Tune Performance - Chapter 4: Common Problems
    Sagi Amichai
    • Apr 7
    • 5 min

    How To Tune Performance - Chapter 4: Common Problems

    This series of articles will cover the first steps you should take when entering a new environment, aiming to improve overall...
    0
    Remote Execution using Powershell and SQL Server
    Eitan Blumin
    • Apr 5
    • 1 min

    Remote Execution using Powershell and SQL Server

    How to remotely control multiple computers without having to log into them? Do any task from one central location, and make it scalable?
    0
    Send Emails from Azure SQL Database by using Azure Logic Apps
    Maria Zakourdaev
    • Mar 22
    • 1 min

    Send Emails from Azure SQL Database by using Azure Logic Apps

    Azure SQL database is a fully managed relational database in the Microsoft cloud. It is a scalable, durable and performant database...
    0
    1
    2
    345

    keep in Touch!

    JOIN OUR MAILING LIST

    CONTACT US

    4 Itzhak Ben Zvi, Hod-Ha'sharon, Israel 4537302

     +972-9-7400101

    info@madeiradata.com

    About Us
    Solutions
    Data Architecture Review
    DBSMART
    Database Health Check
    SQL Server Upgrade
    Join Us

    Privacy Policy

    • Google+ - White Circle
    • Facebook - White Circle
    • Twitter - White Circle
    • LinkedIn - White Circle