Latest Blog Posts
On a client server they are running 32-bit SQL Server 2005 (I know, not supported - that's a different rant/post) on a 64-bit Windows 2008 installation. When I logged…
If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00 PM (EDT)
Do you need to build a High Availability (HA) and/or Disaster Recovery (DR) strategy for SQL Server Databases? If so, you will no doubt have questions like: Read more
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available as I noted before. Unfortunately, reading through the full set of documentation, I have some criticisms to offer. The layout of the documentation goes through “Common runbook tasks”… Read more
I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.
In Europe, Canada and… Read more
Practical Data Migration Strategies
As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many times this includes moving data housed in one technology (legacy) to the upgraded or new platform that is being implemented. Depending upon what you are trying to accomplish there… Read more
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
If you have simple queries or functions that you use regularly you can assign them to a…
I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There are a number of sessions I want to attend including Eric Mezell’s An Introduction to Hadoop, Andy Egger’s Applied Predictive Analytics, David Browne on Enterprise Business Intelligence (for lunch) and… Read more
In short, I will dismiss the notion that float provides a realistic advantage in…
Have you seen the schedule for SQL Saturday #285 – Atlanta? Holy cow they have jam packed too many hard decisions into that schedule. I’ll be presenting Maintenance and Backups: Intro to Ola Hallengren bright and early at 8:15 in the Admin Room, aka Room 3. Luckily for everyone… Read more
I’ve fallen down on my challenge over the last month. It’s been a content time, with me working more towards presentations and writing most of Mar and April to meet deadlines and commitments. I also let my calendar reminder die in Feb and didn’t renew it.
As a result, here… Read more
SQL Server 2014 was officially released in April 1st, 2014. You can download the 120 day Enterprise edition trial version here: http://technet.microsoft.com/en-US/evalcenter/dn205290
As with previous version of SQL server, there are three primary editions of SQL Server 2014 available.
It has been nearly a month since your last blog post Mr. Carter, and frankly your last post was nothing more than a list of things you did in Madison. What gives? Where are you? What is so important that you must leave with such reckless abandon as to not… Read more
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… Read more
Do you know what the “Three A’s of Security” are and how they apply to Microsoft SQL Server? Let’s look at them as they are important for managing security properly on a given Microsoft SQL Server.
Authentication is determining who a person/process is.
When a connection is made, it’s… Read more
Blogging isn’t easy. You have to come up with a topic, write about it, and then release it for the world to see. That’s three kinds of pressure. Now most of us don’t have hundreds or thousands of readers, but the pressure is still there, and it can lead to… Read more
That is a patently false statement and total BS. It sure does crawl up your spine though doesn’t it? Why then do we need to do this?
I read an article, “How DevOps is Killing the Developer,” and, frankly, was a little put off by this:
Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :-
1) Open SQL Server Installation Center > Go to Installation from Left > Click on New SQL Server Failover installation from right
2) Click RUN to start setup
3) Click ok after validation check. In case of… Read more
I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA skills upgrade class in an onsite class to one of Learning Tree’s clients. For those of you that don’t know, a Learning Tree onsite is event is when Learning… Read more
Abstract: Do you have a new piece of hardware going into service and want to see how well it performs? Or do you have a few systems and want to… Read more