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

Latest Blog Posts

4 Things I Wish I Knew Sooner

I was recently called out by Tim Costello on a blog series started by Mike Walsh.  http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant

The series calls for each blogger to list 4 things they wish they had known sooner in their career as a data geek.

1) Knowing how to query data != DBA. You will… Read more

0 comments, 39 reads

Posted in Tim Radney - Database Professional on 2 September 2014

SQLSaturday Orlando Marketing Plan-Part 40

Last week we were at 332, this morning at about the same time we’re at 356. Not bad for a week that included Labor Day. Chart makes it look a little worse than it is, it shows the actual against the goal for the next report period.

 

 

Here’s… Read more

0 comments, 44 reads

Posted in SQLAndy on 2 September 2014

Upcoming Events

My summer event hiatus is coming to a close, and we’re now back into the conference and event season! I’ve spent the summer making some wild plans for new posts and research articles (and more) that I’ll be releasing on here this fall. Stay tuned for some exciting announcements!

I… Read more

0 comments, 38 reads

Posted in Technobabble by Klee from @kleegeek on 2 September 2014

Crosstabs over Pivots

I wrote about a basic PIVOT query recently. It’s an interesting way to write a query and turn row data into columns. That’s handy, and lots of people have a need for it. However I’d never used PIVOT in production code. I’ve always written a crosstab query instead.

If I… Read more

0 comments, 44 reads

Posted in The Voice of the DBA on 2 September 2014

Two simple commands that can be a big help in performance tuning.

The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are the best information about what a query is doing and so how to improve it. However there are a couple of little commands that can be a big help too.… Read more

0 comments, 89 reads

Posted in SQLStudies on 2 September 2014

SQL Server column encryption

We use databases to store a lot of information. This can also include sensitive information we don’t want to give everyone access to. While we can use permission or views to ‘hide’ our sensitive information it will still be stored as plain text in our table. We can use column… Read more

0 comments, 82 reads

Posted in DotNine SQL Server and more on 2 September 2014

The Nine SQL Server Careers

Microsoft SQL Server is a mature and broad technology platform that supports a diverse set of careers - this blog post is an attempt to provide technical detail to my personal theory on careers in the Microsoft SQL Server world.

A mid-tier SQL Server professional who may carry the title…

Read more

0 comments, 69 reads

Posted in SQL Tact on 2 September 2014

Celebrating One Year of Heraflux Technologies

Our company, Heraflux Technologies, celebrated its first birthday today on September 1st. A very sincere thank you goes to all our clients, partners, family, #sqlfamily, and friends for your support! We look forward to another exciting year in business! Stay tuned to this blog and the Heraflux announcements,… Read more

0 comments, 48 reads

Posted in Technobabble by Klee from @kleegeek on 2 September 2014

September 2014 – SQL Server Monthly Maintenance Checklist

It’s time for a monthly reminder to review you SQL Server environment.  As with anything, just because it appears to be running well, doesn’t mean that there isn’t an unknown element causing issues today or in the near future.

A good way to review your environment is to… Read more

0 comments, 92 reads

Posted in StrateSQL on 1 September 2014

Business Intelligence Strategy – Beginning Steps

Business Intelligence Strategy

A business intelligence strategy is used to determine where an organization is and where they are going with their BI implementation.  To start building an effective business intelligence strategy requires taking an objective look at your organizations BI capabilities including data, technology and people.

DATA

When you… Read more

0 comments, 112 reads

Posted in Business Intelligence and Enterprise Architecture on 1 September 2014

Parameterization Part 3: Parameter Sniffing

This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a very important concept in SQL Server, and it certainly deserves a dedicated post. It’s time to dive into all the juicy details about parameter sniffing…

But first, let’s begin with… Read more

0 comments, 135 reads

Posted in Guy Glantser on 1 September 2014

Reblog: August 22 to August 28

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, 105 reads

Posted in StrateSQL on 29 August 2014

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, 109 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, 111 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, 107 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, 2,094 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, 139 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, 106 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, 113 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, 376 reads

Posted in Data Adventures on 27 August 2014

Older posts