Do you want to improve your T-SQL skills? MVP Jacob Sebastian runs regular challenges to get you to think about how to solve a problem in T-SQL. These run monthly and we have a summary and explanation from challenge #1 to help you learn more about moving data from 3 tables into a specific format.
High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This requires planning, and documentation. If you get a Disaster Recovery Plan wrong, it can make an incident into a catastrophe for the business. Hugo Shebbeare discusses some essentials, describes a typical system, and provides sample documentation.
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
By Kevin3NF
Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...
hi, just to get this part out of the way, if my intended target...
Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?
See possible answers