Browse by Tags

• AlwaysOn
• Architecture
• Automation
• Backup
• Best Practices
• Big Data
• Business Intellience
• Career
• Cloud Computing
• Clustering
• Compliance
• Conferences
• data quality
• Database Design
• Database Mirroring
• DBA
• Denali
• DevConnections
• Developer
• Devices
• Disaster Recovery
• Ethics
• ETL
• Express Edition
• FutureWatch
• Goals
• Hadoop
• Hardware
• High Availability
• Humor
• Infrastructure
• Innovation
• Internals
• Interoperability
• IO
• Leadership
• Licensing
• Management
• Memory
• Migration
• Monitoring
• MS-Access
• MySQL
• News Analysis
• NoSQL
• OData
• On-line Resources
• Opinion
• Oracle
• PASS
• People
• Performance
• Productivity
• Professional Development
• Quest Software
• Releases
• Security
• Society
• Speaking
• SQL Programming
• SQL Server 2008 R2
• SQL Server 2012
• SQLIOSIM
• SQLMag
• SSAS
• Sybase
• System Center
• Tips
• Tools
• Transact-SQL Programming
• Trends
• Troubleshooting
• Video
• Virtualization
• VMware
• Wait States
• White Papers
• WorldView
• Writing

• High-Availability White Papers and Resources for SQL Server

  These resources detail five common high-availability and disaster-recovery architectures deployed by customers, along with a case study of each, plus FAQs about SQL Server high availability. Read More... Posted Thursday, July 26, 2012 11:00 AM by KKline | 3 Comments Filed under: Administration, Troubleshooting, Database Mirroring, High Availability, Security, Backup, SQL Server 2012, AlwaysOn, Disaster Recovery

• Recorded Webcast Available: Extend SCOM to Optimize SQL Server Performance Management

  Join me and Eric Brown, Quest Software senior product manager for SQL Server monitoring tools, as we discuss the server health-check capabilities of Systems Center Operations Manager (SCOM) in this previously recorded webcast. We delve into techniques Read More... Posted Thursday, June 28, 2012 7:37 AM by KKline | 2 Comments Filed under: Administration, Quest Software, On-line Resources, Monitoring, System Center, SQL Server 2012, Video

• 'Backup Completed' is NOT an Error Message

  I recommend that you set your SQL Server to use the startup traceflag DBCC TRACEON (3226) to disable backup success message... Read More... Posted Thursday, May 17, 2012 9:40 AM by KKline | 11 Comments Filed under: Administration, Backup, SQL Server 2012

• Build Your Own Microsoft Operations Manager Pack

  Want to develop your own Operations Manager Management Pack? Here's how. Read More... Posted Thursday, May 03, 2012 11:25 AM by KKline | 0 Comments Filed under: Administration, Automation, Infrastructure, Architecture, Management, On-line Resources, System Center

• Give A Round of Applause for Microsoft System Center!

  Check out this collection of useful engineering blogs from the Microsoft System Center team. Read More... Posted Monday, April 30, 2012 11:12 AM by KKline | 2 Comments Filed under: Administration, Management, Monitoring

• New White Paper: SQL Server Extended Events and Notifications

  Download the new, free white paper from Microsoft MVP Jason Strate detailing SQL Server Extended Events and Event Notifications (registration required). Read More... Posted Wednesday, April 25, 2012 9:13 AM by KKline | 10 Comments Filed under: Performance, Best Practices, Administration, Troubleshooting, Tools, Automation, Infrastructure, DBA, SQL Server 2008 R2, White Papers

• Everybody Needs a Test Harness

  Here's a handy little block of T-SQL code to improve code stability. Read More... Posted Monday, October 31, 2011 10:17 AM by KKline | 3 Comments Filed under: Performance, Administration, Troubleshooting, Developer, Automation, DBA, Transact-SQL Programming

• Upcoming SQLSaturday Events in Omaha and Atlanta!

  I've had enough time off from traveling after my surgery to finally travel again. First on the circuit , set for August 27th, is Omaha, Nebraska and SQL Saturday #91 . As a former Crimson Tide alum, I was stoked about going to the University of Nebraska, Read More... Posted Wednesday, August 17, 2011 11:47 AM by KKline | 1 Comments Filed under: Best Practices, Administration, Speaking, Quest Software, Conferences

• New on "Database Trends & Applications"

  In last month's column, "2012 Might Really Be the End of the World as We Know It," I described a number of major developments in the IT industry that are likely to disrupt the life of database professionals everywhere Read More... Posted Tuesday, August 16, 2011 3:37 PM by KKline | 0 Comments Filed under: Trends, Administration, Virtualization, Professional Development, FutureWatch, Devices, Goals, News Analysis, Developer, Career, Innovation, Infrastructure

• Microsoft Document Watch for Operational Excellence

  Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence . I read everything I could on the topic. I made a list of favorites, which became somewhat Read More... Posted Monday, August 08, 2011 3:59 PM by KKline | 0 Comments Filed under: Best Practices, Administration, Internals, Interoperability, High Availability, Security, Compliance, Infrastructure, Architecture

• ETL Demo With Data from Data.Gov

  The idea of ETL leveraging semantic abstraction is quite intriguing and it me a good excuse to use data from data.gov to build a quick demo. Read More... Posted Friday, August 05, 2011 5:45 PM by KKline | 3 Comments Filed under: Administration, Tools, Business Intellience, ETL, Big Data, OData

• Managing Complex DB Environments

  Let's address methods for successfully managing today’s complex heterogeneous database infrastructures. Read More... Posted Wednesday, August 03, 2011 11:05 AM by KKline | 4 Comments Filed under: Trends, Administration, Quest Software, Interoperability, Oracle, Sybase

• Run as Radio Podcast - A little Denali

  In this podcast on the uber-popular podcast "RunAs Radio", host Richard Campbell asks me about what topics are of particular interest at Tech-Ed 2011, focusing the discussion on cloud and SQL Server "Denali" You can download the MP3 version of the podcast Read More... Posted Tuesday, August 02, 2011 2:36 PM by KKline | 0 Comments Filed under: Administration, Cloud Computing, FutureWatch, Denali

• Is There Such a Thing as Easy ETL?

  As soon as your data loading process involves some difficult or sophisticated cleansing or transformations, it gets really, really hard. I've found a cool, free tool - expressor studio - that shields your data integration application, with its associated business and transformation rules, from changes that might occur to underlying target or source files. Read More... Posted Thursday, June 30, 2011 12:57 AM by KKline | 1 Comments Filed under: Administration, PASS, Tools, SQLMag, ETL

• Pain of the Week/Expert's Perspective: Performance Tuning for Backups and Restores

  First off - the Pain of the Week webcast series has been renamed. It's now known as The Expert's Perspective . Please join us for future webcasts and, if you're interested in speaking, drop me a note to see if we can get you on the roster! The bigger Read More... Posted Monday, June 27, 2011 10:39 AM by KKline | 0 Comments Filed under: Performance, Best Practices, Administration, Troubleshooting, Automation, High Availability