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

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

Change Tracking - 2008

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.  Read more...
By Nitesh Dedhia 2012/06/18 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 7,375 reads

The Sequence Object in SQL Server 2012

The Sequence Object is one of the many exciting new features introduced in SQL Server 2012. Learn what this new feature can do for you and how you can use it.  Read more...
By Sanil Mhatre 2012/06/04 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 7,843 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 2012/05/31 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 8,884 reads

How to create a database backup using visual studio

This article describes how to backup a database using a C# Windows Form.   Read more...
By Daniel Calbimonte 2012/03/30 | Source: SQLServerCentral.com | Category: c#
Rating: |  Discuss |   Briefcase | 8,009 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,415 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 2012/01/16 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 7,703 reads

Find Last Restart of SQL Server

How can you tell when your SQL Server instance was last started? In this tip we look at various methods of how to get the start time for a SQL Server instance.  Read more...
By Additional Articles 2011/09/27 | Source: MSSQLTips.com | Category: restart
Rating:  Rate this |   Briefcase | 3,232 reads

SQL Code Reuse: Teaching a Dog New Tricks

Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is akin to trying to persuade a dog not to fetch a stick.  Read more...
By Additional Articles 2011/09/26 | Source: SimpleTalk | Category: code reuse
Rating:  Rate this |   Briefcase | 3,324 reads

10 Bad Things About Reporting Services 2008 R2

SSRS 2008 R2 introduced lots of exciting new features, reviewed in a sister article to this one. Here we consider what Microsoft didn't do well in this version of Reporting Services.  Read more...
By Andy Owl 2011/09/06 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 15,401 reads

10 Good Things About Reporting Services 2008 R2

The 10 things Microsoft got right about SQL Server Reporting Services 2008 R2 (a sister article shows 10 things which aren't quite so good)  Read more...
By Andy Owl 2011/09/05 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 12,892 reads

Using PowerShell to Manage SQL Server

The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.  Read more...
By Additional Articles 2011/08/16 | Source: SQL Server Performance | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,363 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,109 reads

Vote for Me for a PASS SQLRally Precon on SQL Server Security

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...  Read more...
By 2010/10/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,887 reads

SQL Saturday 52 Recap

I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver.  This was the...  Read more...
By Tim Mitchell 2010/10/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,906 reads

SSIS: Conditional File Processing in a ForEach Loop

I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules...  Read more...
By Tim Mitchell 2010/08/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 9,305 reads

Setting All Tempdb Data Files to the Same Size

How to set all tempdb datafiles to same size to meet best practice.   Read more...
By Aldo Gonzalez 2010/07/19 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 9,773 reads

Map IP Address to a Geographical Location

Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.  Read more...
By Oscar D Garcia 2012/07/20 (first published: 2009/07/09) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 48,257 reads

How to find unused Stored Procedures in SQL Server 2005/2008

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database  Read more...
By Ronny Dahl 2010/04/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 26,223 reads

A High Level Comparison Between Oracle and SQL Server - Part IV

The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.  Read more...
By Additional Articles 2010/04/02 | Source: SQL Server Performance | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 3,385 reads

A High Level Comparison Between Oracle and SQL Server - Part III

Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.   Read more...
By Additional Articles 2010/03/30 | Source: SQL Server Performance | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,917 reads
<< Newer    Items 21 to 40 of 114    Older >>