Spring into the Latest Features at the Luxemborg User Group
The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.
2018-04-23
102 reads
Articles
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
2018-04-23
3,713 reads
Making Deployments Simpler with Re-runnable Scripts
Make sure your SQL Server database release scripts to make life easier.
2018-04-20 (first published: 2015-11-17)
10,009 reads
How to Show the Execution Plan of a Running Query
By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?
2018-04-20
4,126 reads
Do you check your backups?
Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.
2018-04-19
1,548 reads
SQL Server Graph Databases – Part 2: Querying Data in a Graph Database
Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use the new function.
2018-04-19
3,455 reads
Why sp_prepare Isn’t as “Good” as sp_executesql for Performance
Erik Darling shows how execution plan estimates suffer.
2018-04-18
3,318 reads
Fixing system database corruption with setup.exe
Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.
2018-04-17
959 reads
Recover Data in SQL Server AWS RDS with the Help of BACPAC
With Amazon RDS, it’s easy to have a SQL Server running in minutes. There are some limitations, though. Seth Delconte explains a workaround to overcome one of the limitations: the inability to restore a second copy of a database to recover missing data.
2018-04-17
2,672 reads
Using T-SQL to Detect Stock Price Reversals with the RSI
Rick Dobson explains the Relative Strength Index (RSI), and shows how to create a TSQL script that computes the RSI for a stock closing price series.
2018-04-16
3,074 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers