This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.

Authors

Top Categories

Database Administration

Posts (366 posts published)

Replacing Trace Flags 1204 and 1222 with the Extended Events system_health Session

by Jes Borland on April 24, 2018
Use ostress to load test a SQL database

by Jes Borland on October 26, 2017
T-SQL Tuesday #67 – What Extended Events is Missing

by Jes Borland on June 9, 2015
You're Invited to T-SQL Tuesday #67: Extended Events

by Jes Borland on June 2, 2015
Automated Database Deployments – Presentation Demos

by Eli Weinstock-Herman (tarwn) on September 7, 2014

continuous delivery continuous integration
Availability Groups Setup and Configuration from A to Z

by Ted Krueger (onpnt) on June 4, 2014
T-SQL Tuesday #052 – Why Back Up System Databases?

by Jes Borland on March 11, 2014
2013 – Review of Writing

by Ted Krueger (onpnt) on January 2, 2014
A New Solution for Monitoring SQL Server

by Jes Borland on December 30, 2013
ACL added security for Availability Group Listener in Azure

by Ted Krueger (onpnt) on December 19, 2013
Can I recover from a secondary replica COPY_ONLY full backup?

by Ted Krueger (onpnt) on December 11, 2013
Async replica loss causes transactional replication to fail

by Ted Krueger (onpnt) on November 29, 2013
Document Your SQL Server Databases with Extended Properties

by Jes Borland on November 6, 2013
Automated Job Activation with Mirroring and Availability Groups

by Ted Krueger (onpnt) on November 5, 2013
SQL Server Services fail to start – FAIL_PAGE_ALLOCATION

by Ted Krueger (onpnt) on October 21, 2013
Enable TDE when Replication is in use

by Ted Krueger (onpnt) on October 10, 2013
Replication requires the actual server name – Incorrect server name

by Ted Krueger (onpnt) on October 9, 2013
SQL Server Configuration Manager – Remote Procedure Call Failed

by Ted Krueger (onpnt) on September 11, 2013
Managing Transaction Log Growth

by Ted Krueger (onpnt) on June 27, 2013
Which loads faster – 2008, 2008 R2 or 2012

by Ted Krueger (onpnt) on June 27, 2013
Supported and unsupported datatypes with Hekaton tables

by SQLDenis on June 25, 2013

hekaton sql server 2014
Yeah, I am sure that is the reason we have Oracle on Azure and Hyper-V now

by SQLDenis on June 24, 2013

azure hyper-v oracle sql server
SQL Server Database owner ~~UNKNOWN~~

by SQLDenis on May 14, 2013

security sql server 2000 sql server 2005 sql server 2008 sql server 2012
SQL Server Baseline Collection

by Ted Krueger (onpnt) on May 7, 2013
Missing index suggestion – Duplicate Index

by Ted Krueger (onpnt) on April 20, 2013
Buffer Latch Error Restoring SQL Server Database

by Ted Krueger (onpnt) on April 10, 2013
BCP all tables into files from a database

by SQLDenis on March 31, 2013

bcp bulk export bulk import data migration
Loading Large Volumes of Data into SQL Azure with SSIS

by Ted Krueger (onpnt) on March 22, 2013
Bring SQL Server databases Online or Offline when running on Amazon RDS

by SQLDenis on March 22, 2013

amazon web services aws cloud rds
Turning on Optimize for Ad hoc Workloads, Ad Hoc Distributed Queries and more on a AWS RDS SQL Server Instance

by SQLDenis on March 21, 2013

amazon web services aws cloud rds
How to read the error log on an Amazon RDS SQL Server instance

by SQLDenis on March 21, 2013

amazon web services aws cloud rds
SQL Sentry – Providing Performance and Knowledge

by Ted Krueger (onpnt) on March 21, 2013
Setting up Mirroring to SQL 2012 Availability Groups Encryption Error

by Ted Krueger (onpnt) on March 20, 2013
Red Gate Releases SQL Backup Pro 7.3

by Ted Krueger (onpnt) on March 20, 2013
MongoDB 2.4 Released

by SQLDenis on March 20, 2013

bigdata mongodb nosql
Use WITH RESULT SETS to change column names and datatypes of a resultset

by SQLDenis on March 17, 2013

how to sql server 2012
Using SELECT * in views gotcha

by Kevin Conan on March 12, 2013

sql views
Giving only insert permissions to a table for a new login

by SQLDenis on March 4, 2013

security sql server 2000 sql server 2005 sql server 2008 sql server 2012 tables
An easier way to get SQL Server startup parameters: the sys.dm_server_registry dmv

by SQLDenis on February 24, 2013

dmv dynamic management view registry sql server 2012 startup options
MongoDB: Using the web-based administrative tool

by SQLDenis on February 24, 2013

administration bigdata mongodb nosql tools
Listing tables that are truly partitioned in SQL Server

by SQLDenis on February 23, 2013

features partitioning sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
Ten things added after SQL Server 2000 that I like the most

by SQLDenis on February 18, 2013

sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
Listing all RESTORE and BACKUP operations currently going on your SQL Server

by SQLDenis on February 17, 2013

backup restore sql server 2000 sql server 2005 sql server 2008 sql server 2012
Windows and SQL Server 2012 Test Setup

by Ted Krueger (onpnt) on February 15, 2013
MongoDB: Exporting data into files

by SQLDenis on February 3, 2013

bigdata collections export mongodb nosql
MongoDB: How to backup all the databases with one command

