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

Articles with tag SQL Server Rss

Search for any content tagged sql server

   Items 1 to 20 of 121    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: MSSQLTips.com | Category: database growth
Rating: (not yet rated)  Rate this |   Briefcase | 2,315 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: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 6,389 reads

Changing SQL Server Database Logical Names

SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.  Read more...
By Shawn Melton 2015/07/20 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,233 reads

SQL Server Downloads

A list of the free version, tools, and sample downloads.  Read more...
By Site Owners 2015/06/23 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,386 reads

Shredding Unicode Japanese characters using SSIS

This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS  Read more...
By Arun Mishra 2015/03/31 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 537 reads

What, when and who? Auditing 101 - Part 3

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.  Read more...
By Roy Ernest 2014/12/19 (first published: 2012/05/31) | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 13,589 reads

What, when and who? Auditing 101 - Part 2

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...
By Roy Ernest 2014/12/12 (first published: 2012/01/16) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 12,771 reads

Document, then Install

Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.  Read more...
By Steve Jones 2014/10/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Removing SQL Server Management Data Warehouse (Data Collector)

Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.  Read more...
By Bruno Silva 2014/09/29 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,770 reads

No Compelling Reason

Steve Jones wants to know if you have compelling reasons to upgrade or not upgrade this week.  Read more...
By Steve Jones 2014/09/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 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 | 7,507 reads

Wandering Towards The Lonely Cloud?

Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?  Read more...
By Scott Crosby 2014/06/05 | Source: SQLServerCentral.com | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Report Builder or Reporting Services?

Should you be using Report Builder 3.0 or SQL Server Reporting Services 2008 R2 to build reports? Here's the 411!  Read more...
By Andy Owl 2014/05/30 (first published: 2012/03/27) | Source: SQLServerCentral.com | Category: report builder
Rating: |  Discuss |   Briefcase | 23,810 reads

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 12,238 reads

A True SQL OS

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...
By Steve Jones 2014/03/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 479 reads

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,629 reads

SQL CLR Multi-Threaded File Copy

A CLR Procedure that performs multi-threaded fie copies without external command line tools.  Read more...
By Steve Ledridge 2013/11/19 | Source: SQLServerCentral.com | Category: async
Rating: |  Discuss |   Briefcase | 2,471 reads

SQL Server Knockoffs

Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.  Read more...
By Steve Jones 2013/10/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 273 reads

The Cloud of Destiny

Is SQL Server going to move to the "cloud?" Steve Jones thinks it is and has a few thoughts as he starts off with "cloud week" here at SQLServerCentral.  Read more...
By Steve Jones 2013/10/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 540 reads

SQL Server Cloud Migration Part I

A SQL Server migration with minimal business impact while synchronizing schema and data.  Read more...
By Edward Polley 2013/09/23 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,299 reads
   Items 1 to 20 of 121    Older >>