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

<< Newer    Items 21 to 40 of 131    Older >>
 

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 | 26,630 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 | 10,052 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 | 517 reads

SQL Server 2012 service accounts

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

Clean Data

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

SSIS 2012 -SSISDB

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

SQL Server 2012, Replication

By G. C. 2013/08/12 | Category: replication
Rating: (not yet rated) |  Discuss |   Briefcase | 1,687 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,234 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 | 10,759 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,853 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,987 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,242 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,641 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,886 reads

Upgrading to 2012

Are many people upgrading to SQL Server 2012? Is it worth the cost for your company for any existing instances? Steve Jones asks the question this week.  Read more...
By Steve Jones 2013/04/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 362 reads

SQL Server 2012 Build List

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

Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell

With SQL Server 2012 AlwaysOn Availability Groups, you can configure read-only routing and to automatically redirect the read-only workloads to a secondary replica after a failover. Can this be done using Windows PowerShell?  Read more...
By Additional Articles 2013/04/17 | Source: MSSQLTips.com | Category: alwayson
Rating:  Rate this |   Briefcase | 1,545 reads

New and Basic Result-set Paging functionality in SQL 2012 Version.

Overview of 2 very important clauses added to SELECT statement in SQL2012 to allow paging on result sets.  Read more...
By Eli Leiba 2013/04/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 581 reads

Generating Sequence Numbers Using the Sequence Object

The new SQL Server 2012 Sequence Object can be used to generate unique numbers that can be automatically incremented based on an increment value. Greg Larsen discusses the different features of the sequence object and how you can use it to generate sequence numbers.  Read more...
By Additional Articles 2013/04/05 | Source: Database Journal | Category: sequence numbers
Rating: (not yet rated)  Rate this |   Briefcase | 2,539 reads
<< Newer    Items 21 to 40 of 131    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)    
contained databases (3)    
create sequence (3)    
hyper-v (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)    
columnstore index (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)    
sql server 2014 (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 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)