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

Memory

By Vyas DCS 2014/11/14 | Category: setup
Rating: (not yet rated) |  Discuss |   Briefcase | 1,392 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 2014/11/05 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 23,632 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 | 43,552 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 2014/11/05 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 23,632 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,070 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 2014/11/05 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 23,632 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,476 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 | 43,552 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 2014/11/05 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 23,632 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 2014/04/15 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 1,683 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 2014/03/24 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 8,621 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 | 43,552 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 2014/11/05 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 23,632 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,476 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 2013/12/26 (first published: 2012/01/19) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 18,892 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 2013/11/25 | Source: SQLServerCentral.com | Category: mcsa 70-462
Rating: |  Discuss |   Briefcase | 9,156 reads

Powershell script to interactively move cluster resources

Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.  Read more...
By Rolando Hernandez 2013/11/19 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 478 reads

SQL Server 2012 service accounts

By Dan Hess 2013/10/25 | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 1,953 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 | 43,552 reads

Clean Data

By Dave 2013/08/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,058 reads
   Items 1 to 20 of 125    Older >>
 
Tags
integration services (ssis) (15)    
alwayson (11)    
high availability (ha) (10)    
t-sql (9)    
administration (5)    
blogs (5)    
editorial (4)    
filetable (4)    
contained databases (3)    
create sequence (3)    
hyper-v (3)    
indexing (3)    
lag (3)    
lead (3)    
performance tuning (3)    
powershell (3)    
security (3)    
sequence (3)    
sql server 2008 (3)    
window functions (3)    
analysis services (ssas) (2)    
availability groups (2)    
backup / recovery (2)    
business intelligence (2)    
clustering (2)    
disaster recovery (dr) (2)    
dmv (2)    
ftp task (2)    
replication (2)    
roles (2)    
sequence objects (2)    
server roles (2)    
sharepoint 2013 (2)    
sql server 2008 r2 (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)    
columnstore index (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)    
identity property (1)    
index maintenance (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 server (1)    
sql server 2005 (1)    
sql server 2014 (1)    
sql server agent (1)    
sql server data tools (1)    
ssdt (1)    
statistics (1)    
stored procedures (1)    
top cpu queries (1)    
tracing (1)    
troubleshooting (1)    
upgradin (1)    
upgrading (1)    
variables (1)    
windows 2012 (1)    
windows server 2012 (1)