Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Articles with tag
SQL Server 2012
Search for
any
content tagged
sql server 2012
<< Newer
Items 21 to 40 of 110
Older >>
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
|
3,186 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,422 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
|
18,048 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,240 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
2018/04/11 (first published: 2014/02/26)
|
Source:
Redgate
|
Category:
replication
Rating:
Rate this
|
Briefcase
|
74,096 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,673 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,752 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
2018/04/11 (first published: 2014/02/26)
|
Source:
Redgate
|
Category:
replication
Rating:
Rate this
|
Briefcase
|
74,096 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
2018/04/11 (first published: 2014/02/26)
|
Source:
Redgate
|
Category:
replication
Rating:
Rate this
|
Briefcase
|
74,096 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
|
8,229 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
2018/04/11 (first published: 2014/02/26)
|
Source:
Redgate
|
Category:
replication
Rating:
Rate this
|
Briefcase
|
74,096 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
2018/04/11 (first published: 2014/02/26)
|
Source:
Redgate
|
Category:
replication
Rating:
Rate this
|
Briefcase
|
74,096 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,505 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
2018/04/11 (first published: 2014/02/26)
|
Source:
Redgate
|
Category:
replication
Rating:
Rate this
|
Briefcase
|
74,096 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
2018/04/11 (first published: 2014/02/26)
|
Source:
Redgate
|
Category:
replication
Rating:
Rate this
|
Briefcase
|
74,096 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
|
13,819 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
2018/04/11 (first published: 2014/02/26)
|
Source:
Redgate
|
Category:
replication
Rating:
Rate this
|
Briefcase
|
74,096 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,673 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
|
17,284 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,274 reads
<< Newer
Items 21 to 40 of 110
Older >>
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.