Search Results

Search found 1313 results on 53 pages for 'dba in ua'.

Page 23/53 | < Previous Page | 19 20 21 22 23 24 25 26 27 28 29 30  | Next Page >

• Streamlining granular recovery for SharePoint, with Red Gate and Metalogix

  We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this: Join SQL Backup’s 35,000+ customers to compress and strengthen your…

  Read the article

• Data Everywhere - Step 3 in the Stairway to Reporting Services

  In this article, MVP Jessica Moss talks about data sources and how to connect them to your report. Learn how to add the reusable data sets and data sources for your reporting projects. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky enough to use it."…

  Read the article

• Oracle Certification on CIOs List of Tops For Career Advancement

  - by Brandye Barrington

  It's no secret that we think Oracle Certifications are some of the top in the industry. We go the extra mile ensuring their validity and value, spending countless hours scoping, developing and supporting these credentials. So although it wasn't a surprise, it was indeed an honor to see Oracle DBA Certifications listed recently in CIO.com's list of…

  Read the article

• T-SQL Quiz 2011

  The 2011 edition of MVP Jacob Sebastian's T-SQL Quiz is underway. You can take part in the quiz each day, submitting your answers for the chance to show off your knowledge and perhaps win some prizes. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky…

  Read the article

• Disk Is Cheap! ORLY?

  People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost. Solomon Rutzky talks about the issues you may face if you are not careful with your storage decisions. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL…

  Read the article

• Optimizing Transaction Log Throughput

  As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. Examples in the article, extracted from SQL Server Transaction Log Management by…

  Read the article

• Improving 2D Range Query Performance in SQL Server

  When using the BETWEEN operator on multiple columns, you are likely using a 2D range query. Such queries perform very poorly in SQL Server. This article examines rewriting these queries for improved performance. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost…

  Read the article

• How to Identify CPU Bottlenecks in SQL Server

  We experience regular slowdowns on our MS SQL database. After analyzing the memory usage we would like to continue the root cause investigation by examining CPU bottlenecks. What is your recommendation to recognize CPU related bottlenecks in SQL Server? Join SQL Backup’s 35,000+ customers to compress and strengthen…

  Read the article

• PASS Virtual Chapters Late April Presentations

  To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’.

  Read the article

• Adding Custom Reports to SQL Server Management Studio

  In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio. An accidental DBA? Try SQL MonitorUse the 30-day full product free trial to get easy-to-understand insights into SQL Server,…

  Read the article

• Getting Started with Maps in SQL Server 2008 R2 Reporting Services

  I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse? Join SQL Backup’s 35,000+ customers to compress and…

  Read the article

• 70-432 Done

  - by GavinPayneUK

  Today I took and passed my first Microsoft exam, 70-432, MCTS SQL Server 2008 DBA etc.  I’m going to be harsh on my success and say while it’s great to pass an exam someone with my level of experience should be focussing on the next harder exam rather than how great is was to pass an MCTS level exam. Having written about…

  Read the article

• How to Speed up MS SQL Reporting Services on First Run

  I set up a new instance of MS SQL Server Reporting Services, but I noticed that it starts up very slow and I have to wait for ages to access the site. I also noticed that it is always slow when it has not been used for a certain period of time. Join SQL Backup’s 35,000+ customers to compress and strengthen…

  Read the article

• SQL Bits VIII

  SQL Bits 8 will be in Brighton in the UK on April 7th-9th. There are paid full days of training as well as a free day on Saturday. Register now for the premier SQL Server event in the UK. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA…

  Read the article

• Introduction to Indexes

  Indexes are critical to good performance. However many people don't understand how indexes well. MVP Gail Shaw provides us with an introductory article on the basics of indexing. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky…

  Read the article

• Understanding Dynamic Management Views and Functions in SQL Server 2008

  Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system. SQL…

  Read the article

• Mission Critical: SQL Server 2008 General Maintenance

  There is nothing that beats a simple checklist for ensuring that things don't get forgotten in the Database Maintenance process. Once again, Buck Woody imagines how the US military would have tackled DBA checklists for 'mission-critical' databases.

  Read the article

• Hiding System Objects in Object Explorer in SQL Server Management Studio

  While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects in Object Explorer. Join SQL…

  Read the article

• Speaking - 24 Hours of PASS, Summit Preview Edition

  - by AllenMWhite

  There's so much to learn to be effective with SQL Server, and you have an opportunity to immerse yourselves in 24 hours of free technical training this week from PASS, via the 24 Hours of PASS event. I'll be presenting an introductory session on PowerShell called PowerShell 101 for the SQL Server DBA . Here's the…

  Read the article

• Troubleshoot Database Concurrency in SQL Server with sp_locks

  sp_locks is a useful tool which can help a DBA in detecting and troubleshooting blocking and concurrency scenarios. This article demonstrates a worked example of using sp_locks to troubleshoot a database concurrency issue. Free trial of SQL Backup™“SQL Backup was able to cut down my backup time…

  Read the article

• Upgrading Data Tier Applications in SQL Server 2008 R2

  Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take? …

  Read the article

• Spring SQL Connections 2011 and SQLServerCentral.

  Once again SQLServerCentral is sponsoring a track at SQL Connections in Orlando this March. Read about the event and our speakers and join us for SQL Server training in Florida. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL…

  Read the article

• Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters

  I'd seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance? Join SQL Backup’s 35,000+ customers to compress and…

  Read the article

• Microsoft SQL Server 2008 Integration Services Problem-Design-Solution - Sample Chapter

  Learning about practical Integration Services is an important part of the well rounded DBA for the future. Read a sample chapter from this new book.

  Read the article

• A follow up to yesterday

  - by GrumpyOldDBA

  As I have been asked,  here to tidy up yesterdays post is the procedure my startup procedure calls along with the logging table deployed in the DBA database. Just to muddy the water further I have routines for remotely calling the DBAMessages table through a remote server to send out…

  Read the article

< Previous Page | 19 20 21 22 23 24 25 26 27 28 29 30  | Next Page >