Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: 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, 256 reads

Posted in Coffee and SQL on 28 September 2013

Poor Microsoft Doesn’t Understand What Tablets Are For

That’s the title of an article i came across this morning in Slate.com. I am not a big fan of Surface. I’m totally IOS fanatic from iPhone to iPadMini to using Mac at home. IMHO, Microsoft has been committing a … Continue reading

Read more

0 comments, 292 reads

Posted in Coffee and SQL on 24 September 2013

Cumulative update package 6 for SQL Server 2012 SP1

Microsoft has release the CU update package 6 for SQL Server 2012 SP1. To apply this package in your environment, you must be running SQL Server 2012 SP1. This cumulative update includes about 20 fixes dealing mostly with MDX queries and SSAS cubes. For more information on the updates included…

Read more

0 comments, 458 reads

Posted in Coffee and SQL on 23 September 2013

Brad Shultz's blog on reviewing your database

Reblogged from SQL Studies: This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, insightful, and mentions a number of very common problems. The descriptions of each problem are well written and easy to understand. There are multiple scripts and…

Read more

0 comments, 238 reads

Posted in Coffee and SQL on 18 September 2013

CIO Report; 14 things you need to know about Data Storage Management

Reblogged from Imtech ICT UK Blog:   Original Article: CIO recently published a detailed article on the 14 things you need to know about Data Storage Management.   What would you add to the list? - comment below. Click the link above for the original article. 1. Know your data. 2. Don't…

Read more

0 comments, 218 reads

Posted in Coffee and SQL on 18 September 2013

Debugging database mail issues in your SQL Server with T-SQL

Problem. Your database mail suddenly stopped sending out email notifications on completed jobs and tasks. You try to send out an email test message from your SSMS and nothing is sent out. Solution. One thing that could cause this issue is when your database mail suddenly hangs or stops in…

Read more

0 comments, 318 reads

Posted in Coffee and SQL on 17 September 2013

Certifications: What are they good for?

Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion about the program and certifications in general. Thomas LaRock even suggested Rebooting the MCM Program Using an RV and an Endless Supply of Chicken Wings. Which I have to say…

Read more

0 comments, 180 reads

Posted in Coffee and SQL on 16 September 2013

SQL SERVER 2012 - How to get a value from previous result row effectively

Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row result in the current row for comparison purposes.  Fortunately, we do have a solution for this problem using self join. But I will share another efficient solution with you using…

Read more

0 comments, 248 reads

Posted in Coffee and SQL on 16 September 2013

10 signs you're not talking to a developer

Reblogged from the pluralsight blog: There are many types of developers out there. And while not all speak the same languages, have the same background, or even agree on the best possible way to do something, there is one thing they come together on: being a developer. There are just…

Read more

0 comments, 252 reads

Posted in Coffee and SQL on 16 September 2013

70-457 Reviewer #12, Restoring SQL Server Databases

This lesson is the third and last part of topic for Managing Data which covers 20% of the certification exam. Restore options depends on the database recovery model and the backup set that you do have. The following rules apply; Full backups only – If you have the latest backup…

Read more

0 comments, 196 reads

Posted in Coffee and SQL on 8 September 2013

70-457 Reviewer #11 Configuring and Maintaining a Backup Strategy

This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL Server 2012 supports the following backup types. Full database backups – this type of backup includes all database objects, system tables and data. Transactions that occur during the backup are…

Read more

0 comments, 207 reads

Posted in Coffee and SQL on 1 September 2013