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

Changing SQL Server Database Logical Names

SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.  Read more...
By Shawn Melton 2015/07/20 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,855 reads

SQL Server Downloads

A list of the free version, tools, and sample downloads.  Read more...
By Site Owners 2015/06/23 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,312 reads

Delete all files from a folder using xp_cmdshell

Delete all files from a folder using xp_cmdshell  Read more...
Rating: |  Discuss |   Briefcase | 765 reads

Extract default & Named Instance from @@servername

Extract default & Named Instance from @@servername. Print all characters before and after \ to find default and named instance name.  Read more...
Rating: |  Discuss |   Briefcase | 862 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 2015/04/07 | Source: SQLServerCentral.com | Category: dependencies
Rating: |  Discuss |   Briefcase | 3,093 reads

Check if SQL Server is running

This script will check if the SQL Server you are connected to is actually running.  Read more...
By Steve Jones 2015/04/01 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,473 reads

Shredding Unicode Japanese characters using SSIS

This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS  Read more...
By Arun Mishra 2015/03/31 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 530 reads

SQL Versions

By Karthik Babu 2015/03/20 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 1,623 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 2015/03/17 | Source: SQLServerCentral.com | Category: split string
Rating: |  Discuss |   Briefcase | 4,499 reads

ColumnStore index

By pramod singla 2015/02/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,551 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,528 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,734 reads

Extract SQL Server Key details

Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.  Read more...
By S M 2014/10/27 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,322 reads

Querying deadlock graph from SQL Extended Events

Sample script to read deadlock graph XML from default system health XEvent.  Read more...
By Marcelo Fonseca 2014/10/21 | Source: SQLServerCentral.com | Category: xevents
Rating: |  Discuss |   Briefcase | 1,874 reads

Document, then Install

Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.  Read more...
By Steve Jones 2014/10/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

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,753 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 | 107 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 | 7,506 reads

Code Names

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

What is 268435456?

By Andy Warren 2014/06/27 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 2,165 reads
   Items 1 to 20 of 150    Older >>
 
Tags
blogs (28)    
t-sql (13)    
editorial (12)    
administration (8)    
cloud services (8)    
integration services (ssis) (8)    
editorial - mp3 (7)    
editorial - wmv (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 log (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)    
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)    
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)