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

Archives: July 2013

Building an Effective Data Warehouse Architecture Presentation

I will be presenting the session “Building an Effective Data Warehouse Architecture” this Wednesday, July 31st, at 10pm EST for the 24 hours of PASS, PASS Summit Preview.  Info about the event, and the abstract for my session, is below.  I hope you can make it!

Mark your calendars… Read more

0 comments, 1,085 reads

Posted in James Serra's Blog on 29 July 2013

Last Weeks Top “Reading” Links #43

Weekly round-up of the links that I tweet out number 43.  As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  While these links aren’t the answer to life, the universe, and… Read more

0 comments, 1,146 reads

Posted in StrateSQL on 29 July 2013

Notes from SQLSaturday #231

First time event in Cocoa Beach went really well!

  • Speaker dinner well attended Friday night at Florida’s Seafood
  • Quite a few out of town speakers, and it seemed like more speakers brought their families. Having the event at a hotel on the beach certainly made it
  • What are the odds…

Read more

0 comments, 715 reads

Posted in SQLAndy on 29 July 2013

Rants about Connect

The site connect.microsoft.com is a wonderful concept: you can provide feedback about the Microsoft products, report bugs and give suggestions directly to the teams responsible for those products. People can vote on items to indicate them as more important.

At least, that’s the theory. It’s been known that the communication… Read more

0 comments, 632 reads

Posted in Koen Verbeeck on 29 July 2013

Benchmark Your SQL Server Instance with DVDStore

Have you ever wanted to know how fast one of your core SQL Servers are running, or ever wanted to compare the raw performance of one server to another? Now you can – and for free! 

Some folks at Dell developed a synthetic benchmark tool a while back that can… Read more

6 comments, 1,267 reads

Posted in Technobabble by Klee from @kleegeek on 29 July 2013

Custom Coding in SQL Report Services

Reporting Services 2008 is a very powerful tool for creating reports. It contains many different tools and even allows you to place complex expressions on reports in every field. Even with all of these tools there are some instances where you need more functionality. This is where custom coding comes…

Read more

0 comments, 658 reads

Posted in Mike Davis SQL on 29 July 2013

Notes on debugging Database Mail problems

I’ve had to debug database mail problems several times over the last year or so. Below is a collection of the stored procedures and queries that I’ve ended up using. I’ve added notes to most of them to help explain and work with them.

USE msdb

-- Check that…

Read more

8 comments, 1,102 reads

Posted in SQLStudies on 29 July 2013

SQL Server – Import text file using xp_cmdshell

There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK INSERT command, SSIS and OPENROWSET.

Apart from this options you can also use xp_cmdshell to import text file to SQL Server. We need to utilize dos command TYPE for… Read more

0 comments, 922 reads

Posted in SQL and Me on 29 July 2013

SQL Server Management Studio Rainbow Edition

Reblogged from The SQL Pro: Ever wanted to know the reason behind the Database color scheme in SQL Server Management Studio? I have always wondered why all the Databases in management studio were Yellow (Online), Grey (Read-Only), Lighter Yellow with text next to it (something like Restoring), or Yellow with…

Read more

0 comments, 642 reads

Posted in Coffee and SQL on 29 July 2013

What I’m sayin’ is…everything is fine.

Let’s say you are a member of the development team. Your team got a new project in the works, so everyone’s excited and and prepping for design and coordinating with other team via lots of project and update meetings for the last few weeks. Everything about the project requirement is…

Read more

0 comments, 600 reads

Posted in Coffee and SQL on 29 July 2013

Free Ebooks! Free Ebooks!

There’s a lot to smile on a cool Monday like this. One, it’s 27C outside here in Singapore, a lot less humid than most days. Two, a smiling barista in Starbucks served my coffee this morning, she must’ve a great morning start too and three, free ebooks from the Red-Gate…

Read more

2 comments, 655 reads

Posted in Coffee and SQL on 29 July 2013

Encourage Someone You Respect To Run For The PASS Board of Directors

PASS is accepting candidate applications for the 2013 election through August 7th, 2013.  Later this year we – the PASS membership – will be voting to fill three seats on the Board. To have a good election we need a great selection of candidates. I hope for a slate of… Read more

0 comments, 592 reads

Posted in SQLAndy on 29 July 2013

SQL Saturday #252, Christchurch New Zealand

SQL Saturday #252 Christchurch, New Zealand


Well, these are exciting times for the Christchurch SQL SERVER User Group.

After a period of fragmentation where our meetings seemed to be at random intervals – mainly due to certain major events outside our control – such as earthquakes, the city… Read more

0 comments, 1,097 reads

Posted in measure twice, cut once. on 28 July 2013

SQL Saturday Sacramento was terrific

This year’s SQL Saturday #222 in Sacramento was a blast. This event was certainly the high point of my summer, and am very thankful to have been selected to speak here.

Yesterday I presented two sessions at the SQL Saturday event in Sacramento, CA. First up was the session called “It’s… Read more

0 comments, 724 reads

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

Security Questions: Recommended Security Book

As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer.  Instead of just a re-cap of all of the questions, instead I’ve opted… Read more

0 comments, 655 reads

Posted in StrateSQL on 27 July 2013

Go ahead. Laugh.

I came across one of my twitter friends @DBAReactions tumblr site and gosh! I cannot stop laughing! Here is one link that is so true, http://dbareactions.tumblr.com/post/47021713946/after-the-san-admin-says-wow-you-were-right. Tell me you haven’t had any issues with the SAN team in your organization. I had. When they gave me a disk on RAID…

Read more

2 comments, 500 reads

Posted in Coffee and SQL on 27 July 2013

Hardware 201: Selecting and Sizing Database Hardware

On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download my deck here.

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

The foundation of database performance is the underlying server hardware and storage subsystem. Even the…

Read more

0 comments, 1,015 reads

Posted in Glenn Berry's SQL Server Performance on 26 July 2013

SQL Server Login Errors

Hello Dear Reader.  Quick blog today.  If you are working in the SQL Server world eventually you will try to connect to a SQL Server and get an error.  A beautiful wonderful descriptive error that reads, pauses… looks around… stands straight…. In my best impersonation of a classic English poet…

Read more

1 comments, 965 reads

Posted in SQLBalls on 26 July 2013

Webcast Presentation Materials: 5 Amazing Reasons DBAs Need to Love Extended Events

If you are looking for a presentation that brings together bacon, unicorns, and lightsabers, then you should have seen my presentation this past Thursday for Pragmatic Works Training on the T’s. The session was 5 Amazing Reasons DBAs Need to Love Extended Events.  In it, I ran through… Read more

0 comments, 869 reads

Posted in StrateSQL on 26 July 2013

Disaster Recovery - Part 1 - Possibly Almost Everything But the Kit

Over the years I have been fortunate or unfortunate enough, depending on who you are to have experienced several disasters along with a couple of very near misses.  In this post I am going to explore some of the areas of DR that are not related to the physical kit.…

Read more

0 comments, 953 reads

Posted in SQL Server 365 on 26 July 2013

Newer posts

Older posts