If you haven’t heard, SSMS v18 went GA (Generally Availability) recently. You can download it from Microsoft, though if you have a preview version, you do need to uninstall...
2019-05-17 (first published: 2019-05-06)
576 reads
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
2019-05-06
166 reads
SQL Server Enterprise Edition can leverage large memory pages to reduce the amount of memory pointers required for larger SQL Server deployments. Reducing the number of pointers makes the...
2019-05-20 (first published: 2019-05-06)
511 reads
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner ... Continue reading
2019-05-22 (first published: 2019-05-06)
548 reads
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-06
16 reads
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-06
56 reads
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-21 (first published: 2019-05-06)
972 reads
Microsoft SQL server database contains the most crucial data of organizations. But while using MS SQL server many users often face problems like abrupt termination, database connection errors, transient...
2019-05-06
12 reads
Microsoft SQL server database contains the most crucial data of organizations. But while using MS SQL server many users often face problems like abrupt termination, database connection errors, transient...
2019-05-06
59 reads
SQLDay starts in a week! Stay tuned during this week as it could be full of surprises! We are ready & prepared and speakers start to arrive next Saturday!...
2019-05-05
23 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers