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

Newsletter Archive: April 2018

Find month: Show current month
SunMonTueWedThuFriSat
1st
2nd

SQLServerCentral Newsletter

  • Storing a variable with a SELECT, and why it didn't work.
  • Beyond Formatting: Improving SQL Code using SQL Prompt Actions
  • How to Back Up SQL Server to Azure Blob Storage
  • Paying It Forward
  • New DMF sys.dm_db_log_stats in SQL Server 2017
3rd

SQLServerCentral Newsletter

  • Cache Snapshots And History Snapshots in SSRS 2016
  • Take the SQL Estate Data Mapping Survey and help shape Redgate’s products
  • An Easier Way of Transposing Query Result in SQL Server
  • ETL or ELT
4th

SQLServerCentral Newsletter

  • Stairway to Biml Level 4: Using Biml as an SSIS Design Patterns Engine
  • Controlling Access to Azure Cosmos DB
  • Free eBook: Inside the SQL Server Query Optimizer
  • Is the DBA Title Dying?
  • Automatically Create indexes as needed
5th

SQLServerCentral Newsletter

  • Scripting Tables and Procedures from SSMS
  • Analyze entity data flow in Power BI Desktop using Sankey charts
  • In Memory of Robert
  • DB Blocking Automated E-mail Alerting with Blocker SP ID & query's
6th

SQLServerCentral Newsletter

  • Data Retention: An Inexact Art
  • How to execute a Powershell script via SSIS
  • One Size Does Not Fit All
7th
8th

Database Weekly

    9th

    SQLServerCentral Newsletter

    • Avoiding Unexpected Results with DATEDIFF in Year Comparisons
    • Mount SQL Server DMVs and Custom Queries Using DBFS on Linux
    • What's Downtime?
    10th

    SQLServerCentral Newsletter

    • How to Programmatically Identify When Your SQL Server Was Last Started
    • TRIM() in T-SQL
    • “Full Stack” Means “Part Time” – or Why DBAs Might Wanna Learn DevOps
    • The Best Ever
    11th

    SQLServerCentral Newsletter

    • Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security
    • Software Testing Skills Must Shift with AI
    • Free eBook: Fundamentals of SQL Server 2012 Replication
    • IoT Success
    • Login restriction from selected applications and users
    12th

    SQLServerCentral Newsletter

    • SQL Server on Amazon RDS vs SQL Server on Amazon EC2
    • Extending DevOps to the database: branching and merging
    • Monitor Query Performance Using Query Store in SQL Server
    • Considering Other Views
    13th

    SQLServerCentral Newsletter

    • How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger
    • SSIS Design Pattern - Staging Fixed Width Flat Files
    • Believing the Data
    14th
    15th
    16th

    Database Weekly

    • Desperation on the Forums

    SQLServerCentral Newsletter

    • Using T-SQL to Detect Stock Price Reversals with the RSI
    • SQL Server From .Net: Making A Connection
    • Redgate’s SQL Privacy Summit – London, 18 May
    • In Depth Learning at the PASS Summit
    • Script - All Jobs (powershell/SMO)
    17th

    SQLServerCentral Newsletter

    • Effective Database Testing with SQL Test and SQL Cover
    • Fixing system database corruption with setup.exe
    • Recover Data in SQL Server AWS RDS with the Help of BACPAC
    • Machine Learning Challenges
    • Finding table name based on a specific value
    18th

    SQLServerCentral Newsletter

    • Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes
    • Why sp_prepare Isn’t as “Good” as sp_executesql for Performance
    • Free eBook: SQL Server Execution Plans, Second Edition
    • Good Security Needs Layers
    • Get Temp Table definition
    19th

    SQLServerCentral Newsletter

    • Do you check your backups?
    • 5 challenges to scaling DevOps at enterprise level
    • SQL Server Graph Databases – Part 2: Querying Data in a Graph Database
    • The Right Connection
    • Flexible Statistics Update
    20th

    SQLServerCentral Newsletter

    • Making Deployments Simpler with Re-runnable Scripts
    • How to Show the Execution Plan of a Running Query
    • Keep It All
    21st
    22nd
    23rd

    Database Weekly

    • SQL Community

    SQLServerCentral Newsletter

    • How to Programmatically Identify When Your SQL Server Was Last Started
    • Custom Metrics for Detecting Problems with Ad-hoc Queries
    • Spring into the Latest Features at the Luxemborg User Group
    • Cancelling DBCC SHRINKFILE with EMPTYFILE
    • New IT Departments
    24th

    SQLServerCentral Newsletter

    • Packaged-Application Database Nightmares - A Horror Story
    • Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes
    • Approaches to masking email addresses
    • Cloud Snake Oil
    • Generate Large Amount of Data For Performance Testing
    25th

    SQLServerCentral Newsletter

    • Shift LEFT magazine: Issue 3
    • Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell
    • Free eBook: SQL Server Internals: In-Memory OLTP
    • SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database
    • Stairway to Advanced T-SQL Crossword
    • Script out EXISTING database mail profile's settings
    26th

    SQLServerCentral Newsletter

    • Hash Join Memory Grant Factors
    • SQL Server From .Net: Building a DataSet with Code
    • Detecting Problems on Databases that use Snapshot-based Transaction Isolation
    • Missing Index Impact and Join Type
    • The Last Service Pack
    • Date Calendar
    27th

    SQLServerCentral Newsletter

    • A strategy for implementing database source control
    • Powershell To Get Active Directory Users And Groups into SQL
    • SQL Server Closure Tables
    • Deliver GDPR-compliant data to SQL Server teams
    • The CDO
    28th

    Database Weekly

      29th
      30th

      SQLServerCentral Newsletter

      • Masking Data in Practice
      • Self SQL Injection
      • Execution Plans and Data Protection
      • Replication Gets Some Love
      Previous month