-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2014

How to Make Sure Your Clients Can Connect to a Multi-Subnet Cluster

When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to make sure you understand a few things in order for your applications to work properly after a failover. For the sake of our discussion, let’s assume we have a multi-subnet… Read more

2 comments, 793 reads

Posted in Matan Yungman on 29 September 2014

PASS Votes… A little bit more #passvotes

I am putting up an abnormal Saturday morning blog post in support of the actions taken by the PASS Board last night.

The story so far…

In order to eliminate all the excess ballots (I received 5 one year although I only used one) being sent to eligible members… Read more

1 comments, 486 reads

Posted in The Scary DBA on 27 September 2014

PASS got it right

This morning I received an email (really 3 emails) about an extension for voting for the Board of Directors giving anyone registered with PASS before June of 2014. I think this is fair and gives those that have been active, but did not update their profile a chance to… Read more

2 comments, 634 reads

Posted in The Smiling DBA on 27 September 2014

Reblog: September 19 to September 25

Photo credit – Mike Lynch

A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… Read more

1 comments, 614 reads

Posted in StrateSQL on 26 September 2014

PASS Rocks SQL Saturday

I had another piece that looked at some issues with PASS slated for today, but it’s been a tough morning. Both with work, and with the conflict with PASS, so I’m going to move this up and give PASS more praise. As conflicted as I am about the organization, it… Read more

1 comments, 800 reads

Posted in The Voice of the DBA on 26 September 2014

Development, Leadership, Age

While I was at the VMWare HQ getting some amazing training a few weeks ago, we had the opportunity to meet a large number of “C” level people from that organization and Pure Storage. In addition, they had multiple development and project management leads come and talk to us. All… Read more

2 comments, 511 reads

Posted in The Scary DBA on 26 September 2014

People Helping People – Volunteers

Continuing on with things that PASS does well, since I want to be balanced, I wanted to talk about volunteers.

I don’t know if you’ve noticed, but PASS gets a lot of volunteers. There are volunteers that run SQL Saturdays. Volunteers that run user groups. Volunteers that help out for… Read more

0 comments, 704 reads

Posted in The Voice of the DBA on 26 September 2014

Friday Followup For September 26, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Building (for FREE) a Virtual Server for SQL Demos
  • Presto Chango…

Read more

0 comments, 365 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 26 September 2014

Re-Indexing – The quest of ultimate automation

In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.

Read more

0 comments, 511 reads

Posted in SQLFeatures on 26 September 2014

Wait Statistics #4 LCK_M_xx

In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type you are sure to see in your environment!

LCK_M_xx waits

As you can guess the LCK_M_xx waits have a relation with locking, they are generated when a query wants… Read more

0 comments, 692 reads

Posted in DotNine SQL Server and more on 26 September 2014

Four Big Things PASS Could Do Next Year

Here’s my wish list:

  • Fix the membership problem. One voter, one vote. That’s what we want. The current hack of requiring an updated profile is just that, a hack. Fixing this, making sure that elections are solid and that members have one permanent PASS identity leads to all kinds of…

Read more

0 comments, 633 reads

Posted in SQLAndy on 25 September 2014

Installing SQL Server 2014 Language Reference Help from disk

Some weeks ago I had to wipe my machine and reinstall everything from scratch, SQL Server included.

For some reason that I still don’t understand, SQL Server Management Studio installed fine, but I couldn’t install Books Online from the online help repository. Unfortunately, installing from offline is not an option… Read more

5 comments, 675 reads

Posted in SpaghettiDBA on 25 September 2014

The BaCON Debacle, or Who’s Mike?

Who is Mike in the business intelligence/analytics world?

Is it Mike White? If it is, he’s the guy I call for help with SSAS stuff. I’ve known Mike for years and he’s a smart guy.

Is it Mike Davis? He’s another smart guy. I don’t know him, but I… Read more

5 comments, 860 reads

Posted in The Voice of the DBA on 25 September 2014

A Bad Day with Backups


I learned a hard lesson when I first started as a DBA.  Although to be honest, it’s not a lesson I should have had to learn (I’ll keep you in suspense).  I work for a large Fortune 100 company and as with many companies our size, there are many processes… Read more

10 comments, 7,015 reads

Posted in Ryan Adams on 25 September 2014

SQLSaturday Orlando Marketing Plan-Part 47

Notes:

  • We sent out a final you haven’t paid for lunch reminder on Wed, asked for a reply if they were planning to bring their own. 20 or so are, so far. We don’t mind that they do of course, but it’s really valuable information because it’s another block of…

Read more

0 comments, 411 reads

Posted in SQLAndy on 25 September 2014

An Amazing Conference

I said that I’d write about some good things PASS does, and I’ll make it a point to do so. Despite my complaints and criticisms, I like the organization. I’ve been a part of it since October 1999, when the initial conference was in the basement ballroom of a hotel… Read more

0 comments, 6,697 reads

Posted in The Voice of the DBA on 25 September 2014

Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR

Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to their latitude/longitude locations so I could use that data within some Tableau dashboards that I’m working on. I had a look around to see what I could find and quickly… Read more

0 comments, 1,077 reads

Posted in SQL Server Rocks! on 25 September 2014

Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR

Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to their latitude/longitude locations so I could use that data within some Tableau dashboards that I'm working on. I had a look around to see what I could find and quickly… Read more

0 comments, 224 reads

Posted in SQL Server Rocks! on 25 September 2014

Presto Chango

About six months ago, I wrote a post reviewing a book titled The Phoenix Project. In that post, I compared the events in the book to my experiences in my role as a production DBA. I also shared some ideas that I gained from the book to help improve… Read more

0 comments, 392 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 September 2014

SQL Server 2014 Cardinality Estimator

SQL Server 2014 Cardinality Estimator

The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query plans in both OLTP and data warehousing solutions.  The cardinality of a field refers to the number of unique values that are populated in the table.  Gender would…

Read more

0 comments, 811 reads

Posted in Business Intelligence and Enterprise Architecture on 25 September 2014

Newer posts

Older posts