Skip to content

SQL Nuggets

Nuggets Of SQL Server Knowledge

Menu
  • Home
  • Blog
  • Speaking
  • Presentations
  • About

Tag: SQL Server 2008 R2

Backups

Automating backups for SQL Server 2008 R2 Express Edition

One of the limitations of SQL Server Express is that you can’t automate backups in it via the SQL Server Agent like you can the other versions of SQL Server. …

Search

Subscribe via Email

Receive notifications of new posts by email.

SUBSCRIBE VIA RSS

RSS Feed RSS - Posts

Categories

  • Availability Groups
  • Azure
  • Backups
  • Conferences
  • DB Engine
  • Errors
  • Indexes
  • MongoDB
  • Monitoring
  • PowerShell
  • Security
  • SQL Scripts
  • SSIS
  • System Views
  • T-SQL
  • Tools

Recent Posts

  • Index Basics: Find Tables That Do Not Have A Clustered Index
  • Notes From A SQL 2017 Azure Install – Trace Flags
  • Notes From A SQL 2017 Azure Install
  • Slides From NCDevCon 2017
  • Index Basics: Hidden Costs Associated With Indexes

Top Posts

  • Notes From A SQL 2017 Azure Install - Trace Flags
  • List All Foreign Keys Referencing A Table In SQL Server
  • Change The Isolation Level Of An Availability Group Database
  • Useful Tools: sp_whoisactive
  • Fixing "Possible Date Calculation Spin For Schedule" Error

Tags

Automation Azure Migration Backups Bad T-SQL Client Tools Clustered Indexes Database Mail Database Maintenance Data Storage DBCC CheckDB dev.Objective() Encryption Execution Plans Express Edition Getting Started Index Basics Internals NOLOCK Nonclustered Indexes NoSQL Performance Permissions Presentations Quickies Server Administration Speaking SQL Agent SQL Saturday SQL Sentry SQL Server 2008 R2 SSMS Storing Passwords System Procedures Top Developer Tips Trace Flags Transaction Isolation Levels Visual Studio
Copyright © 2017 SQL Nuggets – OnePress theme by FameThemes