SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2013

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 280,000 times in 2013. If it were an exhibit at the Louvre Museum, it would take about 12 days for…

Read more

0 comments, 1,123 reads

Posted in Glenn Berry's SQL Server Performance on 31 December 2013

Slimming down The Voice of the DBA Podcasts

I announced in the Christmas editorial that I was discontinuing the video podcasts. Needless to say I heard a complaint from my Mom that afternoon. She enjoys the podcasts, even though she doesn’t understand all the technology. I did get a couple other notes from people and thought I should… Read more

2 comments, 1,389 reads

Posted in The Voice of the DBA on 31 December 2013

Happy New Year 2014

                              HAPPY NEW YEAR 2014

Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my blog last year 2013. I hope this support will continue this year…

Read more

0 comments, 995 reads

Posted in Vivek's SQL Notes on 31 December 2013

Day 7 – Command ‘n Conquer

This is the seventh installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker
  5. Peer Identity
  6. Lost in Space

As a DBA, we sometimes like to shortcut things.  Not… Read more

5 comments, 1,317 reads

Posted in SQL RNNR on 31 December 2013

What’s the Hidden Issue in the Recent PASS Bylaw Changes?

The 2004 PASS Board of Directors

On December 19, 2013, the PASS board of directors (BoD) proposed a small and targeted set of bylaw changes in response to CA relinquishing the BoD seats they were entitled to as a Founding Partner in the professional association.

How Did CA Get Involved…

Read more

5 comments, 2,534 reads

Posted in Kevin E. Kline on 31 December 2013

A Rickety Stairway to SQL Server Data Mining, Part 14.7: Additional Plugin Functionality

By Steve Bolton

…………In order to divide this segment of my amateur tutorial series on SQL Server Data Mining (SSDM) into digestible chunks, I deferred discussion of some functionality that can be implemented in custom algorithms. In the last installment I explained how to write custom data mining functions,… Read more

0 comments, 2,226 reads

Posted in Multidimensional Mayhem on 31 December 2013

12 Webcasts from Pragmatic Works Training On The T’s

In the past year, I’ve done a few presentations for Pragmatic Works Training on the T’s.  If you aren’t familiar with Training on the T’s, it is a free training program offered by Pragmatic Works that delivers hour long training sessions over lunch on every Tuesday and Thursday.  Right… Read more

0 comments, 3,261 reads

Posted in StrateSQL on 31 December 2013

2013 - The Year of Community Speaking

So, the end of 2013 is upon us and what a year it has been. The SQL Server 365 blog saw the number of site hits double from last year, which I am thrilled with. The biggest personal achievement this year was popping my speaking cherry at the Leeds SQL…

Read more

0 comments, 1,111 reads

Posted in SQL Server 365 on 31 December 2013

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 12,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 4…

Read more

0 comments, 1,095 reads

Posted in Chris's SQL Blog on 31 December 2013

How to Configure Form Base Authentication(FBA) in SharePoint Server 2010 Claim based using LDAP

Hello Friends,

It’s been months I haven’t written anything as I was busy with lot of stuff. There are many things to write but starting with topic for which I got many mails from lot of friends through blogs and linked in.

As we all are aware with Claim based… Read more

8 comments, 1,860 reads

Posted in AshishSharePointBlog on 31 December 2013

VMware vNUMA and SQL Server

Jonathan Kehayias (bt ) posted a fantastic write up today on VMware’s vNUMA interactions when the operating system feature ‘CPU hot plug’ is enabled over at SQLPerformance.com. I’ve been mulling around ideas for a similar post but he beat me to it, and did a great… Read more

0 comments, 1,185 reads

Posted in Technobabble by Klee from @kleegeek on 31 December 2013

Wishing all visitors a very happy new year 2014

Wishing all visitors 

A Very Happy & Prosperous

 New Year 2014


Happy New Year! Thanks to visit queryinqsql.com.
Last year I started this Blog,and post  52 articles,scripts,basics of SQL Server that are based on SQL Server 2008.I hope  some of these articles were very helpful for you. In…

Read more

1 comments, 1,431 reads

Posted in Querying Microsoft SQL Server on 30 December 2013

Installed SQL SERVER 2012? maybe you’d like to re-set your shortcuts!


Just a quick post on a seemingly trivial matter that others may find useful.

The post was prompted by the Simple-Talk article on SQL SERVER 2012 keyboard shortcuts

Anyway, I installed SQL SERVER 2012  sometime ago on my laptop and ever since the CTRL-R keyboard shortcut key has… Read more

0 comments, 1,331 reads

Posted in measure twice, cut once. on 30 December 2013

Are CHECKSUMs being performed with a Compressed Backup?

Now, why in the world would I be asking a question like this?
Well, in BOL (BACKUP) is this little blurb:

Specifies that the backup operation will verify each page for checksum and torn page, if enabled and available, and generate a checksum for the entire backup.…

Read more

3 comments, 2,807 reads

Posted in A Discussion of SQL Server-Related Topics on 30 December 2013

Day 6 – Lost in Space

This is the sixth installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker
  5. Peer Identity

One of the more frequently recurring themes I see in my travel and… Read more

2 comments, 1,177 reads

Posted in SQL RNNR on 30 December 2013

Last Weeks Top “Reading” Links #64

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

Posted in StrateSQL on 30 December 2013

Kissing 2013 Goodbye

The end of the year is here, which means it’s time to look back and review my goals and reflect on the highlights and lowlights of the year. I can’t say that I’m sorry to see this year come to an end. 2013 was a tough, ugly year. Tension between… Read more

0 comments, 1,187 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 30 December 2013

SSRS Interactive Sorting a Matrix

Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to click on to perform the action. In the image below you can see a basic matrix report with State as the row group, with year and quarter as the column…

Read more

1 comments, 1,761 reads

Posted in Mike Davis SQL on 30 December 2013

Memory Timeouts

Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.

The timeouts seemed to have no pattern of any kind, there were no long blocking queries, the packages’ sessions were SUSPENDED until they timed out, and the sessions were not blocked at any… Read more

0 comments, 1,067 reads

Posted in Avi Niv on 30 December 2013

A New Year is Right Around the Corner

If you read my 2013 Year In Review you may be here today wondering why I haven’t posted anything despite my stated desire to blog more over the next year. Well, it’s not because I’m waiting until after the new year or anything like that….well, not that may sound a… Read more

0 comments, 1,534 reads

Posted in Bradley Schacht on 30 December 2013

Older posts