SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Newsletter Archive: January 2019

Find month: Show current month
SunMonTueWedThuFriSat
1st

SQLServerCentral Newsletter

  • Update an Azure SQL Data Mart with ADLS files
  • Generate a SSIS-package that reads from Twitter using Biml
  • Real-time performance monitoring for Azure SQL Database Managed Instance
  • The Start of 2019
2nd

SQLServerCentral Newsletter

  • Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)
  • Free eBook: SQL Server Backup and Restore
  • Review Minimum SQL Server Security Practices
  • Thinkers and Doers
3rd

SQLServerCentral Newsletter

  • Workplace Encounter: Effects of TLS 1.2
  • SSRS Reporting Basics: When is SSRS the Right Tool?
  • Working with SQL Server Stored Procedures and .NET
  • Lack of Memory
4th

SQLServerCentral Newsletter

  • Understanding Peer-to-Peer Transactional Replication, Part 3
  • "Surely this one will get a clustered index scan."
  • The Giving Back Workload
5th

Database Weekly

    6th
    7th

    SQLServerCentral Newsletter

    • Keep Column Headers Visible in SSRS
    • Bootstrap 4 and Self-validating Forms
    • Synonyms
    8th

    SQLServerCentral Newsletter

    • Azure DWH part 29: MicroStrategy Desktop with Azure
    • Factors Behind Successfully and Repeatedly Executing Digital Transformation Programs at a Lightning Pace
    • Azure Data Explorer
    • MY Data
    9th

    SQLServerCentral Newsletter

    • Free eBook: Inside the SQL Server Query Optimizer
    • Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions
    • Getting Started with GitHub for SQL Server Developers
    • Is Failure Allowed?
    10th

    SQLServerCentral Newsletter

    • SSRS Reporting Basics: When is SSRS the Right Tool?
    • The Basics of iTVFs
    • Introducing Azure SQL Database Hyperscale
    • Badly Trained AI
    11th

    SQLServerCentral Newsletter

    • Two Things I Would Change in SSISDB Setup
    • Never Judge A Query By Its Cost
    • Manage Data Across Multiple Sources with Azure Data Studio
    • Do you have a security to-do list?
    12th

    Database Weekly

      13th
      14th
      15th

      SQLServerCentral Newsletter

      • SQL Server Logical Reads – What do they really tell us?
      • New Preview of SQL Server Management Studio Available for Download
      • Implementing Stretch Database.
      • Measuring Effectiveness
      • Files with larger disk consumption
      16th

      SQLServerCentral Newsletter

      • Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers
      • Free eBook: Fundamentals of SQL Server 2012 Replication
      • Pages and Extents: Stairway to SQL Server Indexes Level 4
      • Fun with Dates and Times
      17th

      SQLServerCentral Newsletter

      • Saving Data to Various Formats, Using SQL
      • Getting started with SQL 2019 big data cluster in Azure
      • Using T-SQL to Fix Bad Data in XML Documents Using FLWOR
      • Ensuring Designs have Flexibility
      18th

      SQLServerCentral Newsletter

      • Manipulating Filetable Files Programatically
      • Do Functions Stop You From Using Indexes?
      • Logging SQL and Change-Tracking Events in EF Core
      • The Justification Database
      19th

      Database Weekly

        20th
        21st

        SQLServerCentral Newsletter

        • The 4 capabilities you need to introduce true database DevOps
        • The SQL Server LAG Function
        • Creating Measures Using DAX
        • Versatile or Jack of all trades
        22nd

        SQLServerCentral Newsletter

        • Creating and using inline table-valued functions
        • The 2019 State of Database DevOps
        • Customizing the Default Azure Data Studio Dashboards
        • The Lost Time
        23rd

        SQLServerCentral Newsletter

        • Free eBook: SQL Server Execution Plans, Third Edition
        • Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes
        • SQL Server Reporting Services Report Builder with DAX Query Support
        • Faster Cloud Warehouses
        24th

        SQLServerCentral Newsletter

        • Rolling Back CREATE DDL Statements
        • Getting Started with CQRS – Part 2
        • New Case Study: Reducing capital by $500,000 with SQL Clone
        • Fast Enough
        25th

        SQLServerCentral Newsletter

        • Introduction to Microsoft R Services in SQL Server 2016
        • Query Store And Cruel Defaults
        • Protecting Production Data in Non-Production Environments
        • Your Recovery Time
        26th

        Database Weekly

          27th
          28th

          SQLServerCentral Newsletter

          • Introduction to SQL Server Security — Part 1
          • How to do Accurate Address Masking using Data Masker
          • Stairway to SSAS Tabular Level 5: Cleaning up Dimensions
          • The Devil is in the Monitoring Details
          29th

          SQLServerCentral Newsletter

          • SSRS Scale Out with Standard Edition Containers and Instances
          • Database Development in Visual Studio using SQL Change Automation: Getting Started
          • Overview of Azure SQL Database Performance Monitoring
          • A Large GDPR Victim
          30th

          SQLServerCentral Newsletter

          • Database Continuous Integration with the Redgate SQL Toolbelt and Azure DevOps
          • An Introduction to RLS Security Policies: Level 3 of the Stairway to Row-Level Security
          • Free eBook: SQL Server Internals: In-Memory OLTP
          • Cleanup SQL Server Query Store Data After Database Restore
          • Reserved Space
          31st

          SQLServerCentral Newsletter

          • SQL Server Management Studio add-ins
          • Cyber Insecurity in Pakistan
          • Build and fill a database using JSON and SQL Change Automation
          • The Downside of Tool Autonomy
          Previous month