Free SQL Server Learning - Backup compression and storage deduplication: A perfect match?

solving sql server problems for millions of dbas and developers since 2006

Top SQL Server Tools

SQL safe backup

SQL compliance manager

SQL diagnostic manager

SQL Server performance monitoring that makes prioritizing simple

SQL Sentry Performance Advisor

K. Brian Kelley

Brian is a SQL Server author, columnist, and Microsoft MVP focusing primarily on SQL Server and Windows security. In addition to being a database administrator, he has served as an infrastructure and security architect encompassing solutions with Citrix, virtualization, and Active Directory. Brian is also a Certified Information Systems Auditor (CISA) and has been the head of a financial organization’s computer incident response team. Brian is active in the IT community having spoken at DevConnections, SQL Saturdays, code camps, and user groups. He is also the President of the Midlands PASS Chapter, a Professional Association for SQL Server Chapter located in Columbia, SC.

Auditing and Compliance

Auditing SELECT statements in SQL Server 2008 (12/18/2008)
Auditing sysadmin on multiple servers using PowerShell (1/23/2012)
Identifying What Runs at Startup on SQL Server (1/30/2012)
SQL Server Encryption To Block DBAs Data Access (12/19/2012)
SQL Server Security Auditing to Match Logins And Users (8/13/2010)

Backup

How to Identify and Backup the Latest SQL Server Database in a Series (11/20/2012)

Clustering

Understanding why there is still downtime for SQL Server with Microsoft Clustering (11/17/2009)

Database Administration

How to move a SQL Server database within the same instance without losing settings (2/16/2009)

Database Design

Understanding First Normal Form in SQL Server (6/28/2011)

Disaster Recovery

Dynamic Management Views and Functions

SQL Server Case Sensitive Collations and DMVs (3/22/2013)

Encryption

SQL Server Encryption Symmetric vs. Asymmetric Keys (11/23/2009)
Using authenticators with SQL Server encryption (5/27/2009)

Integration Services Import and Export Wizard

Export data to an earlier SQL Server version (4/25/2012)

Linked Servers

On demand creation and destruction of a SQL Server Linked Server (9/25/2009)
On Demand Linked Server Creation with a SQL Server Login (10/14/2009)

Policy Based Management

SQL Server Policy Management to Enforce Database Settings in Development (7/15/2010)

PowerShell

Parsing all the files in a directory using PowerShell (8/22/2012)

Professional Development Books

New Book Introduction To SQL Server (3/14/2011)

Profiler and Trace

Using the Default Trace in SQL Server 2005 and SQL Server 2008 (4/28/2009)

Reporting Services Dynamic Reports

Getting started with report filters in SQL Server Reporting Services SSRS (12/23/2009)

Restore

How to Automate SQL Server Restores for a Test Server (12/11/2012)
Why Can't I Restore a Database to an Older Version of SQL Server? (4/17/2012)

Security

Auditing Failed Logins in SQL Server (4/22/2009)
Auditing SQL Server 2012 Server Roles (11/14/2012)
Auditing SQL Server Password Age (5/11/2011)
Auditing SQL Server Permissions and Roles for the Server (6/29/2010)
Auditing SQL Server User and Role Permissions for Databases (10/20/2010)
Automate collection and saving of failed logins for SQL Server (5/13/2009)
Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions (3/6/2013)
Breaking ownership chaining within a schema in SQL Server (8/11/2009)
Cannot make a role a member of itself error in SQL Server (8/30/2010)
Database level permissions for SQL Server 2005 and 2008 (3/30/2009)
Dynamic SQL and Ownership Chaining in SQL Server (8/24/2009)
Filtering Columns in SQL Server Using Views (9/21/2010)
Filtering SQL Server Columns Using Column Level Permissions (9/30/2010)
Get Back into SQL Server After You've Locked Yourself Out (3/9/2012)
Grant limited permissions to create SQL Server views in another schema Part 1 (7/20/2009)
Grant limited permissions to create SQL Server views in another schema Part 2 (7/27/2009)
How to Audit Login Changes on a SQL Server (7/30/2012)
How to configure password enforcement options for standard SQL Server logins (12/28/2009)
How to Connect to a SQL Server Named Instance (3/22/2012)
How to Create Secure SQL Server Service Accounts (9/28/2011)
How to Setup Row Level Security for SQL Server (12/17/2010)
How to Unlock a SQL Login Without Resetting the Password (8/28/2012)
Identify Local Administrators on a SQL Server box using PowerShell (6/15/2011)
Identifying the Tie Between Logins and Users (5/23/2012)
Implicit Permissions Due to Ownership Chaining or Scopes in SQL Server (11/23/2010)
Implicit Permissions Due to SQL Server Database Roles (11/17/2010)
Issues Determining an Individual SQL Server User's Permissions (7/25/2012)
Nesting Database Roles in SQL Server (4/7/2010)
Network communications mechanisms for SQL Server (12/10/2010)
New Security Catalog Views in SQL Server 2005 and SQL 2008 (12/24/2008)
Ownership chaining in SQL Server security feature or security risk (6/23/2009)
Potential Security Exploit Using CONTROL SERVER Permissions in SQL Server (2/24/2012)
Protecting the SQL Server Backup folder (9/19/2012)
Replace xp_cmdshell command line use with SQL Server Agent (5/19/2010)
Retrieving SQL Server Fixed Database Roles for Disaster Recovery (2/4/2011)
Retrieving SQL Server Permissions for Disaster Recovery (10/27/2010)
Server level permissions for SQL Server 2005 and SQL Server 2008 (3/24/2009)
SQL Server nested securable permissions (4/13/2010)
Tables and Views for Auditing SQL Server Logins (5/24/2010)
The Power of the SQL Server Database Owner (3/15/2013)
Unable to see a SQL Server table (5/18/2011)
Understanding Cross Database Ownership Chaining in SQL Server (6/29/2009)
Understanding GRANT, DENY, and REVOKE in SQL Server (2/27/2013)
Understanding How A User Gets Database Access in SQL Server (6/14/2010)
Understanding SQL Server fixed database roles (12/14/2009)
Understanding SQL Server fixed server roles (11/24/2009)
Understanding When SQL Server Kerberos Delegation is Needed (2/22/2011)
Using a Backup to Find SQL Server Security Changes (9/11/2012)
Using nmap to scan for SQL Servers on a network (8/16/2012)
Using PowerShell to Audit for Blank SA Passwords (9/4/2012)
Why Can't I Set a Default SQL Server Schema for My Windows Group Login? (5/29/2012)
Why System Account is a bad idea for SQL Server Service Account (5/25/2011)

SQL Server Agent

SQL Server Agent Job Email Notifications via PowerShell (12/27/2012)

SQL Server Configurations

How to setup and use a SQL Server alias (11/5/2008)
How to setup security features for SQL Server (1/15/2009)
Understanding the SQL Server SELECT @@VERSION command (12/13/2011)
Using Friendly Names for SQL Servers via DNS (3/28/2012)
Why listing all of your SQL Servers does not always work (7/9/2010)

Surface Area Configuration Manager

SQL Server security settings using the Surface Area Configuration tool (1/22/2009)
SQL Server Surface Area Configuration for Features Option Selection (2/11/2009)

Triggers

Connecting to SQL Server with a Bad Logon Trigger (11/20/2008)
SQL Server 2005 SysAdmin Login Auditing (11/14/2008)
Understanding SQL Server inserted and deleted tables for DML triggers (3/22/2011)

Virtual Machines VM

Viewing VMware Counters in PerfMon for SQL Server (11/7/2012)

Sponsor Information

"Amazing, Amazing, Amazing! SQL doctor is truly one of the most powerful tools I have seen."

Get your SQL Server database under version control now! Find out why...

What grade do you think your SQL Servers get? Find out with a SQL Server Health Check consultant in the USA.

Join the over million SQL Server Professionals who get their issues resolved daily.

Demystify TempDB Performance and Manageability

Copyright (c) 2006-2013 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com