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
1,858 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,285 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,076 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,430 reads
Blogs
Quick 6 month check – how are those learning goals going…?
By HamishWatson
So in January I wrote a blog post on some goals I had this...
“An installation package for the product Microsoft SQL Server 2012 Native Client cannot be found” – during SQL Server 2017 install
By HamishWatson
This blog post is about a situation that initially perplexed me – I was...
Power BI Monthly Digest – July 2019
By Devin-Knight
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...
Forums
Changing Hardware
Comments posted to this topic are about the item Changing Hardware
Generate Random alphanumeric value based on timestamp
Hi All, Thank you for looking into my question. Does anyone have a script...
Ask SSC