Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2014

PASS SQLSaturday – speaking on “Streamlining SQL Server Implementations across organization”

In this session Prakash will walk through the process he has implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

Read more

0 comments, 193 reads

Posted in SQLFeatures on 30 June 2014

HA and DR Precon in Baton Rouge

I’ll be doing a precon for SQLSaturday #324 in Baton Rouge Louisiana on August 1st, 2014 titled “A Day of High Availability and Disaster Recovery” .  If you can make it, I would love to have you in the class.  We are going to cover backups, windows clustering, AlwaysOn Failover… Read more

0 comments, 120 reads

Posted in Ryan Adams on 30 June 2014

SSC Editorial: The Product Centric Career

The Product Centric Career is my latest editorial for SQLServerCentral, this one from the perspective of my own career and how I sort of made decisions that led me to focus on SQL Server.

Read more

0 comments, 178 reads

Posted in SQLAndy on 30 June 2014

Last Weeks Top “Reading” Links #90

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

1 comments, 248 reads

Posted in StrateSQL on 30 June 2014

Speaking at the SQL PASS Summit 2014

The SQL PASS Summit 2014 community sessions were recently released. I’m very pleased and honored to announce that I will be presenting a 75-minute session entitled “Right Sizing Your Virtual Machine” at the Summit this November. It’s a topic that I spend many hours a week on… Read more

0 comments, 147 reads

Posted in Technobabble by Klee from @kleegeek on 30 June 2014

The Curse of Working With A DBA

I no more than finished my rant from last week than I started thinking about all the reasons why a healthy chunk of the reasons that developers want to bypass relational database is not the horror of the relational database itself, although, that’s there. No, a very large reason why… Read more

10 comments, 310 reads

Posted in The Scary DBA on 30 June 2014

Make BOL your friend

One of the most powerful tools we have as users of SQL Server is Books Online (BOL).  Whether you work mainly as an admin, a developer or in BI, Microsoft has provided a HUGE amount of information for you to use.  But BOL is by no means your only resource… Read more

0 comments, 272 reads

Posted in SQLStudies on 30 June 2014

Introduction to Spinlocks in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In last weeks blog posting I have talked about Latches in SQL Server. At the end I… Read more

0 comments, 497 reads

Posted in Klaus Aschenbrenner on 30 June 2014

I like to move it, move it. Upload and download binary data to or from SQL Server using standard tools

Imagine that you have a huge collection of Hello Kitty images (I do).
One day you make a decision to organize your collection - sort it, label it, tag it, remove duplicates and so on. The first thing you need - sophisticated data storage, of course. And it is obvious…

Read more

2 comments, 137 reads

Posted in SQL Code Guard on 30 June 2014

Rename or Change SQL Server Standalone Default Instance

Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance.

Step 1 : Check Current Instance & host name

Current Host Name : admin-0783e4076

Current SQL Instance Name : admin-0783e4076

Select @@ServerName ServerName, Host_name() HostName

Step 2 : Rename Host name & reboot the… Read more

6 comments, 391 reads

Posted in MSSQLFUN on 30 June 2014

Speaking at SQL PASS Summit 2014

I am honored to be selected to deliver 2 sessions at the SQL PASS Summit 2014. I will be delivering a half day session on administering BI systems and a regular session on techniques for indexing. If you were selected to speak this year, congratulations. I look forward to attending…

Read more

Building The SQLSaturday Orlando Marketing Plan-Part 21

Been busy the past week, not as much time on this as I’d have liked:

  • Received the “retro” flyer with the minor revisions we requested
  • Decided flyers are final in design, just need to get them all into PDF
  • Had our first weekly call and talked about the tempo for…

Read more

0 comments, 225 reads

Posted in SQLAndy on 27 June 2014

Speaking at PASS Summit 2014

I am excited and humbled to be speaking at the PASS Summit for my second year in a row! There were 943 submissions and only 144 spots, so I am really excited and honored to be a part of the largest and most amazing SQL Server conference in the world.… Read more

0 comments, 140 reads

Posted in Ryan Adams on 27 June 2014

Reblog: June 20 to June 26

Photo credit – Travis

Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more

1 comments, 174 reads

Posted in StrateSQL on 27 June 2014

PASS Summit Session Selection

Let’s make it democratic. Let’s ensure we get solid sessions from key people. And let’s save a ton of work in the process.

Spotlight Sessions:

There are certain folks that are extremely knowledgeable in their areas of expertise. They also happen to be excellent presenters. Have the spotlight sessions and… Read more

10 comments, 151 reads

Posted in Databases – Infrastructure – Security on 27 June 2014

What is 268435456?

What is 268435456? is the Friday question of the day. It’s a trivia question, but maybe an interesting one for all that. Better than 50% getting it right, not bad for a Friday question!

 

Read more

0 comments, 252 reads

Posted in SQLAndy on 27 June 2014

Mile High Tech Con

There’s a brand new business intelligence conference launching next month in Denver, Colorado.  The Mile High Tech Con is a three-day event taking place July 24-26, 2014, and is aimed at business intelligence practitioners, data analysts, and information managers/CIOs. 

From the event website:

Featuring three days of sessions and events… Read more

0 comments, 144 reads

Posted in Tim Mitchell on 27 June 2014

What is an “operational” DBA?

On Facebook last night, I posted the following:

An operational DBA isn’t just a manager of a traditional RDBMS, transactional system. An operational DBA manages the data platform, whatever it is, when it hits production. Their goals are not traditionally the same as someone focused on development. They are looking…

Read more

2 comments, 194 reads

Posted in Databases – Infrastructure – Security on 27 June 2014

Friday Followup For June 27, 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

  • Dell Webinar: Subqueries For Superheroes
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed By Bad Parameter Sniffing

Read more

0 comments, 101 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 27 June 2014

SQL Saturday #316, MVP’s, MCMs and a baby.

G’Day,

Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).

We learnt a lot from running our first SQL Saturday back in August 2013 – which was SQL Saturday #252

For the second year in a row we hosted… Read more

1 comments, 193 reads

Posted in measure twice, cut once. on 27 June 2014

Older posts