by SQLDenis on February 1, 2013

backup bigdata collections mongodb nosql restore
MongoDB: How to restore collections

by SQLDenis on January 31, 2013

backup bigdata collections mongodb nosql restore
Why there should be SQL Content at Techdays.be

by Axel Achten (axel8s) on January 29, 2013
When do statistics update?

by Ted Krueger (onpnt) on January 28, 2013
A Glance of Plan Explorer Pro's Deadlock Analysis

by Ted Krueger (onpnt) on January 28, 2013
Do not disable foreign keys

by Ted Krueger (onpnt) on January 23, 2013
Database Designing With Performance In Mind

by Ted Krueger (onpnt) on January 22, 2013
Multidocument updates with MongoDB

by SQLDenis on January 20, 2013

bigdata mongodb nosql update
Import Wizard – Microsoft.ACE.OLEDB 12.0 provider is not registered

by Ted Krueger (onpnt) on January 19, 2013
Creating statistics manually – Duplicate Statistics

by Ted Krueger (onpnt) on January 19, 2013
Indexes in MongoDB: A quick overview

by SQLDenis on January 19, 2013

bigdata indexes indexing mongodb nosql
Doing UPSERTs in MongoDB

by SQLDenis on January 12, 2013

bigdata mongodb nosql
Database Projects – Installing the Database Project Template

by Axel Achten (axel8s) on January 8, 2013

database lifecycle database projects sql server datatools ssdt
A Look Inside SQL Server Row and Page Compression

by Jes Borland on December 19, 2012
SQL Advent 2012 Day 15: Benefits of Indexes

by SQLDenis on December 15, 2012

indexing performance query sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012
SQL Advent 2012 Day 13: Features enabled that are not used

by SQLDenis on December 13, 2012

features sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
\"The What, Why, and How of Filegroups\" – I-380 PASS Materials

by Jes Borland on December 12, 2012
Database Projects – Setting up Source Control

by Axel Achten (axel8s) on December 11, 2012

ankhsvn database lifycycle database project sql server sql server data tools ssdt subversion
SQL Server Query Tuning – Back to Basics

by Ted Krueger (onpnt) on December 9, 2012
SQL Advent 2012 Day 8: Foreign Keys

by SQLDenis on December 8, 2012

constraints data integrity foreign keys sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
SQL Advent 2012 Day 7: Lack of constraints

by SQLDenis on December 7, 2012

constraints data integrity sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
SQL Advent 2012 Day 5: Do not trust the SSMS designers

by SQLDenis on December 5, 2012

ddl designers sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
SQL Advent 2012 Day 1: Sizing database files

by SQLDenis on December 1, 2012

filegroups files log sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 tempdb
Utilizing SQL Server Reports from SSMS

by Ted Krueger (onpnt) on November 28, 2012
SQL Advent 2012, here is what is coming

by SQLDenis on November 25, 2012

database design how to sql server 2000 sql server 2005 sql server 2008 sql server 2012 tables
Expert Performance Indexing for SQL Server 2012 for $15

by Ted Krueger (onpnt) on November 20, 2012
Cardinality Estimate and Computed Columns

by Ted Krueger (onpnt) on November 16, 2012
Short-Throw-Away T-SQL

by Ted Krueger (onpnt) on November 15, 2012
Is being a DBA still sexy?

by Jes Borland on November 14, 2012
A Few Notes About Creating Custom SSMS Reports

by Jes Borland on October 31, 2012
Hex Editoring

by Jes Borland on October 30, 2012
SELECT 1 – Column Level Security

by Ted Krueger (onpnt) on October 30, 2012
I'm An Author! "Pro SQL Server 2012 Practices" Releases October 31

by Jes Borland on October 25, 2012
Book Review: SQL Server Hardware

by Jes Borland on October 22, 2012
SELECT * vs SELECT 1 with EXISTS

by Ted Krueger (onpnt) on October 18, 2012
Removed Replication – rowguid added back

by Ted Krueger (onpnt) on October 18, 2012
Why does sys.dm_exec_requests not show my SPID?

by Ted Krueger (onpnt) on October 12, 2012
T-SQL Tuesday #35: Soylent Green SQL Server

by Jes Borland on October 9, 2012
Why do you need additional privileges for truncate table compared to delete?

by SQLDenis on October 7, 2012

delete how to permissions sql server 2005 sql server 2008 sql server 2012 truncate table
Plan Cache effects when dropping columns

by Ted Krueger (onpnt) on September 4, 2012
Free SQL Server Tools

by Jes Borland on August 31, 2012
LOB Logical Reads twice the row count

by Ted Krueger (onpnt) on August 28, 2012
Migrating Replication Subscribing Databases

by Ted Krueger (onpnt) on August 9, 2012
Index Seek on LOB Columns

by Ted Krueger (onpnt) on August 8, 2012
Book Review: Troubleshooting SQL Server – A Guide for the Accidental DBA

by Jes Borland on August 1, 2012
SQL Saturday Indy – Invasion of SSIS

by Ted Krueger (onpnt) on July 26, 2012
Merge Replication Baseline Collector

by Ted Krueger (onpnt) on July 18, 2012
Row Overflow Pages – Index Tuning

by Ted Krueger (onpnt) on June 28, 2012
Balanced Data Distributor for SSIS 2012 Released

by Ted Krueger (onpnt) on June 20, 2012
Diagnostic Manager – Alert Statuses

by Kevin Conan on June 14, 2012

