Posts
  • SQL Shep

    SQL Server 2014 Updatable Columnstore Index

    • 2 Comments
    I have had many calls with customers that essentially ended with your I/O subsystem cannot keep up with your workload. The obvious next question was how do we solve that? My answer was usually get a faster IO subsystem or do less IO! Now, SQL 2014 offers...
  • SQL Shep

    SQL Server 2014 Managed Lock Priority for Partition Switch and Online Reindex

    • 0 Comments
    Online reindex and partition switch have both been around for a while now, however one of the biggest issues which still exists is they both require a schema modification lock which is very unfriendly with other locks. From the lock compatibility matrix...
  • SQL Shep

    SQL 2012 and SQL 2014 NUMA Fix

    • 0 Comments
    SQL 2012 and SQL 2014 NUMA Fix Typically a SQL Server Cumulative Update release is not a noteworthy event, however SQL Server 2012 SP1 CU9 and SQL Server 2014 CU1 include a fix that is noteworthy from a from a CAT Lab perspective. In short, if you...
  • SQL Shep

    Windows Azure Privacy, Security and Compliance

    • 0 Comments
    One of the questions that is very common among customers is what is the security compliance of Azure? This is a very short question with a very long answer. To shorten your search visit the Microsoft Azure Trust Center . At the time of this posting...
  • SQL Shep

    SQL 2014 In-Memory OLTP papers released

    • 0 Comments
    We have released a new feature in SQL Server 2014 that may significantly improve OLTP application performance called “In-Memory OLTP” codename "Hekaton". A single blog post cannot come close to describing the features, benefits and complexities...
  • SQL Shep

    SQL 2014 Standard Edition Improvements

    • 0 Comments
    Good News Everyone! SQL Server 2014 Standard Edition has new features for 2014. 1. Increase in supported RAM to 128GB . 2. Addition of Buffer Pool Extension (BPE). Imagine BPE as a warm cache for the SQL Server buffer pool. As clean pages are aged...
  • SQL Shep

    New Paper Released on SQL 2014 Cardinality Estimation

    • 0 Comments
    There is a new Cardinality Estimator in SQL 2014 . I wanted to drop a quick post to cover a few key points; All of this can be found in Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator A re-designed cardinality estimator...
  • SQL Shep

    Head Blocking Script, Again…

    • 0 Comments
    Did I mention I use this blog to keep scripts so I do not lose them? Well, I do, it is easier to find stuff on the internet than it is on my own machine. This script is not new, it is not extra special for 2014, it's just a basic head blocker script with...
  • SQL Shep

    SQLCAT.com has left the building, but not really...

    • 0 Comments
    Wow, it has been entirely too long since I have posted anything. But I can assure it has been for good reason. I have been neck deep in Hekaton, Column Store and a few other treats in SQL 14. However, I am going to talk about none of that today. If you...
  • SQL Shep

    Azure Billing per minute and No Compute Charge for a stopped IaaS VM

    • 2 Comments
    *Updated to account for Stopped (Deallocated) which means stopped from the portal, not just shutdown from inside the instance!!! You asked for it Microsoft did it. Billing per minute is pretty self-explanatory, prior to June 3 all IaaS compute hours...
  • SQL Shep

    SQL 2014 Preview announced at TechED

    • 0 Comments
    In case you missed it this week and I doubt you did, it was announced at TechED that SQL 2014 will be available for preview the end of this month (June). The biggest most interesting feature for me is In Memory OLTP, of which I am happy to share the first...
  • SQL Shep

    New CAT White Paper Published, SQL Perf in the cloud!

    • 0 Comments
    It is going to be a very busy summer with all the new toys going into preview, but before I get into all of those I wanted to share a paper that was released on SQLCAT.com this week; Performance Guidance for SQL Server in Windows Azure Virtual Machines...
  • SQL Shep

    Spelunking Azure, What does it Cost?

    • 0 Comments
    As I mentioned in a prior post I will be spending some time on Azure, I imagine the things I run into that stump me are probably stumping to the community as well be you a SQL professional, Windows Admin or otherwise. You will know the non SQL specific...
  • SQL Shep

    Multi-Terabyte File Storage in the Cloud using DFS!

    • 1 Comments
    We recently had a question come to the team about DFS(Distributed File System ) in Azure. The short answer is; it works as documented, simply follow the Windows documentation for setting up a DFS Namespace. Many links for you on DFS at the bottom of this...
  • SQL Shep

    I WANT YOUR FEEDBACK ON AZURE!

    • 4 Comments
    It’s no secret that Microsoft has had a huge push for Azure. Even within the CAT team the effect is noticeable. Usually within 24 hours this blog is at least acknowledged if not read by several hundred people, and there is no doubt you are representative...
  • SQL Shep

    Cloud Spelunking, Managing Azure form your Desktop via PowerShell (the Setup)

    • 2 Comments
    These next few posts are going to deviate from the normal SQL, but in time I will get back to that. It recently came to pass that I had to build a domain in the cloud and I will admit setting up the PowerShell management aspects of this task took much...
  • SQL Shep

    Windows 2012 and .Net 3.5 Feature Install

    • 14 Comments
    Windows 2012 Sever RTM was this week, I can think of no better way of honoring it than to write a post on the first thing you will have to work around when installing anything that needs .Net 3.5. While it is well know the .Net is a feature that must...
  • SQL Shep

    SQL 2012 Security Audit 3 (Predicate and Failure)

    • 2 Comments
    This is the script to bring it all together. In this case I have opted for just a server side specification with a filter on the database and exclusion of system objects. You can certainly leave the access to system objects, however it will generate a...
  • SQL Shep

    SQL 2012 Security Audit 2 (Database Audit)

    • 0 Comments
    After mastering SQL Server Audit creation the next item is the database audit. As the name indicates, the Database Audit is Database scoped, so it will focus to the database level actions. This can be useful if you have a single database on the server...
  • SQL Shep

    SQL 2012 Security Audit 1

    • 1 Comments
    While the SQL Server audit is not difficult to setup, I am still seeing many folks use and ask about SQL server side trace to address their auditing needs. Though the SQL Server Audit is a bit confusing the first time or two you set it up it is vastly...
  • SQL Shep

    PASS 2012 Sessions posted

    • 0 Comments
    Nothing techy today, just a reminder that phase 1 of PASS early registration ends June 30. The individual rate will go from $1395 to $1595 on July 1. You will have until October 1 before the rate jumps again. If you can find 4 friends to go with, the...
  • SQL Shep

    Thank you, and Who is on my schedulers?

    • 0 Comments
    In the last two days I have had over 2000 page views on the two posts I have put up. I know I am not that good of blogger yet and the posts are not riveting, so I can only assume that it is the work of Joe Sack and Grant Fritchey who have blasted my blog...
  • SQL Shep

    SQL Server 2012 License Core Limitaion

    • 3 Comments
    Well, I wondered how long it would take before I got a case related the 2012 licensing change, looks like today was the day. I will admit, it is confusing and at the end of the day it is usually not the fault of the DBA that you ended up with a 20 core...
  • SQL Shep

    Surface and SQL

    • 0 Comments
    For my first post i can think of nothing better than mentioning the new Surface . I recall when we demoed the original Surface about 4-6 years ago, depending on where you were at the time. As time goes by it will be more difficult to find a reference...
Page 1 of 1 (24 items)