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

Latest Blog Posts

Top 10 Recommended Books…

So the title says it all, right?  Well, only really partially.

Recently an article was published listing the top 10 most recommended books for SQL Server.  That’s the part the title doesn’t say.  It is really important to understand that we are talking about the top 10 recommended books for… Read more

0 comments, 28 reads

Posted in SQL RNNR on 29 July 2014

How to Edit Read-Only Non-clustered Columnstore Data

As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well as the base table read-only. Which means you can’t insert, update, or delete any data until your drop the index. This may seem like a huge issue, but in…

Read more

0 comments, 47 reads

Posted in Everyday SQL on 29 July 2014

Rename or Change SQL Server Standalone Named Instance

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

Renaming or Changing SQL Server Standalone Named Instance is almost same as SQL Server Standalone Default Instance. You can change a SQL server named SQLServerinstance1 to some other name, such as SQLServerNewinstance1, but… Read more

0 comments, 49 reads

Posted in MSSQLFUN on 29 July 2014

The Growth Of SQLSaturday

A recent Connector showed the following stats for SQLSaturday for the fiscal year ending June 30, 2014 and mentioned 86 events completed:

 

Impressive numbers to be sure, but are we adding events?   Kendal Van Dyke sent me this projection he did while on the Board of Directors:

 

That… Read more

2 comments, 69 reads

Posted in SQLAndy on 28 July 2014

Building The SQLSaturday Orlando Marketing Plan-Part 26

More notes:

  • In hindsight it’s easy to see we should have worked on the email template first, then the flyers. Email is our #1 way of communicating and it’s important to try to get as much out of it as possible.
  • My original vision was to show the seminars as…

Read more

0 comments, 45 reads

Posted in SQLAndy on 28 July 2014

What is ANSI_NULLS and why will I be glad when it finally goes away?

Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and said I would discuss it later. Well it’s later.

In the previous post I discussed how NULL is basically “unknown”. And any time you compare something to “unknown” you… Read more

0 comments, 85 reads

Posted in SQLStudies on 28 July 2014

Why do we need UPDATE Locks 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.)

Today I want to talk about a specific question that I almost get every time when I… Read more

0 comments, 104 reads

Posted in Klaus Aschenbrenner on 28 July 2014

Book: SQL Server 2014 Development Essentials

I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by Packt Publishing.

SQL Server 2014 Development Essentials, ISBN: 9781782172550

SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples, which… Read more

0 comments, 64 reads

Posted in Basit's SQL Server Tips on 28 July 2014

Lost Administrator SA password SQL server 2012

There are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server is new to you and no idea that has own and access to it. In my case the second option J

In my opinion, it’s very easy to work on… Read more

0 comments, 270 reads

Posted in SQL Server Blog Forum on 27 July 2014

Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 1 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 79 reads

Posted in MSSQLFUN on 27 July 2014

Webinar Q&A: Getting Started with Change Data Capture

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so thank you to everyone that attended. If you were unable… Read more

0 comments, 75 reads

Posted in Bradley Schacht on 25 July 2014

Speaking on ETL Security

I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.

Securing the ETL Pipeline

We’re going to look at typical ETL (Extract, Transform, Load) pipelines and consider the weak points an attacker might go after. Our goal in this isn’t… Read more

0 comments, 84 reads

Posted in Databases – Infrastructure – Security on 25 July 2014

Reblog: July 18 to July 24

Photo credit – Husso

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… Read more

0 comments, 82 reads

Posted in StrateSQL on 25 July 2014

A Question From The NomCom

One of the many things we’re discussing going into the 2014 PASS election is what the planned two official campaign events should be. I asked on Twitter yesterday and got some good comments, still looking for more. Last year was (I think) the first year PASS hosted live events, one… Read more

0 comments, 72 reads

Posted in SQLAndy on 25 July 2014

Friday Followup For July 25, 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
  • Which One’s Better?
  • Cheating DBCC To Fix Index Corruption
  • Building (for…

Read more

0 comments, 63 reads

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

Thank You SQLBits!

Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party entertainers, long suffering partners and anyone else involved with the event as it was a top, top few days.

This was my 3rd SQLBits after Liverpool + Nottingham and in… Read more

0 comments, 65 reads

Posted in SQL Server Rocks! on 25 July 2014

Power View report migration from SharePoint 2010 to 2013

With the latest changes to the Microsoft Power BI and ability to create Power View reports within an Excel file (starting from Excel 2013) perhaps there will be no big need to migrate old stand alone Power View reports which were based on Power Pivot data models created in Excel…

Read more

0 comments, 82 reads

Posted in Data Adventures on 24 July 2014

SQL PASS Performance Palooza 2014 Wrap-Up

Today I presented a fun session for the SQL PASS Performance Virtual Chapter’sSummer Performance Palooza 2014” entitled “Infrastructure Tuning for SQL Server”.

Abstract: Mention SQL Server performance to any DBA, and the impulse is to dive headfirst into the database and queries. However, if the infrastructure underneath… Read more

0 comments, 68 reads

Posted in Technobabble by Klee from @kleegeek on 24 July 2014

How To Get The Boss To Pay For Training

How do you get the boss to pay for training? In my experience you have to:

  • Ask. The boss isn’t sitting around thinking of ways to make your life better
  • Align. Ask for training that is relevant, or show how it is relevant if not obvious
  • Persist. Even if you…

Read more

1 comments, 92 reads

Posted in SQLAndy on 24 July 2014

Quick Tips–SQL Prompt Custom Aliases

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into a few people that weren’t aware of some of… Read more

0 comments, 79 reads

Posted in The Voice of the DBA on 24 July 2014

Older posts