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


 

Content with tag SQL Server Rss

   Items 1 to 20 of 98    Next 20 >>
 

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 | 5,816 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 | 2,447 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,000 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 | 13,085 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 | 10,831 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 | 2,724 reads

NetApp Dynamic Backup Script

TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases  Read more...
By Chris Taylor 2011/08/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |  Briefcase | 503 reads

Get SQL Server IP Address

To Get Server IP Address without having to log into box or RDP  Read more...
By Shirley Noa 2011/08/02 | Source: SQLServerCentral.com | Category: ip addresses
Rating: |  Discuss |  Briefcase | 1,977 reads

Changing Primary key names to standard naming convention across the DB

This script will rename the Primary keys to standard notation - PK_TableName  Read more...
By Vidyadhar Pandekar 0001/01/01 | Source: SQLServerCentral.com | Category: rename primary key
Rating: |  Discuss |  Briefcase | 1,535 reads

Create INSERT statements from Excel

Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.  Read more...
By Arun Mallick 0001/01/01 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |  Briefcase | 4,442 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 2011/04/04 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |  Briefcase | 6,979 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,002 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,435 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 | 4,526 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 | 8,697 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 2010/04/16 (first published: 2009/07/09) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |  Briefcase | 35,890 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 | 23,463 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,095 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,723 reads

An Un-CATCHable Error?

I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...  Read more...
By Tim Mitchell 2010/03/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 1,919 reads
   Items 1 to 20 of 98    Next 20 >>
 
Tags
blogs (28)    
editorial (9)    
cloud services (8)    
editorial - mp3 (7)    
editorial - wmv (7)    
patrick leblanc (7)    
editorial - ipod (6)    
integration services (ssis) (6)    
administration (5)    
database weekly (5)    
oracle (5)    
security (5)    
sql server 2005 (5)    
database security (4)    
databases (4)    
learning (4)    
reporting services (ssrs) (4)    
sql server 2008 (4)    
tools (4)    
error logging (3)    
powershell (3)    
sql server 2000 (3)    
articles (2)    
business intelligence (2)    
data warehousing (2)    
etl (2)    
excel (2)    
fundamentals (2)    
ip addresses (2)    
live meeting (2)    
microsoft (2)    
performance (2)    
presenting (2)    
reporting services (2)    
san (2)    
scripting (2)    
speaking (2)    
storage (2)    
t-sql (2)    
t-sqlscripts (2)    
windows security (2)    
analysis services (ssas) (1)    
auditing (1)    
backup (1)    
bcp command (1)    
best practice (1)    
books (1)    
career (1)    
cdc (1)    
change data capture (1)    
change foreign key name (1)    
change tracking (1)    
clustering (1)    
code reuse (1)    
conferences and events (1)    
conferences/user groups (1)    
consolidation (1)    
ct (1)    
database users (1)    
dmo (1)    
dts (1)    
error handling (1)    
event log (1)    
exchange (1)    
export data (1)    
export to excel (1)    
export with column headers (1)    
extract, transform, load (etl) (1)    
filestream (1)    
foreign keys (fk) (1)    
geo database (1)    
graphs (1)    
handle (1)    
hard disk (1)    
initial size (1)    
insert (1)    
instances (1)    
io (1)    
job trends (1)    
jobs (1)    
linear gauge control (1)    
microsoft sql server (1)    
msde (1)    
mysql (1)    
naming convention (1)    
netapp (1)    
neural network (1)    
orphaned (1)    
package (1)    
pass summit (1)    
perfmon (1)    
performance tuning (1)    
pivottable (1)    
primary key (pk) (1)    
professional development (1)    
professional organization for sql server (1)    
query performance (1)    
referential integrity (1)    
rename primary key (1)    
replication (1)    
restart (1)    
scr (1)    
sheet (1)    
snapmanager for sql (1)    
sql audit (1)    
sql saturday (1)    
sql server 2008 r2 (1)    
sql server architecture (1)    
sql university (1)    
sqlsaturday (1)    
stored procedures (1)    
tempdb (1)    
tim mitchell (1)    
training (1)    
troubleshooting (1)    
udf (1)    
user group (1)    
users (1)    
vbscript (1)    
virtualization (1)    
windows (1)    
 
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.