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

Archives: May 2013

Security Questions: Accessing SQL Server Securables

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, 2,113 reads

Posted in StrateSQL on 29 May 2013

I’m a VMware vExpert 2013!

WOW! I have not received the official confirmation yet, but last night John Troyer posted a new entry on the VMware blogs announcing the 2013 vExpert list, and I’m one of 579 on the list! My friend Tony Foster (b | l | t) noticed and shot… Read more

0 comments, 722 reads

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

Painting the US Red

We are bringing Red Gate, through the free SQL in the City event, to the United States again this year.

This event has been hosted in London multiple times, Los Angeles, New York, Austin, San Francisco, Chicago and Boston. It’s a fun day of training, presentations, and networking, all done… Read more

4 comments, 745 reads

Posted in The Scary DBA on 29 May 2013

Security and SSIS webinar recording available

If you missed the webinar Andy Leonard (blog | twitter) and I presented today or you had technical difficulties, here's the recording:


SSIS and Security with Andy and Brian


It runs just about an hour and we ask questions that should be considered when building an… Read more

SharePoint 2010 on SQL 2012 Configuration Failed

Recently while doing an installation of SharePoint 2010 on a Windows Server 2008 R2 server with a SQL Server 2012 back end I ran into a small roadblock. The following error popped up as I was running the product configuration wizard.



Failed to create the configuration database.


Read more

0 comments, 1,084 reads

Posted in Bradley Schacht on 29 May 2013

You Must Cross Teams for Sound Security

I've given a couple of security presentations recently where I talked about how you must keep track of how security is being managed. For instance:


  1. The best practice recommendation is that we use Windows authentication vs. SQL Server authentication.
  2. In an enterprise environment, we typically want to use Windows…

Read more

SSIS Security Presentation today, May 29th

Andy Leonard (blog | twitter) and I are teaming up to do a security presentation today on SSIS. It's scheduled for 11 AM EDT.


Register to attend the webinar!


I'm going to go ahead and post a copy of the slides here before the presentation. There's nothing earth-shattering… Read more

Back to Plan A

At the end of April I posted a bit on my change in plans and what I thought I’d be doing for the next few months, with part of that being some uncertainty on both sides about what the work would be and if it would be a good fit.… Read more

0 comments, 735 reads

Posted in SQLAndy on 28 May 2013

New Immersion Event Classes at SQLskills

There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the two-day IEHW class on September 18-19.

I am really excited to get the chance to teach the IEHW class, and I think it will be a lot of fun! … Read more

0 comments, 764 reads

Posted in Glenn Berry's SQL Server Performance on 28 May 2013

Security Questions: Authentication Performance

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, 680 reads

Posted in StrateSQL on 28 May 2013

SMO vs Invoke-Sqlcmd in Azure

I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be giving at TechEd and the PASS Summit. One of the things I want to do is script out a full backup process (one that’s consistent with transactions)… Read more

3 comments, 962 reads

Posted in The Scary DBA on 28 May 2013

Business Intelligence Requirements Gathering

There are three fundamental steps in building a data warehouse for a BI solution (see Why you need Business Intelligence):

  1. Identify the data the users interact with, or would like to interact with, via interviews.  Make sure to determine the granularity of the data that is needed, if Type…

Read more

2 comments, 4,321 reads

Posted in James Serra's Blog on 28 May 2013

Internet Security Advice For The Family

Constant Vigilance!

For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security. The post today is actually an email exchange between myself and my younger sister. She asked me for some general advice and I wrote a long… Read more

3 comments, 888 reads

Posted in SQL Chicken on 28 May 2013

Using CROSS APPLY to calculate an aggregate across a single row.

I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last two posts. Since it’s been on my mind a lot I started to wonder if I could use it to solve some problems I’ve run across in the past. In… Read more

2 comments, 1,240 reads

Posted in SQLStudies on 28 May 2013

SQL Server – Filtering objects in Object Explorer – Management Studio

When you are working on a database with a large number of objects sometimes it becomes a challenge to locate objects. Object Explorer in SQL Server Management Studio lists all objects according to category and it may be hard to locate specific object.

To resolve this you can Object Explorer… Read more

4 comments, 903 reads

Posted in SQL and Me on 28 May 2013

Using the SSIS Object Variable as a Result Set Enumerator

In the first post in this series, I covered the basics of object typed variables in SQL Server Integration Services, along with a brief examination of some potential use cases.  In this installment, I’m going to illustrate the most common use of object typed variables in SSIS: using an… Read more

10 comments, 1,626 reads

Posted in Tim Mitchell on 28 May 2013

Investigating Plan Cache Bloat

SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory.  However, it can also help give you insight into how consistent your developers are with writing code.

For this topic, we'll just concentrate on a few columns returned by the DMV: sql_handle

Read more

0 comments, 1,050 reads

Posted in Everyday SQL on 28 May 2013


I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits of that is getting to meet and interact with their team.  One of their team that I never really even knew of before he joined SQLskills was Joe Sack,…

Read more

1 comments, 557 reads

Posted in Nebraska SQL from @DBA_ANDY on 28 May 2013

Sum Result of SSRS LookupSet Function

SSRS provides several built-in Lookup functions:  Lookup, MultiLookup and LookupSet.  Lookup returns a single value while MultiLookup and LookupSet return a set of values. If you want to learn more about the SSRS lookup functions check out this blog post

In some situations, we may want to sum the… Read more

10 comments, 3,832 reads

Posted in Salvo(z) SQL on 27 May 2013

Recap of our SQL Saturday #225 in Kosovo, Prishtina

SQL Saturday Kosovo #225, happened last week and I’m very happy that we did for the first time in Balkan region!

Special thanks goes to the sponsors Ipko FoundationPASSMicrosoftICK (Innovation Center Kosovo), RedgateWroxPluralSightxSQL SoftwareDigjitale.com,… Read more

0 comments, 1,117 reads

Posted in Dukagjin Maloku - Dugi'DBA on 27 May 2013

Newer posts

Older posts