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: August 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, 1,021 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, 738 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, 624 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, 646 reads

Posted in Coffee and SQL on 14 August 2013

70-457 Reviewer #09, Auditing SQL Server 2012

This review topic is still covered under the Optimize and Troubleshoot SQL Server lesson which covers 14% of the exam. Auditing gives us, the DBA, the means to see who’s doing what and where they’re doing whatever on our SQL Servers. Auditing will enable you to track any activity on…

Read more

0 comments, 555 reads

Posted in Coffee and SQL on 13 August 2013

Deploying your SSIS Packages in SQL Server 2008

Prior to building and deploying your SSIS project to the SQL SSIS server, you need to build and create a deployment utility file in your machine. You may also create a configuration file that updates the properties of the package elements during runtime. This step is optional and configuration properties…

Read more

0 comments, 809 reads

Posted in Coffee and SQL on 2 August 2013

70-457 Reviewer #08, Implementing Clustered Instance in SQL Server 2012

This part of the review is still a part of the topic Maintain Instances and Databases which accounts for 17% of the examination. The objective here may include, installing a cluster, manage multiple instances on a cluster, setup a subnet clustering and recover from a failed over cluster node. AlwaysOn…

Read more

4 comments, 585 reads

Posted in Coffee and SQL on 1 August 2013