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

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

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,402 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,893 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,364 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 | 733 reads

Get SQL Server IP Address

To Get Server IP Address without having to log into box or RDP  Read more...
By Shirley Bouzon 2011/08/02 | Source: SQLServerCentral.com | Category: ip addresses
Rating: |  Discuss |   Briefcase | 2,793 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 2011/07/29 | Source: SQLServerCentral.com | Category: rename primary key
Rating: |  Discuss |   Briefcase | 1,636 reads

Rateio do valor do Item na Nota - Totvs RM

Essa função calcula a porcentagem do Item em relação ao valor da nota. Aplicável a Totvs RM. Em especial RM Núcleus.  Read more...
By wamj 2011/07/13 | Source: SQLServerCentral.com | Category: totvs rm
Rating: (not yet rated) |  Discuss |   Briefcase | 109 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 2011/05/02 | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 5,129 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,114 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,891 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,907 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,307 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,775 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,261 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,233 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

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 | 2,304 reads

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

Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.   Read more...
By Additional Articles 2010/03/26 | Source: SQL Server Performance | Category: sql server
Rating:  Rate this |   Briefcase | 4,546 reads

A High Level Comparison Between Oracle and SQL Server

Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.  Read more...
By Additional Articles 2010/03/25 | Source: SQL Server Performance | Category: oracle
Rating:  Rate this |   Briefcase | 6,099 reads
<< Newer    Items 41 to 60 of 137    Older >>
 
Tags
blogs (28)    
editorial (12)    
t-sql (12)    
cloud services (8)    
administration (7)    
editorial - mp3 (7)    
editorial - wmv (7)    
integration services (ssis) (7)    
patrick leblanc (7)    
editorial - ipod (6)    
security (6)    
database weekly (5)    
oracle (5)    
powershell (5)    
reporting services (ssrs) (5)    
sql server 2005 (5)    
sql server 2008 (5)    
database security (4)    
databases (4)    
learning (4)    
tools (4)    
c# (3)    
change tracking (3)    
checksum (3)    
error logging (3)    
hashbytes (3)    
microsoft (3)    
performance tuning (3)    
sql server 2000 (3)    
articles (2)    
auditing (2)    
backup / restore (2)    
binary_checksum (2)    
business intelligence (2)    
change data capture (cdc) (2)    
change detection (2)    
conflict resolution (2)    
data warehousing (2)    
etl (2)    
excel (2)    
fundamentals (2)    
ip addresses (2)    
jobs (2)    
live meeting (2)    
presenting (2)    
rowversion (2)    
san (2)    
scripting (2)    
speaking (2)    
sql audit (2)    
storage (2)    
stored procedures (2)    
trivia (2)    
windows security (2)    
analysis services (ssas) (1)    
async (1)    
aws (1)    
azure (1)    
backup (1)    
bcp command (1)    
best practice (1)    
books (1)    
career (1)    
cdc (1)    
change foreign key name (1)    
cloud computing (1)    
cluster (1)    
clustering (1)    
code reuse (1)    
command line install (1)    
conferences and events (1)    
conferences/user groups (1)    
consolidation (1)    
constraints (1)    
consultancy (1)    
ct (1)    
data collector (1)    
database users (1)    
ddl (1)    
deadlock (1)    
deadlock graph (1)    
dependencies (1)    
development (1)    
dmo (1)    
dts (1)    
environment variables (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)    
file copy (1)    
filestream (1)    
foreign keys (fk) (1)    
friday poll (1)    
geo database (1)    
graphs (1)    
handle (1)    
hard disk (1)    
hierarchy (1)    
identity property (1)    
indexes (1)    
initial size (1)    
insert (1)    
instances (1)    
io (1)    
job trends (1)    
linear gauge control (1)    
management data warehouse (1)    
mdw (1)    
microsoft sql server (1)    
migration (1)    
msde (1)    
mssql (1)    
multi threaded (1)    
mysql (1)    
naming convention (1)    
netapp (1)    
neural network (1)    
new feature of sql server 2008 (1)    
nitesh dedhia (1)    
node (1)    
organization chart (1)    
orphaned (1)    
package (1)    
pass summit (1)    
perfmon (1)    
pivottable (1)    
porcentagem itens núcleus (1)    
ports (1)    
primary key (pk) (1)    
professional development (1)    
professional organization for sql server (1)    
programming (1)    
query performance (1)    
rateio itens (1)    
rateio nucleus (1)    
rateio produtos (1)    
r-bar (1)    
referential integrity (1)    
rename primary key (1)    
replication (1)    
report builder (1)    
restart (1)    
rm núcleus (1)    
scr (1)    
search (1)    
sequence (1)    
sheet (1)    
silent install (1)    
snapmanager for sql (1)    
split delimited string. (1)    
split string (1)    
sql (1)    
sql saturday (1)    
sql search (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server architecture (1)    
sql university (1)    
sqlclr (1)    
sqlsaturday (1)    
synchronization (1)    
systemhealth (1)    
tempdb (1)    
tim mitchell (1)    
totvs rm (1)    
training (1)    
tree structure (1)    
triggers (1)    
troubleshooting (1)    
udf (1)    
unattended install (1)    
upgrading (1)    
user group (1)    
users (1)    
valor itens % (1)    
vbscript (1)    
virtualization (1)    
visual studio (1)    
windows (1)    
xevents (1)    
xml (1)    
xquery (1)