Follow my last post which can be found here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/), we discussed about replacing table variable by memory optimized table, this...
2017-02-13 (first published: 2017-02-08)
8,176 reads
This is the third article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON...
2017-02-07
27 reads
Ensuring and maintaining team productivity practices is important for any organization, especially a small and growing team. The biggest part...
2017-02-07
440 reads
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to...
2017-02-07
29 reads
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late...
2017-02-07
985 reads
I love the questions I get while I’m presenting because they force me to think and learn. The question in...
2017-02-14 (first published: 2017-02-07)
1,509 reads
How often is cost the deciding factor in the case of Windows vs Linux? And what if cost wasn’t a...
2017-02-07
398 reads
UPDATE: I also published a blog post using a DAX only approach. Check it out here.
Recently someone had a question...
2017-02-13 (first published: 2017-02-07)
2,985 reads
Restricting user to login from single host may be sometimes required from security point and other business requirements. We can...
2017-02-07
567 reads
There was a question from the op regarding adding a new column to a query output by generating the cyclic...
2017-02-09 (first published: 2017-02-06)
2,517 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
WhatsApp 082225313145 Jl. Banda No.39, Citarum, Kec. Bandung Wetan, Kota Bandung, Jawa Barat 40115
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers