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

Latest Blog Posts

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, 24 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, 23 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, 29 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, 39 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, 46 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, 63 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, 57 reads

Posted in The Voice of the DBA 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, 61 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, 144 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, 72 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

1 comments, 75 reads

Posted in Bradley Schacht on 23 July 2014

Why am I getting a primary/unique key violation?

This may seem like a question with a simple answer but there is a bit more to it than you might think. In fact I know of 3 possible reasons (and there may be more I don’t know) for seeing a primary key error. Technically they occur for any unique… Read more

0 comments, 92 reads

Posted in SQLStudies on 23 July 2014

SQL Server 2012 with SP2 Slipstream ISO images fixed

Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels (MSDN…) and are now available.

Refer : http://support.microsoft.com/kb/2984316

Source : http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/18/sql-server-2012-with-sp2-slipstream-iso-images-fixed.aspx

If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun

Reference :… Read more

0 comments, 105 reads

Posted in MSSQLFUN on 23 July 2014

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

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

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

0 comments, 72 reads

Posted in MSSQLFUN on 23 July 2014

Building the SQLSaturday Orlando Marketing Plan-Part 24

We’re at 180 registered so far and we haven’t published the schedule yet! So far so good. We’re on track to have the schedule live at 60 days out, maybe a little bit sooner. For those not attending you don’t get to see our marketing messages, so I’m including screenshots… Read more

2 comments, 104 reads

Posted in SQLAndy on 22 July 2014

SQL Server Agent job steps vs SSIS

When doing ETL, you have the choice of using T-SQL or SSIS (see When to use T-SQL or SSIS for ETL).  If you decide T-SQL is the way to go and you just want to execute a bunch of T-SQL statements (individually or within a stored procedure), it’s… Read more

1 comments, 123 reads

Posted in James Serra's Blog on 22 July 2014

Keep it simple.... you know.

Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"
The answer is as simple as ExpressProfiler itself - you should always keep things as simple as you can.

Should be balance.
On one hand you have nothing that requires nothing and does nothing -…

Read more

0 comments, 99 reads

Posted in SQL Code Guard on 22 July 2014

SQLBits recap

(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.)

Wow, what an intensive last week! Last week I attended the SQLBits conference in Telford/UK – in… Read more

0 comments, 86 reads

Posted in Klaus Aschenbrenner on 22 July 2014

SSRS report subscription: Fire Event from SSIS package

My previous two posts about SSRS reports being deployed to a SharePoint site along with their subscription didn't stop me from exploring the whole things of SSRS reports subscriptions; regardless of their deployment environment either native or SharePoint mode.

After exploring different aspects of the subject (Subscriptions and Delivery

Read more

0 comments, 136 reads

Posted in Data Adventures on 22 July 2014

Make an SSIS package Delay or Wait for Data

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of guessing the time when the data will be in the database we can have the package look for data in a SQL table. When the table has data then the…

Read more

0 comments, 110 reads

Posted in Mike Davis SQL on 21 July 2014

Older posts