Resumable Online Index Rebuild
I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog...
2017-04-23
2,108 reads
Blog Posts
Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)
Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is a logical continuation...
2017-04-22
555 reads
Excel BI VC presents Prathy Kamasani–Power BI Dashboards for Excel Users
Thu, Apr 27 2017 20:00 GMT Daylight Time
Power BI Dashboard within an hour for Excel users
RSVP:https://attendee.gotowebinar.com/register/8516045593703848705
Power BI Dashboard within an...
2017-04-22
628 reads
Installing a Visual Studio Team Services private build agent hosted On-Premises
This blog post is about a situation where I use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those...
2017-04-22
1,080 reads
Retrospective analysis of SQL Saturday South Island (#sqlsat614)
Now that SQL Saturday South Island (also known as #sqlsat614 on the Twitter) is done I thought it would be...
2017-04-22
258 reads
Why Did Your Availability Group Creation Fail?
Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly the easiest thing in the world to pull off...
2017-04-22
17 reads
Why Did Your Availability Group Creation Fail?
Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly...
2017-04-22
3,724 reads
2 Great Courses For Databases Professionals - Deal Of the Week
I received the email from Learning Tree on Wednesday with their weekly offer of courses running in the London Education...
2017-04-21
618 reads
DevOps Basics– git Cloning Repos
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-04-21
694 reads
SQL Database File Wise Disk Space Monitoring
As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...
2017-04-21
1,198 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
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