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

<< Newer    Items 41 to 60 of 13099    Older >>
 

The Mindset of the Enterprise DBA: Harnessing the Power of Automation

After you have done the necessary groundwork of standardising and centralising your database adminstration processes, you are now in a position to implement some effective automation of some of these processes. Which ones do you choose, and how do you set about automating these tasks?  Read more...
By Additional Articles 2014/09/17 | Source: SimpleTalk | Category: dba skills
Rating:  Rate this |   Briefcase | 8,225 reads

The Need for Auditing

Is C2 auditing widely used? Should it be more widely used? Steve Jones talks about the subject of auditing in today's editorial.  Read more...
By Steve Jones 2014/09/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 601 reads

The Ins and outs of In-Memory OLTP

As you may know, SQL Server is a very robust database, but SQL server has its performance bottlenecks. With the introduction of In-Line memory OLTP, there is a chance to get rid of the performance bottlenecks   Read more...
By Roy Ernest 2014/09/16 | Source: SQLServerCentral.com | Category: microsoft sql server
Rating: |  Discuss |   Briefcase | 5,054 reads

Comparing SQL Server Datatypes, Size and Performance for Storing Numbers

When more than one numeric SQL Server data type may be suitable for a field in a project, which data type should you choose and what are the implications for SQL Server performance?  Read more...
By Additional Articles 2014/09/16 | Source: MSSQLTips.com | Category: datatypes
Rating: (not yet rated)  Rate this |   Briefcase | 8,218 reads

SQL Monitor Custom Metric: Last backup size

Backups are at the heart of the activities of any DBA. You have to restore the backup to know it is good, but you can get an early alert that something is wrong if your backup size changes rapidly or unexpectedly in a short period of time.  Read more...
By 2014/09/16 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,607 reads

Another Way to Look at Trees

An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.  Read more...
By Larry Schmidt 2014/09/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 5,527 reads

The Ten Commandments for DBAs

What should a good DBA do? Steve Jones came across a list he likes that showcases those things that should guide your efforts on a daily basis.  Read more...
By Steve Jones 2014/09/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 274 reads

Who Broke the Build?

Continuous Integration and automatic builds are fantastic tools for software teams, but only if developers take responsibility for their code. Karsten Kempe explains how to use Team Foundation Server to drive better continuous integration, and walks through a simple open-source tool he built to make nightly builds more transparent, and more valuable.  Read more...
By Additional Articles 2014/09/15 | Source: SimpleTalk | Category: continuous integration
Rating: (not yet rated)  Rate this |   Briefcase | 6,649 reads

Survey: Using Online Accounts

Using online accounts for license management has some advantages, Red Gate is researching how to implement this for our tools in a way that improves the experience for all involved. To say thank you for your participation, there's a chance to win a $25 Amazon certificate.  Read more...
By Additional Articles 2014/09/15 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 6,650 reads

Swallowing the Camel

By Tony Davis 2014/09/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 126 reads

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...
By Dwain Camps 2014/09/12 (first published: 2012/11/29) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 17,442 reads

DBAs vs Developers: A Sad Tale of Unnecessary Conflict

For many developers, does DBA really stand for Don't Bother Asking? David Poole thinks it is time to end the unnecessary conflict between developer and DBA, and explains how to deal professionally with the inevitable friction between development and operation activities in IT.  Read more...
By Additional Articles 2014/09/12 | Source: SimpleTalk | Category: dba skills
Rating: (not yet rated)  Rate this |   Briefcase | 10,596 reads

Data Vices

Steve Jones asks about what you might change about yourself at work for this Friday's poll.  Read more...
By Steve Jones 2014/09/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 149 reads

The DBA Team Wants You!

There's a new contest going on, giving you the chance to win some software, SQL training, and a vacation, all at once.  Read more...
By Steve Jones 2014/09/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 151 reads

Practical Uses for Synonyms in SQL Server

The concept of a synonym was introduced in SQL Server 2005. Synonyms are very simple database objects, but have the potential to save a lot of time and work if implemented with a little bit of thought. This article discusses what exactly a synonym is, and a few examples of how to use them.  Read more...
By Jason Shadonix 2014/09/11 | Source: SQLServerCentral.com | Category: synonyms
Rating: |  Discuss |   Briefcase | 7,304 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2014/09/11 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 17,205 reads

SQL Server Hybrid High Availability and Disaster Recovery

This article summarizes the factors to consider and provide an overview of various options for HA and DR in cloud based SQL Server deployments.  Read more...
By Additional Articles 2014/09/11 | Source: MSSQLTips.com | Category: high availability (ha)
Rating: (not yet rated)  Rate this |   Briefcase | 6,123 reads

Prepping for 2015

Steve Jones looks ahead at the new year and how you might want to begin shaping your career.  Read more...
By Steve Jones 2014/09/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 159 reads

Stairway to SQLCLR Level 4: Security (EXTERNAL and UNSAFE Assemblies)

In the fourth level of our Stairway to SQLCLR series we take a detailed look at the EXTERNAL_ACCESS and UNSAFE permission sets. We also explore some differences between using TRUSTWORTHY or an Asymmetric Key.  Read more...
By Solomon Rutzky 2014/09/10 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,808 reads

Are you bad enough to join the DBA Team

If you've ever had a terrible day, send in your story and Grant and Steve will pick their favorite to be spiced up DBA-Team-style. The winner will also be given a ticket to SQL Cruise 2015. Find out how to enter.  Read more...
By Press Release 2014/09/10 | Source: SQLServerCentral.com | Category: database administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,306 reads
<< Newer    Items 41 to 60 of 13099    Older >>