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 61 to 80 of 132    Older >>
 

Please, Sir, I want some more… orphaned database users.

Permissions on our development servers are considerably less stringent than elsewhere with developers afforded the freedom to restore backup’s ad-hoc....  Read more...
By jameshoward3 2009/12/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,733 reads

Linear Gauge Control: A Practical Use

SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I...  Read more...
By Patrick LeBlanc 2009/12/02 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,330 reads

Fundamentals of Storage Systems – Capturing IO Patterns

We often take the advice given to us on forums or in articles at face value. Even though the authors...  Read more...
By Wesley Brown 2009/11/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,357 reads

How to Create a Reporting Services 2005/2008 Template

  At most large companies one business requirement is that all reports have the same look and feel.  This may vary...  Read more...
By Patrick LeBlanc 2009/11/24 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 4,780 reads

Why We Recommend Against xp_cmdshell

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...  Read more...
By 2009/11/19 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 6,845 reads

SQL University: Multiple Paths and Ownership Chaining

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...  Read more...
By 2009/11/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,636 reads

A Neural Network in SQL Server

Modeling and programming a neural Network in SQL Server from new author Silvia Cobialca. Learn how you might be able to implement this AI construct in SQL Server to make predictions.  Read more...
By Silvia Cobialca 2009/10/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 10,756 reads

SQL Server Legend – Data Files and Threads

Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...  Read more...
By Steve Jones 2009/10/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,968 reads

MSDE – Database Size Limit

Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...  Read more...
By Patrick LeBlanc 2009/10/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,370 reads

Red Gate's SQL Data Generator

I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...  Read more...
By 2009/10/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,587 reads

Eliminating Empty Output Files in SSIS

So you’ve got some packages that regularly extract data to one or more text files, but you know that from...  Read more...
By Tim Mitchell 2009/10/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,912 reads

BCP command to export data to excel with column headers

This script export data into excel/CSV file using BCP comnand with column headers  Read more...
By Samardeep Khera 2009/10/01 | Source: SQLServerCentral.com | Category: bcp command
Rating: |  Discuss |   Briefcase | 3,118 reads

The old INNER JOIN syntax vs. the new INNER JOIN syntax

I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...  Read more...
By Brian Kelley 2009/10/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 6,932 reads

Fundamentals of Storage Systems - The Basics of Spinning Disks

  Your servers are only as fast as the slowest part, hard drives. To feed other parts of the system we have...  Read more...
By Wesley Brown 2009/09/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,920 reads

Blobs and Filestreams

In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...  Read more...
By Andy Warren 2009/09/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,196 reads

Windows Internal Database

This past Friday I received a call from our systems team stating that they were running low on Disk Space...  Read more...
By Patrick LeBlanc 2009/09/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,531 reads

Best Practice - Increasing the Number of SQL Server Error Logs

By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.  Read more...
By Additional Articles 2009/09/21 | Source: MSSQLTips.com | Category: sql server
Rating:  Rate this |   Briefcase | 2,885 reads

SQL Server Job Trends on Graphs

 A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...  Read more...
By Bill Nicolich 2009/09/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,070 reads

Best Practice - Increasing the Number of SQL Server Error Logs

By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.  Read more...
By Additional Articles 2009/09/21 | Source: MSSQLTips.com | Category: sql server
Rating:  Rate this |   Briefcase | 1,735 reads

SQL Server 7.0 – Transaction Log Not Backing Up

I have not worked with SQL Server 7.0 in a loooong time.  So when I received a call from a...  Read more...
By Patrick LeBlanc 2009/09/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,646 reads
<< Newer    Items 61 to 80 of 132    Older >>
 
Tags
blogs (28)    
t-sql (12)    
editorial (10)    
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)    
reporting services (ssrs) (5)    
sql server 2005 (5)    
sql server 2008 (5)    
database security (4)    
databases (4)    
learning (4)    
powershell (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)    
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)    
database users (1)    
ddl (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)    
geo database (1)    
graphs (1)    
handle (1)    
hard disk (1)    
identity property (1)    
indexes (1)    
initial size (1)    
insert (1)    
instances (1)    
io (1)    
job trends (1)    
jobs (1)    
linear gauge control (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)    
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)    
tempdb (1)    
tim mitchell (1)    
totvs rm (1)    
training (1)    
triggers (1)    
troubleshooting (1)    
udf (1)    
unattended install (1)    
user group (1)    
users (1)    
valor itens % (1)    
vbscript (1)    
virtualization (1)    
visual studio (1)    
windows (1)    
xml (1)    
xquery (1)