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.
Good Security Needs Layers
A good security system needs layers since our applications and platforms don't exist in a vacuum.
Why sp_prepare Isn’t as “Good” as sp_executesql for Performance
Erik Darling shows how execution plan estimates suffer.
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.
Machine Learning Challenges
Machine Learning is an exciting branch of computer science, but it doesn't solve all our problems.
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.
Desperation on the Forums
Grant talks about the challenges of helping people in online forums and getting them to learn rather than grab the first solution.
In Depth Learning at the PASS Summit
The pre-conference sessions for the 2018 PASS Summit were released.
SQL Server From .Net: Making A Connection
A basic introduction for developers about creating a connection from .Net to SQL Server, and some of the options available.
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.
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers