Archive for SQL

Apr
27

Developers Converge on the Canadian Prairie and Edwin is there with them

by amy

Post to Twitter Post to Facebook Post to StumbleUpon

Third Tier’s Edwin Sarmiento is taking to the Prairie at the Prairie Dev Con 2011 in Regina, Saskatchewan Canada, June 13th and 14th. http://prairiedevcon.com/index.aspx  He’s presenting two sessions, the details of which are below. One of which is deadlock demos. Sound scary? Learn how to over come and be sure to say Hello to Edwin.

Developers, Know Thy SQL Server Indexes

Indexes allow SQL Server to access your data in the most efficient manner. As a developer, understanding how SQL Server indexes work under-the-hood will give you insights on how to design effective indexing strategies.
In this session, you will learn what indexes are, how they work, basic indexing strategies and how query performance is affected by indexes.

SQL Server Execution Plans for Developers

Data-driven applications are mostly created without scalability and performance in mind. As the data grows, performance issues arise. In this session, you will learn how SQL Server execution plans can be used to identify problems with the database design or the TSQL code, and address those problems giving you a guidance on how to effectively improve your query performance.

__________

So who wrote this blog and what do they do for a living anyway?
We’re Third Tier. We provide advanced Third Tier support for IT Professionals like you.

www.thirdtier.net/support

0 Categories : Edwin Sarmiento, SQL
Apr
21

Edwin presents Windows PowerShell for the SQL Server DBA

by amy

Post to Twitter Post to Facebook Post to StumbleUpon

Third Tier’s SQL expert Edwin Sarmiento is a sought after speaker on SQL. In May he’s going to be presenting, Windows PowerShell for the SQL Server DBA and Self-Service Analytics ofn SQL Server 2008 R2 at DevTeach in Montreal – May 30th – June 3rd.

http://www.devteach.com

Edwin is presenting a really great session on Powershell for SQL admins. SQL admins are all familiar with scripting but if you haven’t included Powershell in your toolkit yet, then it’s time to learn how. If you’re attending this conference, then let Edwin help you get started down the Powershell path.

Windows PowerShell for the SQL Server DBA

Windows PowerShell is becoming the scripting language of choice for managing Microsoft servers and workstations. And while T-SQL is still the scripting language for DBAs to administer and manage SQL Server, there are tons of stuff that can be easily done with Windows PowerShell. In this session, learn Windows PowerShell from the ground up and how you can use it with SQL Server Management Objects (SMO) to administer and manage a SQL Server instance.

Self-Service Analytics on SQL Server 2008 R2

We have to admit that Excel is the most popular data visualization tool there is. In this session, we’ll look at using Excel to gather data, cleanse and model that data, and then use it as a source for pivot-table and pivot-chart analysis – all in the context of self-service analytics in SQL Server 2008 R2. We’ll also look at some of the new analysis features available in Excel 2010, including slicers, improved charting, and improved pivot-table functionality

__________

So who wrote this blog and what do they do for a living anyway?
We’re Third Tier. We provide advanced Third Tier support for IT Professionals like you.

www.thirdtier.net/support

0 Categories : Edwin Sarmiento, Powershell, SQL
Apr
18

See Edwin at Pass SQL Rally in Orlando

by amy

Post to Twitter Post to Facebook Post to StumbleUpon

Third Tier’s Edwin Sarmiento is speaking at PASS in Orlando May 11-13th. If you’re looking for a great SQL event, this is the one. Better sign up now. http://www.sqlpass.org/sqlrally/2011/orlando/

While you’re there be sure to catch Edwin’s session:

Title:
DBA Disaster Recovery Techniques To Keep Handy

Speaker:
Edwin Sarmiento

Category:
HA/DR

Level:
400

Abstract:
Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it’s a mission critical one. This session will focus on being prepared for and dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery

Session Goals

  • Understand how disaster recovery strategies should meet the recovery point objective/recovery time objective
  • Be familiar with different recovery strategies based on the selected backup strategies
  • Understand the need for testing disaster recovery strategies on a regular basis

Speaker Bio:
Edwin Sarmiento works as a SQL Server DBA for The Pythian Group in Ottawa, ON in Canada. Prior to joining Pythian, he was a senior systems engineer/DBA for Fujitsu Asia Pte Ltd in Singapore and is responsible for maintaining 200+ servers and databases for a global client in 10 countries. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement: "To help people grow and develop their full potential as God has planned for them" He wants the whole world to know that Filipinos are world-class citizens and bring Jesus Christ to the world.

__________

So who wrote this blog and what do they do for a living anyway?
We’re Third Tier. We provide advanced Third Tier support for IT Professionals like you.

www.thirdtier.net/support

0 Categories : Edwin Sarmiento, SQL
Apr
7

Edwin On Talk TechNet this Friday!

by amy

Post to Twitter Post to Facebook Post to StumbleUpon

Got a SQL question? Our very own Edwin Sarmiento is the featured speaker this month on Talk TechNet this Friday. Talk TechNet is a fun informative talk show and you can call in your questions LIVE! Be sure to call in and say Hello and Edwin.

