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 135    Older >>
 

Removing SQL Server Management Data Warehouse (Data Collector)

Learn how to remove the MDW from your SQL Server environment with the 2008, 2008 R2 and 2012 versions.  Read more...
By Bruno Silva 2014/09/29 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,130 reads

No Compelling Reason

Steve Jones wants to know if you have compelling reasons to upgrade or not upgrade this week.  Read more...
By Steve Jones 2014/09/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 100 reads

Another Way to Look at Trees

An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.  Read more...
By Larry Schmidt 2014/09/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 5,560 reads

Code Names

By Steve Jones 2014/07/04 | Category: trivia
Rating: (not yet rated) |  Discuss |   Briefcase | 1,697 reads

What is 268435456?

By Andy Warren 2014/06/27 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 2,064 reads

Wandering Towards The Lonely Cloud?

Are all RDBMS heading towards "The Cloud"? Is this something we DBAs and consultants should be doing for our client?  Read more...
By Scott Crosby 2014/06/05 | Source: SQLServerCentral.com | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 52 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,353 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,093 reads

A True SQL OS

SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.  Read more...
By Steve Jones 2014/03/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 477 reads

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,608 reads

SQL CLR Multi-Threaded File Copy

A CLR Procedure that performs multi-threaded fie copies without external command line tools.  Read more...
By Steve Ledridge 2013/11/19 | Source: SQLServerCentral.com | Category: async
Rating: |  Discuss |   Briefcase | 2,370 reads

SQL Server Knockoffs

Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.  Read more...
By Steve Jones 2013/10/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 273 reads

The Cloud of Destiny

Is SQL Server going to move to the "cloud?" Steve Jones thinks it is and has a few thoughts as he starts off with "cloud week" here at SQLServerCentral.  Read more...
By Steve Jones 2013/10/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 538 reads

Extended Procs

By Dave 2013/10/01 | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 2,166 reads

SQL Server Cloud Migration Part I

A SQL Server migration with minimal business impact while synchronizing schema and data.  Read more...
By Edward Polley 2013/09/23 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,248 reads

Fastest way to find DB object dependencies

One of the fastest ways to find out objects dependencies in SQL Server.  Read more...
By Kshitij Satpute 2013/08/20 | Source: SQLServerCentral.com | Category: dependencies
Rating: |  Discuss |   Briefcase | 1,728 reads

Fastest way to split delimited string in SQL Server

Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.  Read more...
By Kshitij Satpute 2013/08/14 | Source: SQLServerCentral.com | Category: split string
Rating: |  Discuss |   Briefcase | 2,253 reads

Simplest way to search any string in db objects

Easiest way to search for a string in any object within the database.  Read more...
By Kshitij Satpute 2013/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,151 reads

Using XML from data variable option in SSIS

Learn how you can manipulat XML documents solely in memory. No file required.   Read more...
By Cindy Conway 2013/05/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 4,319 reads

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port  Read more...
Rating: |  Discuss |   Briefcase | 1,348 reads
   Items 1 to 20 of 135    Older >>
 
Tags
blogs (28)    
t-sql (12)    
editorial (11)    
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)    
data collector (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)    
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)    
jobs (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)    
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)    
xml (1)    
xquery (1)