2021-09-08
817 reads
SQL Server 2012
Getting Started with SQL Server 2012 Express LocalDB
Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task.
2017-07-28
5,168 reads
Learning SQL Server 2012
A collection of technologies and links that will help you learn more about SQL Server 2012.
2015-06-25
1,396 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
2014-12-10
8,382 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.
2019-04-02 (first published: 2014-03-24)
25,658 reads
Powershell script to interactively move cluster resources
Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.
2013-11-19 (first published: 2013-11-04)
2,339 reads
2013-10-25
2,050 reads
2013-08-13
2,001 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.
2013-07-04
8,323 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.
2013-06-10
4,886 reads
Blogs
SQL Server Management Studio uses the Visual Studio installer
Yes, SSMS 21 uses the Visual Studio installer. No, you don’t need to download...
Getting Started with Microsoft Fabric: Why It Matters and What You Gain
By Chris Yates
In today’s data-driven world, organizations are constantly seeking ways to simplify their analytics stack,...
Terraform Commands
I realized I never created a post to show how to deploy Terraform from...
Forums
Building a Database Dashboard with SSRS
Comments posted to this topic are about the item Building a Database Dashboard with...
Who is Using Standard Edition?
Comments posted to this topic are about the item Who is Using Standard Edition?
Getting the SQL
Comments posted to this topic are about the item Getting the SQL
Question of the Day
Getting the SQL
If I run this code, what is returned?
SELECT * FROM sys.fn_get_sql(0x0500FF7F149270E460F3E0ADD701000001000000000000000000000000000000000000000000000000000000) AS fgsSee possible answers