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

Latest Blog Posts

Off to Flowcon 2014

With all of the work on a deployment pipeline and Continuous Integration (CI) and Continuous Delivery (CD) I’ve worked on, I thought it would be instructive to go see how the software developers build their product better. A few months ago I noticed that FlowCon 2014 was coming to San… Read more

0 comments, 111 reads

Posted in The Voice of the DBA on 3 September 2014

Left or Right?

No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a canard that still makes the rounds occasionally. Please, help me put this statement to sleep for once and all:

A function on the left side of the equals…

Read more

10 comments, 5,255 reads

Posted in The Scary DBA on 3 September 2014

Analysis Services Dynamic Security

Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted to see specific data.  This can be accomplished by creating dynamic or table based security in Analysis Services which is much less difficult to setup… Read more

0 comments, 130 reads

Posted in Devin Knight on 3 September 2014

PASS Summit 2014 Announcements

In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd – 7th.

Day 2 Keynote -  Dr. Rimma Nehme from Jim Gray’s System Lab

Apparently, Dr. Mehme is a Polybase and query optimization expert from Microsoft and she will be… Read more

0 comments, 109 reads

Posted in The Smiling DBA on 3 September 2014

Restoring Toggle Results Window as Ctrl+R in SSMS

Recent versions of SQL Server Management Studio have unmapped Control+R as the toggle for the Results window in a typical query window. Each time I work on a new SSMS environment or refresh my laptop, I find myself seeking out how to restore this setting.

Here's how, including a picture…

Read more

1 comments, 963 reads

Posted in SQL Tact on 3 September 2014

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

2 comments, 172 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, 145 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, 100 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

2 comments, 1,272 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

4 comments, 1,552 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, 266 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

2 comments, 170 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, 98 reads

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

Last Weeks Top “Reading” Links #99

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, 1 read

Posted in StrateSQL on 1 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

1 comments, 160 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, 199 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

7 comments, 283 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, 163 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, 147 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

6 comments, 6,325 reads

Posted in Databases – Infrastructure – Security on 28 August 2014

Newer posts

Older posts