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

Archives: February 2013

Presentation Materials “A Function is a Function”

Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of the Performance Impacts of User Defined Functions.

Download: A Function By Any Other Name Is A Function

Other resources:

  • http://msdn.microsoft.com/en-us/library/ms189294.aspx
  • http://www.sqlteam.com/article/intro-to-user-defined-functions-updated
  • http://www.amazon.com/Transact-SQL-User-Defined-Functions/dp/1556220790/ref=sr_1_1?ie=UTF8&s=books&qid=1268026139&sr=8-1

Read more

0 comments, 1,258 reads

Posted in StrateSQL on 28 February 2013

Insert multiple values sets into a table in one command

The INSERT command has two distinct ways to load data into a table.

INSERT INTO Table (field1, field2) VALUES ('string1','string2')


INSERT INTO Table (field1, field2)
SELECT field1, field2 FROM Table2

Both of these are very handy and have been around as far back as I can remember. Historically you… Read more

8 comments, 3,079 reads

Posted in SQLStudies on 28 February 2013

A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)

Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

During… Read more

0 comments, 2,006 reads

Posted in A Discussion of SQL Server-Related Topics on 28 February 2013

Dust Off That Resume

Since I started regularly attending SQL Saturday events some five years ago, I’ve sat in on a number of professional development sessions by Andy Warren, Buck Woody, Don Gabor, and others.  Each one offered different bits of advice based on his or her own experience, but there… Read more

0 comments, 3,101 reads

Posted in Tim Mitchell on 28 February 2013

SQL BLOG: Using Triggers for creating history tables in SQL Server

Case Study:
1)       We  need to track the employee table in terms of new records inserted along with the datetime stamp

2)      In case any updation, we need to track the same with only the column name that is updated. Rest all columns should be null. All tracking…

Read more

3 comments, 3,891 reads

Posted in SQL Blog by Rahul Sahay on 28 February 2013

"An item with the same key has already been added."

In SQL Server Reporting Services, when adding a new dataset to a report, you may see an error that looks like this:

"An item with the same key has already been added."

Based on some quick googling, it looks like there are several potential causes for the error, but here's…

Read more

1 comments, 3,775 reads

Posted in SQL Tact on 28 February 2013

Failing to Preview Report in Report Builder


We recently delivered a SQL Server 2012 Reporting Services solution to a client with an additional capability for client’s business users to be able to design, develop and publish ad hoc reports using Report Builder 3.0. During unit testing we had one of the Business Analysts (BA) in… Read more

2 comments, 2,228 reads

Posted in on 28 February 2013

Check out IT Central Station

If you get some time, head on out to IT Central Station.com. You can provide some valuable feedback on the technology products you have had experiences with. I just found out about the site a couple of weeks ago, and am enjoying posting reviews on the products that I… Read more

0 comments, 1,161 reads

Posted in Technobabble by Klee from @kleegeek on 28 February 2013

Data Warehouse Architecture Presentation Slides

Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter.  There were over 200 attendees!  The recording of the session is available here.

Here is the PowerPoint presentation: Building an Effective Data Warehouse Architecture

Data Warehouse Architecture

You’re a DBA and your… Read more

0 comments, 1,603 reads

Posted in James Serra's Blog on 28 February 2013

Optimizing Protected Indexes (was Indexing Encrypted Data)

Why bother encrypting?

Riddle me this batman? Why bother to Encrypt?

As a SQL Server DBA I am primarily responsible for making sure my client’s data is protected and available amongst other things. In many cases I have gone to clients and projects to find that sensitive data is not… Read more

7 comments, 1,623 reads

Posted in WaterOx SQL on 27 February 2013

We’re Live on the PowerScripting Podcast! (Thursday night, 02-28)

Your MidnightDBAs

Unusually, Sean and I will be guests on someone else’s podcast this week! Tune in live to our PowerScripting podcast Thursday Feb 28, 2013 at 9:30PM EST here. You know, if you want to.


-Jen McCown

Read more

1 comments, 1,252 reads

Posted in SQL Awesomesauce on 27 February 2013

Attaching an MDF with no Log (AdventureWorks)

Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently when I downloaded the AdventureWorks2008R2 database, which was just an MDF file. I know I’ve done this before, but I had to stop and look things up, which means… Read more

1 comments, 1,947 reads

Posted in The Voice of the DBA on 27 February 2013

It Is Your Fault

I earned my nickname. I’m proud of it. I am the Scary DBA. I don’t really like to advertise my other nickname, Rant (get it, Grant shortened to another word). I earned that one too. I’m not proud of it at all. I got that one because I sometimes don’t… Read more

10 comments, 1,502 reads

Posted in The Scary DBA on 27 February 2013

Finding SQL Server Installs Using Powershell

Old Dog, New Tricks

I’ve been writing tools for SQL Server for a lot of years. Some of these tools were never completely released. Some of them were just for me. Some of them overlapped other tools already on the market and free for all. Recently, I started updating my… Read more

3 comments, 2,035 reads

Posted in SQL Man of Mystery on 27 February 2013

A Month of PowerShell – Day 27 (Scripting SQL Objects)

Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on this blog at http://blog.waynesheffield.com/wayne/a-month-of-powershell/. Please refer to this page to see all of the posts in this series, and to quickly go to them.

One of the tasks that… Read more

2 comments, 3,431 reads

Posted in A Discussion of SQL Server-Related Topics on 27 February 2013

Setting up an Internal Friendly URL

Note: This solution is not necessarily the best or most efficient solution in all cases.  It is, however, very simple and works with any site - even ones you have no control over.


Internal Web System XYZ must be accessed via an ugly URL such as http://randomservername.internalexample.com:8675309/SomeCrazyPath/SomeFile.htm

Desired End… Read more

1 comments, 2,583 reads

Posted in New York City .NET on 27 February 2013

Thanks to my session attendees

To all of the wonderful attendees to both the VMware Partner Exchange SQL Server on VMware VBCA boot camp on Sunday and the guys who braved the nasty weather for the Fort Wayne SQL Server Users Group presentation tonight, I say thank you. All of your questions were great… Read more

0 comments, 1,076 reads

Posted in Technobabble by Klee from @kleegeek on 27 February 2013

Converting Inches to Centimeters - Long Hand

Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then convert that number from inches to centimeters. While that is handy, I thought it would be best to include a few… Read more

0 comments, 1,149 reads

Posted in SQLRunner on 26 February 2013

Get Database information in mail using PowerShell !

Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would you love to get a report which will help you maintain and manage your large shared SQLServer environments neat and clean?

If your answer is Yes, then powershell is your… Read more

4 comments, 1,883 reads

Posted in SQLSailor.com on 26 February 2013

SSRS 101 – Creating a Shared Dataset

Now that you have created a Share Data Source, it’s time to add some data to your project. In this post I will explain Shared Datasets and demonstrate how to add a one to your project.

As with a data source, you can create an embedded or shared dataset. The… Read more

0 comments, 2,797 reads

Posted in SQLDownSouth on 26 February 2013

Older posts