Dealing with High Concurrency with Table Hints
Systems with a large number of requests on a critical database table are prone to blocking and slowness. We take a look at getting things done using T-SQL table hints.
2017-06-20
2,091 reads
Joao Osorio
Data Lifecycle Management using SQL Server
With the data proliferation issues, a well-defined lifecycle for data retention is a growing demand.
2016-11-10
1,389 reads
SQL Server 2016: built-in JSON Use case scenarios
There's built-in JSON support starting with SQL Server 2016. Does that mean we should all ditch XML and start using JSON? It depends mostly on the target of your data output processing.
2016-08-16
2,376 reads
Continuous Integration with Microsoft SQL Server
What about database development? In most projects, developers aren’t focused on database development and for proper CI, the database version should keep neck to neck with the application builds.
2016-06-08
3,491 reads
Blogs
Data Masker Reads Column Classificiations
By Steve Jones
One of the newer features in Data Masker for SQL Server is the ability...
Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method
Yesterday in this post I described a method to correct permissions when upgrading a...
Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Verify your SQL Server database backups
Comments posted to this topic are about the item Verify your SQL Server database...
error trying to create another log file
For some reason I'm unable to create another log file. Ideas? ALTER DATABASE [DBNAME]...
Ask SSC