dba diagnostic manager idera sql
Does updating a column to itself get logged? #TSQL2sday 31

by Ted Krueger (onpnt) on June 12, 2012
T-SQL Tuesday #31 – Reporting Services Logs

by Jes Borland on June 12, 2012
Diagnostic Manager Quick Tip – Job Messages

by Kevin Conan on May 24, 2012

dba diagnostic manager idera sql
How to change the SA password in SQL Server

by SQLDenis on May 22, 2012

security sql server 2005 sql server 2008
Using EXECUTE AS OWNER

by Ted Krueger (onpnt) on April 19, 2012
Columnstore Index – Index Statistics

by Ted Krueger (onpnt) on April 10, 2012
Columnstore Index Basics

by Ted Krueger (onpnt) on April 9, 2012
Presenting "Filegroups: Putting the Pieces Together" for Chicago SQL Connections

by Jes Borland on March 26, 2012
CozyRoc Releases SSIS+ 1.6 Beta

by Ted Krueger (onpnt) on March 2, 2012
SQL Server Installation Error – Consistency validation for SQL Server Registry keys

by Ted Krueger (onpnt) on February 16, 2012
RedGate SQL Tab Magic

by SQLArcher on February 16, 2012
Merge Replication – Filtered Data Publication Setup

by Ted Krueger (onpnt) on February 14, 2012
Row-Level and Column-Level tracking in Merge Replication

by Ted Krueger (onpnt) on February 14, 2012
SQL Server and xp_cmdshell – The good, the bad and more ugly

by Ted Krueger (onpnt) on February 7, 2012
Automating Index Statistics Collection with SSIS – The fast one

by Ted Krueger (onpnt) on January 27, 2012
Automating Index Statistics Collection

by Ted Krueger (onpnt) on January 25, 2012
Cheatsheet: Relational Database Management Systems Comparison

by Jes Borland on January 24, 2012
Take advantage of Database Mirroring in your applications

by Ted Krueger (onpnt) on January 24, 2012
Estimating Mean Uptime for Team-based uptime measurements

by Ted Krueger (onpnt) on January 23, 2012
Could not find stored procedure 'sp_ExecuteSQL'

by Ted Krueger (onpnt) on January 19, 2012
January #Meme15 Assignment – Twitter, the Blog, taking over the universe

by Ted Krueger (onpnt) on January 16, 2012
Friday SQL Nugget #1

by Jes Borland on January 13, 2012
WiSSUG "Filegroups: Putting the Pieces Together" Materials

by Jes Borland on January 11, 2012
MySQL MyISAM and InnoDB Engine Differences

by Jes Borland on January 10, 2012
SQL Server Auditing: Looking Back

by SQLArcher on January 9, 2012
SQLCop integration with Red Gate's SQL Test

by George Mastros (gmmastros) on January 4, 2012

sql test sqlcop tsqlt
Book Review: Microsoft SQL Server 2008 Internals

by Jes Borland on January 4, 2012
Presenting "Filegroups: Putting The Pieces Together" for WiSSUG

by Jes Borland on January 3, 2012
SQL Server Auditing: Managing Your Audits

by SQLArcher on January 2, 2012
SQL Server Auditing: Creating a Database Specification

by SQLArcher on December 28, 2011
Replacing sysfiles With sys.database_files

by Jes Borland on December 21, 2011
SQL Server Auditing: Creating a Server Specification

by SQLArcher on December 21, 2011
SQL Server Audits: Introduction

by SQLArcher on December 21, 2011
SQL Server Integration Services tools to have – Configuration File Editor

by Ted Krueger (onpnt) on December 15, 2011
Troubleshooting Merge Replication Performance – Indexing Publications

by Ted Krueger (onpnt) on December 14, 2011
Fixing orphaned database users in 2005 to 2012 – T-SQL Tuesday #025

by Ted Krueger (onpnt) on December 13, 2011
T-SQL Tuesday #25: T-SQL Tricks – Checking Transaction Log Space Used

by Jes Borland on December 13, 2011
Troubleshooting Merge Replication – Logging

by Ted Krueger (onpnt) on December 12, 2011
Merge Replication – Parameterized Filters

by Ted Krueger (onpnt) on December 9, 2011
Red Gate's new SQL Index Manager

by Ted Krueger (onpnt) on December 8, 2011
SQL Server Integration Services tools to have – Expression Editor & Tester

by Ted Krueger (onpnt) on December 8, 2011
Dynamic Connections in SSIS – Extract, Transform and Load

by Ted Krueger (onpnt) on December 7, 2011
Location of files for new database in SQL Server

by SQLDenis on November 17, 2011

data files files log files sql server 2005 sql server 2008 sql server 2012
SQL Server 2012 RC0 is here!

by Ted Krueger (onpnt) on November 17, 2011
What #sqlfamily Means To Me (Or, A Case of the Warm Fuzzies)

by Jes Borland on November 7, 2011
SSMS Assembly Error – Microsoft.SqlServer.Sqm.dll

by Ted Krueger (onpnt) on October 31, 2011
My Favorite PowerShell Script: Reading Log Files

by Jes Borland on October 28, 2011
SQL Saturday #99 Minnesota – #SQLAwesome

by Ted Krueger (onpnt) on October 26, 2011
PASS Summit 2011: A Picture Book

by Jes Borland on October 18, 2011
Fix Execution Plan showing Parallelism

by Ted Krueger (onpnt) on October 6, 2011
SQL Server Views and Metadata

