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

Latest Blog Posts

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, 17 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, 12 reads

Posted in Klaus Aschenbrenner 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, 191 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, 60 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, 67 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, 74 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, 61 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, 67 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, 56 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, 59 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, 76 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, 64 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

0 comments, 83 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, 74 reads

Posted in The Voice of the DBA on 24 July 2014

My Visit to WPC 2014

Last week I attended WPC. This is an annual event organized by Microsoft for its partners around the world. WPC stands for “Worldwide Partner Conference”, and this is exactly what it is. Last week it was held in Washington D.C, and there were 16,000 people in this event from over… Read more

0 comments, 24 reads

Posted in Guy Glantser on 24 July 2014

Building the SQLSaturday Orlando Marketing Plan-Part 25

Just the chart today. We’re considerably ahead of previous year registrations for the same number of weeks out. I’m looking at that number every day now!


Read more

0 comments, 72 reads

Posted in SQLAndy on 23 July 2014

T-SQL–Converting Seconds to Time

I was working on a small piece of code the other day that was calculating the seconds for an event. I had a function that returned me the seconds as an integer. That’s good, but I wanted to get that value back in minutes and seconds. The scale wasn’t so… Read more

1 comments, 169 reads

Posted in The Voice of the DBA on 23 July 2014

Challenge Accepted

There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these:

Oh please! Couldn’t we be a little more challenging? Anyway, here’s the deal, you donate to a good cause, Doctors Without Borders. We hit 10K and I’ll sport those… Read more

4 comments, 89 reads

Posted in The Scary DBA on 23 July 2014

Find Users Logged Into Remote Computer

Have you ever wanted to find out if someone is logged into a computer or maybe who is logged into a computer without having to remote in to check? Recently I was working on a project doing some SharePoint work using 3 accounts: Admin/Install, Farm and Service. The work I… Read more

2 comments, 97 reads

Posted in Bradley Schacht on 23 July 2014

My Visit to Redmond

Last week, I had the pleasure of attending the EBC in Redmond. If you don’t know what EBC is, that’s OK. I didn’t know either until Microsoft invited me there a couple of months ago. EBC stands for “Executive Briefing Center”. It’s a building in Redmond designated to host customer… Read more

0 comments, 23 reads

Posted in Guy Glantser on 23 July 2014

Older posts