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 146    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 R Dedhia 2012/06/18 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 7,490 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,866 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,288 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,685 reads

Session complete status and estimated completion time

A small retake on the popular percent complete script which tell how much more time an executing command will take.  Read more...
By Hemanth Damecharla 2012/03/21 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 918 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,589 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,376 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,357 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,498 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,941 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,384 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 | 745 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,835 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,645 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 | 112 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,185 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,191 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 | 2,018 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,955 reads
<< Newer    Items 41 to 60 of 146    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)    
columnstore index (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)    
indexing (1)    
initial size (1)    
insert (1)    
instances (1)    
io (1)    
japanese character (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 saturday (1)    
sql search (1)    
sql server 2008 r2 (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql server architecture (1)    
sql university (1)    
sqlclr (1)    
sqlsaturday (1)    
ssis (1)    
synchronization (1)    
systemhealth (1)    
tempdb (1)    
tim mitchell (1)    
totvs rm (1)    
training (1)    
tree structure (1)    
triggers (1)    
troubleshooting (1)    
tsql (1)    
udf (1)    
unattended install (1)    
unicode character (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)