Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Server Rss

<< Newer    Items 21 to 40 of 181    Older >>
 

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,683 reads

In Memory Code Name

By Steve Jones 2016/04/01 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 1,262 reads

Using PowerShell for SQL Server Replication Tracking

Tim Smith shows how using PowerShell can be an effective way to track SQL Server snapshot and transactional replication counts for sources and destinations.  Read more...
By Additional Articles 2016/01/28 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,846 reads

SQL Server Memory

SQL Server Memory in Task Manager - Should I be Worried?  Read more...
By Ginger Keys 2015/12/14 | Source: SQLServerCentral.com | Category: memory
Rating: |  Discuss |   Briefcase | 7,741 reads

Doing a SQL Server Healthcheck via PowerShell

PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid Afzalalghom's Healthcheck allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories.  Read more...
By Additional Articles 2015/12/01 | Source: SimpleTalk | Category: healthcheck
Rating:  Rate this |   Briefcase | 4,414 reads

Renaming

By Steve Jones 2015/09/28 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,654 reads

How to Confuse the SQL Server Query Optimizer

Want to 'trick' SQL Server into performing millions of logical reads to return data, when only are few thousand were really required? In this article, Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the point that it generates and reuses very inefficient execution plans.  Read more...
By Additional Articles 2015/09/21 | Source: SimpleTalk | Category: query optimizer
Rating:  Rate this |   Briefcase | 3,522 reads

PowerShell and ADO.NET Connection String Settings for SQL Server

Tim Smith addresses some common questions from PowerShell developers about connection strings, errors with strings, and alternative development approaches to using connection strings.  Read more...
By Additional Articles 2015/09/11 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,307 reads

SSIS Package documentor

Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.   Read more...
By Divya Agrawal 2016/11/04 (first published: 2015/09/01) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 11,843 reads

Identify SQL Server Database Growth Rates

Unchecked SQL Server database growth can hurt the bottom line of organizations in the form of poor application performance and increased infrastructure costs. In this article, Marios Philippopoulos looks at whether there's an easy way to proactively obtain a recent list of the fastest-growing databases in a SQL Server instance using information captured by default in the database engine.  Read more...
By Additional Articles 2015/08/26 | Source: MSSQLTips.com | Category: database growth
Rating: (not yet rated)  Rate this |   Briefcase | 3,553 reads

SQL Server Performance Dashboard Reports

Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).  Read more...
By Arun Sirpal 2016/12/09 (first published: 2015/08/20) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 10,503 reads

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 | 5,121 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,579 reads

Delete all files from a folder using xp_cmdshell

Delete all files from a folder using xp_cmdshell  Read more...
Rating: |  Discuss |   Briefcase | 890 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 | 967 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,190 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,627 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 | 555 reads

SQL Versions

By Karthik Babu 2015/03/20 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 1,698 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,619 reads
<< Newer    Items 21 to 40 of 181    Older >>
 
Tags
blogs (28)    
editorial (14)    
t-sql (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)    
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)    
data warehousing (2)    
database (2)    
database growth (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)    
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)    
books (1)    
career (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 users (1)    
datamate technology (1)    
dba (1)    
ddl (1)    
deadlock graph (1)    
deadlocks (1)    
dependencies (1)    
development (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)    
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)    
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)    
referential integrity (1)    
regression (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 2012 (1)    
sql server 2014 (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)