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

Archives: December 2012

Compress Dynamic Files Using 7-Zip in SSIS


This blog post is in response to a request/comment from Thato in this previous article. Hence, I have taken much of the logic used in the aforementioned article and changed it from static to dynamic file compression. Thus, I am still using SQL Server Integration Services‘s Execute… Read more

5 comments, 447 reads

Posted in on 30 December 2012

Test Hadoop cluster on vmware

SQL Server MVP Jeremiah Peschka posted 2 articles about Hadoop, which makes me be interested on the nosql skill.

I don't have much knowledge on Nosql and Linux system, so I am going to setup a testing environment on my laptop in holidays

1. download CentOS Linux setup iso file

2. download java jdk 1.6

Read more

25 comments, 2,583 reads

Posted in James' SQL Footprint on 29 December 2012

TempDB Destroyer

One of my previous posts, I covered how to create a really big database with just garbage data in it. Recently, I was given a task to blow up tempdb. I thought about using a similar script and tried it out. Of course it worked and it blew up…

Read more

0 comments, 1,042 reads

Posted in SQL Sandwiches on 29 December 2012

SQL Server 2012 Standard Edition Licensing Limits

As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be adjusted in light of the capabilities of modern, commodity server hardware.

As a DBA and consultant, I would like to see everyone running SQL Server 2012 Enterprise Edition. It has… Read more

10 comments, 6,976 reads

Posted in Glenn Berry's SQL Server Performance on 29 December 2012

SQL Server 2012 Diagnostic Information Queries (Dec 2012)

Here is the December 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. There is also one new query at the very end, adapted from my colleague, Erin Stellato.

To go with it is…

Read more

0 comments, 937 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2012

Reblog: December 21 to December 27

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 1,024 reads

Posted in StrateSQL on 28 December 2012

PASSMN Presentation Materials

Last week, I presented on extended events at the Minnesota SQL Server user group (PASSMN).  The turnout was quite excellent and I expect at least a few people will be interested in the materials that were presented.

So… here they are Extended Events - Work Smarter, Not Harder -… Read more

0 comments, 696 reads

Posted in StrateSQL on 28 December 2012

Index Analysis Post Christmas Update

Last week I mentioned that I had put up a few new versions of my index analysis script.  Turns out a few people downloaded it and found some issues.  I also have been playing with it some more and noticed some quirks that were a bit irritating to me, so… Read more

0 comments, 665 reads

Posted in StrateSQL on 28 December 2012

My RSS Reader…The Great Clean Up

If you blog and call yourself a blogger then you probably have a pretty full RSS reader. Mine has been added to considerably over the years. Well I signed into my Google reader account today and I realised that there is a lot of blogs that either I don’t read… Read more

0 comments, 867 reads

Posted in The SQL DBA in the UK on 28 December 2012

SQL Server Cumulative Update

Microsoft today announced the latest round of SQL Server Cumulative Updates

SQL Server 2012 CU 5 – You can get more information here

SQL Server 2008 SP2 CU 4 – You can get more information here

SQL Server 2008 SP1 CU10 – You can get more information here

This might… Read more

0 comments, 758 reads

Posted in The SQL DBA in the UK on 28 December 2012

Closing the Results Window in SSMS

This is a guest post by David Postlethwaite.

I’ve been wondering how to do this for years. At SQL Bits and SQL Saturday the presenters make the results window disappear with a keyboard click but I could never work it out.

Well today I was working on a query and…

Read more

0 comments, 935 reads

Posted in The SQL DBA in the UK on 28 December 2012

It’s Another 24 Hours of PASS

With the upcoming PASS Business Analytics Conference, it only makes sense for there to be a 24 Hours of PASS to go a long with it.  And have no fear, that is what is coming your way on January 30, 2013.

In a bit of a departure from previous… Read more

0 comments, 1,065 reads

Posted in StrateSQL on 27 December 2012

I Pulled a Forest Gump

Last Friday I went for a quick run before we packed up and headed to Steamboat Springs for a week’s vacation skiing with the family. Saturday I snowboarded, came back to the condo, found no treadmill, slippery, icy conditions on the roads, and just stopped running.

No fanfare, no complaints,… Read more

2 comments, 1,690 reads

Posted in The Voice of the DBA on 27 December 2012

PASS Summit 2012 session videos online

If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash drive or view them online.  You can purchase the Regular Summit Sessions as well as the Pre-Conference Sessions.  However, if you are interested in the sessions from 2011… Read more

0 comments, 1,865 reads

Posted in James Serra's Blog on 27 December 2012

Predictions for 2013

I’m on holiday, but I have a set of predictions for 2013 coming on Jan 1. This is a little notice in hopes that a few of you might join in to the meme and make a few predictions for 2013.

Database related, technology related, car related, write a few… Read more

2 comments, 901 reads

Posted in The Voice of the DBA on 27 December 2012

Big Data: An Introduction with Hive

Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL. At the same…

Read more

2 comments, 364 reads

Posted in SQL & BI on 26 December 2012

NULL Values Impact the Performance of MAX() and MIN()

We know that we need to take special attention about NULL values while writing queries because they may lead us into writing incorrect query logics. NULLs may also affect the performance of aggregation function MAX() and MIN(). I have submitted this issue to Microsoft Connect. There are number of… Read more

3 comments, 1,640 reads

Posted in John Huang’s Blog on 26 December 2012

Querying the Procedural Cache: Just in Time for the New Years’

I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for peace, happiness and health for 2013.

The goal of this post is to aid in the understanding of the procedure cache and execution plans to ensure we use fewer resources,… Read more

0 comments, 1,392 reads

Posted in The Database Hive for SQL Server DBAs on 26 December 2012

FOR XML Clause

FOR XML CLAUSE:  Sometimes we need to data in form of XML from Database.SQL Server provide FOR XML Clause. For XML clause returns result of query as XML.There are some options with FOR XML clause
  • Raw
  • Path
·         Auto
  • Elements(can be used with raw,auto,path)
  • Explicit

You will find…

Read more

0 comments, 671 reads

Posted in Querying Microsoft SQL Server on 26 December 2012

Big Data - An Introduction to Pig

In my previous article, I have explained Big Data and Hadoop in details. In this article I would like to go little deeper with Pig. Pig is a high-level platform for creating Map Reduce programs used with Hadoop. Pig is made up of two components: the first is the…

Read more

0 comments, 391 reads

Posted in SQL & BI on 25 December 2012

Newer posts

Older posts