SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Server Rss

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

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 | 555 reads

SQL Versions

By Karthik Babu 2015/03/20 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 1,699 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,625 reads

ColumnStore index

By pramod singla 2015/02/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,634 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,781 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,914 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,426 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 2016/09/16 | Source: SQLServerCentral.com | Category: xevents
Rating: |  Discuss |   Briefcase | 3,784 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 | 107 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,928 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 | 108 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,536 reads

Code Names

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

What is 268435456?

By Andy Warren 2014/06/27 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 2,210 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 | 56 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,997 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,348 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 | 482 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,640 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,503 reads
<< Newer    Items 41 to 60 of 184    Older >>
 
Tags
blogs (28)    
t-sql (15)    
editorial (14)    
administration (10)    
integration services (ssis) (9)    
powershell (9)    
cloud services (8)    
editorial - mp3 (7)    
editorial - wmv (7)    
patrick leblanc (7)    
security (7)    
editorial - ipod (6)    
reporting services (ssrs) (6)    
database weekly (5)    
oracle (5)    
sql server 2005 (5)    
sql server 2008 (5)    
database security (4)    
databases (4)    
learning (4)    
microsoft (4)    
tools (4)    
c# (3)    
change tracking (3)    
checksum (3)    
data warehousing (3)    
error log (3)    
hashbytes() (3)    
performance tuning (3)    
sql server 2000 (3)    
agent jobs (2)    
articles (2)    
auditing (2)    
azure sql database (2)    
backup and restore (2)    
binary_checksum (2)    
business intelligence (2)    
change data capture (cdc) (2)    
change detection (2)    
clustering (2)    
conflict resolution (2)    
database (2)    
database growth (2)    
development (2)    
etl (2)    
excel (2)    
fundamentals (2)    
initial size (2)    
ip addresses (2)    
live meeting (2)    
migration (2)    
presenting (2)    
r language (2)    
rowversion (2)    
san (2)    
scripting (2)    
speaking (2)    
sql audit (2)    
sql server 2012 (2)    
storage (2)    
stored procedures (2)    
trivia (2)    
visual studio (2)    
windows security (2)    
ado.net (1)    
analysis (1)    
analysis services (ssas) (1)    
application design (1)    
async (1)    
autogrowth (1)    
aws (1)    
azure (1)    
backup (1)    
bacpac (1)    
baseline (1)    
bcp command (1)    
best practice (1)    
big data (1)    
biztalk log shipping (1)    
books (1)    
career (1)    
cdata (1)    
cdc (1)    
change foreign key name (1)    
checkout (1)    
cloud computing (1)    
cluster (1)    
cms (1)    
code reuse (1)    
code review (1)    
columnstore index (1)    
command line install (1)    
conferences and events (1)    
conferences/user groups (1)    
configuration (1)    
consolidation (1)    
constraints (1)    
consultancy (1)    
cpu (1)    
ct (1)    
data analysis (1)    
data collector (1)    
database administration (1)    
database design (1)    
database users (1)    
datamate technology (1)    
dba (1)    
ddl (1)    
deadlock graph (1)    
deadlocks (1)    
dependencies (1)    
disk space usage (1)    
dmo (1)    
document (1)    
dts (1)    
enterprise edition (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)    
glm (1)    
graphs (1)    
growth rates (1)    
handle (1)    
hard disk (1)    
healthcheck (1)    
hibernate (1)    
hierarchy (1)    
identity property (1)    
indexing (1)    
insert (1)    
installation (1)    
instances (1)    
introduction (1)    
io (1)    
ironpython (1)    
japanese character (1)    
job trends (1)    
linear gauge control (1)    
linux (1)    
management data warehouse (1)    
mdw (1)    
memory (1)    
microsoft azure (1)    
microsoft sql server (1)    
miscellaneous (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)    
orm (1)    
orphaned users (1)    
other (1)    
paas (1)    
partition switching (1)    
partitioning (1)    
pass summit (1)    
perfmon (1)    
perfmon counters (1)    
pivottable (1)    
politics (1)    
porcentagem itens núcleus (1)    
ports (1)    
primary key (pk) (1)    
professional development (1)    
professional organization for sql server (1)    
programming (1)    
ptvs (1)    
python tools (1)    
query optimizer (1)    
query performance (1)    
query store (1)    
r services (1)    
rateio itens (1)    
rateio nucleus (1)    
rateio produtos (1)    
r-bar (1)    
react (1)    
referential integrity (1)    
regression (1)    
remote access (1)    
rename primary key (1)    
replication (1)    
replication tracking (1)    
report builder (1)    
resource governor (1)    
restart (1)    
rm núcleus (1)    
schema swapping (1)    
scr (1)    
search (1)    
sequence (1)    
sheet (1)    
silent install (1)    
smo (1)    
snapmanager for sql (1)    
split delimited string. (1)    
split string (1)    
sql login using powershell (1)    
sql migrator (1)    
sql on linux (1)    
sql saturday (1)    
sql search (1)    
sql server 2008 r2 (1)    
sql server 2014 (1)    
sql server 2016 (1)    
sql server architecture (1)    
sql university (1)    
sqlclr (1)    
sqlsaturday (1)    
statistics (1)    
synchronization (1)    
systemhealth (1)    
task manager (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)    
upgrade (1)    
upgrading (1)    
user groups (1)    
users (1)    
valor itens % (1)    
vbscript (1)    
virtualization (1)    
windows (1)    
windows login (1)    
xevents (1)    
xml (1)    
xquery (1)