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

Content with tag SQL Server 2012 Rss

   Items 1 to 20 of 148    Older >>
 

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through SP2 CU11.  Read more...
By Steve Jones 2016/05/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 17,113 reads

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.   Read more...
By Eirikur Eiriksson 2016/04/22 (first published: 2014/03/24) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 12,760 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 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,811 reads

Script move of DB files from one location to another

Generates Scripts to move DB files from one location to another SQL and powershell scripts  Read more...
By Greg Ryan 2016/04/11 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,381 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 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,811 reads

A Review of rsNeatPublish

rsNeatPublish: Toolset to automate deployment of all SSRS 2008R2/12/14/16 objects  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 590 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 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,811 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 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,811 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 | 3,538 reads

MCSA 70-462 Training Kit Preparation: Hyper-V Lab Environment Setup

If you are planning on taking the Microsoft Certification Exam for 70-462, this guide provides the step-by-step instructions to completely setup your Hyper-V lab environment used in the official training kit.  Read more...
By Bruce Hendry 2015/09/11 (first published: 2013/11/25) | Source: SQLServerCentral.com | Category: mcsa 70-462
Rating: |  Discuss |   Briefcase | 16,893 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 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,811 reads

Learning Columnstore Indexes

References and links to learn more about columnstore indexes.  Read more...
By Site Owners 2015/08/03 | Source: SQLServerCentral.com | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 2,787 reads

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

SQL 2012 Clusters

By Vyas DCS 2015/07/09 | Category: sql engine
Rating: (not yet rated) |  Discuss |   Briefcase | 1,339 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 | 17,762 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 | 1,185 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 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,811 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,555 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 | 9,175 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 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,811 reads
   Items 1 to 20 of 148    Older >>
 
Tags
integration services (ssis) (15)    
alwayson (11)    
high availability (ha) (10)    
t-sql (9)    
administration (5)    
blogs (5)    
indexing (5)    
sql server 2014 (5)    
editorial (4)    
filetable (4)    
security (4)    
sql server 2008 (4)    
sql server 2008 r2 (4)    
backup and restore (3)    
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)    
window functions (3)    
analysis services (ssas) (2)    
availability groups (2)    
business intelligence (2)    
disaster recovery (dr) (2)    
dmv (2)    
ftp task (2)    
replication (2)    
reporting services (ssrs) (2)    
roles (2)    
sequence objects (2)    
server roles (2)    
sharepoint 2013 (2)    
sql server 2016 (2)    
virtualization (2)    
adventureworks2012 (1)    
analytic functions (1)    
azure (1)    
backup (1)    
bism (1)    
books on line (bol) (1)    
build list (1)    
callout box (1)    
career (1)    
ci (1)    
cluster (1)    
concat() (1)    
continuous delivery (1)    
continuous integration (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)    
deploy (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)    
product reviews (1)    
pssdiag (1)    
remote path (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 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)