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.

Moving your FTData files and FDLAUNCHERRORLOG in Clustered SQL Server 2008

Scenario: I have given a new storage by SAN team to move my database files and logs from old drive to the new storage. All database files and logs files have been successfully migrated to the new storage. But how … Continue reading

Read more

0 comments, 218 reads

Posted in Coffee and SQL on 13 November 2013

Troubleshooting Database Mirroring Configuration

From my last post, http://coffeeandsql.com/2013/11/10/70-457-reviewer-15-implement-database-mirroring/, you were able to successfully setup a database mirroring. For further monitoring and checking if everything is OK, you may use the following T–SQL statements. To check the principal id the database mirroring is using; … Continue reading

Read more

0 comments, 428 reads

Posted in Coffee and SQL on 11 November 2013

70-457 Reviewer #15 Implement Database Mirroring

This reviewer is part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of the certification exam. Database mirroring is a process of creating and maintaining an always up-to-date copy of your database on another … Continue reading

Read more

1 comments, 235 reads

Posted in Coffee and SQL on 10 November 2013

70-457 Reviewer #14 Database and Application Roles

This lesson is part two of lesson Reviewer #13 Managing SQL Server Logins. There is so much to cover about securing SQL that i decided to cover the entire lesson in parts. From the first lesson we covered mainly logins … Continue reading

Read more

0 comments, 204 reads

Posted in Coffee and SQL on 10 November 2013

70-457 Reviewer #13 Managing SQL Server Logins

This lesson covers managing security principals at the instance level. Security principals at this level allows access to the instance and serve as gateway that allow access to database hosted on the instance. This part of the lesson covers 18% … Continue reading

Read more

2 comments, 218 reads

Posted in Coffee and SQL on 10 November 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, 327 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, 356 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, 591 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, 281 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, 264 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, 397 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, 230 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, 285 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, 317 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, 240 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, 252 reads

Posted in Coffee and SQL on 1 September 2013

70-457 Reviewer #10 Managing SQL Server Agent

This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables you to execute scheduled or event-driven administrative jobs, automating processes you would otherwise have to execute manually. Each SQL Server instance you setup has a separate SQL Server Agent. During…

Read more

0 comments, 280 reads

Posted in Coffee and SQL on 31 August 2013

Using DMV to identify sessions in your SQL Server

More than running sp_who2, which gives you more information than the good ol’ sp_who, or querying sys.dm_exec_sessions to check all sessions running in your SQL Server, you need be able to flag to suspicious or questionable sessions thats running transactions in your server. You need to identify which session has…

Read more

0 comments, 360 reads

Posted in Coffee and SQL on 24 August 2013

Who’s doing what to your SQL Server?

When doing any kind of troubleshooting in your SQL Server first thing you ask is who is currently connected to the SQL Server having problem and what the heck is going on? First thing you do? Run sp_who2. That will simply tell you about the sessions currently on in your…

Read more

0 comments, 323 reads

Posted in Coffee and SQL on 24 August 2013

Get the Backup History in your Central Management Server for SQL Server

I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me in my everyday database administration tasks. I want to share with you guys my CMS setup as below. So for across all these servers, and everytime I need to setup…

Read more

0 comments, 320 reads

Posted in Coffee and SQL on 14 August 2013

Newer posts

Older posts