Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 326 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')

And

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

2 comments, 496 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, 667 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, 1,892 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

1 comments, 545 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

0 comments, 762 reads

Posted in SQL Tact 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, 337 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, 598 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

4 comments, 209 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.

Onward!

-Jen McCown
http://www.MidnightDBA.com/Jen

Read more

1 comments, 386 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, 581 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, 449 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, 594 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

1 comments, 1,879 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.

Problem:

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

0 comments, 489 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, 308 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, 290 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

2 comments, 579 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

1 comments, 813 reads

Posted in SQLDownSouth on 26 February 2013

A Month of PowerShell – Day 26 (Changing Login Passwords)

Welcome to Day 26 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.

If you utilize the sa… Read more

0 comments, 607 reads

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

Older posts