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

Latest Blog Posts

Unit testing with SQL Server article on SQLServerCentral.com

My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).

You can read it here.

Stay tuned! :)


Read more

0 comments, 150 reads

Posted in Alessandro Alpi on 26 March 2015

tSQLt with TRY..CATCH

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still needs to re-throw an exception.

Here’s a short example. I’ve… Read more

0 comments, 139 reads

Posted in The Voice of the DBA on 25 March 2015

I am a Superhero

Two weeks ago I attended SQLBits in London. This is probably the biggest SQL Server conference in Europe, and this time there were around 1,700 attendees in a special edition of SQLBits – the Superheroes edition.

Between the various sessions and the exhibition hall, I met a lot of people… Read more

0 comments, 121 reads

Posted in Guy Glantser on 25 March 2015

Toshiba Portege Z301-A Review

Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as a laptop, and only a laptop. Horror show if you need to present from it. So, I replaced it with an HP… which also gave me some troubles (try presenting… Read more

0 comments, 92 reads

Posted in The Scary DBA on 25 March 2015

Clean out all bad characters from a string.

I have a customer who is having a problem with a load. He is getting a fair number of bad characters including some unicode characters. The unicode characters in particular are making it so those values won’t go into a varchar column. This isn’t an uncommon problem so when he… Read more

3 comments, 96 reads

Posted in SQLStudies on 25 March 2015

The Idea Book

How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be easy to add automation to [y]”, or “It would be a lot of fun to work on a project to build [z]”? For me, this has happened a lot, and… Read more

1 comments, 88 reads

Posted in Tim Mitchell on 25 March 2015

Excel Tip #22: Combo Charts – Out of the Box Functionality

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later.  Much of the content will be a result of my daily interactions with business users and other BI devs.  In order to not… Read more

0 comments, 113 reads

Posted in DataOnWheels on 24 March 2015

The Basic TRY..CATCH

Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct hadn’t existed. As a result, my code over the years is littered with catching @@error in a variable and then acting on that result. 

However I’m trying to do better,… Read more

0 comments, 163 reads

Posted in The Voice of the DBA on 24 March 2015

Simple Parameterization and Data Types

Simple paramaterization occurs when the optimizer determines that a query would benefit from a reusable plan, so it takes the hard coded values and converts them to a parameter. Great stuff. But…

Let’s take this example. Here’s a very simple query:

SELECT ct.*
FROM    Person.ContactType AS ct
WHERE   ct.ContactTypeID =…

Read more

1 comments, 105 reads

Posted in The Scary DBA on 24 March 2015

The shaky bug in SSIS

You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012 has had a make-over. Nothing too drastic, but at least the undo button works. However, sometimes when you drag or move tasks/components on the canvas, they start to shake. A… Read more

0 comments, 113 reads

Posted in Koen Verbeeck on 24 March 2015

A 2015 full of DLM

After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:

PASS Italian Virtual Chapter, April 14. I’ll demonstrate the SQL source control usage on SQL Server database
PASS SQL Saturday Torino, May 23, I’ve proposed two sessions (source control and…

Read more

0 comments, 81 reads

Posted in Alessandro Alpi on 24 March 2015

Use the WordPress Revision Counter to Keep Shipping Posts

I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve wanted to (working hard on this though – at least one post a week!).  There is no getting around it – blogging is time consuming.  Especially technical blogging.  My first… Read more

0 comments, 179 reads

Posted in Adam Kreul | Blog on 24 March 2015

How to resolve Space issue in SQL server 2005 TIP #93

 

Hello friends,

Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more solution which is VARDECIMAL feature.

** VARDECIMAL feature exist in SQL SERVER’s Developer & Enterprise edition.

** This feature is not available in SQL Server 2005’s Standard… Read more

0 comments, 88 reads

Posted in Rajat Jaiswal-337252 on 23 March 2015

Speaking at SQL Saturday #389 – Huntington Beach

I’ll be traveling to CA next month for SQL Saturday #389 – Huntington Beach as well as a Red Gate DLM training session run by Ike Ellis. I’m assisting Ike in running a Database Continuous Integration class. It’s a paid for event, but you’ll learn how to set up and… Read more

0 comments, 128 reads

Posted in The Voice of the DBA on 23 March 2015

ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance

Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice!

Optimization Phases and Missed Opportunities and

Working Around Missed Optimizations

Paul White (b | t) writes two fascinating blog posts that go hand-in-hand concerning query optimization.  He goes into some… Read more

0 comments, 84 reads

Posted in Kevin E. Kline on 23 March 2015

Selected as a PernixPro

Today I’d like to announce that I have been selected as a PernixPro for 2015! It’s a program similar to VMware’s vExpert, Microsoft’s MVP, and other community awards for those that help spread the word about PernixData. I’m very proud to be a part of this program! Read more

0 comments, 85 reads

Posted in Technobabble by Klee from @kleegeek on 23 March 2015

Exam Prep 70-463: Executing packages in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 113 reads

Posted in Cleveland DBA on 23 March 2015

0 to Speaker

Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I actually submitted a session. This is the first time I’ve ever submitted something for the summit and only the third time I’ve submitted a session anywhere. And no, in neither… Read more

10 comments, 103 reads

Posted in SQLStudies on 23 March 2015

Fix Inconsistent Line Terminators in SSIS

There is a flat file processing issue I’ve run into a number of times over the years, and it’s come up again several times recently. The issue relates to the line terminators used in data files. Occasionally, changes to the systems generating these data files, or perhaps even manual edits,… Read more

3 comments, 102 reads

Posted in Tim Mitchell on 23 March 2015

Older posts