THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DBA   (RSS)
Showing page 1 of 13 (128 total posts)
  • ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior - SQL Server Performance

    Here are some oldies, but goodies that I recommend you read:Two Partitioning Peculiarities and Aggregates and PartitioningMost of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in detail by internals master Paul White ...
    Posted to Kevin Kline (Weblog) by KKline on March 30, 2015
  • ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo - SQL Server Performance

    Aaron Bertrand (b | t) is on a roll this month's SQL Server performance highlights with more great articles from SQLPerformance.com. Troubleshooting AlwaysOn – Sometimes it takes many sets of eyesAaron Bertrand (b | t) hit some obstacles recently when configuring an Availability Groups lab environment. This post ...
    Posted to Kevin Kline (Weblog) by KKline on March 9, 2015
  • ICYMI: the Halloween Problem and DBCC CheckConstraints - SQL Server Performance

    Don't miss these great articles on SQLPerformance.com from the industry’s top experts:A Look At DBCC CHECKCONSTRAINTS and I/OErin Stellato (b | t) of SQLskills takes a deep look into the I/O impact of running DBCC CHECKCONSTRAINTS, including explaining why some check methods may consume a lot more I/O than others.The ...
    Posted to Kevin Kline (Weblog) by KKline on March 2, 2015
  • ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

    One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What'dya want, a hand-written invitation?!?) I want to take a moment to point out a good one that I think anybody who writes SQL code on SQL Server should watch.If you know anything about the staff ...
    Posted to Kevin Kline (Weblog) by KKline on February 27, 2015
  • ICYMI: Sequences, CPUs, and Trimming T-Logs

    Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info comes from the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013: Generate a set or sequence without loopsAaron Bertrand (b|t) provides detailed performance information ...
    Posted to Kevin Kline (Weblog) by KKline on February 23, 2015
  • IT Pro Events & Free Stuff for the Central USA – Jan 2015

    Central USA IT Pro Community News – Jan 2015 There are lots of free, in-person and virtual events happening in the central USA over the next few weeks. Don't miss out on training, ebooks, and other goodies! Come to the Nashville SQL Saturday on Jan 17!Upcoming Events Jan 10th – Kansas City – SharePoint Saturday Jan ...
    Posted to Kevin Kline (Weblog) by KKline on January 8, 2015
  • Mission Critical Performance Enhancements in SQL Server 2014 on DBTA.com

     Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.”  Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and ...
    Posted to Kevin Kline (Weblog) by KKline on November 28, 2014
  • SQL Server 2014 Overview on DBTA.com

     Haven't upgraded late? Well, SQL Server 2014 is a great place to start! Perhaps this is your first time reading my column on DBTA.com or you don’t know much about SQL Server. If either of those are true, then it might be a surprise to you that Microsoft has accelerated the release cadence for SQL Server to around one new release every ...
    Posted to Kevin Kline (Weblog) by KKline on November 25, 2014
  • Third Party Applications and Other Acts of Violence Against Your SQL Server

    I just got finished reading a great blog post from my buddy, Thomas LaRock (t | b), in which he describes a useful personal policy he used to track changes made to his SQL Servers when installing third-party products. Note that I'm talking about line-of-business applications here - your inventory management systems and help desk ...
    Posted to Kevin Kline (Weblog) by KKline on August 12, 2014
  • You Need a DBA

    This post was inspired by a recent conversation with a DBA followed by reading The Curse of Relational Databases (especially the comments) posted at Grant Fritchey’s SQL Server Central blog. I have two points to make: As of mid-2014 a physical person is required to properly administer a production relational database instance. The title ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 24, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement