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

Coffee and SQL

I’m Carla Abanes, working as a full time Senior SQL Database Administrator here in Singapore for an established financial trading firm.

Archives: July 2013

Amazon Partners With Cloud vLab To Teach Developers How To Use AWS

Reblogged from TechCrunch: Nobody has ever accused Amazon Web Services of hiding its complexities. It seems even Amazon acknowledges that getting started with its ever-expanding cloud services platform isn't easy. For a while now, Amazon has offered a number of instructor-led classes, but today the company also announced that it…

Read more

0 comments, 1,136 reads

Posted in Coffee and SQL on 31 July 2013

Using MSX and TSX to scale out your maintenance plans

For our front office alone, I manage about 15-20 SQL database servers.  Add to that other database servers that I coordinate with other sister companies under umbrella company, I say, total development database servers would run up to total of 25-30 servers. You would ask, how do I manage the…

Read more

3 comments, 1,118 reads

Posted in Coffee and SQL on 30 July 2013

How secure is your IT career? Really?

I was reading some articles from my favorite influencers in LinkedIn and I came across this one. I was enlightened actually so I wanted to share it here in my blog site. It made me rethink and evaluate my career plans and where I want it to be in 5…

Read more

1 comments, 1,026 reads

Posted in Coffee and SQL on 30 July 2013

SQL Server Management Studio Rainbow Edition

Reblogged from The SQL Pro: Ever wanted to know the reason behind the Database color scheme in SQL Server Management Studio? I have always wondered why all the Databases in management studio were Yellow (Online), Grey (Read-Only), Lighter Yellow with text next to it (something like Restoring), or Yellow with…

Read more

0 comments, 620 reads

Posted in Coffee and SQL on 29 July 2013

What I’m sayin’ is…everything is fine.

Let’s say you are a member of the development team. Your team got a new project in the works, so everyone’s excited and and prepping for design and coordinating with other team via lots of project and update meetings for the last few weeks. Everything about the project requirement is…

Read more

0 comments, 590 reads

Posted in Coffee and SQL on 29 July 2013

Free Ebooks! Free Ebooks!

There’s a lot to smile on a cool Monday like this. One, it’s 27C outside here in Singapore, a lot less humid than most days. Two, a smiling barista in Starbucks served my coffee this morning, she must’ve a great morning start too and three, free ebooks from the Red-Gate…

Read more

2 comments, 645 reads

Posted in Coffee and SQL on 29 July 2013

Go ahead. Laugh.

I came across one of my twitter friends @DBAReactions tumblr site and gosh! I cannot stop laughing! Here is one link that is so true, http://dbareactions.tumblr.com/post/47021713946/after-the-san-admin-says-wow-you-were-right. Tell me you haven’t had any issues with the SAN team in your organization. I had. When they gave me a disk on RAID…

Read more

2 comments, 489 reads

Posted in Coffee and SQL on 27 July 2013

70-457 Reviewer #07, Resolving Concurrency Problems in SQL Server 2012

This topic is part of the lessons covered in Optimization and Troubleshooting SQL Server 2012 which is 14% of overall scoring in the exam. For this article, I will cover the following subtopics; Resolving Concurrency Problems Blocks and Deadlocks Identifying Issues Resolving Issues Resolving Concurrency Problems Many factors can affect…

Read more

0 comments, 1,732 reads

Posted in Coffee and SQL on 25 July 2013

Understanding Contained Database in SQL Server 2012

SQL Server 2012 supports contained databases and partially contained databases, which provide a high degree of isolation from the database engine instance but are not fully contained. The contained database becomes highly portable that you can migrate it to any instance or even in SQL Azure. In SQL Server 2012,…

Read more

0 comments, 1,068 reads

Posted in Coffee and SQL on 24 July 2013

70-457 Reviewer #06, Configuring and Managing Database in SQL Server 2012

DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have direct impact on users and applications. This lesson, which is still part of Configuring SQL Server 2012 Components, covers the following topics; Designing and Managing Filegroups Configuring and Standardizing Database…

Read more

0 comments, 608 reads

Posted in Coffee and SQL on 24 July 2013

70-457 Reviewer #05, Configuring SQL Server 2012 Components

The lessons covered for this review is Configure Analysis Services Configure and Deploy Reporting Services Configure and Deploy Sharepoint Integration Configure Integration Services security Managing Full-Text Indexing Configure Filestream and Filetable Configure Analysis Services You have 2 options when configuring analysis services: multidimensional or tabular mode and data mining mode.…

Read more

2 comments, 536 reads

Posted in Coffee and SQL on 22 July 2013

Rebuilding server level collation setting

Scenario You have just completed setting up a new development database server for a new project. After that, everyone in the team now starts working on implementing their design and starts to create their objects. When the time came for them to start adding test data, Chinese characters cannot be…

Read more

0 comments, 1,788 reads

Posted in Coffee and SQL on 19 July 2013

70-457 Reviewer #04, Implement a Migration Strategy

Upgrading an instance is a process in which you upgrade an existing instance of SQL Server to SQL Server 2012. Before proceeding to implement a migration strategy, you will need to ask yourself the following and evaluate From which edition do you need to upgrade or migrate? Your current SQL…

Read more

0 comments, 551 reads

Posted in Coffee and SQL on 18 July 2013

70-457 Reviewer #03, Planning an Installation of SQL Server 2012

Planning an installation on SQL Server 2012 is under the Install and Configure SQL Server objective which is 19% of the total examination for 70-457. I will be writing all the important things to consider planning an installation for SQL Server 2012 in a nugget form to serve as a…

Read more

0 comments, 590 reads

Posted in Coffee and SQL on 16 July 2013

Check unused index in SQL Sever 2008

Checking for unused indices across your database should also be a part of housekeeping. Usually i would schedule checking for unused indices on quarterly basis. Just to minimize surprises on a database suddenly timing out. The DMV for checking on usage and statistics is sys.dm_db_index_usage_stats. Here’s a script that i…

Read more

0 comments, 308 reads

Posted in Coffee and SQL on 15 July 2013

What’s yours?

I always have mine black coffee to go. What’s yours?

Read more

0 comments, 255 reads

Posted in Coffee and SQL on 14 July 2013

MSSQLTIPS SQL Server Webcast

MSSQLTIPS offers new webcast monthly. Topics in various areas of SQL Server are covered and perfect for all DBAs out there seeking to learn more.  Visit http://www.mssqltips.com/webcastlist.asp to see all available webcast. Archive list goes as far back as 2007 when SQL Server 2008 came out. If you are using…

Read more

0 comments, 338 reads

Posted in Coffee and SQL on 12 July 2013

SQL Server Diagnostic Information Queries for July 2013

Reblogged from Glenn Berry's SQL Server Performance: I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. Rather than having a separate blog post for each version, I’ll just put the links for all four versions…

Read more

0 comments, 305 reads

Posted in Coffee and SQL on 11 July 2013

Access denied on your SSIS SQL Server 2008

Scenario. You have a new SSIS server. All DTS packages migrated and deployed successfully to this new SSIS server. You send email notifications to the development team of the new server and that they can all continue to work on this new SSIS server now. All of them reply back…

Read more

3 comments, 309 reads

Posted in Coffee and SQL on 11 July 2013

70-457 Reviewer #02, What is Columnstore Index?

Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index geared toward increasing query performance involving large result sets, ideally in fact tables for OLAP query. This type of index is based on Vertipaq engine acquisition. Columnstore indexes in the…

Read more

1 comments, 769 reads

Posted in Coffee and SQL on 10 July 2013

Older posts