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

Archives: September 2013

MidnightSQL Server Evaluation script, version 1.0

Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on a server when I first start a project, and uncover the big potential issues. So, I started developing a set of scripts to help me gather and summarize that information…

Read more

3 comments, 1,224 reads

Posted in SQL Awesomesauce on 30 September 2013

SQL Server :Part 1 : Architecture of Transaction Log

In our earlier post, we have discussed in detail about the architecture of the data file and different types of pages. In this post, we will be discussing about the architecture of log file.

Logging is a mechanism used in RDBMS to support various ACID (Atomicity,Consistency,Isolation and Durability) properties of transactions. A transaction…

Read more

211 comments, 9,817 reads

Posted in PracticalSQLDba on 30 September 2013

SQL Saturday #190 Denver Wrap Up

I must admit… Denver is my favorite town in this country. The outdoor things to do, the wide variety of locals and transplants, and the thin air all are favorable to me. I’m looking to move here someday soon. With that said, this year’s SQL Saturday #190 in Denver was… Read more

0 comments, 1,244 reads

Posted in Technobabble by Klee from @kleegeek on 30 September 2013

Last Weeks Top “Reading” Links #51

Monday morning and it’s time for weekly round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  While these links aren’t the answer to life, the universe, and everything, they do share a few… Read more

0 comments, 1,463 reads

Posted in StrateSQL on 30 September 2013

An Experiment Concludes

That was hard work

You may or may not have noticed, but every single week day for the month of September, I’ve put up a blog post. Some were short little blurbs linking to some other person’s blog or an article that I decided to comment on. Some were the… Read more

9 comments, 1,576 reads

Posted in The Scary DBA on 30 September 2013

Cumulative Update – 6 for SQL Server 2012 Service Pack 1 Is Now Available !

The 6th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 6 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can plan to test CU6 in test environment… Read more

0 comments, 1,172 reads

Posted in MSSQLFUN on 30 September 2013

The MERGE statement doesn’t have a WHERE clause.

What the heck? Even indexes have WHERE clauses these days. I can’t remember what I was reading when I saw this but it completely flabbergasted me. If you go look at MERGE in BOL you will see what I mean. So does this mean you can’t restrict data in a… Read more

5 comments, 1,326 reads

Posted in SQLStudies on 30 September 2013

MDX YTD Calculation Issus

If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues. In the image below you can see the calculation is working for all years except for 2008.

My first thought was data issue. After querying the table and finding no…

Read more

0 comments, 1,215 reads

Posted in Mike Davis SQL on 30 September 2013

Speaking Twice on Oct 1, 2013

Carolina Technology Conference:

To start things off, I'll be speaking in the morning at the Carolina Technology Conference. I have a 40 minute slot from 10:05 - 10:45 AM Eastern. I'm shooting for a 30-35 minute presentation with 5-10 minutes of questions. Here's the information on the talk:

  Read more

0 comments, 2,781 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 September 2013

Disaster Recovery and Business Continuity

Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work.  I just started my job two weeks ago and made a list of questions to go through with them. After asking the one about when they last pulled an offsite… Read more

4 comments, 2,105 reads

Posted in Simple SQL Server on 30 September 2013

SQL Server Statistics


Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table. They represent the table in the sense that optimizer refers to the statistics to generate a plan rather than scanning the whole table for plan generation. These stats are… Read more

6 comments, 3,083 reads

Posted in SQL Toast on 29 September 2013

MDX+SSRS #31– Query Designer in SSRS only allows the Measures dimension in the first axis

In Chapter 1 of the book MDX with SSAS 2012 Cookbook, in the first recipe “Putting data on x and y axes”, I have given a simple example to show how easy it is to use the CROSSJOIN function to "combine" more than one hierarchy into the COLUMNS and… Read more

0 comments, 4,082 reads

Posted in Sherry Li's BI Corner on 28 September 2013

Strategizing your Index Maintenance in SQL Server

Index maintenance is part of the DBA’s life. Surely you have a maintenance task for this somewhere running daily or weekly on your server. For the junior DBA, the rebuilding of indexes task will include a scheduled job that will … Continue reading

Read more

0 comments, 1,220 reads

Posted in Coffee and SQL on 28 September 2013

Do you want me to tell you the truth or do you want me to tell you what you want to hear?

We live in a Dilbert age.

If you are a DBA and have worked in organizations of any size you are guaranteed to have seen things that are so insane they just simply can not be made up.

However, despite the occasional apparent triumphs over reality by PHBs that we… Read more

0 comments, 1,685 reads

Posted in @chuckboycejr on 28 September 2013

Houston Tech Fest 2013 - SQL Admin Best Practices with DMV's

Here is the downloadable file with all my sample scripts and slidedeck from my SQL Admin Best Practices with DMV's presentation from the 2000+ person Houston Tech Fest 2013 at the Reliant Center in Houston!

Thanks for attending! If you attended my talk, shoot me some feedback here: http://speakerrate.com/william.assaf

Read more

0 comments, 1,023 reads

Posted in SQL Tact on 28 September 2013

Interviews with Great SQL People – Authors, MVPs, many more

I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work keeps happening. Pfft. If you didn’t know, we interview great folk at #sqlpass: @ItzikBenGan, @SQLRunr, @brianknight, @billramo, @GFritchey & more in 2009… Interviewed @mrdenny, @sirsql, @gfritchey, @way0utwest, @mark_AzureCAT at #sqlpass…

Read more

0 comments, 1,245 reads

Posted in SQL Awesomesauce on 27 September 2013

Reblog: September 20 to September 26

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question.  It’s that whole “cha-ching” – buried treasure! feeling.  That’s kind of the aim of this blog post.  To provide… Read more

0 comments, 1,303 reads

Posted in StrateSQL on 27 September 2013

Azure Offerings Continue to Expand

We just received word of a bunch of new functionality over at Scott Guthrie’s blog. Not a lot of stuff for data pro’s… unless you work with Oracle. Yeah, you can now create Oracle VMs. See the image below:


I swear, I can’t tell you why this gives… Read more

0 comments, 1,299 reads

Posted in The Scary DBA on 27 September 2013

Understanding Microsoft Self-Service BI Recording and Q&A

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013.  If you weren’t you can now download the recording here.

Because I covered new material all the way to the end of the webinar i thought I’d also answer some… Read more

0 comments, 1,321 reads

Posted in Devin Knight on 26 September 2013

Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload

Last Monday, I presented a session for Pragmatic Works Training on the T’s on the Microsoft’s Parallel Data Warehouse.  In the session, titled Recognizing the Parallel Data Warehouse (PDW) Workload, I discussed the role for MPP and PDW in the enterprise and the types of workloads that it can… Read more

0 comments, 1,546 reads

Posted in StrateSQL on 26 September 2013

Older posts