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

Content with tag SQL Server Rss

   Items 1 to 20 of 173    Older >>
 

Which Edition of SQL Server is Best for Development Work?

You might think, as a developer, that nothing but the best is good enough as a development database. You might be mistaken. There is a lot to be said for LocalDB, but Ed Elliott argues that every edition has its pros and cons, and you need to consider Cloud-based resources, VMs and Containerised databases too. There is a whole range of alternatives and how you choose depends on the type of database you are developing, but for Ed, LocalDB gets the five-star accolade.  Read more...
By 2016/11/23 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,136 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,634 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,272 reads

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  Read more...
By Tomaž Kaštrun 2016/09/15 | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 2,378 reads

Azure SQL Limitations compared with a SQL Server Enterprise

In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.  Read more...
By Daniel Calbimonte 2016/07/26 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 1,847 reads

Database autogrowth and initail size setup.

Set initial size and autogrowth of all database on a SQL instance in a go.  Read more...
By Rajesh Sharma 2016/06/21 | Source: SQLServerCentral.com | Category: database
Rating: |  Discuss |   Briefcase | 550 reads

Database checkout alert when SQL Starts

Receive an email alert with some health information when SQL SERVER starts.  Read more...
By Rajesh Sharma 2016/06/17 | Source: SQLServerCentral.com | Category: database
Rating: (not yet rated) |  Discuss |   Briefcase | 465 reads

Using IronPython to talk to SQL Server

IronPython is a Python implementation build on .NET. This article shows how you can use IronPython to access SQL Server Management Objects.  Read more...
By Gerald Britton 2016/06/13 | Source: SQLServerCentral.com | Category: ironpython
Rating: |  Discuss |   Briefcase | 1,438 reads

The Politics of SQL Security

Dealing with SQL Server security when the application it uses is full of security holes.  Read more...
By Scott Crosby 2016/05/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 135 reads

Agent Job Schedule Description

Yet another schedule description query with added grammatical improvements.  Read more...
By Michael McCormick 2016/05/06 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 557 reads

SQL Server Resource Governor

Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.  Read more...
By Arun Sirpal 2016/04/26 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 1,550 reads

Migrating an on premise SQL Server Database to Azure

For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.  Read more...
By Arun Sirpal 2016/04/21 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,303 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,272 reads

In Memory Code Name

By Steve Jones 2016/04/01 | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 1,245 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,774 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,673 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,344 reads

Renaming

By Steve Jones 2015/09/28 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,644 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,486 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,254 reads
   Items 1 to 20 of 173    Older >>
 
Tags
blogs (28)    
t-sql (14)    
editorial (13)    
administration (10)    
integration services (ssis) (9)    
cloud services (8)    
powershell (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)    
conflict resolution (2)    
data warehousing (2)    
database (2)    
etl (2)    
excel (2)    
fundamentals (2)    
initial size (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)    
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)    
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)    
clustering (1)    
cms (1)    
code reuse (1)    
code review (1)    
columnstore index (1)    
command line install (1)    
conferences and events (1)    
conferences/user groups (1)    
consolidation (1)    
constraints (1)    
consultancy (1)    
cpu (1)    
ct (1)    
data collector (1)    
database growth (1)    
database users (1)    
ddl (1)    
deadlock graph (1)    
deadlocks (1)    
dependencies (1)    
development (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)    
graphs (1)    
growth rates (1)    
handle (1)    
hard disk (1)    
healthcheck (1)    
hierarchy (1)    
identity property (1)    
indexing (1)    
insert (1)    
instances (1)    
introduction (1)    
io (1)    
ironpython (1)    
japanese character (1)    
job trends (1)    
linear gauge control (1)    
management data warehouse (1)    
mdw (1)    
memory (1)    
microsoft azure (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 users (1)    
paas (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)    
r language (1)    
r services (1)    
rateio itens (1)    
rateio nucleus (1)    
rateio produtos (1)    
r-bar (1)    
referential integrity (1)    
rename primary key (1)    
replication (1)    
replication tracking (1)    
report builder (1)    
resource governor (1)    
restart (1)    
rm núcleus (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 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)    
upgrading (1)    
user group (1)    
users (1)    
valor itens % (1)    
vbscript (1)    
virtualization (1)    
windows (1)    
xevents (1)    
xml (1)    
xquery (1)