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

<< Newer    Items 21 to 40 of 14038    Older >>

Identify SQL Server Database Growth Rates

Unchecked SQL Server database growth can hurt the bottom line of organizations in the form of poor application performance and increased infrastructure costs. In this article, Marios Philippopoulos looks at whether there's an easy way to proactively obtain a recent list of the fastest-growing databases in a SQL Server instance using information captured by default in the database engine.  Read more...
By Additional Articles 2015/08/26 | Source: | Category: database growth
Rating: (not yet rated)  Rate this |   Briefcase | 2,613 reads


Steve Jones draws an analogy today between your career and time on the ocean.  Read more...
By Steve Jones 2015/08/25 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 102 reads

Exam 70-462: Using Azure for the Practice Setup

A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.  Read more...
By Nathan Bell 2015/08/25 | Source: | Category: certification
Rating: |  Discuss |   Briefcase | 3,645 reads

Deciding on a Primary Key in Oracle

Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.  Read more...
By Additional Articles 2015/08/25 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,159 reads

The Process to Provision and Configure Azure SQL PaaS

This document describes the process to provision a SQL Azure server manually. While it is expected that most servers will be provisioned using automation, DBA's must have the skills and know the process to perform the same provisioning manually.  Read more...
Rating: |  Discuss |   Briefcase | 1,053 reads

Learning Live Query Statistics

References and information on the Live Query Statistics feature in SQL Server 2016.  Read more...
By Site Owners 2015/08/24 | Source: | Category: live query statistics
Rating: (not yet rated) |  Discuss |   Briefcase | 1,311 reads

Why Use Version Control?

Steve Jones has a story about what it's like to work with, and without, Version Control Systems.  Read more...
By Steve Jones 2015/08/24 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads

Multi-Platform Mobile Development with PhoneGap

Of course it seems a great idea to have your application on all the main mobile platforms as well as on the desktop. However, as Arkadiusz Pachucy knows all too well, this can ultimately leave you with a full-scale maintenance nightmare. In this article he looks at whether technologies like PhoneGap/Cordova or Adobe Air could be the perfect compromise - and if so, what frameworks to use.  Read more...
By Additional Articles 2015/08/24 | Source: SimpleTalk | Category: multi-platform
Rating: (not yet rated)  Rate this |   Briefcase | 2,520 reads

Annual Security Compliance Training

A guest editorial from Andy Warren that looks at annual training to try and improve security.  Read more...
By Andy Warren 2015/08/21 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2015/08/21 (first published: 2013/05/08) | Source: | Category: pdf
Rating: |  Discuss |   Briefcase | 26,175 reads

What is DNX?

In the past, working in .NET for non-Windows platforms has been dependent on third-party frameworks like Mono. Now, with VS2015 and DNX Microsoft have stepped up to provide everything you need to code multi-platform apps straight out of the box. Clive Tong introduces this new .NET technology.  Read more...
By Additional Articles 2015/08/21 | Source: SimpleTalk | Category: dnx
Rating: (not yet rated)  Rate this |   Briefcase | 3,266 reads

The Road to Success

The road to success is paved with cobblestones. 
By Steve Jones 2015/08/20 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 125 reads

SQL Server Performance dashboard reports

Setting up SQL Server Management Studio (SSMS)based performance dashboard driven off servers that are registered through a Central Management Server (CMS).  Read more...
By Arun Sirpal 2015/08/20 | Source: | Category: sql server
Rating: |  Discuss |   Briefcase | 6,566 reads

Using Microsoft DiskSpd to Test Your Storage Subsystem

Glenn Berry gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.  Read more...
By Additional Articles 2015/08/20 | Source: | Category: diskspd
Rating:  Rate this |   Briefcase | 3,699 reads

Database Documentation Survey

Documentation often gets left behind in software development, perhaps even more so when it comes to developing the database schema. How do you keep yours up-to-date? Do you even think you should?  Read more...
By Additional Articles 2015/08/27 (first published: 2015/08/20) | Source: Redgate | Category: survey
Rating:  Rate this |   Briefcase | 3,561 reads

PowerShell Tool Time: The Tool Framework

Start learning Powershell (PoSh) for SQL Server and improve your ability to write utilities that will make your job easier.  Read more...
By Mike Fal 2015/08/19 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 5,122 reads

Free Webinar: Should your databases be Continuously Delivered?

If you want to learn more about Continuous Delivery, and where your databases fit into the picture, join Dave Farley on September 2nd for a webinar covering why databases are an essential component of CD, and how to start modernizing your software development practices.  Read more...
By Additional Articles 2015/08/31 (first published: 2015/08/13) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 7,203 reads

Live Query Statistics in SQL Server 2016

SQL Server 2016, which at the time of writing is in preview release CTP 2.1, has a great new feature called Live Query Statistics. In this article, Koen Verbeeck introduces the new feature which allows you to view a live execution plan of an active query, giving a fantastic opportunity for troubleshooting and debugging.   Read more...
By Additional Articles 2015/08/19
Rating: (not yet rated)  Rate this |   Briefcase | 2,720 reads

Byte Me: Corporate Oversight

You can count on this. 
By Bob Lang 2015/08/19 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 175 reads

Connect to Salesforce Data as a Linked Server

Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.  Read more...
By Eric Madariaga 2015/08/18 | Source: | Category: salesforce
Rating: |  Discuss |   Briefcase | 3,667 reads
<< Newer    Items 21 to 40 of 14038    Older >>