by Ted Krueger (onpnt) on October 6, 2011
SQL Saturday Iowa another success!

by Ted Krueger (onpnt) on October 6, 2011
SQL Saturday #92 – Portland, OR

by Jes Borland on October 3, 2011
SQL Server Deep Dives Volume 2

by Ted Krueger (onpnt) on October 2, 2011
Troubleshooting SQL Server: A guide for the Accidental DBA

by Ted Krueger (onpnt) on October 2, 2011
2011 Quarter 3 Goals: Kicking [beep], Taking Names

by Jes Borland on September 30, 2011
Tips and Tricks to Make SQL Server Management Studio Awesome

by Jes Borland on September 22, 2011
Attending PASS Summit 2011? Want Lunch? And Free Career Advice? I Have Just The Event...

by Jes Borland on September 15, 2011
Watch Me (and 23 Others!) During 24 Hours of PASS: Summit Preview

by Jes Borland on August 31, 2011
T-SQL Tuesday

by Ted Krueger (onpnt) on August 10, 2011
T-SQL Wednesday #21 – T-SQL That Should Have Been Flushed Down the Toilet

by Jes Borland on August 10, 2011
Red Gate SQL Toolbelt Review

by David Forck (thirster42) on August 8, 2011
Chicago SQL Connections – Reporting Services 201 Slides & Code

