Microsoft Sql Server Admin

Posts (541 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
• Transactional Replication from Availability Groups to Azure SQL Database: Part 1 – Planning

  by Jes Borland on December 26, 2016
• 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
• Availability Groups Setup and Configuration from A to Z

  by Ted Krueger (onpnt) on June 4, 2014
• MDS: A Database Error Has Occurred

  by Koen Verbeeck on April 18, 2014

  batch error mds syndicated
• T-SQL Tuesday #052 – Why Back Up System Databases?

  by Jes Borland on March 11, 2014
• Master Data Services (Second Edition) – Review

  by Koen Verbeeck on January 31, 2014

  master data management master data services mds sql server 2012 syndicated
• T-SQL Tuesday #50 – Automating Your Installs

  by Brian Davis on January 14, 2014

  automation tsql2sday
• 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
• SQL Server 2012 Reporting Services Blueprints – Review

  by Koen Verbeeck on December 12, 2013

  blueprints book reporting services review sql server ssrs
• 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
• Master Data Services stops working after an upgrade

  by Koen Verbeeck on November 27, 2013

  cumulative update error master data services mds sql server syndicated version
• Document Your SQL Server Databases with Extended Properties

  by Jes Borland on November 6, 2013
• Speaking about BIML at the SQL Server Days 2013

  by Koen Verbeeck on October 15, 2013

  biml speaking sql server sqlserverdays sqlug ssis syndicated
• SQL Agent Job High Availability – Availability Groups

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

  by Ted Krueger (onpnt) on September 11, 2013
• Virtual book club.. who is in?

  by SQLDenis on August 22, 2013

  book sql server
• SSIS Deployment with PowerShell: Adding Environment References

  by Koen Verbeeck on August 21, 2013

  catalog deployment powershell sql server ssis syndicated
• 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
• List of new programmability features/T-SQL enhancements in SQL Server besides Hekaton

  by SQLDenis on June 25, 2013

  hekaton sql server 2014
• Supported and unsupported datatypes with Hekaton tables

  by SQLDenis on June 25, 2013

  hekaton sql server 2014
• New Dynamic Management Views in SQL Server 2014 CTP1

  by SQLDenis on June 25, 2013

  dmv dynamic management view 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
• Nice Collection Of Free SQL Server, Visual Studio, Azure ebooks

  by SQLDenis on June 19, 2013

  ebook sql server sql server 2012
• Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site

  by Koen Verbeeck on June 12, 2013

  business intelligence demo environment excel power view powerpivot sharepoint 2013 sql server ssas ssrs syndicated
• Building a SharePoint 2013 BI Demo Environment Part 9 – Installing Reporting Services

  by Koen Verbeeck on June 11, 2013

  business intelligence demo environment excel power view powerpivot sharepoint 2013 sql server ssas ssrs syndicated
• Building a SharePoint 2013 BI Demo Environment Part 8 – Verifying PowerPivot Integration

  by Koen Verbeeck on June 10, 2013

  business intelligence demo environment excel powerpivot sharepoint 2013 sql server ssas syndicated
• Building a SharePoint 2013 BI Demo Environment Part 7 – Configuring SharePoint

  by Koen Verbeeck on June 7, 2013

  business intelligence demo environment excel powerpivot powerpivot configuration tool sharepoint 2013 sql server ssas syndicated
• Building a SharePoint 2013 BI Demo Environment Part 6 – Installing PowerPivot for SharePoint

  by Koen Verbeeck on June 6, 2013

  business intelligence demo environment excel powerpivot sharepoint 2013 sql server ssas syndicated
• Building a SharePoint 2013 BI Demo Environment Part 5 – Installing SharePoint

  by Koen Verbeeck on June 5, 2013

  business intelligence demo environment sharepoint 2013 sql server syndicated virtual machine
• Building a SharePoint 2013 BI Demo Environment Part 4 – Installing SQL Server

  by Koen Verbeeck on June 4, 2013

  business intelligence demo environment sharepoint 2013 sql server virtual machine
• Building a SharePoint 2013 BI Demo Environment Part 3 – Installing the OS

  by Koen Verbeeck on June 3, 2013

  business intelligence demo environment hyper-v sharepoint 2013 sql server syndicated virtual machine windows server 2012
• SQL Server 2012 System views poster available for download

  by SQLDenis on May 31, 2013
• Building a SharePoint 2013 BI Demo Environment Part 2 – Building the VM

  by Koen Verbeeck on May 31, 2013

  business intelligence demo environment hyper-v sharepoint 2013 sql server syndicated virtual machine
• Building a SharePoint 2013 BI Demo Environment Part 1 – Introduction

  by Koen Verbeeck on May 30, 2013

  business intelligence demo environment sharepoint 2013 sql server syndicated
• 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
• Fixing a SQL Server could not spawn FRunCM thread error

  by SQLDenis on April 30, 2013

  encryption error fix sql server 2005 sql server 2008 sql server 2012
• Where to find the xtype info for SQL Server in a table

  by SQLDenis on April 26, 2013

  howto sql server 2000 sql server 2005 sql server 2008 sql server 2012 table tip
• 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
• Using a Dedicated Administrator Connection via SSMS

  by SQLDenis on April 7, 2013

  dac how to sql server 2008 sql server 2012
• BCP all tables into files from a database

  by SQLDenis on March 31, 2013

  bcp bulk export bulk import data migration
• Messing with your friendly DBA on April Fools' Day

  by SQLDenis on March 29, 2013

  prank sql server 2000 sql server 2005 sql server 2008 sql server 2012
• Little used SSIS tasks: Data Profiling Task

  by SQLDenis on March 28, 2013

  ssis
• SQL Server Management: Compatibility Levels

  by Kevin Conan on March 28, 2013

  compatibility level dba sql server
• 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
• Trying out Amazon Relational Database Service

  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
• Creating a SQL Server Unique Index that behaves like an Oracle Unique Index

  by SQLDenis on March 20, 2013
• Red Gate Releases SQL Backup Pro 7.3

  by Ted Krueger (onpnt) on March 20, 2013
• Unique index difference between Oracle and SQL Server

  by SQLDenis on March 19, 2013

  gotcha null oracle sql server tip
• Using WITH RESULT SETS with stored procedures that return multiple resultsets

  by SQLDenis on March 18, 2013

  how to sql server 2012
• Use WITH RESULT SETS to change column names and datatypes of a resultset

  by SQLDenis on March 17, 2013

  how to sql server 2012
• Wrap inserts in a transaction for faster performance

  by SQLDenis on March 13, 2013

  performance sql server 2008 sql server 2012 testing transactions
• Triggers affect on SQL System Variables

  by Kevin Conan on March 12, 2013

  rowcount identity sql trigger
• Using SELECT * in views gotcha

  by Kevin Conan on March 12, 2013

  sql views
• Use the sp_describe_undeclared_parameters stored procedure to check if dynamic SQL has undeclared parameters

  by SQLDenis on March 6, 2013
• 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
• Column name or number of supplied values does not match table definition when dealing with temp tables

  by SQLDenis on March 3, 2013

  gotcha sql server 2000 sql server 2005 sql server 2008 sql server 2012 tables temp 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
• 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
• Suppressing xp_cmdshell output

  by SQLDenis on February 21, 2013

  features sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms xp_cmdshell
• 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
• BULK INSERT data where the row terminator is a linefeed in SQL Server

  by SQLDenis on February 14, 2013

  bcp bulk insert files import sql server 2005 sql server 2008 sql server 2012
• Getting file size, space used and space free information for a SQL Server database

  by SQLDenis on February 13, 2013

  sql server 2000 sql server 2005 sql server 2008 sql server 2012 sqlcop tables
• Discovering new things (for me) in SSMS

  by SQLDenis on February 10, 2013

  sql server 2005 sql server 2008 sql server 2012 sqlcop ssms tables
• SQL Server Support Windows Phone App released

  by SQLDenis on February 9, 2013

  mobile sql server 2000 sql server 2005 sql server 2008 sql server 2012 windows phone
• Getting the tables with the most rows from your database

  by SQLDenis on February 8, 2013

  sql server 2000 sql server 2005 sql server 2008 sql server 2012 sqlcop tables
• Listing all your SQL Server databases ordered by size

  by SQLDenis on February 8, 2013

  databases sql server 2000 sql server 2005 sql server 2008 sql server 2012 sqlcop
• Getting the biggest tables in your SQL Server database

  by SQLDenis on February 8, 2013

  sql server 2000 sql server 2005 sql server 2008 sql server 2012 sqlcop tables
• MongoDB: How to drop databases and collections

  by SQLDenis on February 5, 2013

  bigdata collections databases mongodb nosql
• MongoDB: How to backup and restore databases

  by SQLDenis on January 30, 2013

  backup bigdata mongodb nosql restore
• When do statistics update?

  by Ted Krueger (onpnt) on January 28, 2013
• MongoDB: How to limit results and how to page through results

  by SQLDenis on January 26, 2013

  bigdata mongodb nosql paging sorting
• How do you manage SQL Agent Jobs when using mirroring?

  by SQLDenis on January 25, 2013

  ha ha/dr jobs maintenance mirroring
• WHERE not to use FUNCTIONS

  by Axel Achten (axel8s) on January 24, 2013

  function sql server tsql where
• 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
• Why avoiding multiple code blocks in a Stored Procedure

  by Axel Achten (axel8s) on January 21, 2013

  case if else procedure cache t-sql
• 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
• What is going on with Database Mail in SQL Server

  by SQLDenis on January 15, 2013

  database mail mail sql server 2008 sql server 2012
• Database Mail maintenance in SQL Server

  by SQLDenis on January 14, 2013
• Setting up SQL Server Database Mail with gmail

  by SQLDenis on January 13, 2013

  database mail gmail sql server 2005 sql server 2008 sql server 2012
• Getting started with Execution Plans

  by Axel Achten (axel8s) on January 10, 2013

  execution plan query plan
• Giving users the ability to change a stored procedure without making them db_owner

  by SQLDenis on January 8, 2013

  dcl permissions security sql server 2008 sql server 2012 stored procedures
• Database Projects – Installing the Database Project Template

  by Axel Achten (axel8s) on January 8, 2013

  database lifecycle database projects sql server datatools ssdt
• Use the sys.database_mirroring DMV to quickly check if the databases are in principal or mirror role and what state they are in

  by SQLDenis on January 7, 2013

  ha/dr mirroring sql server 2005 sql server 2008 sql server 2012
• Truncate rollback differences between SQL Server and Oracle

  by SQLDenis on January 6, 2013

  gotcha oracle sql server tip truncate
• What is the Dual table in Oracle and why do I need it?

  by SQLDenis on January 6, 2013

  gotcha oracle sql server tip
• Differences between Oracle and SQL Server when working with NULL and blank values

  by SQLDenis on January 6, 2013

  gotcha null oracle sql server tip
• Why you shouldn't use SELECT *

  by Axel Achten (axel8s) on January 2, 2013

  select select star t-sql
• SHOW_STATISTICS Density showing key column – Why?

  by Ted Krueger (onpnt) on December 31, 2012
• SQL Advent 2012: Recap

  by SQLDenis on December 25, 2012

  ddl designers sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• SQL Advent 2012 Day 21: With VLDBs it matters what you do and how you do it

  by SQLDenis on December 22, 2012

  indexing performance query sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 very large databases vldb
• A Look Inside SQL Server Row and Page Compression

  by Jes Borland on December 19, 2012
• SQL Advent 2012 Day 18: Stay relevant and marketable

  by SQLDenis on December 19, 2012

  big data hadoop nosql sql server 2012
• SQL Advent 2012 Day 17: No matter how long you are on the wrong path, go back

  by SQLDenis on December 17, 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
• SQL Advent 2012 Day 12: Proactive notifications

  by SQLDenis on December 12, 2012

  errors notifications sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• SQL Advent 2012 Day 11: Cursors and loops

  by SQLDenis on December 11, 2012

  cursors loops sql server 2005 sql server 2008 sql server 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
• Update Table Based on a JOIN

  by Ted Krueger (onpnt) on December 11, 2012
• SQL Server Query Tuning – Back to Basics

  by Ted Krueger (onpnt) on December 9, 2012
• SQL Server Data Type Conversion Poster is available for download

  by SQLDenis on December 8, 2012

  chart conversions data types pdf poster sql server 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 6: Standardized Naming And Other Conventions

  by SQLDenis on December 6, 2012

  conventions ddl designers 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 4: Triggers, what to do, what not to do

  by SQLDenis on December 4, 2012

  database ddl triggers dml triggers rdbms sql sql server 2008 sql server 2012 t-sql triggers
• SQL Advent 2012 Day 3: Sargable Queries

  by SQLDenis on December 3, 2012

  database indexing performance tuning rdbms sargable sql sql server 2008 sql server 2012 t-sql
• SQL Advent 2012 Day 2: Data types storage differences

  by SQLDenis on December 2, 2012

  backup conversions log performance sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 storage
• 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
• Getting SSRS Subscriptions for a Specific Date

  by Kevin Conan on November 20, 2012
• Expert Performance Indexing for SQL Server 2012 for $15

  by Ted Krueger (onpnt) on November 20, 2012
• Find all the tables and indexes that have data compression

  by SQLDenis on November 16, 2012

  compression how to indexing partitioning sql server 2008 sql server 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
• SSMS Add-in for Plan Explorer Update

  by Ted Krueger (onpnt) on October 17, 2012
• Plan Explorer Pro – First Glance

  by Ted Krueger (onpnt) on October 15, 2012
• Adding nonclustered index on primary keys

  by Ted Krueger (onpnt) on October 11, 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 Server 2008 R2 SP2 Released

  by SQLDenis on July 27, 2012

  service pack sql server 2008 r2 support
• Merge Replication Baseline Collector

  by Ted Krueger (onpnt) on July 18, 2012
• T-SQL Tuesday 32: A Day in the Life a Grrl Geek

  by Jes Borland on July 17, 2012
• See Exactly What's Happenin' with SSIS 2012 Data Taps

  by joshuafennessy on July 12, 2012
• Setting up a Central Management Server

  by Kevin Conan on June 29, 2012

  cms sql server
• Row Overflow Pages – Index Tuning

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

  by Kevin Conan on June 14, 2012

  dba diagnostic manager idera sql
• T-SQL Tuesday #31 – Logging Simple Things

  by Eli Weinstock-Herman (tarwn) on June 12, 2012

  sql server t-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
• OUTPUT Clause and @@identity, scope_identity()

  by SQLDenis on May 25, 2012

  dml insert output sql server 2005 sql server 2008 sql server 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
• Don't put a return statement in a stored procedure inside a transaction

  by SQLDenis on May 18, 2012

  how to sql server 2005 sql server 2008 sql server 2012 tip
• SQL Azure How To Rebuild A Clustered Index

  by SQLDenis on May 3, 2012

  azure cloud computing fragmentation sql azure
• A couple of things to be aware of when working with tables in SQL Azure

  by SQLDenis on May 2, 2012

  azure sql azure the cloud
• How to search for data with underscores or brackets in SQL Server?

  by SQLDenis on May 2, 2012

  like regular expressions s ql server 2005 sql server 2000 sql server 2008 sql server 2012
• I'm a Radio Star! I'm Talking SSRS on RunAs Radio

  by Jes Borland on April 18, 2012
• Diagnostic Manager – Custom Alerts

  by Kevin Conan on April 13, 2012

  backups diagnostic manager idera monitoring sql
• Finding Exact Duplicate Indexes

  by George Mastros (gmmastros) on April 12, 2012
• Downloading SQL Server Sample Databases much improved with new CodePlex changes

  by SQLDenis on April 3, 2012

  database samples sql server 2005 sql server 2008 sql server 2012
• Dammit people, get to know check constraints and use them!

  by SQLDenis on April 3, 2012

  check constraints ow to sql server 2005 sql server 2008 sql server 2012 tip trick
• You don't need to shrink a database to get a smaller backup

  by SQLDenis on March 31, 2012

  how to maintenance sql server 2000 sql server 2005 sql server 2008
• Presenting "Filegroups: Putting the Pieces Together" for Chicago SQL Connections

  by Jes Borland on March 26, 2012
• How to give permissions to User-Defined Table Types

  by SQLDenis on March 21, 2012
• Using DTUtil from PowerShell

  by Axel Achten (axel8s) on March 16, 2012

  dtutil posh powershell ssis
• Diagnostic Manager – Viewing History outside of 8AM to 5PM

  by Kevin Conan on March 13, 2012

  diagnostic manager idera sql server
• Moving On, Getting Converted...

  by SQLArcher on March 13, 2012
• Idera Diagnostic Manager for End Users

  by Kevin Conan on March 12, 2012

  diagnostic manager idera sql server
• Setting up Kerberos authentication between SQL Servers

  by David Forck (thirster42) on March 7, 2012
• Merge Replication – COM Based Resolver throws Buffer too small Error

  by Ted Krueger (onpnt) on March 6, 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
• Getting the list of parameters from a stored procedure by using sqlCmd.Parameters or INFORMATION_SCHEMA.parameters

  by SQLDenis on February 14, 2012

  parameters stored procedure
• Difference between a cross join and a full outer join

  by SQLDenis on February 12, 2012

  joins sql server 2000 sql server 2005 sql server 2008 sql server 2012 t-sql
• SQL Server and xp_cmdshell – The good, the bad and more ugly

  by Ted Krueger (onpnt) on February 7, 2012
• Convenient ad-hoc bcp table loading

  by Erik on February 4, 2012
• Automating Index Statistics Collection with SSIS – The fast one

  by Ted Krueger (onpnt) on January 27, 2012
• Madison SQL Server User Group

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

  by Ted Krueger (onpnt) on January 25, 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
• How to connect to SQL Server when your default database is unavailable

  by SQLDenis on January 14, 2012

  connecting connection how to sql server 2005 sql server 2008 tip
• WiSSUG "Filegroups: Putting the Pieces Together" Materials

  by Jes Borland on January 11, 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
• SQL Azure Compatibility Assessment service released

  by SQLDenis on January 4, 2012

  azure cloud computing sql azure
• Presenting "Filegroups: Putting The Pieces Together" for WiSSUG

  by Jes Borland on January 3, 2012
• Scripting data in SQL Server 2012

  by SQLDenis on January 2, 2012

  scripting
• 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
• Upgrade Assistant for SQL Server 2012 available for download

  by SQLDenis on December 23, 2011

  sql server 2005 sql server 2008 sql server 2012 upgrade
• SQL Advent 2011 Day 23: OBJECT_DEFINITION

  by SQLDenis on December 23, 2011

  metadata object_definition sql server 2005 sql server 2008 stored procedures
• SQL Advent 2011 Day 21: TRY CATCH

  by SQLDenis on December 21, 2011

  error error handling sql server 2005 sql server 2008 try catch
• 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 Advent 2011 Day 19: Filtered Indexes

  by SQLDenis on December 19, 2011

  indexing sql server 2005 sql server 2008
• SQL Advent 2011 Day 18: Table-valued Parameters

  by SQLDenis on December 18, 2011

  sql server 2008 table-valued parameters tvp
• SQL Advent 2011 Day 17: varchar(max)

  by SQLDenis on December 17, 2011

  data types ntext nvarchar(max) sql server 2005 sql server 2008 text varchar(max)
• SQL Advent 2011 Day 15: Joins

  by SQLDenis on December 16, 2011

  how to joins sql server 2005 sql server 2008 tip
• SQL Server Integration Services tools to have – Configuration File Editor

  by Ted Krueger (onpnt) on December 15, 2011
• SQL Advent 2011 Day 14: EXCEPT and INTERSECT SET Operations

  by SQLDenis on December 15, 2011

  except intersect sql server 2005 sql server 2008 union
• Troubleshooting Merge Replication Performance – Indexing Publications

  by Ted Krueger (onpnt) on December 14, 2011
• SQL Advent 2011 Day 13: DDL Triggers

  by SQLDenis on December 13, 2011

  auditing ddl triggers triggers
• 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
• SQL Advent 2011 Day 10: Upsert by using the Merge statement

  by SQLDenis on December 10, 2011

  how to merger sql server 2008 tip upsert
• 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 Advent 2011 Day 5: Common Table Expressions

  by SQLDenis on December 5, 2011

  common table expression cte tables
• SQL Advent 2011 Day 4: Schemas

  by SQLDenis on December 4, 2011

  how to schema skills sql server 2005 sql server 2008
• SQL Advent 2011 Day 2: system tables and catalog views

  by SQLDenis on December 2, 2011

  administration dmv sql server 2005 sql server 2008 views
• How to capture the error output from a stored procedure when calling another stored procedure in SQL Server?

  by SQLDenis on December 1, 2011

  error how to output parameter sql server 2005 sql server 2008 tip
• SQL Advent 2011 Day 1: Date and time

  by SQLDenis on December 1, 2011

  dates datetime datetime2 gotcha sql server 2008 time
• 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
• SQLCop is now available via chocolatey

  by Christiaan Baes (chrissie1) on November 16, 2011

  chocolatey sqlcop
• List all stored procedures that run at startup in SQL Server

  by SQLDenis on November 15, 2011

  administration sql server 2005 sql server 2008
• You should be watching

  by David Forck (thirster42) on November 9, 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
• Database space use

  by David Forck (thirster42) on October 24, 2011
• What does a SQL Server DBA need to check for daily, weekly, monthly, quarterly and yearly?

  by SQLDenis on October 18, 2011

  monitoring
• PASS Summit 2011: A Picture Book

  by Jes Borland on October 18, 2011
• SQL Server 2008 Service Pack 3 has been released

  by SQLDenis on October 6, 2011

  service pack sql server 2008
• 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
• Returning a value inserted in a table with a newsequentialid() default on a uniqueidentifier column

  by SQLDenis on September 23, 2011

  database how to sql server 2005 sql server 2008 uniqueidentifier
• 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
• Use common table expressions to simplify your updates in SQL Server

  by SQLDenis on September 10, 2011

  common table expression cte data manipulation sql server updates
• How much longer will the SQL Server database restore take

  by SQLDenis on September 2, 2011

  dmv dynamic management views restore
• 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
• SQL Injection Pocket Reference for MySQL, SQL Server and Oracle

  by SQLDenis on July 29, 2011

  mysql oracle security sql injection sql server
• How to find what column caused the String or binary data would be truncated message

  by SQLDenis on July 27, 2011

  errors importing truncation
• SQL Server Denali Feature Packs

  by SQLArcher on July 21, 2011
• TRY_CONVERT in SQL Server Denali CTP3

  by SQLDenis on July 19, 2011

  denali functions sql server try_convert
• SQL Server Columnstore Index FAQ wiki page published

  by SQLDenis on July 15, 2011

  columnstore
• Concat function in SQL Server Denali CTP3

  by SQLDenis on July 15, 2011

  concat denali functions sql server
• ColumnStore Index limitations in SQL Server Denali CTP3

  by SQLDenis on July 14, 2011

  apollo columnstore denali olap oltp
• A Quick look at the new EOMONTH function in SQL Server Denali CTP3

  by SQLDenis on July 13, 2011

  dates denali functions
• A Quick look at the new IIF function in Denali CTP3

  by SQLDenis on July 13, 2011

  denali functions iif
• SQL Server Code Name "Denali" CTP3 is available for download

  by SQLDenis on July 12, 2011

  denali
• T-SQL Tuesday #20 – T-SQL Best Practices

  by Jes Borland on July 12, 2011
• 2011 Quarter 2 Goal Review

  by Jes Borland on July 1, 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
• Book Review: Securing SQL Server By Denny Cherry

  by SQLDenis on May 27, 2011
• SQL Server Filegroup Piecemeal Restores

  by Jes Borland on May 24, 2011
• SQL Server DBA Tip 16 – Working with Files and Folders

  by Ted Krueger (onpnt) on May 17, 2011
• Separation of Duties Framework Enhancements – Ask & You May Receive

  by Brian Davis on May 16, 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
• SQLAzure – My First Cloud

  by Eli Weinstock-Herman (tarwn) on May 12, 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
• Transaction Log: VLF's, Auto Growth and Performance

  by SQLArcher on May 11, 2011
• SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory

  by Ted Krueger (onpnt) 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
• Match your defaults with your trigger values to prevent horrible fragmentation on your indexes and tables

  by SQLDenis on May 6, 2011

  pitfalls sql server 2000 sql server 2005 sql server 2008 triggers
• 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
• SQL Server 2008 R2 SP1 CTP Available for download

  by SQLDenis on April 22, 2011

  service pack sql server 2008 r2
• Should SQL Server Professionals Learn Oracle?

  by Ted Krueger (onpnt) on April 21, 2011
• Use DDL Triggers To Track Table Changes

  by SQLDenis on April 21, 2011

  alter table auditing ddl ddl triggers triggers
• When changing column data types use ALTER TABLE TableName ALTER Column syntax, don't drop and recreate column

  by SQLDenis on April 10, 2011

  dates datetime datetime2 gotcha sql server 2008
• Observing – Optimize for Ad Hoc Workload server option

  by SQLology ~ Kim Tessereau on April 9, 2011
• Be careful when passing around parameters, make sure they are the same size and type

  by SQLDenis on April 8, 2011

  best practice data types gotcha pitfalls sql server
• 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
• What does the lock icon mean in SSMS when looking at a stored procedure?

  by SQLDenis on April 6, 2011

  permissions ssms stored procedures
• SQL University – Performance Week

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

  by Jes Borland on April 4, 2011
• My Experience Attending a Free-Con

  by Jes Borland on March 31, 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
• T-SQL Tuesday #016 – COUNT and DELETE duplicates

  by Ted Krueger (onpnt) on March 8, 2011
• New Collection of SQL Server Videos on Channel 9

  by SQLDenis on March 5, 2011

  denali howto sql server 2008 r2 videos
• Come One, Come All to T-SQL Tuesday #016 : Aggregate Functions

  by Jes Borland on February 26, 2011
• What does a SQL Server developer need to know?

  by SQLDenis on February 21, 2011

  how to skills sql server 2005 sql server 2008
• Latest article by SQL Server MVP Erland Sommarskog is a gem

  by SQLDenis on February 21, 2011

  how to performance sql server 2005 sql server 2008 ssms tip
• 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
• Using Database Snapshot As A Protection Against Rogue Deletes

  by SQLDenis on February 2, 2011

  delete snapshot sql server 2005 sql server 2008
• 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
• Adding External Tools to SQL Server

  by David Forck (thirster42) on January 27, 2011
• Lessons Learned from Failing the MCTS 70-432

  by Jes Borland on January 24, 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
• Dealing with The row value(s) updated or deleted either do not make the row unique or they alter multiple rows errors

  by SQLDenis on December 8, 2010

  normalization sql server denali ssms
• 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
• Tapping Into Your Reporting Services Database

  by David Forck (thirster42) on November 19, 2010

  reporting services sql server 2005 sql server 2008 sql server 2008 r2 ssrs t-sql
• SQL Server Denali CTP1 Announced at PASS

  by SQLDenis on November 9, 2010

  ctp database sql server denali
• What SQL Server book would you recommend for a Sybase and Oracle admin?

  by SQLDenis on November 8, 2010

  books sql server 2008
• 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
• Security Auditing a Database

  by David Forck (thirster42) on October 8, 2010
• 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 Server 2008 Service Pack 2 Released

  by SQLDenis on September 29, 2010

  service pack sql server 2008
• 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
• 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
• Creating a baseline for SQL Server

  by Ted Krueger (onpnt) on August 9, 2010

  baseline monitoring performance sql server sql server 2008
• How to return only weekend data for the last 4 weeks in SQL Server

  by SQLDenis on August 6, 2010

  dates howto sql server 2008 sql server 2005
• Baseline, Performance Reporting and being a proactive DBA

  by Ted Krueger (onpnt) on August 5, 2010

  baseline monitoring performance reporting sql server 2008
• SQLCop A Tool To Highlight Potential Problems With Your Database

  by SQLDenis on July 25, 2010

  sql sql server sqlcop
• 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
• How to get the processid that SQL Server is using if you have multiple instances of SQL Server running

  by SQLDenis on May 12, 2010

  how to 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
• SSIS A difference between C# and VB in a script task

  by SQLDenis on May 3, 2010

  c# ssis vb
• 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
• Planning your SQL Server mirroring landscape

  by Ted Krueger (onpnt) on May 3, 2010

  high availability mirroring sql server 2008
• How to insert values into a table with only an identity column

  by SQLDenis on April 30, 2010

  how to identity tip
• SQL Saturday New York City recap

  by SQLDenis on April 25, 2010

  community sqlsaturday
• 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
• 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
• Finding meaningful error details to report execution failures

  by Ted Krueger (onpnt) on March 30, 2010
• Interview with me about the chapters I wrote for the SQL Server Deep Dives book

  by SQLDenis on March 26, 2010

  book interview sql server 2008
• SQL Saturday 33 – Charlotte, NC

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

  dba sqlsaturday sqlserver
• Do You Get A Benefit From Compressing Backups If You Already Have Compressed Data?

  by SQLDenis on March 2, 2010

  backups compression restores
• Choosing operating modes for mirroring over a WAN

  by Ted Krueger (onpnt) on March 2, 2010
• 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
• SQL Saturday in Chicago – Schedule is up!

  by Ted Krueger (onpnt) on February 11, 2010
• Running sp_helpdb against a snapshot shows wrong files on SQL Server 2008

  by SQLDenis on February 11, 2010

  bug feature snapshot sql server 2008
• 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
• 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
• Microsoft Announces SQL Server Migration Assistant for MySQL

  by SQLDenis on January 12, 2010

  azure mysql 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
• Procedures with cursors

  by George Mastros (gmmastros) on November 20, 2009
• Collation conflicts with temp tables and table variables.

  by George Mastros (gmmastros) on November 19, 2009
• To BUILTINAdmin or not to BUILTINAdmin

  by Ted Krueger (onpnt) on November 19, 2009
• SQL Server collation conflicts

  by George Mastros (gmmastros) on November 18, 2009
• Don't use text datatype for SQL 2005 and up

  by George Mastros (gmmastros) on November 17, 2009
• Do not use the float data type

  by George Mastros (gmmastros) on November 16, 2009
• Beginning stages of a DR plan for SQL Server

  by Ted Krueger (onpnt) on November 13, 2009
• Best Practice: Coding SQL Server triggers for multi-row operations

  by SQLDenis on November 12, 2009

  how to sql server 2000 sql server 2005 sql server 2008 tip triggers
• Best Practice: Do not cluster on UniqueIdentifier when you use NewId

  by George Mastros (gmmastros) on November 12, 2009
• Best Practice: Every table should have a primary key

  by George Mastros (gmmastros) on November 11, 2009
• Do not use spaces or other invalid characters in your column names

  by George Mastros (gmmastros) on November 10, 2009
• SQL Server 2008 R2 November CTP Available For Download

  by SQLDenis on November 9, 2009

  business intelligence gemini madison sql server 2008 sql server 2008 r2
• Always include precision and scale with decimal and numeric

  by George Mastros (gmmastros) on November 9, 2009
• Always include size when using varchar, nvarchar, char and nchar

  by George Mastros (gmmastros) on November 6, 2009
• SQL Server 2008 R2 Editions Pricing Announced

  by SQLDenis on November 6, 2009

  business intelligence gemini madison sql server 2008 sql server 2008 r2
• Test your Full Recovery model by restoring backups

  by Ted Krueger (onpnt) on November 5, 2009
• Don't prefix your table names with tbl

  by George Mastros (gmmastros) on November 5, 2009
• Don't start your procedures with SP_

  by George Mastros (gmmastros) on November 4, 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
• SQL University and why you should be attending

  by Ted Krueger (onpnt) on October 14, 2009
• Win A Copy Of SQL Server 2008 Administration in Action

  by SQLDenis on October 13, 2009

  book freebie
• 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
• T-SQL To find Out If An Index Is Clustered Or Non Clustered

  by SQLDenis on October 6, 2009

  functions how to indexing sql server 2000 sql server 2005 sql server 2008 tip
• 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
• 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
• SQL Server StreamInsight CTP2 Available For Download

  by SQLDenis on August 22, 2009

  business intelligence sql server 2008 r2 streaminsight
• 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
• Recover a database without the ldf file

  by Ted Krueger (onpnt) on August 13, 2009
• SQL Server 2008 R2 August Community Technology Preview (CTP) Announced

  by SQLDenis on August 10, 2009

  business intelligence gemini madison sql server 2008 r2
• 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
• Restoring multiple transaction log backups

  by Ted Krueger (onpnt) on July 22, 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
• Automatically create a SQL Server table in a new database.

  by George Mastros (gmmastros) on July 3, 2009
• Dynamic column names and fields in SSRS (Custom Matrix)

  by Ted Krueger (onpnt) on July 1, 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
• Writing reports off third party databases the easy way

  by Ted Krueger (onpnt) on June 5, 2009
• Removing replication and handling tables with identity seeds

  by Ted Krueger (onpnt) on June 4, 2009
• Log Shipping for DR and failing back in case of disaster. The cheap way!

  by Ted Krueger (onpnt) on June 1, 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
• SMO Script Index and FK's on a database

  by Ted Krueger (onpnt) on May 18, 2009
• Read data on Mirror to prevent production database stress

  by Ted Krueger (onpnt) on May 13, 2009
• Disaster/Recovery for Reporting Services objects (rdl, rds etc..)

  by Ted Krueger (onpnt) on May 8, 2009
• Handling long running queries with a stop sign

  by Ted Krueger (onpnt) on May 5, 2009
• Quick Data Model creation off SSAS Data Source in SSRS

  by Ted Krueger (onpnt) on April 27, 2009
• 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
• What makes a successful SQL Server Reporting Services implementation?

  by Ted Krueger (onpnt) on April 20, 2009
• Troubleshooting Performance Problems in SQL Server 2008 White Paper Released

  by SQLDenis on April 15, 2009

  performance sql server 2008 troubleshooting white paper
• 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
• Copy SQL Server Database

  by Ted Krueger (onpnt) on April 13, 2009
• Rule "Previous releases of Microsoft Visual Studio 2008" failed

  by ca8msm on April 9, 2009
• SQL Server 2008 sp1 Download

  by Alex Ullrich on April 8, 2009
• ExecutionLog Table in SSRS 2008 Gone

  by Ted Krueger (onpnt) on March 27, 2009
• Disable SQL Agent Jobs with TSQL based on events

  by Ted Krueger (onpnt) on March 26, 2009
• Backups are for sissies!!!

  by Ted Krueger (onpnt) on March 11, 2009
• Scan network for SQL Server instances

  by Ted Krueger (onpnt) on March 9, 2009
• What To Do When Your Identity Column Maxes Out

  by Erik on March 6, 2009
• Installing SQL Server 2008 express on Windows XP SP 2 without reading the manual

  by Christiaan Baes (chrissie1) on February 8, 2009

  sql server express 2008
• SQL server Linked server between 2005 64bits and a 2000 32 bits server.

  by Christiaan Baes (chrissie1) on January 9, 2009

  32 bits 64 bits linked server sql server 2000 sql server 2005
• Overlooking system databases and fragmentation

  by Ted Krueger (onpnt) on December 18, 2008
• Quest LiteSpeed update 5.0.2.1030 Released

  by Ted Krueger (onpnt) on December 17, 2008
• Impersonating a SQL Server DBA

  by Ted Krueger (onpnt) on December 16, 2008
• SQL Server Rounding Methods

  by George Mastros (gmmastros) on December 11, 2008
• Index and Statistic creation with SQL Server DTA

  by Ted Krueger (onpnt) on December 3, 2008
• Securing your password for SQL Server 2005 and 2008 and more

  by Ted Krueger (onpnt) on December 2, 2008
• ReportViewer and the RSPrintClient Control Problems

  by Ted Krueger (onpnt) on December 1, 2008
• SQL Agent Job Notifications

  by Ted Krueger (onpnt) on December 1, 2008
• Setting a standard DateFormat for SQL Server

  by George Mastros (gmmastros) on November 20, 2008
• Do not truncate your ldf files!

  by Ted Krueger (onpnt) on November 20, 2008
• Performance (How is my SQL Server running?)

  by Ted Krueger (onpnt) on November 18, 2008
• Proactive Deadlock Notifications

  by Ted Krueger (onpnt) on November 17, 2008
• Troubleshooting Blocking 101 on SQL Server

  by Ted Krueger (onpnt) on November 14, 2008
• User to Schema to Roles for controlling security

  by Ted Krueger (onpnt) on November 7, 2008
• 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
• Good SQL Articles To Read If You Can't Afford Books

  by SQLDenis on May 23, 2008

  database deadlocks functions howto math sql sqlserver tips toread tricks
• How to get the selectivity of an index

  by SQLDenis on May 20, 2008

  database indexes optimizing sql sqlserver
• Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization

  by SQLDenis on February 8, 2008

  book databases programming review sql