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

Latest Blog Posts

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, 31 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

0 comments, 85 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, 48 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, 49 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, 65 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, 78 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, 49 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, 71 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

0 comments, 104 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, 87 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, 73 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, 114 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, 94 reads

Posted in Mike Davis SQL on 21 July 2014

Tampa Code Camp Revivial

If you were to look around Florida at the various cities technology based User Groups, and their accompanying local conferences you will see some of the best in the land.  Orlando started SQL Saturday since 2007 with Tampa following closely thereafter.  South Florida has hosted Code Camp for 10 years… Read more

0 comments, 71 reads

Posted in Jason Carter on 21 July 2014

Rename SharePoint Central Administration Database

SharePoint uses a series of SQL Server databases to save configuration information, security setups and all the user data that has been created. The Central Administration site is no different and has its own content database that is created when running the SharePoint configuration wizard. Unfortunately, unlike when creating service… Read more

0 comments, 59 reads

Posted in Bradley Schacht on 21 July 2014

Powershell Tips–Showwindow

Looking for help is a pain in Powershell. I type something like

help get-process

execute this and I’m scrolling up and down. Things scroll off the screen and I have to muddle through, meanwhile, my code is at the bottom of the window.

Even when things stop at the end… Read more

0 comments, 106 reads

Posted in The Voice of the DBA on 21 July 2014

July 2014 – SQL Server Monthly Maintenance Checklist

It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist.  Even though it hasn’t been updated, hopefully people have been continuing to look at their environments and performing the needed monthly maintenance activities.

Doing this is important because if you don’t know where you… Read more

0 comments, 84 reads

Posted in StrateSQL on 21 July 2014

Null Values in SQL Server

Walk & Talk #001 – Unknown or Null Values

Ride with us in this video as we head to Richmond, Virginia to present to their user group.

This is the first official Walk & Talk, but you’ll notice we’re not exactly walking along.

Through this video we talk about and… Read more

1 comments, 83 reads

Posted in WaterOx SQL on 21 July 2014

Last Weeks Top “Reading” Links #93

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

0 comments, 90 reads

Posted in StrateSQL on 21 July 2014

Victims of Success

I took part in the PASS Summit 2014 selection committee this year because I was really curious about seeing how the sausage gets made. I’ve seen how actual sausage gets made and I still eat sausage.  Despite a few hiccups and communication issues, internal and external, I think the selection… Read more

5 comments, 71 reads

Posted in The Scary DBA on 21 July 2014

Older posts