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

Archives: April 2012

Slacking Off: Totally TED

Lately I’ve taken to watching TED talks in the evening.  They’re thought-provoking, usually entertaining, and, best of all when watching late at night, short.  I have to control myself though, I could spend hours jumping from one great topic to another.  Really, I should probably watch something less thought-provoking right… Read more

2 comments, 455 reads

Posted in Cleveland DBA on 27 April 2012

Big Apple SQL - SQLSaturday #158 NYC Announced!

 Come this August 4th, 2012, the Big Apple will be baking, but not just because of the hot summer day we're expecting!  No, something much more filling will be cookin, with the announcement that SQLSaturday is returning to NYC! 

We've been thinking, talking, planning,  and hoping behind the scenes that… Read more

0 comments, 1,147 reads

Posted in Pearl Knows on 27 April 2012

SSWUG Expo..I'm up!

I am proud to say that one of the webcasts I taped last year for SSWUG is part of the Free Virtual Expo.  My SSIS Enhanced Threading Framework is being shown.  Click here to register. Read more

0 comments, 48 reads

Posted in SQLRunner on 26 April 2012

April Hammond .net User Group Presentation - SQL Server Security and Permissions

Here's the slide deck and sample files from last night's presentation at the Hammond .net User Group.  We discussed SQL Server security principals, permissions and application authentication.  If you were in the audience, thanks for attending!

Download the slides and sample scripts here.


Read more

0 comments, 495 reads

Posted in SQL Tact on 26 April 2012

SQL Server 2012 Diagnostic Information Queries (April 2012)

It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. These queries are meant to be used with SQL…

Read more

1 comments, 1,474 reads

Posted in Glenn Berry's SQL Server Performance on 26 April 2012

The Mentoring Experiment – Cycle 2

It’s been a long time, almost a year since Andy Warren and I kicked off The Mentoring Experiment. We had a successful cycle 1, and are not in the process of looking for mentors for cycle 2. Once we get an idea of how many people are willing to… Read more

0 comments, 494 reads

Posted in The Voice of the DBA on 26 April 2012

AlwaysOn Failover Bug

I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a nutshell, if you have a table with an IDENTITY seed less than 1000, when you do a failover the table is reseeded to 1001. The steps to reproduce are posted… Read more

5 comments, 585 reads

Posted in The Scary DBA on 26 April 2012

See you at SQL Saturday 130 Jacksonville!



http://www.flickr.com/photos/rohicks/4788477593/

Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL!  The good people from the Jacksonville SQL Server User Group have put together an excellent event.  If you are in the Jacksonville area, (or in FL or GA for that matter) and would like…

Read more

0 comments, 232 reads

Posted in SQLBalls on 26 April 2012

Beer, Cheese and SQL Saturday 118 Madison

This past weekend I (w|t) headed up to Madison, WI to attend and present at SQL Saturday 118. The MADPASS team did a fantastic job on their first SQL Saturday.

Attendance was excellent with 227 total consisting of locals and groups from Minnesota, Iowa, Missouri, Indiana,… Read more

1 comments, 500 reads

Posted in The Gerasus Software Blog on 26 April 2012

Offset without OFFSET

A while ago Robert Cary posted an article on SQL Server Central entitled 2005 Paging – The Holy Grail which is, as the title would suggest about paging in SQL Server.  This article provoked some really interesting chat around the subject and is well worth a read.

This is now… Read more

4 comments, 1,334 reads

Posted in Dave Ballantynes blog on 26 April 2012

Enterprise Data Warehouse Architecture Options

Enterprise Data Warehouse Architecture Options

Of course, your architecture depends on your business requirements along with technical, historical, and political factors. While business requirements are usually business-specific, we can start with a list of broad requirements, or architecture goals, that most organizations would support:

1. Excellent query performance for users Read more

0 comments, 1,417 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 25 April 2012

Creating a Symmetric Key in SQL Server

Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and resource usage, much better than asymmetric keys. Creating a symmetric key is fairly simple, using DDL that’s easy to understand.

One note before I show this is that symmetric keys… Read more

1 comments, 1,508 reads

Posted in The Voice of the DBA on 25 April 2012

New White Paper: SQL Server Extended Events and Notifications

Download the new white paper: How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues

SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to… Read more

2 comments, 817 reads

Posted in Kevin E. Kline on 25 April 2012

2012 (2011) Data Breach Report

I had a chance over the weekend to finish reading the Verizon 2012 Data Breach Investigations Report. It’s a compilation of data about 2011 data breaches and they try to call out what they see as interesting in addition to showing a few different views of the data. It’s… Read more

0 comments, 392 reads

Posted in SQLAndy on 25 April 2012

Identity Crisis

I’m sure most people have identity values lurking somewhere in their databases.  In fact I would guess that most people have a lot of them.

An often overlooked fact is that while they are an ever increasing/decreasing value, they do have limits.

If you have a high number of inserts… Read more

10 comments, 1,973 reads

Posted in Mat Walters' SQL Blog on 25 April 2012

SQL Backup 7

What more could you add to a SQL Server backup product? It seems that many software products, including Red Gate’s SQL Backup Pro, have been able to handle the things most DBAs care about for some time: compression and encryption. Today my company has released a new version of… Read more

0 comments, 515 reads

Posted in The Voice of the DBA on 24 April 2012

Automatic page repair with SQL Server Mirroring

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring versus the more traditional Failover Clustering. Both are features provided by SQL Server for achieving high availability, buth they both have pro’s and con’s that could make a decision hard.… Read more

0 comments, 1,358 reads

Posted in SQL Server Notes from the Field on 24 April 2012

Oracle Tips for MSBI Devs #3: Choosing Drivers

When working with Oracle, drivers are truly a pain to get working correctly.  I will discuss my preferred choice and why for the following tools – SSIS, SSAS, and SSRS. SSIS Drivers Without much question, you should use the Attunity tools for working with Oracle data in the Data Flow…

Read more

0 comments, 441 reads

Posted in DataOnWheels on 24 April 2012

List of Sharepoint Blogs

I ran across this list of Sharepoint blogs by Rene Modery while doing some Sharepoint reading. He has an OPML file of the list, making it easy to add to your reader. Thought some of you might find it useful.

Read more

0 comments, 213 reads

Posted in SQLAndy on 24 April 2012

Updated Thoughts on Antivirus on SQL Servers

I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't like running standard antivirus on Exchange, SQL Server, or Active Directory domain controllers. My SharePoint admin friends have made good arguments to avoid it there, too. But a lot of… Read more

Newer posts

Older posts