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
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
Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.
2018-04-13 (first published: 2015-10-06)
11,537 reads
How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?
2018-04-13
5,279 reads
The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.
2018-04-12
4,214 reads
Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.
2018-04-11
2,961 reads
Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.
2018-04-10
4,855 reads
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
2018-04-10
3,427 reads
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
2018-04-09
1,790 reads
With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.
2018-04-09
2,500 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers