Why QUOTENAME is important
Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.
Help us define the State of Database Monitoring in 2020
The State of SQL Server Monitoring was launched in 2018. This year we are interested in gathering insight across database platforms, not just SQL Server. Have your say and take the survey to be first to receive the report and enter your chance to win a $500 Amazon voucher.
Take the survey.
The First Time I Had to Restore a Database
Do you remember the very first time you had to do a database restore to fix something you messed up?
Implementing Reporting Application Enhancements with No Downtime
The purpose of this article is to detail steps that would help implement an enhancement to reporting application that uses SQL Server Database (or any other database) in backend without causing downtime to reporting application.
Who is the best person for the job?
Sometimes it is hard to admit that you are not the best person for the job that is presented to you.
SQL Server Disaster Recovery Options
This presentation is to get you thinking about the disaster recovery options for SQL Server, things like backups, log shipping, Availability Groups, clustering and more while putting them in the context of the enterprise.
More Time to Certify
You have more time to earn that MCSA, MCSE, or MCSD, thanks to Microsoft and the pandemic.
Stairway to U-SQL Level 16: The Azure Data Lake Catalog
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
Stairway to U-SQL Level 16: The Azure Data Lake Catalog
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
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
Experimental Verification of the NKTg Law on 8 Planets (NASA 2024 Data, SQL)
Nguyen Khanh Tung Email: traiphieu.com@gmail.com ORCID: 0009-0002-9877-4137 -------------------------------------------------------------------------------- Abstract This article presents a numerical...
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
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