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

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,050 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,285 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 | 88 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,476 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 | 105 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 | 6,907 reads

Code Names

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

What is 268435456?

By Andy Warren 2014/06/27 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 2,087 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 | 53 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,482 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,128 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 | 478 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,612 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,395 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 | 539 reads

Extended Procs

By Dave 2013/10/01 | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 2,174 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,255 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,741 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,275 reads
   Items 1 to 20 of 138    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)    
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)    
indexes (1)    
initial size (1)    
insert (1)    
instances (1)    
io (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 (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)    
systemhealth (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)    
xevents (1)    
xml (1)    
xquery (1)