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

Archives: March 2014

Cumulative Update #16 for SQL Server 2008 SP3

Here’s a link for the download for the CU #16 for SQL2008 SP3  The post also includes all the previous updates and with links to the KB articles.  

Read more

0 comments, 471 reads

Posted in Coffee and SQL on 31 March 2014

The Primary Filegroup Cannot be Backed Up as a File Backup

File Group backups are great when working with very large databases (VLDB’s) that have been partitioned.  Typically when I come across File Group backups implemented in production the database is using the full recovery model. With the full recovery model you can specify individual file groups for backup. A very… Read more

0 comments, 899 reads

Posted in Tim Radney - Database Professional on 31 March 2014

Send SMS from SQL Server

We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production server. Though this is NOT a feature of SQL Server, but we have a simple workaround for this.

Cell phone service providers have a SMS gateway. These gateways accept requests… Read more

0 comments, 679 reads

Posted in SQL Toast on 31 March 2014

Last Weeks Top “Reading” Links #77

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

Posted in StrateSQL on 31 March 2014

Follow Up on The Unusable User–Question Of The Day

I posted about one of my questions of the day called The Unusable User last week and wanted to return to post some final stats and thoughts on how it turned out. First the stats:



Overall the comments on the question were good, especially about the style. I’m… Read more

0 comments, 473 reads

Posted in SQLAndy on 31 March 2014

SQL Server Quickie #12 – Nested Loop Operator

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

Today I have uploaded the 12th SQL Server Quickie to YouTube. This time I’m talking about the… Read more

0 comments, 698 reads

Posted in Klaus Aschenbrenner on 31 March 2014

We Are Hiring!

My employer Ntirety (a division of HOSTING) is currently looking for multiple SQL Server DBA's.  As you have probably seen from me on Twitter (or on this blog) previously, I joined Ntirety last November as a 100% work-from-home Senior SQL Server DBA.

Ntirety is based out of Boston, but…

Read more

0 comments, 492 reads

Posted in Nebraska SQL from @DBA_ANDY on 31 March 2014

GetLogSpace – table and stored procedure

We’ve talked before about how to get log space usage information in SQL Server.  After the 1,032nd time I re-wrote my custom query to also see the UNused log space, it occurs to me that this would be a nice thing to have on your server on a permanent basis.…

Read more

3 comments, 403 reads

Posted in SQL Awesomesauce on 31 March 2014

Default nullability of a new column

Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? I always did. Turns out I was wrong.

When you don’t specify NULL vs NOT NULL it will usually default to NULL. Here are some exceptions where it will default… Read more

0 comments, 430 reads

Posted in SQLStudies on 31 March 2014

Default nullability of a new column

Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? I always did. Turns out I was wrong.

When you don’t specify NULL vs NOT NULL it will usually default to NULL. Here are some exceptions where it will default… Read more

0 comments, 333 reads

Posted in SQLStudies on 31 March 2014

SSIS Web Service Task

The Web Service task in SSIS can be used to call a web service command to perform a needed operation in your package. The results of most web services will be in XML Format. You can save these results into a variable or into a file. Either way, you can…

Read more

2 comments, 2,312 reads

Posted in Mike Davis SQL on 31 March 2014

the power of people who are trustworthy

If you missed 60 Minutes last night, watch this.

Read more

0 comments, 505 reads

Posted in @chuckboycejr on 31 March 2014

SQL 2014 Release Date, April 1st

I'm not a fan of anything releasing on April Fool’s Day, but that's not for me to decide. I personally cannot wait to upgrade to 2014.  I want to see the full power behind PCI-e based SSDs pushing extended ram. I want to have the security of having a server…

Read more

0 comments, 918 reads

Posted in DBA On The Go on 31 March 2014

SQL Server 2014 RTM

The new version of SQL Server will be here on Tuesday.

(Someone at Microsoft has a sense of humour in releasing the newest version of SQL Server on April Fool’s Day.)

At some point the usual argument about when a company should upgrade will be had. I’ve worked companies that… Read more

0 comments, 771 reads

Posted in The DBA Who Came In From The Cold on 30 March 2014

Calendar Tables in T-SQL

In an earlier blog, we covered a type of auxiliary table (the Tally Table) that can provide a lot of querying flexibility if you have one in your database or construct one in-line to your query. Today we’re going to talk about another: the Calendar table.

The basic concept… Read more

4 comments, 9,551 reads

Posted in DwainCSQL on 30 March 2014

South Alabama Day of .NET Presentations Downloads

I have been running into longtime SQL Saturday friend Ryan Duclos at SQL Saturday events in Baton Rouge and Pensacola since the beginning SQL Saturday days, so when he headed up a Day of .NET in Mobile, AL at the University of South Alabama, I was happy to join the…

Read more

0 comments, 450 reads

Posted in SQL Tact on 29 March 2014

Houston SQL Saturday #308 – Presenting

Saturday May 10th – Houston SQL Saturday #308

I will be presenting at the upcoming SQL Saturday in Houston on May10th.  For those of you not familiar with SQL Saturdays.  It is an all day training event hosted by the local SQL Server User Groups.  If you are interested in… Read more

0 comments, 548 reads

Posted in Business Intelligence and Enterprise Architecture on 29 March 2014

T4 Support in SSDT

Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me.  On tuesday night, at SQL Supper, Geoff Clark ( a uk MCM ) (t) done a fantastic presentation on end-to-end datawarehouse loading, a portion of this was on t4… Read more

0 comments, 22 reads

Posted in Dave Ballantynes blog on 29 March 2014

All in Fun

My first commercial!

Steve on a Horse

This comes from our DBA Team promotion, which is ongoing this year.

Filed under: Blog Tagged: Humor, Red Gate, syndicated

Read more

0 comments, 425 reads

Posted in The Voice of the DBA on 28 March 2014

Reblog: March 21 to March 27

Photo credit – Jenn and Tony Bot

Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came… Read more

1 comments, 387 reads

Posted in StrateSQL on 28 March 2014

Older posts