Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2014

Handling Perfmon Logs with Relog

In a recent situation, I was tasked by a client to check one of their servers which they believed to be grossly over-provisioned.  As a VM they knew they could easily pull both CPU and RAM from the server if they could determine the true needs of the server.


Read more

2 comments, 2,456 reads

Posted in Nebraska SQL from @DBA_ANDY on 29 May 2014

Auditing and Event SubClasses

A recent discussion got me to thinking about Auditing.  To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields related to auditing as it stands in SQL Server.

In talking to the person who raised the valid concern about the… Read more

2 comments, 1,428 reads

Posted in SQL RNNR on 28 May 2014

Do you apply SQL Server Cumulative Updates?

I think Steve Jones makes a great point here with respect to cumulative updates:

“This is one reason I’ve been hesitant to remain current with Cumulative Updates (CUs). Microsoft doesn’t stand behind them, with the text on each CU page that users should only apply the patch if they…

Read more

8 comments, 4,592 reads

Posted in Databases – Infrastructure – Security on 28 May 2014

Speaking at MagicPASS Tonight

I’m back at MagicPASS tonight, delivering two presentations – one about credit card security using SQL Server and one about learning plans, both are topics I’m enthusiastic about. It’s a great venue, if you’re in the area hope you can make it.

Read more

0 comments, 411 reads

Posted in SQLAndy on 28 May 2014

Webcast Follow-Up: Getting Started with Windows Azure and SQL Databases

Late last month, I delivered a webcast for Pragmatic Works Training on the T’s.  The session was titled Getting Started with Windows Azure and SQL Databases.  In the session, I how data platform professionals can start looking at Microsoft Azure and some of the services and their benefits… Read more

0 comments, 470 reads

Posted in StrateSQL on 28 May 2014

Quick Tips–SQL Prompt Qualifying Columns

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

2 comments, 1,324 reads

Posted in The Voice of the DBA on 28 May 2014

Webcast Follow-Up: Leveraging Cloud for the Modern SQL Developer

Similar the post earlier today, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month.  This was is titled Leveraging Cloud for the Modern SQL Developer.  In the session, I discussed how and where SQL developers can look to Microsoft Azure… Read more

0 comments, 373 reads

Posted in StrateSQL on 28 May 2014

Building The SQLSaturday Orlando Marketing Plan-Part 14

Quick notes today:

  • Event team likes first flyer (retro) better than the second one (doesn’t have enough why, doesn’t use space well). Both can be tweaked. I’m going to order two more. One to try to get a yet different take on the event, one to trial a seminar flyer…

Read more

0 comments, 303 reads

Posted in SQLAndy on 28 May 2014

Microsoft Dynamics AX 2012 – Multiple Rows In Demand Forecast Table [FORECASTSALES] for each item

Why are there multiple rows for each item in the Demand Forecast Table in Microsoft Dynamics AX 2012? This is helpful to know for BI for cubes that aggregate the data in the [FORECASTSALES] table. Basically the overview line and each exploded line of the same item is stored in…

Read more

0 comments, 445 reads

Posted in Terry's Business Intelligence on 28 May 2014

PASS 2014 NomCom Candidates Announced

Eleven candidates for the nomcom this year, details at The NomCom campaign will open on June 2 and close on June 6, 2014. Balloting will open on June 3 and close on June 6, 2014. Which does make it a little strange – the names are public, but… Read more

0 comments, 452 reads

Posted in SQLAndy on 28 May 2014

Who has the DAC open?

The other day I started seeing the following error in my SQL log.

Error: 17810, Severity: 20, State: 2.

Could not connect because the maximum number of ’1′ dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by…

Read more

0 comments, 2,010 reads

Posted in SQLStudies on 28 May 2014

How Does Disabling an Index Affect the Index Usage DMV Counters

A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)?

Great question! Not one that is straightforward to answer via the Twitter medium though, so I wanted to share some more detail here. Read more

5 comments, 1,364 reads

Posted in John Sansom - SQL Server DBA in the UK on 28 May 2014

How Much Value Would a SQLSaturday Certificate of Completion Have?

Note: Posted May 27, 2014, additions posted May 28, 2014 further down.

I think it’s been discussed a time or two, but the idea of issuing certificates of completion for SQLSaturday came up as an idea on how to increase value/attendance at SQLSaturday Orlando this year. The basic idea is… Read more

4 comments, 456 reads

Posted in SQLAndy on 27 May 2014

Webcast Follow-Up: 5 SQL Server Indexing Myths

Similar to yesterday’s post, I have a follow-up for another Pragmatic Works Training on the T’s session that I delivered last month.  This was is titled 5 SQL Server Indexing Myths.  In the session, I discussed discussed five common indexing myths that I’ve come across over the years. The… Read more

1 comments, 563 reads

Posted in StrateSQL on 27 May 2014

Attaching All Databases with PowerShell–Checking All Databases

I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the first time I thought that Powershell might prove more useful than other methods. This series looks at my script, and this part examines the first part that I wrote.

I… Read more

0 comments, 819 reads

Posted in The Voice of the DBA on 27 May 2014

Building The SQLSaturday Orlando Marketing Plan-Part 13

Here is the second of the two flyers I ordered from (see the first one here). The center image is from the event site and is of our venue, Seminole State College. It’s clean, but I think the images don’t add a lot of value. Appreciate any feedback… Read more

0 comments, 322 reads

Posted in SQLAndy on 27 May 2014

Get User In Reporting Services-Question of the Day

Get User In Reporting Services is my newest question to be published at as a “Question of the Day”. Interestingly so far 71% of people are getting one of the three correct answers, but 84% are also picking the same wrong answer. Can you figure it out?


Read more

0 comments, 361 reads

Posted in SQLAndy on 27 May 2014

SQL Server 2014 Launch Party Mississauga Ontario (Toronto) June 21, 2014

This event promises to be a highlight of the Canadian SQL Server calendar year. The presenters are all 'first class'. All are SQL Server MVP's and they will be addressing us in both official languages. The event is being held at Microsoft's offices in Mississauga Ontario from 10 AM to…

Read more

0 comments, 582 reads

Posted in Simon Says on 27 May 2014

Speaking at SQLSaturday #310 in Dublin/Ireland

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

I’m very proud to announce that I will speak at the SQLSaturday #310 in Dublin. On September… Read more

0 comments, 531 reads

Posted in Klaus Aschenbrenner on 26 May 2014

Languages of Big Data Apache Hadoop

Languages of Big Data

Big Data is here and rapidly growing.  If you are just starting to learn about Big Data then it is important for you to understand all of the various pieces that can be used in Big Data architectures.  The Apache foundation is a major player in… Read more

Newer posts

Older posts