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

Archives: April 2012

Less Energy through Better Design

When I attended SQL Saturday #131 at the Chandler Gilbert Community College, I was struck by a few design elements that I thought were great examples of how a little thought can improve the experience of a space, and use less energy.

The event was outside Phoenix, which is hot.… Read more

0 comments, 1,968 reads

Posted in The Voice of the DBA on 30 April 2012

SQL Saturday #131 Recap

This past weekend I attended a SQL Saturday in the desert. SQL Saturday #131 was held in Phoenix, AZ

It’s April, but it was definitely hot. However the campus at Chandler Gilbert Community College was geared to the desert with lots of shade and open spaces. I was surprised how… Read more

0 comments, 1,888 reads

Posted in The Voice of the DBA on 30 April 2012

Generate restore script automatically by backup history table

I wrote a store procedure which could generate restore script automatically by backup history table. it can help you select a best restore solution base on the backup history table.

For instance,  if you backup the database as the sequence below
ID backup_start_date backup_type
1 2012-04-30 18:28:43.000 Full
2 2012-04-30…

Read more

4 comments, 5,829 reads

Posted in James' SQL Footprint on 30 April 2012

There is awesomeness to be had at #SQLRally

Two days of precons.
60 regular sessions over two days.
The now-famous Women in Technology luncheon.
Open access to Microsoft Customer Service and Support engineers and the SQL Server Customer Advisory Team.

And you’re not GOING? Are you SERIOUS?!?  Do you have any idea how easy it is… Read more

0 comments, 1,473 reads

Posted in SQL Awesomesauce on 30 April 2012

Give A Round of Applause for Microsoft System Center!

I hope you’ve taken a few minutes to peek in on the nice refresh that’s happened on a bunch of the System Center engineering blogs.  Good things are afoot there.  And if you haven’t checked in, avail yourself of these great resources:

System Center: Service Manager

System Center: Operations Manager Read more

1 comments, 1,535 reads

Posted in Kevin E. Kline on 30 April 2012

You need to run DBCC CheckDB regularly

You never know when you’ll encounter corruption. It can happen at any time, usually due to some sort of hardware problem or driver issue. Corruptions don’t disappear and you can’t necessarily

Corruptions can be caused by numerous factors, and it isn’t something you can predict. However sooner or later,… Read more

0 comments, 3,279 reads

Posted in The Voice of the DBA on 30 April 2012

SSAS File System Error

I received this error the other day when trying to process a particular SSAS cube:

Error      18           File system error: The following file is corrupted: Physical file: file:///\\%3f\E:\SQL\OLAP\Data\Options”>\\?\E:\SQL\OLAP\Data\Options BI QA.0.db\Dim Date.0.dim\1.Year No.bstore. Logical file .                                0              0

I also could not process or browse any cubes at all, even cubes… Read more

7 comments, 2,856 reads

Posted in James Serra's Blog on 30 April 2012

SQL Server 2008 Diagnostic Information Queries (May 2012)

Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic Information Queries. This version works on SQL Server 2008 and SQL Server 2008 R2. There are a few queries that only work with SQL Server 2008 R2 SP1, but… Read more

10 comments, 1,906 reads

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

Blogging Tools: BlogDesk Review

As a blogger, you have several options available to you when it comes to writing posts.  You can write them online, directly inside whatever platform you’re using, be it WordPress, Blogger, TypePad, etc.  If you prefer to write posts offline, you can use a text editor like Word or WordPad… Read more

0 comments, 2,095 reads

Posted in Cleveland DBA on 30 April 2012

Changing DB_CHAIN Can Clear the Plan Cache

If you make changes to the settings of a database, it can cause the procedure cache to be cleared. Microsoft has documented changes that cause this for all procs within a database (scroll down to just above the examples). But guess what, if you change the DB_CHAINING option, it clears… Read more

0 comments, 1,721 reads

Posted in The Scary DBA on 30 April 2012

SQL Server 2012: Biggest Little Core-house

You sure do got a 'purty motherboard...

Now that SQL Server 2012 is generally available to the public, many companies are looking at the new platform and trying to figure out how to move to it and take advantage of all the new cool features. Unfortunately, some folks haven’t… Read more

7 comments, 2,906 reads

Posted in SQL Chicken on 30 April 2012

Locked out of SQL Server.

This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql server.

I have a SQL Server instance with the sa account disabled and all other logins removed to simulate a situation were I am locked out of SQL Server. My… Read more

3 comments, 2,462 reads

Posted in Ctrl-alt-geek on 30 April 2012

SQL Server – Four-part object names

Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion if objects with similar names exists in different schemas. Some features requires that two-part naming must be used such as creating a view WITH SCHEMABINDING.

However, you can also… Read more

0 comments, 3,075 reads

Posted in SQL and Me on 30 April 2012

SQL Saturday 130 Deck & Scripts Live

Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville.  This is just a quick post to say that the slide Deck & Scripts are now up and on the Resource Page, I'll follow this up next week with a longer post reviewing the event.  Click Here for the Resource…

Read more

0 comments, 1,139 reads

Posted in SQLBalls on 28 April 2012

Always use Configuration Manager for changing service account

When your service account is expired/disabled or is not having access than sql service could not able to start and you may get an error an en eventvwr as

“Could not open error log file ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG’. Operating system error = 5(Access is denied.).

so you just change… Read more

0 comments, 1,742 reads

Posted in Vinay Thakur on 28 April 2012

Exposing OData Endpoints using the ASP.Net MVC Web API

The new Web API that comes with ASP.Net MVC 4 has been getting a lot of posts on creating RESTful services, however one thing that I’ve not seen mentioned a great deal is it’s ability to expose OData endpoints.

It almost makes it too easy, rather than talk about it… Read more

0 comments, 56 reads

Posted in Gavin Draper's SQL Server Blog on 28 April 2012

SSIS Data Flow Tuning

During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.

When a source is pulling in data, it places them into buffers; one row=one buffer.  The default setting for DefaultBufferMaxRows=10,000.  This means that the source will… Read more

0 comments, 2,765 reads

Posted in SQLRunner on 27 April 2012

SQL Saturday Houston #107 Recap

I enjoyed a long weekend in Houston starting with Kalen Delaney’s Pre-con on Query Tuning. I have learned over the past years that I should concentrate on 2 or 3 items to take from the training. The first was no matter what kind of T-SQL development is done through an… Read more

2 comments, 1,606 reads

Posted in The Smiling DBA on 27 April 2012

Cool Data Visualization

I attended a course from Edward Tufte a few years ago on Data Visualization, and while I learned some neat things, I never was able to implement them well. I think part of it is a complete lack of an art gene in my person, but I do keep it… Read more

0 comments, 1,980 reads

Posted in The Voice of the DBA on 27 April 2012

Appending New Rows Only

I saw a question in the forums related to inserting new rows into a SQL Server table only if they didn’t exist. The current solution was using an ADO.NET DataTable , checking for new rows and then pushing the rows back to SQL Server by calling the Update method on… Read more

2 comments, 5,002 reads

Posted in Chad Miller on 27 April 2012

Older posts