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

Archives: January 2012

Execution Plans, What Do I Look At?

The question came up, what are the top 3-5 things that you look at in a query. I realized then that I hadn’t really written them down. There are some areas that let me know pretty much immediately where problems lie within a plan. You don’t necessarily know the answer… Read more

9 comments, 1,765 reads

Posted in The Scary DBA on 30 January 2012

Apply to Be A 2012 Idera ACE!

The call for applications is open today, a chance for six lucky people to do more in the SQL community for a year. Idera will sponsor your travel to a few events in the US, invite you to do webcasts that often have 1000+ attendees, and work with you to… Read more

0 comments, 654 reads

Posted in SQLAndy on 30 January 2012

New article: Identifying What Runs at Startup on SQL Server

Another article has published over at MSSQLTips.com. This one covers how to identify what stored procedures are set to run when SQL Server starts up as well as what jobs are set to run when SQL Server Agent comes online. An attacker could use both of these places to embed code to regain… Read more

System Base Tables

On January 19th, I published a post about the Dedicated Administrator Connection.  I spoke very briefly of the system base tables in that article.  Today, I want to dive into these tables a little bit more.

First, let’s get the Microsoft definition for these tables.  ”System base tables are… Read more

0 comments, 897 reads

Posted in SQL RNNR on 30 January 2012

Blogging: Starting a Blog

Following on from the first post in my blogging series Building a Blog I’m just going to take a  quick look at some of the blogging platforms you can choose to manage your blog. The most common platform that I have come across if WordPress. I haven’t really used… Read more

0 comments, 662 reads

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

SQL server – ISNUMERIC and checking for valid numeric tyopes

During a large ETL process from  a staging table  , UPDATE was creating an error on a CONVERT.

Msg 245, Sev 16, State 1, Line 17 : Conversion failed when converting the nvarchar value '??u?  ? ? ?AA???????????W?????????a??????K???????????????????1217' to data type int. [SQLSTATE 22018]


It was necessary to create… Read more

0 comments, 996 reads

Posted in SQLServer-DBA on 30 January 2012

Detect Worst Performing SQL Queries

This series of Videos will walk through how to detect worst performing sql queries which is slowing down Microsoft SQL Server, after this session you should be able to achieve below objectives… How to use SQL Server DMO’s to gather what resources are the bottlenecks and which queries are causing…

Read more

0 comments, 709 reads

Posted in SQLFeatures on 29 January 2012

Rebuild System Databases

Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation goes like:
FB Friend: Hi
I : Hi
FB Friend: I need your help
FB Friend : My SQL Server is not starting...
I : What is an error you…

Read more

Find failed SQL jobs with powershell

This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again.  Kent Chenery (blog | twitter) did a nice session on powershell for n00bs and it got me thinking that I need to start posting some of my powershell stuff up… Read more

8 comments, 9,694 reads

Posted in SQL Sandwiches on 29 January 2012

Find Login in Active Directory

Find Login in AD

Many times we require to know if particular login is a part of ad user group. Or sometimes we need to know a AD group and wanted to know who all logins are part of it.

There are many different ways to achieve this.

  1. I follow…

Read more

0 comments, 803 reads

Posted in Vinay Thakur on 29 January 2012

Creating merge replication conflict alerts

One of the challenges in working with Merge Replication is handling conflicts since writes can occur at any node in a topology. In an earlier post I demonstrated how to handle conflicts using the business logic handler framework - now I would like to show how to create Merge Replication… Read more

1 comments, 1,410 reads

Posted in SQLREPL on 28 January 2012

Petitions on Change.org and Thoughts on Changing PASS

I tried this out – Change.org that is – recently as part of a post about PASS and wanted to post a few comments about the experience.

Setting up a petition was very easy and they do a good job of walking you through the process. The total time is… Read more

0 comments, 727 reads

Posted in SQLAndy on 28 January 2012

January #Meme15 Round-Up

The second round of #meme15 finished up last week and it’s time to see who participated.  In total, there were fifteen people that participated in the event.  If I’ve missed anyone, just leave a comment here and I’ll update this post.

As a refresher, #meme15 is dedicated to discussing and… Read more

0 comments, 744 reads

Posted in StrateSQL on 28 January 2012

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, 598 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, 1,215 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, 514 reads

Posted in StrateSQL on 27 January 2012

Link: How USB Charging Works

Good discussion of how USB charging works.

Read more

0 comments, 663 reads

Posted in SQLAndy 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, 998 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

4 comments, 683 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, 627 reads

Posted in DataOnWheels on 26 January 2012

Newer posts

Older posts