Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 11668    Next 20 >>
 

Automating SQL Traces

Capturing the activity on a server when a problem occurs can be a challenge for many DBAs. This article shows how you can automate the capture of information when a CPU spike occurs.  Read more...
By Clark Froebe 2013/05/23 | Source: SQLServerCentral.com | Category: sql trace
Rating: |  Discuss |   Briefcase | 2,899 reads

Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets

There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.  Read more...
By Additional Articles 2013/05/23 | Source: SimpleTalk | Category: sql server 2012
Rating:  Rate this |   Briefcase | 970 reads

Transaction Log Stairway Series available as a book

Red Gate Books has released SQL Server Transaction Log Management, a free eBook on maintaining and troubleshooting the enigmatic transaction log based on the Stairway Series.  Read more...
By Press Release 2013/05/23 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 767 reads

Trusting Systems

The trust we build by ensuring our computer systems work is important. If we can't maintain that trust, Steve Jones sees a problem for our careers.  Read more...
By Steve Jones 2013/05/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

Data Mining Introduction Part 5: the Neural Network Algorithm

This is the 5th article about Data Mining with SQL Server. This chapter is about Neural Networks.  Read more...
By Daniel Calbimonte 2013/05/22 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 3,634 reads

Understanding HA

Dealing with disaster situations or trying to maintain an HA environment can be stressful. However knowledge about your goals and the capabilities of each technology, along with practice, can make things much easier.  Read more...
By Steve Jones 2013/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 81 reads

Paging Data with T-SQL

Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.  Read more...
By Additional Articles 2013/05/22 | Source: Database Journal | Category: paging data
Rating:  Rate this |   Briefcase | 2,763 reads

Power View for Cubes

This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models[1], this SQL Server 2012 CTP release allows connections between Power View and Multidimensional Models ( cubes) and not just Tabular Models.  Read more...
By Ivan Paniagua 2013/05/21 | Source: SQLServerCentral.com | Category: power view
Rating: |  Discuss |   Briefcase | 4,570 reads

Centralizing SQL Server Express Job Scheduling

I'm interested in monitoring all my SQL Server backups, but for SQL Server Express we're currently using scheduled backups using Windows Task scheduler on each SQL Server Express since SQL Agent does not come installed on Express Editions. Is there an alternative where I can utilize my existing SQL Server infrastructure?  Read more...
By Additional Articles 2013/05/21 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 1,590 reads

How do you solve T-SQL problems?

It's good to have a methodology for solving problems, and T-SQL is no exception to this. Steve Jones notes that all too often we look at solving a problem, but only doing half the job.  Read more...
By Steve Jones 2013/05/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 181 reads

How Maintenance Plans are a Big Plus for SQL Server Administration

SQL Server 2012 makes your database maintenance jobs easy by proving an effective Maintenance Plan Wizard. This wizard does a fair job of creating core maintenance plans for your database.  Read more...
By Prett Sons 2013/05/20 | Source: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 3,730 reads

SQLServerCentral Hosts AdventureWorks on Azure

SQLServerCentral and Red Gate software have agreed to host the AdventureWorks database on the Azure platform and give free access to anyone that wants to practice querying it.  Read more...
By Press Release 2013/05/20 | Source: SQLServerCentral.com | Category: adventureworks
Rating: |  Discuss |   Briefcase | 950 reads

Connecting to AdventureWorks on Azure

A quick guide for connecting to our free copy of AdventureWorks on the Azure platform.  Read more...
By Steve Jones 2013/05/20 | Source: SQLServerCentral.com | Category: adventureworks
Rating: |  Discuss |   Briefcase | 1,012 reads

Morphing Microsoft

Is Microsoft trying to move away from just being a software vendor? It seems they'd like to and that's a goal, but are they moving in the right direction? Steve Jones has a few ideas to help them.  Read more...
By Steve Jones 2013/05/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads

Powershell for DBAs

Powershell is a great tool for helping you work with multiple instances of SQL Server. This week Steve Jones talks about how and why you might want to get started.  Read more...
By Steve Jones 2013/05/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 109 reads

Azure SQL Database Maintenance

It is increasingly likely that DBAs are now given responsibility for maintaining Azure SQL databases as well as conventional SQL Server databases. What is likely to be required by way of maintenence? What are the differences? Grant Fritchey covers what you need to know.  Read more...
By Additional Articles 2013/05/20 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,563 reads

Powershell Database Backup Script

Learn how to write a script for regular database backups using Powershell and SMO.  Read more...
By Jimmy Atsaves 2013/05/17 (first published: 2011/01/05) | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 17,673 reads

Raw Materials - Beyond Global

There's more than one way to be green.  Read more...
By Larry Gonick 2013/05/17 (first published: 2010/09/22) | Source: SQLServerCentral.com | Category: raw materials
Rating: |  Discuss |   Briefcase | 10,719 reads

Getting Started Formatting SSRS Reports

Once you've prepared an SSRS report, it needs formatting to get it ready for the people who need to read it. This tip covers the basics of formatting SSRS Reports.  Read more...
By Additional Articles 2013/05/17 | Source: SQL Server Performance | Category: ssrs
Rating:  Rate this |   Briefcase | 2,672 reads

The Control Poll

Do you use version control for your databases? For your application code? Is there a time when you think it's not needed? Steve Jones asks the question today.   Read more...
By Steve Jones 2013/05/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 80 reads
   Items 1 to 20 of 11668    Next 20 >>