Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag sql server 2012 Rss

   Items 1 to 20 of 136    Older >>
 

MS15-058: Vulnerabilities in SQL Server could allow remote code execution

A vulnerability has been released that can affect SQL Server 2008, 208 R2, 2012, and 2014.  Read more...
By Press Release 2015/07/15 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 5,201 reads

SQL 2012 Clusters

By Vyas DCS 2015/07/09 | Category: sql engine
Rating: (not yet rated) |  Discuss |   Briefcase | 1,193 reads

A Quick Tour of the Performance Dashboard Reports

SQL Server Performance Dashboard comprises a set of custom reports that give you nitty gritty details about the performance of your SQL Server instance.  Read more...
By Prett Sons 2015/07/03 (first published: 2013/06/11) | Source: SQLServerCentral.com | Category: performance dashboard reports
Rating: |  Discuss |   Briefcase | 16,877 reads

Learning SQL Server 2012

A collection of technologies and links that will help you learn more about SQL Server 2012.  Read more...
By Site Owners 2015/06/25 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 432 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,278 reads

The new Analytic functions in SQL Server 2012

SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.  Read more...
By Wayne Sheffield 2015/05/01 (first published: 2012/01/19) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 27,127 reads

CONCAT and STUFF Functions in SQL Server 2012

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.  Read more...
By Additional Articles 2015/05/01 | Source: Database Journal | Category: concat
Rating: (not yet rated)  Rate this |   Briefcase | 8,692 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,278 reads

Columnstore Indexes

By Dawn Strickrott 2015/03/16 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,598 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,278 reads

Lead and Lag Functions in SQL Server 2012

Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function  Read more...
By Additional Articles 2014/12/10 | Source: Database Journal | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 7,279 reads

Memory

By Vyas DCS 2014/11/14 | Category: setup
Rating: (not yet rated) |  Discuss |   Briefcase | 1,747 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,278 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,375 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,278 reads

Dynamic Management Views: Changes in SQL Server 2012

There were many new DMVs added in SQL Server 2012, and some that have changed since SQL Server 2008 R2. This is a brief overview of the biggest changes and what they mean to you!  Read more...
By Edward Pollack 2014/07/03 | Source: SQLServerCentral.com | Category: dynamic management view
Rating: |  Discuss |   Briefcase | 5,309 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,278 reads

Server_Config_Script_2012

Here's a quick query you can run across all your servers (2012) to find a wealth of information like service pack, edition, number of CPUs and RAM. Even more is available if you want to add additional SERVERPROPERTY attributes or fields from one of the DMVs.  Read more...
Rating: |  Discuss |   Briefcase | 2,568 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.  Read more...
By Ola Hallengren 2014/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 44,375 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/06/03 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 41,278 reads
   Items 1 to 20 of 136    Older >>
 
Tags
integration services (ssis) (15)    
alwayson (11)    
high availability (ha) (10)    
t-sql (9)    
administration (5)    
blogs (5)    
indexing (5)    
editorial (4)    
filetable (4)    
security (4)    
sql server 2008 (4)    
sql server 2014 (4)    
clustering (3)    
columnstore index (3)    
contained databases (3)    
create sequence (3)    
hyper-v (3)    
lag (3)    
lead (3)    
performance tuning (3)    
powershell (3)    
sequence (3)    
sql server 2008 r2 (3)    
window functions (3)    
analysis services (ssas) (2)    
availability groups (2)    
backup / recovery (2)    
business intelligence (2)    
disaster recovery (dr) (2)    
dmv (2)    
ftp task (2)    
replication (2)    
roles (2)    
sequence objects (2)    
server roles (2)    
sharepoint 2013 (2)    
virtualization (2)    
adventureworks2012 (1)    
analytic functions (1)    
azure (1)    
backup (1)    
backup / restore (1)    
bism (1)    
books on line (bol) (1)    
build list (1)    
callout box (1)    
career (1)    
cluster (1)    
concat (1)    
conversion functions (1)    
copy database script (1)    
cume_dist (1)    
data access (1)    
data modeling (1)    
data quality services (dqs) (1)    
database engine (1)    
database recovery advisor (1)    
database weekly (1)    
date manipulation (1)    
datetimefromparts (1)    
digital certificates (1)    
dmo (1)    
dynamic management view (1)    
ebook (1)    
error handling (1)    
events (1)    
execute sql task (1)    
execution plans (1)    
expressions (1)    
extended events (1)    
files and filegroups (1)    
first_value (1)    
foreach loop container (1)    
formatting (1)    
friday poll (1)    
ftp (1)    
ftp connection (1)    
functions (1)    
identity property (1)    
integration services catalog (1)    
integrity check (1)    
interactive (1)    
iscsi san (1)    
last_value (1)    
licensing (1)    
local path (1)    
maintenance plans (1)    
map tool (1)    
master data services (mds) (1)    
mcsa 70-462 (1)    
monitoring (1)    
multicast (1)    
network service (1)    
new feature (1)    
nt service (1)    
oltp (1)    
ordnance survey os data (1)    
over clause (1)    
percent_rank (1)    
percentile_cont (1)    
percentile_dist (1)    
performance (1)    
performance dashboard reports (1)    
point in time recovery (1)    
power view (1)    
pssdiag (1)    
remote path (1)    
reporting services (ssrs) (1)    
resource governor (1)    
resource groups (1)    
restore (1)    
sequence numbers (1)    
sequence object (1)    
server config 2012 (1)    
server name (1)    
server password (1)    
server user name (1)    
service accounts (1)    
service broker (1)    
services (1)    
setup (1)    
sharepoint (1)    
sharepoint 2010 (1)    
spatial data (1)    
sql engine (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2016 (1)    
sql server agent (1)    
sql server data tools (1)    
ssdt (1)    
statistics (1)    
stored procedures (1)    
stuff (1)    
top cpu queries (1)    
tracing (1)    
troubleshooting (1)    
upgradin (1)    
upgrading (1)    
variables (1)    
windows 2012 (1)    
windows server 2012 (1)