TechNet Webcast: Talk TechNet with Keith Combs and Matt Hester – Episode 20: Edwin Sarmiento on SQL Server DBA (Level 100)

Event ID: 1032483824

Language(s): English.

Product(s): Microsoft SQL Server 2008 R2.

Audience(s): IT Generalist.

Talk TechNet is all about discussing topics and trends in the world of IT Professionals.  In this show we’ll have guest Edwin Sarmiento. Edwin is a Microsoft SQL MVP. Call in and join us for what promises to be a lively 60 minute session.  Get some burning questions answered on SQL Server DBA tasks.
Presenters: Keith Combs, Sr. Program Manager, Microsoft Corporation, Matt Hester, Sr. IT Pro Evangelist, Microsoft Corporation, and Edwin Sarmiento, Microsoft SQL Server MVP, Microsoft SQL Server MVP

You can register here:

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032483824&EventCategory=4&culture=en-US&CountryCode=US

0 Categories : Edwin Sarmiento, SQL
Mar
24

SBS 2008 Monitoring Database Fills to Capacity

by amy

Post to Twitter Post to Facebook Post to StumbleUpon

One of the differences between SBS 2003 and SBS 2008 is how the monitoring database is handled. In SBS 2003 the database did not have a size limitation and was able to grow as large as required. In SBS 2008, this is no longer the case. SQL Express has a 4GB limit and the other day one of my clients hit it.

So how do you know when your SBS Monitoring database is full? You’ll get this error in the Application Log:

Log Name:      Application
Source:        MSSQL$SBSMONITORING
Date:          3/19/2010 7:36:29 AM
Event ID:      1827
Task Category: (2)
Level:         Error
Keywords:      Classic
User:          SYSTEM
Computer:      SBS2008.domain.local
Description:
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

It’s pretty clear from the message what the problem is. So what caused it and how do we fix it?

The cause is that the database is not configured to purge old data. There is a fix for this and it turns out to the same sql script that is used for an SBS problem where the Console displays too slowly. Run this script against your SBS Monitoring database and it will only hold data for the last 90 days. So if your database isn’t completely filled up yet you’ll want to run this now.

NOTE: The following instructions and script link from from the Official SBS Blog posting SBS 2008 Console May Take Too Long to Display Alerts and Security Statuses, Display Not Available, or Crash.

  • Download the following file to the server you are going to be working on:
    1. http://cid-d5fe25afb6c3615f.skydrive.live.com/self.aspx/.Public/updateSBSMonitoring.sql
    2. We recommend you save the file to an easy to access path, such as c:\windows\temp.
  • Complete a backup of the SBSMonitoring Databases
    1. Open Services from Administrative Tools, Services
    2. Accept the UAC prompt
    3. Find and stop the SQL Server (SBSMONITORING) service.
    4. Make a copy of the files in the following folder:
      1. C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data
    5. Once the file backup is completed, start the SQL Server (SBSMONITORING) service.
  • Proceed to run the following set of commands to implement the improvements
    1. Open an Administrative Command Prompt (Run As Admin)
    2. Type the following command, substitute the path to the updateSBSMonitoring.sql file as needed (We recommend that you do NOT copy & paste this command directly from the blog post):
      1. Sqlcmd -S %computername%\SBSMonitoring -E  -i c:\windows\temp\updateSBSMonitoring.sql
      2. Success will show an output like this:
        Changed database context to ‘SBSMonitoring’
        (1 rows affected)

    • If your database is completely filled up like mine was, then you need to replace it with a clean empty one. I consulted out resident SQL expert, Edwin Sarmiento, for this advice. You’ll have to get clean empty database through one of 3 methods: Open a ticket with Third Tier, open a ticket with Microsoft, or stand up an SBS 2008 server and grab it from there.

    To install your new clean database do this:

    1. Open an elevated SQL Server Management Studio Express
    2. Connect to the <servername>\SBSMonitoring database using Windows Authentication
    3. Expand Databases and right-click on SBS Monitoring
    4. Choose Tasks, then Backup
    5. Make a backup of the current database
    6. Next Choose Tasks, then Detach to detach the database from SQL
    7. Open Services.msc and stop the SQL Server (SBSMonitoring) and SQL Full Text Search (SBSMonitoring) services
    8. Open an elevated Windows Explorer and drill down to c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data and replace the SBSMonitoring and SBSMonitoring_Log files with the blank ones you obtained.
    9. Start the services that you stopped earlier
    10. Verify that you can run a report from the console

    Since you have now gone to the trouble of installing a new database, to insure that this doesn’t happen again run the above SQL script on the new database.

    —
    So who wrote this blog and what do they do for a living anyway?

    We’re Third Tier. We provide advanced Third Tier support for IT Professionals.
    Third Tier Get Support BlogFeed Blog Twitter Twitter Facebook Facebook LinkedIn LinkedIN

    8 Categories : Amy Babinchak, Edwin Sarmiento, SBS 2008, SQL

    Search

    Support

    Third Tier provides advanced support services to IT Professionals. Learn about what we do at http://www.thirdtier.net or click on the support icon below to chat with one of our support representatives.

    Third Tier
    Copyright © 2012 All Rights Reserved
    iThemes Builder by iThemes
    Powered by WordPress