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

Archives: June 2012

Almost an MCSA

I took four beta tests earlier this year for SQL Server 2012. I had debated writing another book, and I’ve worked on a few of the cert books in the past, so I thought this would be a good chance to look at the tests. Since I had free invites… Read more

0 comments, 622 reads

Posted in The Voice of the DBA on 25 June 2012

Goals – The end of one year, start of another

Just about a year ago, I talked about the importance of setting goals for yourself, both personally and professionally, making sure they’re lofty enough to challenge you, and making them public in order to hold yourself accountable.  It’s hard to believe a year has passed already, but here we are,… Read more

5 comments, 483 reads

Posted in Cleveland DBA on 25 June 2012

Does Encryption Affect Seeing Statements in Deadlock Graphs?

Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:

CREATE PROCEDURE DL2e
    WITH ENCRYPTION
AS 
    BEGIN TRANSACTION
    UPDATE  Purchasing.PurchaseOrderDetail
    SET     OrderQty = 2
    WHERE   ProductID = 448
            AND PurchaseOrderID = 1255;

Then I’ll execute things in the following order. From one… Read more

3 comments, 1,239 reads

Posted in The Scary DBA on 25 June 2012

Maintenance Plan Owner

We all inherit things from time to time through our profession.  Sometimes we inherit some good things, sometimes we inherit some things that are not so good.  Other times we inherit some things that are just plan annoying.  Yet other times, we inherit things that may be annoying and we… Read more

5 comments, 1,979 reads

Posted in SQL RNNR on 25 June 2012

Don’t believe everything you read: Reconfigure flushes the plan cache

I’ve been doing a fair bit of research and investigation into the behavior of the plan cache recently. So I was concerned when I read somewhere that the reconfigure statement causes the SQL Server plan cache to be flushed. If this is true then it is a pretty crucial piece… Read more

4 comments, 2,204 reads

Posted in Ctrl-alt-geek on 25 June 2012

Join me at the PASS Summit

It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting in SQL Server.  It couldn’t possible have been 8 months since we were attending after-party events together, stopping by the Tap House for a beer, or closing down Bush Gardens… Read more

0 comments, 291 reads

Posted in Tim Mitchell on 25 June 2012

Join me at the PASS Summit

It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting in SQL Server.  It couldn’t possible have been 8 months since we were attending after-party events together, stopping by the Tap House for a beer, or closing down Bush Gardens… Read more

0 comments, 124 reads

Posted in Tim Mitchell on 25 June 2012

SQL Server : Parameter Sniffing


Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure. Her complaint was one stored procedure is taking long time from the application but completing in two seconds in SSMS.I told her it might be due to parameter sniffing but…

Read more

9 comments, 4,814 reads

Posted in PracticalSQLDba on 25 June 2012

Super SQLSaturday #158 Summer Spectacular Event Update & Speaker Schedule!

 

When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent amount of interest, registrants, and speakers.  Yet, so early on, it is amazing that we received over 150 speaker abstracts, 15 sponsors, and almost 200 registrations. We fully… Read more

0 comments, 1,309 reads

Posted in Pearl Knows on 24 June 2012

Using SQL Server 2012 FileTables

SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL Server FILESTREAM technology. As per Microsoft BOL, “FileTable lets an application integrate its storage and data management components, and provides integrated SQL Server services – including full-text search and semantic… Read more

4 comments, 5,509 reads

Posted in Basit's SQL Server Tips on 24 June 2012

Generating Surrogate Keys With SSIS

A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key of the table and is used to join a dimension to a fact table. Among other benefits, surrogate keys allow you to maintain history in a dimension table. Despite of… Read more

5 comments, 3,221 reads

Posted in Sam Vanga on 24 June 2012

Excellent SSIS 2012 Upgrade Video

This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL Server 2012 SSIS.  I’m very impressed at the much-improved capabilities for deploying SSIS packages in a less-scary way using package and project parameters, support for SSIS “environments” (“prod”, “dev”, “test”,… Read more

0 comments, 700 reads

Posted in New York City .NET on 24 June 2012

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .

First, in BOL, for "DBCC DBREINDEX" , it mentions
This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify…

Read more

2 comments, 5,931 reads

Posted in James' SQL Footprint on 23 June 2012

Inspirational Database Administration Requirements

 

Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined by the requirements from management. I had been fortunate to work with a few excellent managers in the past and benefited a lot from their requirements. I’ll share some… Read more

1 comments, 545 reads

Posted in DBA Philosophy on 23 June 2012

SQL Server 2012 Installation Guide

This article walks the user through installation of SQL Server 2012 on a Windows Server 2008 system using the SQL Server setup installation wizard. The installation process is simple, straight forward and is very similar to SQL Server 2008 / 2008 R2 setup. The procedure described is for a non-clustered… Read more

10 comments, 62,287 reads

Posted in Basit's SQL Server Tips on 23 June 2012

I don’t care and why that is good for my blog

I expressed in my About page that this blog is never meant to be a technical blog. But the pressure of relevancy keeps popping up: I need technical content if I want this blog to survive. Readers want to read technical stuff – something they can apply in their job. Read more

4 comments, 524 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 22 June 2012

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn’t Apply to Dropped Databases or Does It?

5 Second Rule Doesn't Apply to Dropped Databases or Does It?


Imagine you get a frantic call from someone, we’ll call him George, who just dropped a busy production database, and if he can’t get it back up ASAP,… Read more

Is That Your Code? [Copyright Considerations]

Think about that last SQL statement that you wrote.  Did you originally write it?  Are you sure you wrote it?  What about the one that does that thing that you think is really clever?  Can you go through all of the code in your script folder, and identify which ones… Read more

1 comments, 447 reads

Posted in StrateSQL on 22 June 2012

Presenting at PASS Summit 2012

I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”.  I get the privilege to present on some awesome new technologies released in SQL Server 2012. Here are my sessions for this year’s Summit: A Window into Your Data:  Using SQL…

Read more

0 comments, 280 reads

Posted in DataOnWheels on 22 June 2012

Speaking at SQL Saturday 159 in Kansas City!

Come to Kansas City on August 4th for SQL Saturday 159 and hear us speak!




At 2:30pm, I will be speaking with my House of Brick Technologies colleague David Klee (B/T) on Virtualizing Business Critical SQL Servers - this is the marquee topic for our employer,…

Read more

0 comments, 192 reads

Posted in Nebraska SQL from @DBA_ANDY on 22 June 2012

Newer posts

Older posts