by Jes Borland on August 4, 2011
A Cheat Sheet for All the *{_(%#$] PowerShell Punctuation

by Jes Borland on July 22, 2011
ColumnStore Index limitations in SQL Server Denali CTP3

by SQLDenis on July 14, 2011

apollo columnstore denali olap oltp
T-SQL Tuesday #20 – T-SQL Best Practices

by Jes Borland on July 12, 2011
Excel 2010 Data Source "From Microsoft Query" Missing DSNs

by Jes Borland on June 30, 2011
User Groups? Those Still Exist? They Do, and You Should Be Going To One

by Jes Borland on June 24, 2011
I'm Speaking! PASS Summit 2011

by Jes Borland on June 17, 2011
Energizing the Next Generation: A Women In Tech Discussion at SQL Saturday #75

by Jes Borland on June 15, 2011
Do you care that SQL Server Denali cannot be installed on Windows XP?

by SQLDenis on June 15, 2011

denali sql server windows 7 windows xp
SQL Saturday #75, Columbus OH: I Came, I Saw, I Ran

by Jes Borland on June 14, 2011
Saving Table Space (Quick And Dirty)

by David Forck (thirster42) on June 13, 2011
A week in Sybase Training, what did I learn, day 5

by SQLDenis on June 10, 2011

ase sql server sybase training
A week in Sybase Training, what did I learn, day 4

by SQLDenis on June 9, 2011

ase sql server sybase training
A week in Sybase Training, what did I learn, day 2

by SQLDenis on June 7, 2011

ase sql server sybase training
A week in Sybase Training, what did I learn, day 1

by SQLDenis on June 6, 2011

ase sql server sybase training
I'll See You At SQL Saturday #75 Columbus, OH

by Jes Borland on June 6, 2011
SQL Saturday Pensacola – Measure of success

by Ted Krueger (onpnt) on June 6, 2011
SQL Server 2008 R2 Setup starts and then disappears

by Ted Krueger (onpnt) on June 6, 2011
Do you still use sp_change_users_login instead of ALTER USER UserName WITH LOGIN = UserName

by SQLDenis on June 3, 2011

permissions sql server 2005 sql server 2008 sql server 2008 r2
SQL Server Filegroup Piecemeal Restores

by Jes Borland on May 24, 2011
Watch all the Tech·Ed North America 2011 SQL Server videos

by SQLDenis on May 19, 2011

sql server 2008 r2 sql server denali videos
SQL Server DBA Tip 16 – Working with Files and Folders

by Ted Krueger (onpnt) on May 17, 2011
SQL Server DBA Tip 15 – SQL Server Agent – Job ownership

by Ted Krueger (onpnt) on May 16, 2011
SQL Server DBA Tip 14 – SQL Server General – Updating Production Data

by Ted Krueger (onpnt) on May 13, 2011
SQL Server DBA Tip 13 – SQL Server built in DR/HA Solutions

by Ted Krueger (onpnt) on May 12, 2011
SQL Server DBA Tip 12 – SQL Server Tuning – Missing Index DMV

by Ted Krueger (onpnt) on May 11, 2011
SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory

by Ted Krueger (onpnt) on May 10, 2011
T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

by Jes Borland on May 10, 2011
SQL Server DBA Tip 10 – SQL Server Reporting – Offload the reporting factor

by Ted Krueger (onpnt) on May 9, 2011
Removing OS Files Through a Stored Procedure

by SQLology ~ Kim Tessereau on May 7, 2011
SQL Server Database Administration Tip a Day Series

by Ted Krueger (onpnt) on May 6, 2011
SQL Server DBA Tip 9 – SQL Server Monitoring – Default Trace

by Ted Krueger (onpnt) on May 6, 2011
SQL Server DBA Tip 8 – Server Monitoring – Baseline

by Ted Krueger (onpnt) on May 5, 2011
SQL Server DBA Tip 7 – Server Security and grouping – Schema Control

by Ted Krueger (onpnt) on May 4, 2011
Compressing Data with Uniqueidentifier columns

by Ted Krueger (onpnt) on May 3, 2011
SQL Server DBA Tip 6 – Server Security – Windows Authentication / SQL Authentication

by Ted Krueger (onpnt) on May 3, 2011
Windows Server 2008 R2 Failover Clustering - It's Cool

by Jes Borland on May 2, 2011
SQL Server DBA Tip 5 – Server Considerations – Installing Features (SSIS, SSRS, Engine, SSAS)

by Ted Krueger (onpnt) on May 2, 2011
SQL Server DBA Tip 4 – Server Considerations – 32 bit / 64 bit

by Ted Krueger (onpnt) on April 29, 2011
SQL Server DBA Tip 3 – Server Configuration – Model Database

by Ted Krueger (onpnt) on April 28, 2011
SQL Server DBA Tip 2 – Server Configuration – Data/Log Files

by Ted Krueger (onpnt) on April 27, 2011
SQL Server DBA Tip 1 – Server Configuration – MAX Memory

by Ted Krueger (onpnt) on April 26, 2011
SQL Server Filegroups: The What, The Why and The How

by Jes Borland on April 26, 2011
Difference between a Cumulative Update and Service Pack for SQL Server

by Ted Krueger (onpnt) on April 23, 2011
Should SQL Server Professionals Learn Oracle?

by Ted Krueger (onpnt) on April 21, 2011
Why do we need error handling?

by SQLology ~ Kim Tessereau on April 17, 2011
Observing – Optimize for Ad Hoc Workload server option

by SQLology ~ Kim Tessereau on April 9, 2011
Bulk loading data into a merge replicated table

by Ted Krueger (onpnt) on April 8, 2011
Compress Data Partition Snapshots with SSIS – SQL University

by Ted Krueger (onpnt) on April 7, 2011
2011 Quarter 1 Goal Review

by Jes Borland on April 6, 2011
SQL University – Performance Week

by Ted Krueger (onpnt) on April 5, 2011
Meme Monday: Eleven Words or Less

by Ted Krueger (onpnt) on April 4, 2011
Using STOPAT in the RESTORE DATABASE Statement

by Jes Borland on April 4, 2011
Wow what a week in review.....

by SQLology ~ Kim Tessereau on March 30, 2011
Automate Database Restore to Remote Instance with SSIS

by Ted Krueger (onpnt) on March 30, 2011
SQL Saturday #67 Chicago 2011 Wrap-Up

by Jes Borland on March 28, 2011
SQL Saturday in Chicago 2011 Eval

by Ted Krueger (onpnt) on March 27, 2011
SQL Saturday #67 Chicago 2011: Have Fun Storming the Castle!

by Jes Borland on March 21, 2011
24 Hours of PASS: Wrap-Up, Slides, Demos and High-Fives

by Jes Borland on March 17, 2011
SUM (T-SQL Tuesday #016: Aggregate Functions)

by Jes Borland on March 10, 2011
T-SQL Tuesday #016 – COUNT and DELETE duplicates

by Ted Krueger (onpnt) on March 8, 2011
SSIS:Multi Instance Management made easy.

by SQLArcher on March 7, 2011
Come One, Come All to T-SQL Tuesday #016 : Aggregate Functions

by Jes Borland on February 26, 2011
MADPASS Meeting Wrap-Up

by Jes Borland on February 24, 2011
Trapping errors when working with linked servers

by SQLDenis on February 15, 2011

errors how to linked servers trapping
Changing a SQL Server Database Owner

by Jes Borland on February 15, 2011
24 Hours of PASS, WIT Edition: Register! Learn! Listen to Me!

by Jes Borland on February 14, 2011
Renaming Physical Database Files

by Ted Krueger (onpnt) on February 9, 2011
T-SQL Tuesday#15 – Automation with PowerShell (Replace with RegEx)

by Ted Krueger (onpnt) on February 8, 2011
SQL University – SQL Server Reporting Services: Exploring the RSReportServer.config File

by Jes Borland on February 3, 2011
SQL University – SQL Server Reporting Services Configuration Files Overview

by Jes Borland on February 1, 2011
Backup file contents with SSIS – INSERT/UPDATE Decisions

by Ted Krueger (onpnt) on January 31, 2011
Backup file contents with SSIS – Supporting tables and procedures

by Ted Krueger (onpnt) on January 28, 2011
Backup file contents with SSIS – Foreach Loop Container and file handling

by Ted Krueger (onpnt) on January 25, 2011
Lessons Learned from Failing the MCTS 70-432

by Jes Borland on January 24, 2011
Backup file contents with SSIS – Defining the Design

by Ted Krueger (onpnt) on January 24, 2011
How to Delete Large amounts of data in a Batch.

by ptheriault on January 20, 2011
First glance at the new Red Gate SQL Monitor

by Ted Krueger (onpnt) on December 30, 2010

performance red gate sql monitor sql server
Using RMO to run replication tasks

by Ted Krueger (onpnt) on December 30, 2010

replication rmo sql server 2008
Policy-Based Management for SQL Agent History

by Ted Krueger (onpnt) on December 28, 2010

policy-based management sql server 2008
Running older compatibility levels in newer versions

by Ted Krueger (onpnt) on December 28, 2010

database administration sql server 2008 sql server upgrade
Procedure expects parameter error from SqlCommand

by Ted Krueger (onpnt) on December 27, 2010

.net c# slqcommand sql server
How to move datafiles to a new drive in SQL Server

by SQLDenis on December 17, 2010

administration files sql server 2005 sql server 2008
T-SQL Tuesday #013: What Does the Business Want?

by Jes Borland on December 14, 2010
T-SQL Tuesday #13: What the Business Says Is Not What the Business Wants

by Ted Krueger (onpnt) on December 14, 2010

cubes olap reporting sql server t-sql tuesday
SSRS: How to monitor report subscriptions

by ptheriault on December 8, 2010
Mirroring and Transactional Replication setup – Auto Failover

by Ted Krueger (onpnt) on November 30, 2010

mirroring replication sql server 2005 sql server 2008 transactional replication
Run SSIS Package from Stored Procedure

by Ted Krueger (onpnt) on November 29, 2010

sql server 2008 sql server integration services ssis
Using SSIS to import a directory of images

by Ted Krueger (onpnt) on November 24, 2010

import image rapid development sql server 2008 sql server integration services ssis
The Productive DBA: Part 2 Document the Database

by ptheriault on November 23, 2010
The Productive DBA

by ptheriault on November 22, 2010
Upgrading the DBA

by ptheriault on November 18, 2010
Execution Plans – Indexing to achieve optimal query plans

by Ted Krueger (onpnt) on October 25, 2010

execution plans pass sql server 2008 sql server community tuning
Who shrunk the files? (DBCC SHRINKFILE Audit)

by Ted Krueger (onpnt) on October 22, 2010
SQLCop behind a Proxy

by Ted Krueger (onpnt) on October 18, 2010

best practices sql server 2008 sql server community sqlcop
Wisconsin SQL Server User Group

by Ted Krueger (onpnt) on October 11, 2010

execution plans pass sql server 2008 sql server user group wissug
The History of SQL Server Integration Services

by Ted Krueger (onpnt) on October 11, 2010

sql server 2008 r2 sql server history sql server integration services ssis
SSIS runs in BIDS but not with SQL Agent

by Ted Krueger (onpnt) on October 6, 2010

sql server 2008 r2 sql server agent failure sql server integration services ssis
SQL Saturday #46, Raleigh NC

by Eli Weinstock-Herman (tarwn) on September 22, 2010

community sqlsaturday
Have SQL, will travel – East Iowa SQL Saturday

by Ted Krueger (onpnt) on September 20, 2010

configuration files configuration variables dtsx parent child packages sql saturday sql server 2008 ssis
SQL Saturday Iowa

by Ted Krueger (onpnt) on September 11, 2010

sql community sql server sql server 2008 sql server integration services ssis
The Lazy DBA Series: Wizards!

by Ted Krueger (onpnt) on August 25, 2010

database administration import wizard sql server sqlpass
The Lazy DBA Series: High Availability

by Ted Krueger (onpnt) on August 24, 2010

database administration sql server sqlpass
The Lazy DBA Series: Email me, I'm broke!

by Ted Krueger (onpnt) on August 24, 2010
SQLCop update Version 1.1

by George Mastros (gmmastros) on August 23, 2010
The Lazy DBA Series: Monitoring

by Ted Krueger (onpnt) on August 22, 2010

baseline monitoring performance red gate reporting sql response sql server 2008
The Lazy DBA Series: SQL Trace / Profiler

by Ted Krueger (onpnt) on August 20, 2010

database administration sql server sqlpass
Making SSIS Dynamic: Passing variables between packages

by Ted Krueger (onpnt) on August 19, 2010

configuration files configuration variables dtsx parent child packages sql server 2008 ssis
Making SSIS Dynamic: Configuration Management

by Ted Krueger (onpnt) on August 18, 2010

configuration files configuration variables dtsx parent child packages sql server 2008 ssis
SQL Saturday 28, Baton Rouge

by Eli Weinstock-Herman (tarwn) on August 16, 2010

community sqlsaturday
Creating a baseline for SQL Server

by Ted Krueger (onpnt) on August 9, 2010

baseline monitoring performance sql server sql server 2008
Baseline, Performance Reporting and being a proactive DBA

by Ted Krueger (onpnt) on August 5, 2010

baseline monitoring performance reporting sql server 2008
RID Lookup take me down

by Ted Krueger (onpnt) on July 18, 2010

execution plan query tuning rid lookup sql server 2008 t-sql
Change Data Capture rundown 100 (setup)

by Ted Krueger (onpnt) on July 12, 2010

cdc change data capture new features sql server 2008 tracking data
SQL Server and the Auto Close Setting

by Ted Krueger (onpnt) on June 12, 2010

auto close deprecated list sql community sql server
SQL Server and High Availability

by Ted Krueger (onpnt) on June 11, 2010

backup disaster recovery dr ha high availability log shipping mirroring restore sql server 2008 sql university
SQL University – Recess time!

by Ted Krueger (onpnt) on June 10, 2010

backup disaster recovery dr ha high availability log shipping mirroring restore sql server 2008 sql university
Log Shipping for cheap DR

by Ted Krueger (onpnt) on June 10, 2010

backup disaster recovery dr ha high availability log shipping mirroring restore sql server 2008
T-SQL Tuesday – Give me my cores SSIS 2008!

by Ted Krueger (onpnt) on June 8, 2010

sql community sql server 2008 sql server 2008 r2 sql server integration services ssis ssis 2008
The SQL Server backup – foundation of any Disaster / Recovery

by Ted Krueger (onpnt) on June 8, 2010

backup disaster recovery dr ha high availability mirroring restore sql server 2008
Welcome to HA and DR week!

by Ted Krueger (onpnt) on June 7, 2010
Removing old files with SSIS

by Ted Krueger (onpnt) on June 4, 2010

delete files sql community sql server sql server 2008 sql server integration services ssis
Report Manager / Report Server Loading Slow Initially

by Ted Krueger (onpnt) on May 28, 2010

report manager report server sql server reporting services ssrs
Transaction Log expanding on restore after shrink

by Ted Krueger (onpnt) on May 27, 2010

backup ldf restore shrinkfile sql server sql server 2008 transaction log
Virtual Lab: Creating the Basic SQL 2008 R2 Virtual Machine

by Eli Weinstock-Herman (tarwn) on May 20, 2010

sql server sql server 2008 r2 virtual lab vmware
Three different ways of populating variables with configuration values in SQL Server

by SQLDenis on May 19, 2010

howto sql server 2000 sql server 2005 sql server 2008 tip
12 ways to break your database server before the first transaction

by Ted Krueger (onpnt) on May 19, 2010

dmf dmv index maintenance performance sql server 2005 sql server 2008
How to use T-SQL to get the command line startup parameters that were used to start SQL Server

by SQLDenis on May 18, 2010

howto sql server 2005 sql server 2008 tip
Five things wouldn't miss in SQL Server

by Ted Krueger (onpnt) on May 11, 2010

meme sql server tagged
Trusting Database Engine Tuning Advisor for Query Tuning

by Ted Krueger (onpnt) on May 11, 2010

database engine tuning advisor index maintenance sql server 2005 sql server 2008
Mirroring Hands On with Developer Edition

by Ted Krueger (onpnt) on May 9, 2010

high availability mirroring sql server 2008
Database Mail Won't Deliver to Distribution Group

by David Forck (thirster42) on May 7, 2010
SQL Connections Suburban Chicago Wrap Up

by Ted Krueger (onpnt) on May 6, 2010

community help pass sql server ssug
Planning your hardware for SQL Server Mirroring

by Ted Krueger (onpnt) on May 4, 2010

high availability mirroring sql server 2008
SQL Connections Suburban Chicago May 2010 Meeting (SSIS Basics)

by Ted Krueger (onpnt) on May 3, 2010

sql community sql server sql server integration services ssis
Stripping rows out of file imports

by Ted Krueger (onpnt) on April 22, 2010
Do you use disable index or drop index when running your ETL processes in SQL Server

by SQLDenis on April 21, 2010

indexing question
Delay Validation with SSIS Tasks

by Ted Krueger (onpnt) on April 5, 2010

integrated services sql server ssis
Getting the physical device name and backup time for a SQL Server database

by SQLDenis on April 2, 2010

backup recovery sql server 2005 sql server 2008
Internet Facing Reporting Services Instance

by David Forck (thirster42) on March 31, 2010
Index DMV usage considerations

by Ted Krueger (onpnt) on March 31, 2010

dmf dmv index maintenance performance sql server 2005 sql server 2008
SQL Saturday 33 – Charlotte, NC

by Eli Weinstock-Herman (tarwn) on March 7, 2010

dba sqlsaturday sqlserver
Using schemas to maintain order as a DBA

by Ted Krueger (onpnt) on February 26, 2010

dba schema sql server
Table sizes

by niikola on February 18, 2010
Mirroring: Witness misconceptions in High-Performance

by Ted Krueger (onpnt) on February 16, 2010

high availability mirroring sql server 2008
SQL Saturday in Chicago – Schedule is up!

by Ted Krueger (onpnt) on February 11, 2010
Read from your mirror in SQL Server

by Ted Krueger (onpnt) on February 3, 2010
Running static code analysis on SQL Server database with Visual Studio Team System for database architects

by SQLDenis on January 31, 2010

code analysis sql server 2008 visual studio 2008
Backup and copy warm-standby (log shipped) databases in SQL Server

by Ted Krueger (onpnt) on January 27, 2010
Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters

by SQLDenis on January 22, 2010

dmv performance sql server 2000 sql server 2005 sql server 2008
Use alter table alter column to change datatypes for a column in SQL Server

by SQLDenis on January 19, 2010

database design how to sql server 2000 sql server 2005 sql server 2008 tables
SQL Server 2008 R2 to be released in May

by SQLDenis on January 19, 2010

business intelligence gemini madison sql server 2008 sql server 2008 r2
Activity Monitor to gather statistics and health of SQL Server 2008

by Ted Krueger (onpnt) on January 18, 2010
Find Out If You Are Using Deprecated Features In SQL Server 2008

by SQLDenis on January 14, 2010

dmv dynamic management views sql server 2005 sql server 2008
Interview with Brent Ozar about the book Professional SQL Server 2008 Internals and Troubleshooting

by SQLDenis on January 13, 2010

book interview performance tuning sql server 2008
Find Out What Percent Of The Log Is Being Used For Each Database In SQL Server 2005 and 2008

by SQLDenis on January 13, 2010

dmv dynamic management views sql server 2005 sql server 2008
Mirroring SQL Server 2005 to SQL Server 2008 (part 2)

by Ted Krueger (onpnt) on January 12, 2010
Mirroring SQL Server 2005 to SQL Server 2008 (Part 1)

by Ted Krueger (onpnt) on January 11, 2010
SQL Azure CTP Testers Can Upgrade Their Accounts To Paid Commercial Subscriptions Starting Today

by SQLDenis on January 4, 2010

azure cloud computing sql azure
Using Variables in SSIS: Purpose review and functional examples

by Ted Krueger (onpnt) on December 31, 2009
Script Task vs Flat File Connection Management

by Ted Krueger (onpnt) on December 16, 2009
Dynamic SQL Server connections in Reporting Services

by Ted Krueger (onpnt) on December 12, 2009
Introducing SQL Server to Oracle

by Ted Krueger (onpnt) on December 11, 2009
Testing backup compression in SQL Server 2008

by SQLDenis on November 22, 2009

backups compression sql server 2008
To BUILTINAdmin or not to BUILTINAdmin

by Ted Krueger (onpnt) on November 19, 2009
Beginning stages of a DR plan for SQL Server

by Ted Krueger (onpnt) on November 13, 2009
Back to business for the SQL Server community

by Ted Krueger (onpnt) on November 13, 2009
Test your Full Recovery model by restoring backups

by Ted Krueger (onpnt) on November 5, 2009
Dealing with Cannot resolve collation conflict for equal to operation errors

by SQLDenis on October 26, 2009

collation database gotcha programming sql server 2000 sql server 2005 sql server 2008 tip
Series of "Bad habits to kick" by Aaron Bertrand

by Ted Krueger (onpnt) on October 18, 2009
How to Monitor Database Mirroring

by ptheriault on October 15, 2009
SQL University and why you should be attending

by Ted Krueger (onpnt) on October 14, 2009
Interview With Rod Colledge About The Book SQL Server 2008 Administration in Action

by SQLDenis on October 12, 2009

administration book interview sql server 2008
Derived Column and the Data Flow Task

by Ted Krueger (onpnt) on October 8, 2009
To SA or not to SA

by Ted Krueger (onpnt) on October 7, 2009
Suffer to succeed. Another SQL Server Import Story

by Ted Krueger (onpnt) on September 30, 2009
Review of SQL Server 2008 Administration in Action

by SQLDenis on September 28, 2009

book database sql server 2008
Keep your DBA guard up at all times

by Ted Krueger (onpnt) on September 25, 2009
SQL Server MVP Deep Dives a book written by SQL Server MVPs supporting a good cause

by SQLDenis on September 25, 2009

book charity sql server 2008
Use INDEXKEY_PROPERTY in SQL Server to determine if columns in indexes are sorted ascending or descending

by SQLDenis on September 23, 2009

functions indexes indexing sql server 2005 sql server 2008
6 ways to import data into SQL Server

by Ted Krueger (onpnt) on September 14, 2009
Using Mirroring to Reduce DB Migration Downtime (Part 2)

by Ted Krueger (onpnt) on September 10, 2009
Using Mirroring to Reduce DB Migration Downtime (Part 1)

by Ted Krueger (onpnt) on September 10, 2009
East Iowa SQL Saturday Oct. 17th

by Ted Krueger (onpnt) on September 9, 2009
How I got started with SQL Server

by Ted Krueger (onpnt) on September 8, 2009
How I got started with SQL Server

by SQLDenis on September 7, 2009

meme sql server
SSMS Tools PACK, Something Every SQL Server Developer That Uses SSMS Should Have Installed

by SQLDenis on August 30, 2009

sql server 2005. tools sql server 2008 ssms
Scripting all jobs on SQL Server 2005/2008 into one file

by SQLDenis on August 23, 2009
Death by a thousand tools

by Ted Krueger (onpnt) on August 19, 2009
Scripting All The Jobs On Your SQL Server Instance Into Separate Files By Using SMO

by SQLDenis on August 18, 2009

jobs msdb scripting smo
Working with Excel to match data 101

by Ted Krueger (onpnt) on August 5, 2009
SQL Server sprawl, heard it twice in one day

by SQLDenis on August 5, 2009

sql server sprawl
Instance design; Where to do your work as a DBA and DB Developer

by Ted Krueger (onpnt) on July 28, 2009
Dynamic Data Sources in SSRS

by Ted Krueger (onpnt) on July 24, 2009

ssrs
How to get data out of Microsoft Dynamics Great Plains

by David Forck (thirster42) on July 10, 2009
Go ahead and click it! I triple dog dare you!!!

by Ted Krueger (onpnt) on July 10, 2009
Push your DBA skills over the edge by becoming a better developer

by Ted Krueger (onpnt) on July 9, 2009
Dynamic column names and fields in SSRS (Custom Matrix)

by Ted Krueger (onpnt) on July 1, 2009
DBA SQLCLR Procedures

by Ted Krueger (onpnt) on June 26, 2009
Not a fan of the Report Manager in SSRS? Using SSRS procedures to get the job done

by Ted Krueger (onpnt) on June 25, 2009
Compression tools are a must for any DBA

by Ted Krueger (onpnt) on May 27, 2009
Here Is Yet Another Reason For Upgrading To SQL Server 2008 From SQL Server 2000

by SQLDenis on May 22, 2009

sql server 2000 sql server 2008
Blocking due to fragmented HEAP Tables

by Ted Krueger (onpnt) on April 24, 2009
Please Mr. DBA, Change default passwords and use strong passwords

by Ted Krueger (onpnt) on April 23, 2009
The DBA.. their role, expectations and future?

by Ted Krueger (onpnt) on April 15, 2009
Rebuild master and restore system databases from complete disk failure

by Ted Krueger (onpnt) on April 14, 2009
Scan network for SQL Server instances

by Ted Krueger (onpnt) on March 9, 2009
Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation

by SQLDenis on September 18, 2008

book data modeling database design interview sql server 2008
How to get the selectivity of an index

by SQLDenis on May 20, 2008

database indexes optimizing sql sqlserver