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

Latest Blog Posts

Microsoft Data Appliances Help Simplify MSBI Projects

As some of you know, I am really excited about the data appliances Microsoft and HP have released this year.  I really believe that they make it even easier to get MSBI projects up and running while minimizing the complexity of building out servers. Read more about my thoughts on…

Read more

0 comments, 53 reads

Posted in DataOnWheels on 27 January 2012

SSAS fact table dilemma

Here is a situation I ran into recently concerning using a fact table in SSAS.  This experience may help you out if you run into something similar:

A data warehouse has an advertising table that has these four fields: Product Type, Inches, Lines, Pieces. The Inches, Lines and Pieces fields… Read more

0 comments, 57 reads

Posted in James Serra's Blog on 27 January 2012

Re-blog – January 20 – January 26

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have… Read more

0 comments, 50 reads

Posted in StrateSQL on 27 January 2012

SQL Server - Generate SQL INSERT from Excel

Generate SQL Server INSERT statements with Excel Concatenate.

A developer requested  access to a Production database. The details were to COPY and PASTE from a Excel spreadsheet into Access , which then updated SQL Server.  Upon asking him , why he used this method , he said “It’s the way… Read more

0 comments, 16 reads

Posted in SQLServer-DBA on 27 January 2012

Blogging: Building a Blog

I took an interest in building  a blog/website several years ago when I first started my company and working for myself. Over the years I have tried many different approaches and over the last few years I have settled on using my blog to build my brand.

More recently a… Read more

0 comments, 75 reads

Posted in The SQL DBA in the UK on 27 January 2012

X on XMLA: i. Using XMLA

In my previous blog, I introduced the “X on XMLA” series.  In this blog, I will do more of an introduction to XMLA by discussing how I have used XMLA in my experience with SSAS. What is XMLA? XML for Analysis or XMLA is the API used to interact with…

Read more

0 comments, 73 reads

Posted in DataOnWheels on 26 January 2012

Introduction to XML DML (Part 2) - Using the modify() method: replace value of

This is the second part of a 3 part blog which will attempt to show some different ways of how you can use the xml modify() method to update the contents of an XML document. This part, starting at the absolute basics, will cover the ability to update data in… Read more

0 comments, 76 reads

Posted in SQL Server Rocks! on 26 January 2012

SQLCruise: The Trident

Move over Poseidon.  I’m hitting the sea with my own trident (assuming I can get it through the TSA).  My trident is made from the culmination of my favorite three things.  My wife, SQL Server, and cruising.  Let me explain.

Back in October of last year, Idera ran a contest… Read more

0 comments, 78 reads

Posted in Ryan Adams on 26 January 2012

Database 101

I had an interesting phone call this morning from our professional services team.  They are carrying out what I can only call extreme testing on one of our products to see just how much data we can process in a given time window.  The issue they ran into was a…

Read more

0 comments, 97 reads

Posted in SQL Server 365 on 26 January 2012

You require WHAT for a license?

I was trying to acquire a license for a product I was trying to look at using a free program. Now, because the organization is providing the license for free, I expect some strings to be attached. Want me email? Yup, how else would you send me the license? You… Read more

SSRS - Custom Code with External Assemblies

In a previous post I wrote about how you can use embedded custom code to extend the capabilities of Reporting Services.  This week I will show you another method of using custom code but this time with external assemblies.  Ideally when using custom code you would choose to do so… Read more

0 comments, 99 reads

Posted in Devin Knight on 26 January 2012

SQL Server – Error Logs recycle without SQL Server Restart

If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming to search for specific Messages. 

It is a good idea to recycle the SQL Server Error Logs . To create a new Error Log file without restarting SQL… Read more

0 comments, 30 reads

Posted in SQLServer-DBA on 26 January 2012

Enabling Compression? Update your baseline

I wrote recently about capacity planning, with an item near the end about disk usage. Someone pointed out to me that compression can dramatically affect your baseline, and as you implement it, or de-implement it, you need to update your baseline.

That’s an important point, and if you make… Read more

0 comments, 89 reads

Posted in SQL Musings on 25 January 2012

Improving cube processing time

As your SSAS cube gets bigger, cube processing time will become a problem.  This is especially true as more and more companies want cube processing during the day instead of the usual off-hours time when no one is using the cube.  Partitioning the cube can help to reduce the processing… Read more

0 comments, 112 reads

Posted in James Serra's Blog on 25 January 2012

Venting Frustration

We as DBA’s face an ever growing list of things to do and services to support.  We work in high pressure environments where time is of the essence and there is little to no room for error.  The very nature of our roles mean we have to work unsociable hours…

Read more

0 comments, 95 reads

Posted in SQL Server 365 on 25 January 2012

Windows 8 Easy Refresh?

I saw this write up about the built in ability to both restore to factory settings as well as just refresh (basically a clean install but preserves your data). It’s not a dumb idea, it solves a common problem that has been already a long time. Way way back when… Read more

0 comments, 31 reads

Posted in SQLAndy on 25 January 2012

Notes from 'Putting a Better SQL Server in Production' - the Ideal Pre-Prod checklist from Robert L. Davis

 

Last week, I sat in on Putting a Better SQL Server in Production - this is an ideal pre-prod checklist from Robert L. Davis.

The original slide deck available here (on demand), from his January 19th presentation:

I have placed a copy that includes my notes here… Read more

0 comments, 63 reads

Posted in The Database Hive for SQL Server DBAs on 25 January 2012

Congratulations to Philippe Falardeau for Monsieur Lazhar's Oscar Nomination (Played by Fellag, the Algerian Comedian Famous For Le Visa)

 

Congratulations to Philippe Falardeau - he has made the official Oscar Nominations!

http://www.monsieurlazharmovie.com/ tourné à Montréal – Filmed in Montreal! The hilarious Algerian comedian Fellag is the star who plays the teacher.  Watch Fellag's joke about getting a Visa for France :) http://www.youtube.com/watch?v=fNgGEZCdVqI un des meilleurs comédiens d’Algerie J… Read more

0 comments, 36 reads

Posted in The Database Hive for SQL Server DBAs on 25 January 2012

About those backups...

So I went to present at Charleston PASS on Thursday night and of course I had my standard contact information on my slides. This included the web site I have (had) as my brochure site: truthsolutions.com (it's not up, so no link). I hadn't checked it in a while because… Read more

Slammer, Alive…Barely

Slammer

By now you must have heard of the SQL Slammer worm.  It was quite an infectious little nuisance.  The harm it caused came largely due to unpatched, unprotected SQL Servers.

We are now 9 years out from the initial discovery of this worm.  The worm has made its way… Read more

1 comments, 101 reads

Posted in SQL RNNR on 24 January 2012

Older posts