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

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,233 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 | 7,956 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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,310 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/02/26 | Source: Red-Gate | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 4,049 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...
By Patrick Akhamie 2014/02/06 | Source: SQLServerCentral.com | Category: server config 2012
Rating: |  Discuss |   Briefcase | 1,350 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,449 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 | 8,148 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 | 427 reads

SQL Server 2012 service accounts

By Dan Hess 2013/10/25 | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 1,910 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/03/21 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 41,310 reads

Clean Data

By Dave 2013/08/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,999 reads

SSIS 2012 -SSISDB

By pramod singla 2013/08/13 | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 1,800 reads

SQL Server 2012, Replication

By G. C. 2013/08/12 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,633 reads

Why SQL Server 2012 needs Windows Server 2012

While AlwaysOn and Columnar lookup are good enough reasons to migrate to SQL Server 2012, you need to be aware of the problems associated with certain virtualize environments.   Read more...
By Jim Johnston 2013/07/04 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 8,087 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...
Rating: |  Discuss |   Briefcase | 9,768 reads

The Importance of Reading Comments

Read when you search for help on the internet. You might miss a very important part of what you must do.  Read more...
By Manie Verster 2013/06/10 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 4,837 reads

Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets

There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.  Read more...
By Additional Articles 2013/05/23 | Source: SimpleTalk | Category: sql server 2012
Rating:  Rate this |   Briefcase | 2,826 reads

Power View for Cubes

This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models[1], this SQL Server 2012 CTP release allows connections between Power View and Multidimensional Models ( cubes) and not just Tabular Models.  Read more...
By Ivan Paniagua 2013/05/21 | Source: SQLServerCentral.com | Category: power view
Rating: |  Discuss |   Briefcase | 6,016 reads

How Maintenance Plans are a Big Plus for SQL Server Administration

SQL Server 2012 makes your database maintenance jobs easy by proving an effective Maintenance Plan Wizard. This wizard does a fair job of creating core maintenance plans for your database.  Read more...
By Prett Sons 2013/05/20 | Source: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 4,526 reads

SQL Server 2012 Integration Services - Using PowerShell to Configure Package Execution Parameters

Marcin Policht explores some of PowerShell's SSIS-specific automation capabilities by demonstrating the process of configuring an already deployed package in order to carry out a parameterized package execution.  Read more...
By Additional Articles 2013/04/29 | Source: Database Journal | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 1,775 reads
   Items 1 to 20 of 116    Older >>
 
Tags
integration services (ssis) (15)    
alwayson (11)    
high availability (ha) (10)    
t-sql (9)    
blogs (5)    
administration (4)    
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)    
ftp task (2)    
replication (2)    
roles (2)    
sequence objects (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)    
dmv (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)    
format (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)    
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 role (1)    
server roles (1)    
server user name (1)    
service accounts (1)    
service broker (1)    
services (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)    
store procedure (1)    
top cpu queries (1)    
tracing (1)    
troubleshooting (1)    
upgradin (1)    
upgrading (1)    
variables (1)    
windows 2012 (1)    
windows server 2012 (1)