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

Latest Blog Posts

Friday Followup For August 29, 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
  • Cheating DBCC To Fix Index Corruption
  • Automated Source Control: A Librarian…

Read more

0 comments, 27 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 29 August 2014

4 Attitudes I Wish I Had Earlier as a DBA

I was tagged by Mike Walsh (blog | twitter) in his post 4 Attitudes I Wish I Had Earlier As a DBA.

I Don’t Have to Do It Alone

I’ve always worked hard in my IT career to be knowledgeable in my field. I don’t like not… Read more

0 comments, 53 reads

Posted in Databases – Infrastructure – Security on 28 August 2014

I Didn’t Hyperventilate!

I gave what is officially my second presentation this week. I presented at the Triad SQL BI (Twitter | PASS) user group meeting and I didn’t hyperventilate! That’s a huge deal for someone like me, who is petrified of public speaking.

It started out a little rough though. Read more

0 comments, 64 reads

Posted in SQL Swimmer on 28 August 2014

I did my part – Helping others

Let’s raise some money, people.

TL;DR Donate to Doctors Without Borders, the Argenis Without Borders campaign.

What started out as a joke has grown, and we’re really looking to raise some money for this charity. I did my part

I started shopping, and I’ll be rainbow decked for the… Read more

0 comments, 54 reads

Posted in The Voice of the DBA on 28 August 2014

The Art of Performance Tuning

Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play. And whilst I don’t disagree that a certain level of knowledge is involved, I completely disagree that only certain people can performance tune.

Given the correct approach, anyone should be… Read more

0 comments, 89 reads

Posted in The DBA Who Came In From The Cold on 28 August 2014

Four things I wish I’d known back then

In the blogging meme of the day, I was tagged by my friend Tim Costello to share four things I wish I’d known back when.  The only hard part was paring the list down to four items.

I think back to 15 years ago, when I was working retail and… Read more

3 comments, 62 reads

Posted in Tim Mitchell on 28 August 2014

My SQLBits Session Recordings

Last month, I had the pleasure of presenting two of my favorite sessions at the SQLBits conference in Telford, UK.

A few days ago, all of the session recordings were uploaded to the SQLBits site.

In my first session, “Query Progress Tracking in SQL Server“, I talked about… Read more

0 comments, 63 reads

Posted in Matan Yungman on 28 August 2014

SSRS report: Multi-value parameter going after Data-driven subscription

It is always good to enrich SSRS reports with multi-value parameters; users have more flexibility to combine different reporting scenario with no need to run a report for different parameter values separately. On the other hand, developers can craft their skills to embed multi-value parameters into report datasets; referencing different…

Read more

0 comments, 122 reads

Posted in Data Adventures on 27 August 2014

Presenting At OPASS August 2014 Meeting On 8/28

Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User Group (OPASS). Identity values seem like a straightforward topic but as SQL Server has evolved different methods for working with them have been introduced and each has caveats to… Read more

0 comments, 66 reads

Posted in Kendal Van Dyke on 27 August 2014

Finding a job!

I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years and 15 jobs or so (some contract positions) I’ve never been out of work for more than a month and a half at a time. I’ve always thought the methods… Read more

0 comments, 114 reads

Posted in SQLStudies on 27 August 2014

Automated Source Control: A Librarian For Your Database Objects, Part 3

As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are written for Perforce.  I’ll try to clearly explain, in terms of source control, the functional parts of the script, so that you can easily transfer this to your own… Read more

0 comments, 144 reads

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

Better Presentations–Hide those Windows

This is part of a series of tips for speakers to make your presentations better.

I wanted to give some specific SQL Server presentation items that have bothered me recently. These aren’t big things, but they do cause problems for attendees, and that might mean the difference between someone learning… Read more

3 comments, 108 reads

Posted in The Voice of the DBA on 26 August 2014

SQLSaturday Orlando Marketing Plan-Part 39

Registration is 332 as of 8 am on August 26. We added a whopping 40 registrations last week – a very good week! Our standard Tuesday email will go out about 10 am this morning with topics on MVP’s in attendance and lunch. On Friday we’ll have our first “special”… Read more

0 comments, 84 reads

Posted in SQLAndy on 26 August 2014

Using indexed views on ANY core SQL server edition

I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server. As it stands the documentation clearly states that you can create and… Read more

0 comments, 144 reads

Posted in SQL Server Rocks! on 26 August 2014

Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !

The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

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

0 comments, 94 reads

Posted in MSSQLFUN on 26 August 2014

Painful or Helpful? No SSMS Multiserver Results if One Instance Errors

I've been going back and forth with this question for a few days now.

If one instance in a multiserver query presents an error, no resultsets from any of the other instances are displayed, even if n "row(s) affected)" is displayed in the Messages tab.

This is particularly painful when querying dynamic management objects across server…

Read more

0 comments, 74 reads

Posted in SQL Tact on 26 August 2014

Continuous Integration/Delivery without Testing!

Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to write code, but to deploy working code. So what if we did the automated builds and deployed them to development or QA? No errors, so I’m good, right?

Not so… Read more

0 comments, 3,034 reads

Posted in Databases – Infrastructure – Security on 25 August 2014

How to kill a negative SPID (like SPID -2 or -3) in SQL Server?

Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all the user sessions & stop the application but still we are facing this issue.

Further going into details, I found that… Read more

0 comments, 134 reads

Posted in MSSQLFUN on 25 August 2014

The amazing never shrinking heap

This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However until recently I could never duplicate it on purpose. (You can read that as I’ve had a production problem bite me in the …. repeatedly.) At least I couldn’t duplicated… Read more

0 comments, 132 reads

Posted in SQLStudies on 25 August 2014

Automated Source Control: A Librarian For Your Database Objects, Part 2

I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to script out your database objects using Powershell.  The resulting scripts are the standard DDL scripts that you can generate from Management Studio, and for most of us, are just… Read more

0 comments, 1,989 reads

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

Older posts