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

Archives: October 2013

Removing HTML formatting tag - BR - from XML using XQuery

This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained within a CDATA section. Sure it is all perfectly valid XML at the end of the day, but it makes working with it a bit harder as each section of… Read more

0 comments, 3,463 reads

Posted in SQL Server Rocks! on 31 October 2013

One day in the office

I got back from SQL Intersection on Wednesday afternoon. I did work a bit, but not too much after traveling and speaking this week. Today I’m in the office, but only today.

Tomorrow I’m outside.

I have more vacation scheduled tomorrow, along with Monday and Tuesday. Given the nature of… Read more

0 comments, 1,172 reads

Posted in The Voice of the DBA on 31 October 2013

Scaring a Database Near you

Something I have a hard time by-passing is a good R2 unit.  I have R2 units in so many different forms, including a standing R2 cake one year for my birthday.  So when I cam across this R2 unit, I just had to share it.

That is a pumpkin carved… Read more

1 comments, 1,246 reads

Posted in SQL RNNR on 31 October 2013

SQL Server Data Tools for SQL Server 2014 CTP2 now available

From Microsoft, SSDT is now available for SQL Server 2014:

We’d like to announce the availability of SSDT that supports SQL Server 2014 databases.  SQL Server Data Tools for SQL Server 2014 CTP2 is pre-release software, does not support upgrade from an existing SSDT install or upgrading to any new… Read more

2 comments, 1,554 reads

Posted in James Serra's Blog on 31 October 2013

Tales from the Query Processor: II

Hello Dear Reader!  Today is Halloween, October 31st.  My Daughter turns a big 15 today!  Happy Birthday Ches!!!!!

To celebrate two years ago I posted my first Halloween Blog.  Tales from the Query Processor.  It was a lot of fun to write a fiction/horror story revolving around SQL Server…

Read more

1 comments, 1,358 reads

Posted in SQLBalls on 31 October 2013

Happy Halloween! A TALE OF THE SCARY DBA! - Reblog


Today, October 31, 2013 is Halloween, and in the spirit of the holiday of ghosts, goblins, vampires, werewolves, witches and warlocks, I just couldn’t resist, to bring you a short Halloween poem to roast one of our favorite SQL DBAs, Grant Fritchey (blog|twitter), aka the… Read more

0 comments, 1,950 reads

Posted in Pearl Knows on 31 October 2013

To DBA or Not to DBA…

In my day to day operations I have the opportunity to work with people in various capacities in regards to data.  Sometimes it is in the capacity of a mentor, sometimes in the capacity of a consultant, and sometimes just in the capacity of the dude that fixes the problem. Read more

0 comments, 1,213 reads

Posted in SQL RNNR on 31 October 2013

Free Online SQL Server Training for the Week of November 3, 2013

I'm trying to re-establish this running guide to free online training for the following week. If you're a training provider and I've missed you, please drop me a line at brian {dot} kelley {at} sqlpass {dot} org. All times are Eastern (New York). To convert to your local time, use… Read more

0 comments, 3,317 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 31 October 2013

Monthly profit percentage techniques


A few days ago, a friend of mine approached me with an interesting challenge. What he was trying to achieve was to extract monthly profit percentages from a SQL Server table (along with the projected monthly goal) and to place the latest month’s actuals into an SSRS gauge and… Read more

1 comments, 1,814 reads

Posted in Simon Says on 30 October 2013

Winner – Conference Pass to SQL Server Live! in Orlando

This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando.

Those rather nice folks at SQL Server Live are also offering SQL Brit readers (that’s you lot) an exclusive discount of $500 for their upcoming event in… Read more

0 comments, 1,329 reads

Posted in John Sansom - SQL Server DBA in the UK on 30 October 2013

I’m Attending SQLSaturday #248 in Tampa on Nov 9, 2013

I’ll be heading back to Tampa on November 9, 2013 for the BI Edition of SQLSaturday. I’ll be presenting PCI for the SQL DBA and trying to tailor it a little to the BI crowd – mostly around using a lot of caution about expanding the PCI scope when… Read more

0 comments, 1,180 reads

Posted in SQLAndy on 30 October 2013

Interview With Rick Bolesta of the PASS Board of Directors

Rick Bolesta and Neil Buchwalter of CA technologies are leaving the Board at the end of 2013. CA and Microsoft were the two ‘founding’ organizations when PASS was chartered and each has had two seats on the PASS Board since then. I caught up with Rick during the 2013 PASS…

Read more

0 comments, 1,393 reads

Posted in SQLAndy on 30 October 2013

Adding a column to a table with a default (NULL vs NOT NULL)

There are lots of ways to learn new things, or be reminded of old things. One of my favorites is the QotD on sql server central. Recently there was an interesting question on defaults. It pointed out that there is a difference between adding a column with a… Read more

3 comments, 4,605 reads

Posted in SQLStudies on 30 October 2013

Virtualization for SQL Server DBAs – New SQL Saturday Pre-Con Session

Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL Server DBAs”. The first event session will be held on December 6th in Chevy Chase, MD, as one of three precon sessions for the SQL Saturday Washington DC event scheduled… Read more

0 comments, 1,187 reads

Posted in Technobabble by Klee from @kleegeek on 30 October 2013

First take on PowerPivot

What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built on a database server (SQL)…

Read more

2 comments, 1,634 reads

Posted in Terry's Business Intelligence on 30 October 2013

Is There Interest in SQL Server Security Pre-Cons?

I’m very passionate about security, especially database security. As the numbers with regards to data breaches continue to climb, this is become even more important to me. I’ve been affected personally by data breaches, as have many others. For instance, I’ve had to change out my credit cards due to… Read more

6 comments, 2,673 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 October 2013

A Rickety Stairway to SQL Server Data Mining, Part 14.5: The Predict Method

By Steve Bolton

…………In order to divide the Herculean task of describing custom algorithms into bite-sized chunks, I omitted discussion of some plug-in functionality from previous installments of this series of amateur tutorials on SQL Server Data Mining (SSDM). This week’s installment ought to be easily digestible, since it… Read more

2 comments, 2,735 reads

Posted in Multidimensional Mayhem on 30 October 2013

sp_BackupDatabases v1.2

I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent jobs to perform its tasks, instead of running dynamic SQL statements. This makes the process much more resilient when it comes to handling errors – one failed backup can’t… Read more

0 comments, 1,586 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 29 October 2013

Fixing Cardinality Estimation Errors with Filtered Statistics

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Cardinality Estimation is one of the hidden gems in SQL Server. In general, Cardinality Estimation means that the Query Optimizer tries to find out during the query compilation, how many rows… Read more

0 comments, 3,358 reads

Posted in Klaus Aschenbrenner on 29 October 2013

PASS Summit 2013

Not much news came out of the PASS Summit 2013 from last week, but boy did I have a blast!  I met over 100 people who were presenters or bloggers (I counted).  I made an effort to find them as I wondered around the halls.  I also had a lot… Read more

0 comments, 1,106 reads

Posted in James Serra's Blog on 29 October 2013

Older posts